List:General Discussion« Previous MessageNext Message »
From:a.smith Date:September 7 2011 5:21pm
Subject:MySQL daemons restarting every 7 minutes
View as plain text  
Hi,

   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.



Thread
MySQL daemons restarting every 7 minutesa.smith7 Sep
  • Re: MySQL daemons restarting every 7 minutesSuresh Kuna9 Sep
    • Re: MySQL daemons restarting every 7 minutesa.smith9 Sep
      • Re: MySQL daemons restarting every 7 minutesSuresh Kuna9 Sep
        • Re: MySQL daemons restarting every 7 minutesa.smith9 Sep
          • Re: MySQL daemons restarting every 7 minutesReindl Harald9 Sep
            • Re: MySQL daemons restarting every 7 minutesa.smith9 Sep
              • Re: MySQL daemons restarting every 7 minutesSuresh Kuna10 Sep
                • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                  • Re: MySQL daemons restarting every 7 minuteswalter harms10 Sep
                    • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                      • Re: MySQL daemons restarting every 7 minuteswalter harms10 Sep
                        • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                          • Re: MySQL daemons restarting every 7 minuteswalter harms10 Sep
                            • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                              • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                                • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                                  • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                            • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                              • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                  • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                    • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep