1187757385 发表于 2023-12-25 21:11:30

【已完成】sql数据库启动不了

面板版本:8.0.4
浏览器版本:360
什么设备:CentOS-7.8.2003-x64
什么系统和架构:CentOS-7.8.2003-x64
问题具体描述:SQL数据库启动不了
重现方式:SQL数据库启动不了



阿珂 发表于 2023-12-26 09:57:37

查看mysql错误日志:
cat /www/server/data/*.err|grep -i -C 10 error

1187757385 发表于 2023-12-26 10:03:56

t an error reading communication packets)
2023-12-11T01:37:07.129190Z 674113 Aborted connection 674113 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:37:47.134796Z 674350 Aborted connection 674350 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:38:47.144572Z 674654 Aborted connection 674654 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:41:07.161012Z 675251 Aborted connection 675251 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:41:47.165603Z 675281 Aborted connection 675281 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:41:47.165611Z 675296 Aborted connection 675296 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:43:57.181205Z 675920 Aborted connection 675920 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:44:47.185518Z 676167 Aborted connection 676167 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:45:07.188554Z 676173 Aborted connection 676173 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:46:27.194124Z 676550 Aborted connection 676550 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:46:47.196559Z 676633 Aborted connection 676633 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:46:47.196559Z 676630 Aborted connection 676630 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:49:57.216048Z 677472 Aborted connection 677472 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:50:47.218703Z 677728 Aborted connection 677728 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:50:57.219305Z 677781 Aborted connection 677781 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:51:47.222321Z 677790 Aborted connection 677790 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:51:47.222603Z 677806 Aborted connection 677806 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:52:47.227186Z 678108 Aborted connection 678108 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:53:57.235832Z 678375 Aborted connection 678375 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:55:57.253332Z 678949 Aborted connection 678949 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:56:47.258883Z 679212 Aborted connection 679212 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:56:47.259134Z 679217 Aborted connection 679217 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:56:57.262203Z 679228 Aborted connection 679228 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T01:59:07.275290Z 679710 Aborted connection 679710 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:00:02.665948Z 680247 Aborted connection 680247 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:00:32.127951Z 679963 Aborted connection 679963 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:01:47.292158Z 680217 Aborted connection 680217 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:01:47.292737Z 680249 Aborted connection 680249 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:01:47.293000Z 680257 Aborted connection 680257 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:01:47.293312Z 680229 Aborted connection 680229 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:01:47.293924Z 680244 Aborted connection 680244 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:01:47.297505Z 680235 Aborted connection 680235 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:02:57.298527Z 680494 Aborted connection 680494 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:04:07.306308Z 680779 Aborted connection 680779 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:06:07.317422Z 681247 Aborted connection 681247 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:06:47.320651Z 681473 Aborted connection 681473 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)

1187757385 发表于 2023-12-26 10:04:48

提示这些

阿珂 发表于 2024-1-29 16:36:13

上面是一个无法连接数据库的错误,
检查网络连接是否正常
数据库配置是否正确
以及检查mysql的日志,找到更详细的错误信息,帮助定位问题
页: [1]
查看完整版本: 【已完成】sql数据库启动不了