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

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

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

 

尝试直接启动

1 [root@host-10-10-208-42 data]# 2019-11-28T00:19:26.425020Z mysqld_safe Logging to '/data/mysql/log/error.log'.
2 2019-11-28T00:19:26.477312Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/data
3 2019-11-28T00:19:28.385703Z mysqld_safe mysqld from pid file /data/mysql/mysql.pid ended
4 
5 [1]+ Done cd /usr/local/mysql && ./bin/mysqld_safe


查看error日志

复制代码
 1 Attempting backtrace. You can use the following information to find out
 2 where mysqld died. If you see no messages after this, something went
 3 terribly wrong...
 4 stack_bottom = 7fabd5396dd8 thread_stack 0x40000
 5 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xf4e815]
 6 /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x4a4)[0x7d1be4]
 7 /lib64/libpthread.so.0[0x306580f790]
 8 /lib64/libc.so.6(gsignal+0x35)[0x3065432625]
 9 /lib64/libc.so.6(abort+0x175)[0x3065433e05]
10 /usr/local/mysql/bin/mysqld(_Z18ut_print_timestampP8_IO_FILE+0x0)[0x7c0ffe]
11 /usr/local/mysql/bin/mysqld(_Z20btr_cur_latch_leavesP11buf_block_tRK9page_id_tRK11page_size_tmP9btr_cur_tP5mtr_t+0
12 x7ac)[0x117b23c]
13 /usr/local/mysql/bin/mysqld(_Z27btr_cur_search_to_nth_levelP12dict_index_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_
14 tmPKcmP5mtr_t+0x233b)[0x118787b]
15 /usr/local/mysql/bin/mysqld(_Z22row_search_index_entryP12dict_index_tPK8dtuple_tmP10btr_pcur_tP5mtr_t+0x13b)[0x10e
16 2e7b]
17 /usr/local/mysql/bin/mysqld[0x10e0012]
18 /usr/local/mysql/bin/mysqld(_Z14row_purge_stepP9que_thr_t+0xa1d)[0x10e224d]
19 /usr/local/mysql/bin/mysqld(_Z15que_run_threadsP9que_thr_t+0x9bf)[0x1098a7f]
20 /usr/local/mysql/bin/mysqld(srv_worker_thread+0x100)[0x1111be0]
21 /lib64/libpthread.so.0[0x3065807a51]
22 /lib64/libc.so.6(clone+0x6d)[0x30654e896d]
23 
24 Trying to get some variables.
25 Some pointers may be invalid and cause the dump to abort.
26 Query (0): is an invalid pointer
27 Connection ID (thread ID): 0
28 Status: NOT_KILLED
29 
30 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
31 information that should help you find out what is causing the crash.
复制代码

 

解决方式
datadir
/data/mysql/data

ib_logfile0和ib_logfile1

1 mv ib_logfile0 ib_logfile0_bak

posted on   数据与人文  阅读(1099)  评论(0编辑  收藏  举报

编辑推荐:
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
阅读排行:
· 分享4款.NET开源、免费、实用的商城系统
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

统计

点击右上角即可分享
微信分享提示