mysql 一種crash的解決方法

來源:本站原創 Linux 超過984 views圍觀 0條評論

報錯日志如下,數據庫無法起來

Thread pointer: 0x0
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 = 0x0 thread_stack 0x48000
/usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x7f176b69b96d]
/usr/libexec/mysqld(handle_fatal_signal+0x515)[0x7f176b2b1285]
/lib64/libpthread.so.0(+0xf370)[0x7f176a9e0370]
/lib64/libc.so.6(gsignal+0x37)[0x7f176918f1d7]
/lib64/libc.so.6(abort+0x148)[0x7f17691908c8]
/usr/libexec/mysqld(+0x6920d5)[0x7f176b4a10d5]
/usr/libexec/mysqld(+0x6a38b7)[0x7f176b4b28b7]
/usr/libexec/mysqld(+0x68ca17)[0x7f176b49ba17]
/usr/libexec/mysqld(+0x679e25)[0x7f176b488e25]
/usr/libexec/mysqld(+0x624dd0)[0x7f176b433dd0]
/usr/libexec/mysqld(+0x750760)[0x7f176b55f760]
/usr/libexec/mysqld(+0x750c38)[0x7f176b55fc38]
/usr/libexec/mysqld(+0x748b61)[0x7f176b557b61]
/usr/libexec/mysqld(+0x73c816)[0x7f176b54b816]
/usr/libexec/mysqld(+0x64edcd)[0x7f176b45ddcd]
/usr/libexec/mysqld(+0x64f4a6)[0x7f176b45e4a6]
/lib64/libpthread.so.0(+0x7dc5)[0x7f176a9d8dc5]
/lib64/libc.so.6(clone+0x6d)[0x7f176925173d]
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.————crash———–
170927 19:20:03 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
[[email protected] ~]# df -h
Filesystem           Size  Used Avail Use% Mounted on
/dev/mapper/cl-root   17G  2.1G   15G  13% /
devtmpfs             1.9G     0  1.9G   0% /dev
tmpfs                1.9G   12K  1.9G   1% /dev/shm
tmpfs                1.9G  8.7M  1.9G   1% /run
tmpfs                1.9G     0  1.9G   0% /sys/fs/cgroup
/dev/sda1           1014M  184M  831M  19% /boot
tmpfs                378M     0  378M   0% /run/user/0
[[email protected] ~]#
[[email protected] ~]#
[[email protected] ~]#
[[email protected] ~]#
[[email protected] ~]# find / -name ibdata*     因數據損壞,導致無法重啟,刪掉下面文件即可.
/var/lib/mysql/ibdata1
[[email protected] ~]# find / -name ib_logfile*
/var/lib/mysql/ib_logfile0
/var/lib/mysql/ib_logfile1
[[email protected] ~]# rm -rf /var/lib/mysql/ibdata1
[[email protected] ~]# rm -rf /var/lib/mysql/ib_logfile0
[[email protected] ~]# rm -rf /var/lib/mysql/ib_logfile1
[[email protected] ~]#
[[email protected] ~]#
systemctl restart mariadb  重起成功
[[email protected] ~]#

文章出自:CCIE那點事 http://www.qdxgqk.live/ 版權所有。本站文章除注明出處外,皆為作者原創文章,可自由引用,但請注明來源。 禁止全文轉載。
本文鏈接:http://www.qdxgqk.live/?p=3572轉載請注明轉自CCIE那點事
如果喜歡:點此訂閱本站
上篇文章:
?
?
萌宠夺宝游戏