HTTPS
AMH 社区首页
AMH社区 - 开放自由有价值的社区
|
|
|---|---|
|
saolia |
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分)
2017-03-31 12:02:47 1
|
|
yanghang |
没空间了，先把空间腾出一些来看看，如果有问题再去修复表
回复
2017-03-31 12:47:32 2
|
|
淹死的鱼 |
看不懂帮顶 看着好复杂
回复
2017-03-31 13:36:55 3
|
|
amysql |
磁盘已没可用空间。
------ mysql没有启动问题。 都可以看， https://amh.sh/bbs/forum.php?mod=redirect&goto=findpost&ptid=5173&pid=34859 都一一执行排查看返回有哪些结果。
回复
2017-03-31 15:10:58 4
AMH面板 - 好用高效低占用、安全可靠极稳定 |
|
飒丶 |
引用: 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文件。
回复
2017-05-14 20:37:07 5
|
|
飒丶 |
引用: 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 求大大告诉下什么原因...打不开后台了
回复
2017-05-14 20:43:55 6
|
|
9513645 |
引用: 飒丶 发表于 2017-05-14 20:37:07 5.3也出现了类似问题...但不知道怎么解决 提示是: 您当前系统无法正常工作，请排查解决：No such file or directory Mysql链接出错，请配置/Amysql/conf... SQL 没有启动， ssh重启 amh mysql start
回复
2017-05-15 00:04:30 7
|
|
yanghang |
这个不一定是没启动，可能是有问题启动不了了
回复
2017-05-15 09:20:04 8
|
|
飒丶 |
引用: 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可以启动...今天再次出现这个问题... 报错不变...但启动不了了
回复
2017-05-15 09:47:57 9
|
|
yanghang |
这个报警应该不会影响mysql启动才对
回复
2017-05-15 16:30:31 10
|
[求助帖]
您当前系统无法正常工作，请排查解决：Can't connect to local MySQL server through socket '/tmp/mysql
