CCIE那点事

报错日志如下,数据库无法起来

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
[root@zabbix01 ~]# 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
[root@zabbix01 ~]#
[root@zabbix01 ~]#
[root@zabbix01 ~]#
[root@zabbix01 ~]#
[root@zabbix01 ~]# find / -name ibdata*     因数据损坏,导致无法重启,删掉下面文件即可.
/var/lib/mysql/ibdata1
[root@zabbix01 ~]# find / -name ib_logfile*
/var/lib/mysql/ib_logfile0
/var/lib/mysql/ib_logfile1
[root@zabbix01 ~]# rm -rf /var/lib/mysql/ibdata1
[root@zabbix01 ~]# rm -rf /var/lib/mysql/ib_logfile0
[root@zabbix01 ~]# rm -rf /var/lib/mysql/ib_logfile1
[root@zabbix01 ~]#
[root@zabbix01 ~]#
systemctl restart mariadb  重起成功
[root@zabbix01 ~]#