Mysql not starting

MySQL & MariaDB Other MySQL® Questions
1

Hi there

I’m new to mysql and i have no clue what is going on. When i try to start it, it fails and here is the content of log file:

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 = 0 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x35)[0x7ab385]
/usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x687584]
/lib64/libpthread.so.0(+0xf500)[0x7fc2a08d5500]
/lib64/libc.so.6(gsignal+0x35)[0x7fc29fa9d8a5]
/lib64/libc.so.6(abort+0x175)[0x7fc29fa9f085]
/usr/sbin/mysqld[0x8bdbe1]
/usr/sbin/mysqld[0x897933]
/usr/sbin/mysqld[0x898410]
/usr/sbin/mysqld[0x887dab]
/usr/sbin/mysqld[0x875166]
/usr/sbin/mysqld[0x823542]
/usr/sbin/mysqld[0x9273d3]
/usr/sbin/mysqld[0x8756f2]
/usr/sbin/mysqld[0x8233f7]
/usr/sbin/mysqld[0x92757e]
/usr/sbin/mysqld[0x92890a]
/usr/sbin/mysqld[0x91cd1f]
/usr/sbin/mysqld[0x843ee7]
/usr/sbin/mysqld[0x83b0bc]
/lib64/libpthread.so.0(+0x7851)[0x7fc2a08cd851]
/lib64/libc.so.6(clone+0x6d)[0x7fc29fb5311d]
You may download the Percona Server operations manual by visiting
. You may find information
in the manual which will help you identify the cause of the crash.
121129 16:09:52 mysqld_safe mysqld from pid file /mnt/opt/mysql/data/tor-web01.be02.achievers.com.pid ended

Here is my version : mysql Ver 14.14 Distrib 5.5.27, for Linux (x86_64) using readline 5.1
on centos 6.3

Thanks!

2

Hi,

Can you tell me how you have installed MySQL? It looks like you didn’t installed debug symbol packages (package contains debug symbols for use debugging the database server) and due to that it’s hard to check this trace.

It would be also helpful if you can provide full error log while restarting MySQL.

3

Hi

In fact it was my DB which was corrupted, so i did ran a backup from the day before and everything is ok now :slight_smile:

Thanks for your help!