mysql server not starting

Posts regarding the MySQL database server
Post Reply
mister_v
Posts: 184
Joined: Thu Mar 04, 2010 9:19 pm

mysql server not starting

Post by mister_v »

Hi,
after a reboot of my machine mysql is not strating.
I tried it with

Code: Select all

/etc/init.d/mysql start
It tries to start for about 10min,
and then goes down again.


The log file /var/log/mysql/mysqld.err,
Doesn't give much info

Code: Select all

2016-12-30 22:54:37 19461 [Note] InnoDB: FTS optimize thread exiting.
2016-12-30 22:54:37 19461 [Note] InnoDB: Starting shutdown...
2016-12-30 22:54:39 19461 [Note] InnoDB: Shutdown completed; log sequence number 303644152193
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'BLACKHOLE'
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'ARCHIVE'
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'MRG_MYISAM'
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'MyISAM'
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'MEMORY'
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'CSV'
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'sha256_password'
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'mysql_old_password'
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'mysql_native_password'
2016-12-30 22:54:39 19461 [Note] Shutting down plugin 'binlog'
2016-12-30 22:54:39 19461 [Note] /usr/sbin/mysqld: Shutdown complete


Anyone has any ideas?
mister_v
Posts: 184
Joined: Thu Mar 04, 2010 9:19 pm

Re: mysql server not starting

Post by mister_v »

I looked further in the log file and found my problem:

Code: Select all

2016-12-30 22:54:37 19461 [Note] InnoDB: 5.6.34 started; log sequence number 303644152183
2016-12-30 22:54:37 19461 [ERROR] I/O error reading the header from the binary log, errno=175, io cache code=0
2016-12-30 22:54:37 19461 [ERROR] I/O error reading the header from the binary log
2016-12-30 22:54:37 19461 [ERROR] Can't init tc log
2016-12-30 22:54:37 19461 [ERROR] Aborting

2016-12-30 22:54:37 19461 [Note] Binlog end
2016-12-30 22:54:37 19461 [Note] Shutting down plugin 'partition'
2016-12-30 22:54:37 19461 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
Used to delete the log files in the MySQL data-directory (mysqld-bin.0xxxx)
because there were too many and just taking up space.
but I did not update mysqld-bin.index.
apparently MySQl tries to use these files and when it can't, it doesn't start.

I emptied the file mysqld-bin.index,
and restart the MySQL-deamon -> works
Post Reply