AMH开源社区

AMH社区 - 开放自由有价值的社区

[求助帖] 您当前系统无法正常工作,请排查解决:Can't connect to local MySQL server through socket '/tmp/mysql

saolia
铁牌会员
0.00 价值分

13,156 次阅读   13 张回复   saolia 发表于 2017-03-31 12:02:47
您当前系统无法正常工作,请排查解决:Can't connect to local MySQL server through socket '/tmp/mysql-generic-5.5.sock' (2) Mysql链接出错,请配置/Amysql/config.php文件。

/etc/init.d/amh-start 命令错误全是一个数据库的:

170331 0:13:35 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:35 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:13:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:48 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:13:48 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:59 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:13:59 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:16:44 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:16:44 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:16:54 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:16:54 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:17:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:17:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:17:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:17:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:17:40 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:17:40 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 9:12:28 [Warning] Disk is full writing './taovr/wp_posts.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:12:28 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:13:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:13:32 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:23:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:23:32 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:33:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:33:32 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:43:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:43:32 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:53:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:53:32 [Warning] Retry in 60 sec170331 09:58:48 mysqld_safe Starting mysqld daemon with databases from /home/usrdata/mysql-generic-5.5

170331 0:13:35 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:35 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:13:36 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:13:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:48 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:13:48 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:13:59 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:13:59 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:16:44 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:16:44 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:16:54 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:16:54 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:17:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:17:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:17:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:17:37 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 0:17:40 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_postmeta' is marked as crashed and should be repaired
170331 0:17:40 [ERROR] /usr/local/mysql-generic-5.5/bin/mysqld: Table './taovrr/wp_posts' is marked as crashed and should be repaired
170331 9:12:28 [Warning] Disk is full writing './taovr/wp_posts.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:12:28 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:13:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:13:32 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:23:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:23:32 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:33:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:33:32 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:43:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:43:32 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170331 9:53:32 [Warning] Disk is full writing './mysql-bin.000007' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170331 9:53:32 [Warning] Retry in 60 sec170331 09:58:48 mysqld_safe Starting mysqld daemon with databases from /home/usrdata/mysql-generic-5.5

[OK] pure-ftpd-1.0.36 is already installed.
正在启动 pure-config.pl:Running: /usr/local/pure-ftpd-1.0.36/sbin/pure-ftpd --daemonize -g/usr/local/pure-ftpd-1.0.36/pure-ftpd.pid -S21 -A -c50 -B -C8 -D -E -fftp -H -I15 -lpuredb:/usr/local/pure-ftpd-1.0.36/etc/pureftpd.pdb -lunix -L10000:8 -m4 -s -U133:022 -u100 -k99 -Z -p10100:10180


新手麻烦大神详细些感谢!
评价: 这个问题有价值吗?  没有 (0分)   有, 感谢 (0分)
2017-03-31 12:02:47 1

yanghang
银牌会员
1563.14 价值分

没空间了,先把空间腾出一些来看看,如果有问题再去修复表
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2017-03-31 12:47:32 2

淹死的鱼
铁牌会员
3.44 价值分

看不懂帮顶 看着好复杂
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2017-03-31 13:36:55 3

amysql
创始人
97660.81 价值分

磁盘已没可用空间。

------
mysql没有启动问题。
都可以看,
https://amh.sh/bbs/forum.php?mod=redirect&goto=findpost&ptid=5173&pid=34859

都一一执行排查看返回有哪些结果。
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2017-03-31 15:10:58 4

飒丶
铁牌会员
6.00 价值分

引用:
amysql 发表于 2017-03-31 15:10:58
磁盘已没可用空间。

------
mysql没有启动问题。
都可以看,
https://amh.sh/bbs/forum.php?mod=redirect&goto=findpost&ptid=...



5.3也出现了类似问题...但不知道怎么解决
提示是:
您当前系统无法正常工作,请排查解决:No such file or directory Mysql链接出错,请配置/Amysql/config.php文件。
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2017-05-14 20:37:07 5

飒丶
铁牌会员
6.00 价值分

引用:
amysql 发表于 2017-03-31 15:10:58
磁盘已没可用空间。

------
mysql没有启动问题。
都可以看,
https://amh.sh/bbs/forum.php?mod=redirect&goto=findpost&ptid=...


查找的执行结果是
find / -name my.cnf
/usr/local/mysql-5.6/mysql-test/suite/federated/my.cnf
/usr/local/mysql-5.6/mysql-test/suite/rpl_ndb/my.cnf
/usr/local/mysql-5.6/mysql-test/suite/ndb_team/my.cnf
/usr/local/mysql-5.6/mysql-test/suite/ndb_binlog/my.cnf
/usr/local/mysql-5.6/mysql-test/suite/ndb_big/my.cnf
/usr/local/mysql-5.6/mysql-test/suite/ndb_rpl/my.cnf
/usr/local/mysql-5.6/mysql-test/suite/rpl/my.cnf
/usr/local/mysql-5.6/mysql-test/suite/rpl/extension/bhs/my.cnf
/usr/local/mysql-5.6/mysql-test/suite/ndb/my.cnf
/usr/local/mysql-5.6/my.cnf
/root/amh/modules/mysql-5.6/my.cnf
求大大告诉下什么原因...打不开后台了
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2017-05-14 20:43:55 6

9513645
银牌会员
1428.02 价值分

引用:
飒丶 发表于 2017-05-14 20:37:07
5.3也出现了类似问题...但不知道怎么解决
提示是:
您当前系统无法正常工作,请排查解决:No such file or directory Mysql链接出错,请配置/Amysql/conf...



SQL 没有启动,

ssh重启 amh mysql start
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2017-05-15 00:04:30 7

yanghang
银牌会员
1563.14 价值分

这个不一定是没启动,可能是有问题启动不了了
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2017-05-15 09:20:04 8

飒丶
铁牌会员
6.00 价值分

引用:
yanghang 发表于 2017-05-15 09:20:04
这个不一定是没启动,可能是有问题启动不了了

启动报[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
第一次修改my.cnf 添加了explicit_defaults_for_timestamp=true可以启动...今天再次出现这个问题...
报错不变...但启动不了了
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2017-05-15 09:47:57 9

yanghang
银牌会员
1563.14 价值分

这个报警应该不会影响mysql启动才对
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2017-05-15 16:30:31 10
 1 2 >  (总2页)
AMH社区列表
旅客不可参与帖子, 请您先登录
用户服务中心