MySQL Forums
Forum List  »  General

Error : MySQL shutdown unexpectedly
Posted by: Dhirajkumar Deore
Date: August 10, 2013 03:36AM

i am using xampp and my laptop shutdown unexpectedly and after that mySQL stopped working it generates error...Here is error log ...pls help


Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)
130810 12:14:12 [Note] Plugin 'FEDERATED' is disabled.
130810 12:14:12 InnoDB: The InnoDB memory heap is disabled
130810 12:14:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130810 12:14:12 InnoDB: Compressed tables use zlib 1.2.3
130810 12:14:12 InnoDB: Initializing buffer pool, size = 16.0M
130810 12:14:12 InnoDB: Completed initialization of buffer pool
130810 12:14:12 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130810 12:14:12 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...
130810 12:14:13 InnoDB: Waiting for the background threads to start
130810 12:14:14 InnoDB: 5.5.32 started; log sequence number 1616736
130810 12:14:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130810 12:14:14 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130810 12:14:14 [Note] Server socket created on IP: '0.0.0.0'.
130810 12:14:14 [Note] Event Scheduler: Loaded 0 events
130810 12:14:14 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)
130810 12:22:55 [Warning] IP address '1.93.46.251' could not be resolved: No such host is known.
130810 12:50:28 [Warning] IP address '121.165.104.15' could not be resolved: No such host is known.
130810 14:52:52 [Note] Plugin 'FEDERATED' is disabled.
130810 14:52:52 InnoDB: The InnoDB memory heap is disabled
130810 14:52:52 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130810 14:52:52 InnoDB: Compressed tables use zlib 1.2.3
130810 14:52:52 InnoDB: Initializing buffer pool, size = 16.0M
130810 14:52:52 InnoDB: Completed initialization of buffer pool
130810 14:52:52 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130810 14:52:52 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...
130810 14:52:53 InnoDB: Waiting for the background threads to start
130810 14:52:54 InnoDB: 5.5.32 started; log sequence number 1619083
130810 14:52:54 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130810 14:52:54 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130810 14:52:54 [Note] Server socket created on IP: '0.0.0.0'.
130810 14:52:54 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
130810 14:52:59 [Note] Plugin 'FEDERATED' is disabled.
130810 14:52:59 InnoDB: The InnoDB memory heap is disabled
130810 14:52:59 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130810 14:52:59 InnoDB: Compressed tables use zlib 1.2.3
130810 14:52:59 InnoDB: Initializing buffer pool, size = 16.0M
130810 14:52:59 InnoDB: Completed initialization of buffer pool
130810 14:53:00 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130810 14:53:00 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...
130810 14:53:01 InnoDB: Waiting for the background threads to start
130810 14:53:02 InnoDB: 5.5.32 started; log sequence number 1619083
130810 14:53:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130810 14:53:02 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130810 14:53:02 [Note] Server socket created on IP: '0.0.0.0'.
130810 14:53:02 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
130810 14:54:38 [Note] Plugin 'FEDERATED' is disabled.
130810 14:54:38 InnoDB: The InnoDB memory heap is disabled
130810 14:54:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130810 14:54:38 InnoDB: Compressed tables use zlib 1.2.3
130810 14:54:38 InnoDB: Initializing buffer pool, size = 16.0M
130810 14:54:38 InnoDB: Completed initialization of buffer pool
130810 14:54:38 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130810 14:54:38 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...
130810 14:54:38 InnoDB: Waiting for the background threads to start
130810 14:54:40 InnoDB: 5.5.32 started; log sequence number 1619083
130810 14:54:40 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130810 14:54:40 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130810 14:54:40 [Note] Server socket created on IP: '0.0.0.0'.
130810 14:54:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
130810 14:56:34 [Note] Plugin 'FEDERATED' is disabled.
130810 14:56:34 InnoDB: The InnoDB memory heap is disabled
130810 14:56:34 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130810 14:56:34 InnoDB: Compressed tables use zlib 1.2.3
130810 14:56:34 InnoDB: Initializing buffer pool, size = 16.0M
130810 14:56:34 InnoDB: Completed initialization of buffer pool
130810 14:56:34 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130810 14:56:34 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...
130810 14:56:35 InnoDB: Waiting for the background threads to start
130810 14:56:36 InnoDB: 5.5.32 started; log sequence number 1619083
130810 14:56:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130810 14:56:36 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130810 14:56:36 [Note] Server socket created on IP: '0.0.0.0'.
130810 14:56:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

Options: ReplyQuote


Subject
Written By
Posted
Error : MySQL shutdown unexpectedly
August 10, 2013 03:36AM
September 09, 2013 08:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.