当前位置:论坛首页 > Linux面板 > 讨论

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

发表在 Linux面板2023-12-25 21:11 [复制链接] 4 1520

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



123.png
使用道具 举报 只看该作者 回复
发表于 2023-12-26 09:57:37 | 显示全部楼层
查看mysql错误日志:
  1. cat /www/server/data/*.err|grep -i -C 10 error
复制代码
使用道具 举报 回复 支持 反对
发表于 2023-12-26 10:03:56 | 显示全部楼层
t an error reading communication packets)
2023-12-11T01:37:07.129190Z 674113 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] Aborted connection 680247 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2023-12-11T02:00:32.127951Z 679963 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] 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 [Note] Aborted connection 681473 to db: 'jiuleyun_jlkey_c' user: 'jiuleyun_jlkey_c' host: 'localhost' (Got an error reading communication packets)
使用道具 举报 回复 支持 反对
发表于 2023-12-26 10:04:48 | 显示全部楼层
提示这些
使用道具 举报 回复
发表于 2024-1-29 16:36:13 | 显示全部楼层
上面是一个无法连接数据库的错误,
检查网络连接是否正常
数据库配置是否正确
以及检查mysql的日志,找到更详细的错误信息,帮助定位问题
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

立即付费处理

工作时间:09:00至24:00

快速回复 返回顶部 返回列表