Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2006
    Posts
    466

    MySQL getting started and stopped all the time (by Innodb ?)

    MySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:

    070106 14:40:25 InnoDB: Started; log sequence number 5 959534492
    /usr/sbin/mysqld: ready for connections.
    Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$
    A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
    070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown
    070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted
    070106 14:40:40 InnoDB: Starting shutdown...
    070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492
    070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete
    070106 14:40:42 mysqld ended
    070106 14:40:42 mysqld started
    070106 14:40:42 InnoDB: Started; log sequence number 5 959534492

    Any ideas ?

  2. #2
    Join Date
    Jan 2004
    Location
    North Yorkshire, UK
    Posts
    4,163
    >A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007

    That would probably indicate that it's being done by a cron, have you checked there aren't any crons running?

    Dan

  3. #3
    Join Date
    Feb 2006
    Posts
    466
    Bingo...cron is causing the issue. But I really wonder why because none of the lines in /etc/crontab could trigger the issue... Maybe one of my customer's cronjob.

  4. #4
    Join Date
    Feb 2006
    Posts
    466
    With cron being on the issue occurs pretty much exactly every 20 seconds.

  5. #5
    Join Date
    Feb 2006
    Posts
    466
    Ah damn... I know what it is ! I had set up a MySQL database that a perl script would query for monitoring reasons. Then I forgot about it and a few days ago I found that database and wondered what it was so I deleted it because I thought I didn't need it. Now my monitoring script would restart MySQL every 20 seconds... LOL !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •