as of yesterday the MySQL Daemons keep restarting every 7 mins or
so on one of my FreeBSD servers. The only work carried out recently
related to MySQL on this server was to temporarily disable replication
(its a slave) of one DB, and then re-enable it (via restore of data
and updating the log file and pos).
Now I keep seeing this:
110907 18:03:58 mysqld_safe mysqld restarted
110907 18:03:58 [Note] Plugin 'FEDERATED' is disabled.
110907 18:03:58 InnoDB: Initializing buffer pool, size = 2.0G
110907 18:03:59 InnoDB: Completed initialization of buffer pool
110907 18:03:59 InnoDB: Started; log sequence number 0 44233
110907 18:03:59 [Note] Event Scheduler: Loaded 0 events
110907 18:03:59 [Note] Slave SQL thread initialized, starting
replication in log 'mysql-bin.002818' at position 46048, relay log
'./tau-relay-bin.000037' position: 251
110907 18:03:59 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.1.58' socket: '/tmp/mysql.sock' port: 3306 FreeBSD
110907 18:03:59 [Note] Slave I/O thread: connected to master
'slave@kappa:3306',replication started in log 'mysql-bin.002818' at
Not seeing any other info, such as why the daemons stopped, just this
repeated over and over...
I didn't find much useful info searching on the internet, came up with this:
but its an unresolved bug.
I have tried, restoring all DBs from a working server and that didn't
work. So wouldnt seem to be related to the contents of the databases.
System is FreeBSD 8.2 amd64, MySQL 5.1.58 (I upgrade this from 5.1.51
as a try and fix it quick approach but no joy).
Any one chip in from experience what this may be?? I'm considering
upgrading to 5.5 to give that a try...
thanks in advance,