执行sql语句时报错cncurrency mode is disabled not creating a lock manager
时间: 2024-02-28 09:54:05 浏览: 16
这个错误通常是因为在执行 SQL 语句时,MySQL 的并发模式没有启用导致的。并发模式可以通过设置参数 innodb_concurrency_tickets 和 innodb_adaptive_hash_index 来启用。
你可以尝试在 MySQL 的配置文件 my.cnf 中添加以下参数来启用并发模式:
```
innodb_concurrency_tickets=5000
innodb_adaptive_hash_index=ON
```
如果还是无法解决问题,你还可以尝试升级 MySQL 版本或者重新安装 MySQL。
相关问题
执行sql 报错Public Key Retrieval is not allowed
当使用MySQL 8.x版本连接时,可能会出现“Public Key Retrieval is not allowed”的错误。这是因为MySQL 8.x版本默认情况下禁用了明文密码传输,需要使用加密的方式进行连接。为了解决这个问题,可以尝试以下两种方法:
1.在JDBC连接URL中添加allowPublicKeyRetrieval=true参数,例如:
```java
jdbc:mysql://localhost:3306/test?useSSL=false&allowPublicKeyRetrieval=true
```
2.在JDBC连接URL中添加sslMode=DISABLED参数,例如:
```java
jdbc:mysql://localhost:3306/test?useSSL=false&sslMode=DISABLED
```
以上两种方法都可以解决“Public Key Retrieval is not allowed”的错误,具体使用哪种方法取决于你的具体情况。
bolt.service is a disabled or a static unit not running, not starting it.
This message indicates that the systemd unit file for the "bolt" service is either disabled or marked as a static unit, and thus it is not being started by the system.
To enable and start the "bolt" service, you can use the following commands:
```
sudo systemctl enable bolt.service
sudo systemctl start bolt.service
```
This will enable the service to start automatically at boot time and start it immediately. If the service is still not starting after running these commands, you may need to check the logs for more information on why it is failing to start.