mysql - MySQL CentOS6将不会启动( 无法通过套接字'/var/lib/mysql/mysql.sock'连接到本地MySQL服务器( 111 ) )

  显示原文与译文双语对照的内容
0 0

昨晚以来,我一直在我的VPS上获取数据库连接错误。

当我尝试重新启动MySQL服务时,我得到'无法通过套接字'/var/lib/mysql/mysql.sock'连接到本地MySQL服务器( 111 )"'

日志具有下列内容


Thread pointer: 0x2e0c0f0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7ffffa49de18 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x85c02e]
/usr/sbin/mysqld(handle_fatal_signal+0x41a)[0x6b680a]
/lib64/libpthread.so.0[0x3ffbc0f500]
/lib64/libc.so.6(gsignal+0x35)[0x3ffb4328e5]
/lib64/libc.so.6(abort+0x175)[0x3ffb4340c5]
/usr/sbin/mysqld(fil_io+0x34e)[0x77bfce]
/usr/sbin/mysqld[0x7646b0]
/usr/sbin/mysqld(buf_read_page+0x21d)[0x76508d]
/usr/sbin/mysqld(buf_page_get_gen+0x373)[0x75ec63]
/usr/sbin/mysqld(flst_insert_before+0x25d)[0x7856bd]
/usr/sbin/mysqld(trx_purge_add_update_undo_to_history+0xf9)[0x7dc909]
/usr/sbin/mysqld(trx_undo_update_cleanup+0x29)[0x7ebb29]
/usr/sbin/mysqld(trx_commit_off_kernel+0x1b5)[0x7ea605]
/usr/sbin/mysqld(trx_sig_start_handle+0x1f3)[0x7eacf3]
/usr/sbin/mysqld[0x7b32fb]
/usr/sbin/mysqld(que_run_threads+0x117)[0x7b34c7]
/usr/sbin/mysqld(que_eval_sql+0x76)[0x7b3cf6]
/usr/sbin/mysqld(row_drop_table_for_mysql+0x391)[0x7bfba1]
/usr/sbin/mysqld(_ZN11ha_innobase12delete_tableEPKc+0xe7)[0x7471f7]
/usr/sbin/mysqld(_Z19mysql_rm_tmp_tablesv+0x26d)[0x61602d]
/usr/sbin/mysqld(main+0x52d)[0x5d8e2d]
/lib64/libc.so.6(__libc_start_main+0xfd)[0x3ffb41ecdd]
/usr/sbin/mysqld[0x529d59]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): is an invalid pointer
Connection ID (thread ID): 0
Status: NOT_KILLED

我已经在这里搜索了许多建议的解决方案,但是希望有人能够根据日志向我指出正确的方向。

真正的损失。

先谢谢了。

时间: 原作者:

0 0

昨晚在centos操作系统上遇到同样的问题。 重新启动VPS并重新联机。

原作者:
...