【待反馈】mysql数据库隔两三天自动停止，数据库里的数
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：系统版本：
问题描述：
相关截图（日志、错误）：2024-03-04T22:00:47.085417Z 247415 Got packets out of order2024-03-04T22:00:47.157739Z 247416 Got packets out of order2024-03-04T22:00:47.224754Z 247417 Got packets out of order2024-03-04T22:33:34.904004Z 247418 Hostname 'security.criminalip.com' does not resolve to '185.242.226.23'.2024-03-04T22:33:34.904035Z 247418 Hostname 'security.criminalip.com' has the following IP addresses:2024-03-04T22:33:34.904040Z 247418 - 15.164.5.2092024-03-04T22:33:35.073725Z 247418 Got an error reading communication packets2024-03-05T01:17:44.541703Z 247419 Got packets out of order2024-03-05T01:17:45.342428Z 247420 IP address '223.199.191.125' could not be resolved: Name or service not known2024-03-05T01:17:45.342526Z 247420 Got an error reading communication packets2024-03-05T01:17:45.432344Z 247421 IP address '223.199.191.125' could not be resolved: Name or service not known2024-03-05T01:17:45.432465Z 247421 Got packets out of order2024-03-05T01:17:47.574353Z 247422 Got packets out of order2024-03-05T01:17:48.792353Z 247423 Got an error reading communication packets2024-03-05T02:41:32.234160Z 247424 IP address '165.154.33.72' could not be resolved: Name or service not known2024-03-05T02:41:32.592917Z 247424 Got an error reading communication packets2024-03-05T02:41:42.958842Z 247425 Got timeout reading communication packets2024-03-05T02:41:44.100934Z 247426 Access denied for user ''@'165.154.33.72' (using password: NO)2024-03-05T02:41:50.011304Z 247427 Access denied for user 'root'@'165.154.33.72' (using password: YES)2024-03-05T03:45:48.185397Z 247428 Got packets out of order2024-03-05T06:00:17.235212Z 247429 IP address '115.239.183.86' could not be resolved: Name or service not known2024-03-05T06:00:17.235290Z 247429 Got an error reading communication packets2024-03-05T06:00:17.311952Z 247430 Access denied for user 'root'@'115.239.183.86' (using password: NO)2024-03-05T06:23:41.925008Z 247432 IP address '118.125.28.49' could not be resolved: Name or service not known2024-03-05T06:23:41.930912Z 247432 Got an error reading communication packets2024-03-05T06:23:41.951916Z 247433 Access denied for user 'root'@'118.125.28.49' (using password: NO)2024-03-05T06:27:28.835124Z 247435 IP address '222.209.93.155' has been resolved to the host name '155.93.209.222.broad.cd.sc.dynamic.163data.com.cn', which resembles IPv4-address itself.2024-03-05T06:27:28.954816Z 247435 Access denied for user 'root'@'222.209.93.155' (using password: NO)2024-03-05T06:28:48.988518Z 247436 Accepted a connection with deprecated protocol 'TLSv1.1' for account `root`@`%` from host `47.108.235.18`. Client supplied username `root`2024-03-05T06:48:07.165783Z 247437 Host name 'ip-131-156.turbo.net.id' could not be resolved: Name or service not known2024-03-05T06:48:07.165892Z 247437 Got an error reading communication packets2024-03-05T06:48:09.135131Z 247438 Access denied for user 'root'@'103.50.131.156' (using password: NO)2024-03-05T06:53:20.531802Z 247441 IP address '211.149.233.27' could not be resolved: Name or service not known2024-03-05T06:53:20.532334Z 247440 IP address '211.149.233.27' could not be resolved: Name or service not known2024-03-05T06:53:20.532409Z 247440 Got an error reading communication packets2024-03-05T06:53:20.538746Z 247441 Access denied for user 'root'@'211.149.233.27' (using password: NO)2024-03-05T07:57:07.071913Z 247443 IP address '71.6.232.22' could not be resolved: Name or service not known2024-03-05T07:57:14.886735Z 247443 Got an error reading communication packets2024-03-05T08:17:19.899057Z 247444 IP address '35.190.199.12' has been resolved to the host name '12.199.190.35.bc.googleusercontent.com', which resembles IPv4-address itself.2024-03-05T08:17:20.101967Z 247444 Got an error reading communication packets2024-03-05T08:17:20.446872Z 247445 IP address '34.77.127.183' has been resolved to the host name '183.127.77.34.bc.googleusercontent.com', which resembles IPv4-address itself.2024-03-05T08:17:20.653205Z 247445 Access denied for user 'root'@'34.77.127.183' (using password: NO)2024-03-05T08:24:10.594524Z 247446 Host name 'dedic1476.hidehost.net' could not be resolved: Name or service not known2024-03-05T08:24:10.594611Z 247446 Got packets out of order2024-03-05T08:55:09.959349Z 247447 Got an error reading communication packets2024-03-05T09:42:30.420768Z 247448 IP address '223.113.128.162' could not be resolved: Name or service not known2024-03-05T09:42:31.078495Z 247448 Got an error reading communication packets2024-03-05T10:14:36.429665Z 247449 Hostname 'apzg-0721m-082.stretchoid.com' does not resolve to '162.243.131.27'.2024-03-05T10:14:36.429690Z 247449 Hostname 'apzg-0721m-082.stretchoid.com' has the following IP addresses:2024-03-05T10:14:36.429694Z 247449 - 127.0.0.12024-03-05T10:14:36.429745Z 247449 Got packets out of order2024-03-05T12:19:31.267346Z 247450 Hostname 'apzg-0729a-054.stretchoid.com' does not resolve to '198.199.95.66'.2024-03-05T12:19:31.267389Z 247450 Hostname 'apzg-0729a-054.stretchoid.com' has the following IP addresses:2024-03-05T12:19:31.267395Z 247450 - 127.0.0.12024-03-05T12:19:31.456276Z 247450 Got an error reading communication packets2024-03-05T12:43:02.767010Z 247451 IP address '223.86.50.18' could not be resolved: Name or service not known2024-03-05T12:43:02.767099Z 247451 Got an error reading communication packets2024-03-05T12:43:02.802088Z 247452 Access denied for user 'root'@'223.86.50.18' (using password: NO)2024-03-05T12:50:43.790506Z 247454 IP address '118.121.243.210' could not be resolved: Name or service not known2024-03-05T12:50:43.790576Z 247454 Got an error reading communication packets2024-03-05T12:50:43.845858Z 247455 Access denied for user 'root'@'118.121.243.210' (using password: NO)2024-03-05T15:55:12.096336Z 247457 IP address '47.108.66.7' could not be resolved: Name or service not known2024-03-05T15:55:12.096401Z 247457 Got an error reading communication packets2024-03-05T15:55:12.098459Z 247458 Access denied for user 'root'@'47.108.66.7' (using password: NO)2024-03-05T15:58:15.202711Z 247460 IP address '43.143.241.67' could not be resolved: Name or service not known2024-03-05T15:58:21.460634Z 247460 Got an error reading communication packets2024-03-05T17:17:33.848763Z 247461 Got an error reading communication packets2024-03-05T17:20:54.697062Z 247462 IP address '91.92.249.132' could not be resolved: Name or service not known2024-03-05T17:20:54.962308Z 247462 Access denied for user 'root'@'91.92.249.132' (using password: NO)2024-03-05T17:22:33.037378Z 247464 IP address '198.235.24.243' could not be resolved: Name or service not known2024-03-05T17:22:43.042407Z 247464 Got timeout reading communication packets2024-03-05T18:25:20.331845Z 247465 Access denied for user 'root'@'91.92.249.132' (using password: NO)2024-03-05T18:28:14.863455Z 0 Giving 0 client threads a chance to die gracefully2024-03-05T18:28:14.863490Z 0 Shutting down slave threads2024-03-05T18:28:14.863499Z 0 Forcefully disconnecting 0 remaining clients2024-03-05T18:28:14.863508Z 0 Event Scheduler: Purging the queue. 0 events2024-03-05T18:28:14.863585Z 0 Binlog end
您好，根据这个命令把您的数据库错误的日志信息截图发出来
cat /www/server/data/*.err|grep -i -C 10 error 大炮运维V587 发表于 2024-3-7 09:05
您好，根据这个命令把您的数据库错误的日志信息截图发出来
上面就是输入这个命令出来的截图内容，截图不知道为啥发不出来，说太大了，超过字节数。
另外说明的是，这个数据库我就把root账号下的host改为了%（不然不知道为什么访问不到这个数据库），其他没有什么改动操作 以上是错误日志截图，数据库自动停止，数据库里的数据全部被删除，且宝塔登录都需要重新数据账号密码。
大炮运维V587 发表于 2024-3-7 09:05
您好，根据这个命令把您的数据库错误的日志信息截图发出来
有空回复下问题不 宝塔用户_ywezqf 发表于 2024-3-17 15:42
有空回复下问题不
您好，您的mall_tiny
这个库存在吗？ 大炮运维V587 发表于 2024-3-18 16:07
您好，您的mall_tiny
这个库存在吗？
一直都会存在，就是库里添加的数据莫名其妙都被删除了。 宝塔用户_ywezqf 发表于 2024-3-18 20:26
一直都会存在，就是库里添加的数据莫名其妙都被删除了。
数据库错误日志中搜下 shutdown 这个关键词，把最新生成的截图发出来 大炮运维V587 发表于 2024-3-29 17:36
数据库错误日志中搜下 shutdown 这个关键词，把最新生成的截图发出来
这是最近一次重启数据库后又被删除数据库的错误日志，有shutdown相关字眼的就这一个。
大炮运维V587 发表于 2024-3-29 17:36
数据库错误日志中搜下 shutdown 这个关键词，把最新生成的截图发出来
仔细看了下这里也有些shutdown相关信息
宝塔用户_ywezqf 发表于 2024-3-31 13:01
仔细看了下这里也有些shutdown相关信息
您好，您这个是做了数据库主从吗？ 大炮运维V587 发表于 2024-4-10 14:22
您好，您这个是做了数据库主从吗？
没有做数据库主从 你好 解决了吗 宝塔用户_ivvmnq 发表于 2024-5-7 19:49
你好 解决了吗
解决了，有可能是做了数据库主从的原因，也有可能是数据库root账号下的host改为了全部网址可访问（%）的问题，我把两个都修改后，现在正常运行了。感谢:lol
页:
[1]