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 port: mysql-server-5.1.58 110907 18:03:59 [Note] Slave I/O thread: connected to master 'slave@kappa:3306',replication started in log 'mysql-bin.002818' at position 46048
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:
http://bugs.mysql.com/bug.php?id=26895
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,
Andy.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Sep 09
Suresh Kuna Re: MySQL daemons restarting every 7 minutes
Sep 09, 2011; 10:13
Suresh Kuna
Re: MySQL daemons restarting every 7 minutes
Sep 09
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 09, 2011; 11:46
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 09
Suresh Kuna Re: MySQL daemons restarting every 7 minutes
Sep 09, 2011; 20:42
Suresh Kuna
Re: MySQL daemons restarting every 7 minutes
Sep 09
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 09, 2011; 17:30
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 09
Reindl Harald Re: MySQL daemons restarting every 7 minutes
Sep 09, 2011; 18:49
Reindl Harald
Re: MySQL daemons restarting every 7 minutes
Sep 09
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 09, 2011; 18:07
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 10
Suresh Kuna Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 09:53
Suresh Kuna
Re: MySQL daemons restarting every 7 minutes
Sep 10
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 12:24
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 10
Reindl Harald Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 13:50
Reindl Harald
Re: MySQL daemons restarting every 7 minutes
Sep 10
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 15:07
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 10
walter harms Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 16:16
walter harms
Re: MySQL daemons restarting every 7 minutes
Sep 10
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 15:25
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 10
Reindl Harald Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 16:45
Reindl Harald
Re: MySQL daemons restarting every 7 minutes
Sep 10
walter harms Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 16:52
walter harms
Re: MySQL daemons restarting every 7 minutes
Sep 10
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 15:54
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 10
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 16:32
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 10
walter harms Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 18:21
walter harms
Re: MySQL daemons restarting every 7 minutes
Sep 10
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 17:52
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 10
Reindl Harald Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 18:57
Reindl Harald
Re: MySQL daemons restarting every 7 minutes
Sep 10
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 18:02
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 10
Reindl Harald Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 19:12
Reindl Harald
Re: MySQL daemons restarting every 7 minutes
Sep 10
a.smith Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 18:21
a.smith
Re: MySQL daemons restarting every 7 minutes
Sep 10
Reindl Harald Re: MySQL daemons restarting every 7 minutes
Sep 10, 2011; 19:30
Reindl Harald
Re: MySQL daemons restarting every 7 minutes
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!