ITPub博客

首页 > 数据库 > MySQL > MySQL启动报错-The server quit without updating PID file[FAILED]mysql/mysql.pid).

MySQL启动报错-The server quit without updating PID file[FAILED]mysql/mysql.pid).

原创 MySQL 作者:DBA_每日记 时间:2019-12-02 09:08:08 0 删除 编辑

问题背景:客户反馈mysql服务启动失败

报错如下

Starting MySQL....The server quit without updating PID file[FAILED]mysql/mysql.pid).


尝试直接启动

[root@host-10-10-208-42 data]# 2019-11-28T00:19:26.425020Z mysqld_safe Logging to '/data/mysql/log/error.log'.

2019-11-28T00:19:26.477312Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/data

2019-11-28T00:19:28.385703Z mysqld_safe mysqld from pid file /data/mysql/mysql.pid ended


[1]+  Done                    cd /usr/local/mysql && ./bin/mysqld_safe


查看error日志

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 = 7fabd5396dd8 thread_stack 0x40000

/usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xf4e815]

/usr/local/mysql/bin/mysqld(handle_fatal_signal+0x4a4)[0x7d1be4]

/lib64/libpthread.so.0[0x306580f790]

/lib64/libc.so.6(gsignal+0x35)[0x3065432625]

/lib64/libc.so.6(abort+0x175)[0x3065433e05]

/usr/local/mysql/bin/mysqld(_Z18ut_print_timestampP8_IO_FILE+0x0)[0x7c0ffe]

/usr/local/mysql/bin/mysqld(_Z20btr_cur_latch_leavesP11buf_block_tRK9page_id_tRK11page_size_tmP9btr_cur_tP5mtr_t+0

x7ac)[0x117b23c]

/usr/local/mysql/bin/mysqld(_Z27btr_cur_search_to_nth_levelP12dict_index_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_

tmPKcmP5mtr_t+0x233b)[0x118787b]

/usr/local/mysql/bin/mysqld(_Z22row_search_index_entryP12dict_index_tPK8dtuple_tmP10btr_pcur_tP5mtr_t+0x13b)[0x10e

2e7b]

/usr/local/mysql/bin/mysqld[0x10e0012]

/usr/local/mysql/bin/mysqld(_Z14row_purge_stepP9que_thr_t+0xa1d)[0x10e224d]

/usr/local/mysql/bin/mysqld(_Z15que_run_threadsP9que_thr_t+0x9bf)[0x1098a7f]

/usr/local/mysql/bin/mysqld(srv_worker_thread+0x100)[0x1111be0]

/lib64/libpthread.so.0[0x3065807a51]

/lib64/libc.so.6(clone+0x6d)[0x30654e896d]


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


The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

information that should help you find out what is causing the crash.



datadir

/data/mysql/data


ib_logfile0和ib_logfile1


mv ib_logfile0 ib_logfile0_bak


再次尝试启动成功 


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/69950231/viewspace-2666409/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2019-10-09

  • 博文量
    110
  • 访问量
    47801