Mysql restarts automatically

  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql restarts automatically

    My SQL server restarts automatically, when i saw the error log I found the following lines

    Number of processes running now: 0
    091017 16:03:47 mysqld restarted
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    091017 16:03:47 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    InnoDB: Last MySQL binlog file position 0 9718618, file name ./mysql-bin.000088
    091017 16:03:48 InnoDB: Started; log sequence number 0 407054
    091017 16:03:48 [Note] Recovering after a crash using mysql-bin
    091017 16:03:50 [Note] Starting crash recovery...
    091017 16:03:50 [Note] Crash recovery finished.
    091017 16:03:51 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.0.67-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

    Please help me to get out of this problem.

    Thank You

  • #2
    Please ......Reinstall your MySQL Server....
    Then check....