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

问题背景：客户反馈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 再次尝试启动成功