MySQL Daemon failed to start.

General support questions
Post Reply
crachbach12
Posts: 1
Joined: 2018/05/18 17:45:57

MySQL Daemon failed to start.

Post by crachbach12 » 2018/05/18 17:54:20

This is my first post to ask for help, so I hope I can help you help me .

[root@vmi183370 ~]# service mysqld restart
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
[root@vmi183370 ~]#





----------------------------------------------------------------------
when I pull mysqld.log I see the following:
nano /var/log/mysqld.log



180518 15:15:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180518 15:15:19 InnoDB: Initializing buffer pool, size = 8.0M
180518 15:15:19 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 3051272819
180518 15:15:19 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 3051276083
180518 15:15:20 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 $
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=8384512
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 338336 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.


------------------------------------------------
when I pull tail I see the following:

tail /var/log/mysqld.log




[root@vmi183370 ~]# tail /var/log/mysqld.log
/usr/libexec/mysqld() [0x787c3d]
/usr/libexec/mysqld(recv_recover_page+0x34f) [0x7896ff]
/usr/libexec/mysqld(buf_page_io_complete+0x548) [0x74aab8]
/usr/libexec/mysqld(fil_aio_wait+0xfa) [0x762c6a]
/usr/libexec/mysqld() [0x7c8ce0]
/lib64/libpthread.so.0() [0x3386807aa1]
/lib64/libc.so.6(clone+0x6d) [0x33864e8bcd]
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.
180518 17:47:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended



please help
Best regards

Post Reply