MySQL shutdown unexpectyedly
Posted: 08. January 2014 02:01
Just installed XAMPP Control Panel. Got Apache running, but MySQL doesn't seem to want to play nice. Any help would be appreciated.
Here's the output:
Attempting to start MySQL service...
5:55:47 PM [mysql] Status change detected: running
5:55:52 PM [mysql] Status change detected: stopped
5:55:52 PM [mysql] Error: MySQL shutdown unexpectedly.
5:55:52 PM [mysql] This may be due to a blocked port, missing dependencies,
5:55:52 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:55:52 PM [mysql] Press the Logs button to view error logs and check
5:55:52 PM [mysql] the Windows Event Viewer for more clues
5:55:52 PM [mysql] If you need more help, copy and post this
5:55:52 PM [mysql] entire log window on the forums
And here's the log:
2013-12-24 16:53:59 2884 [Note] Plugin 'FEDERATED' is disabled.
2013-12-24 16:54:00 b5c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-12-24 16:54:00 2884 [Note] InnoDB: The InnoDB memory heap is disabled
2013-12-24 16:54:00 2884 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-12-24 16:54:00 2884 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-12-24 16:54:00 2884 [Note] InnoDB: Not using CPU crc32 instructions
2013-12-24 16:54:00 2884 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-12-24 16:54:00 2884 [Note] InnoDB: Completed initialization of buffer pool
2013-12-24 16:54:00 2884 [Note] InnoDB: Highest supported file format is Barracuda.
2013-12-24 16:54:01 2884 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=1625987
2013-12-24 16:54:01 2884 [Warning] InnoDB: Starting to delete and rewrite log files.
2013-12-24 16:54:01 2884 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2013-12-24 16:54:01 2884 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
2013-12-24 16:54:01 2884 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2013-12-24 16:54:01 2884 [Warning] InnoDB: New log files created, LSN=1625987
2013-12-24 16:54:01 2884 [Note] InnoDB: 128 rollback segment(s) are active.
2013-12-24 16:54:01 2884 [Note] InnoDB: Waiting for purge to start
2013-12-24 16:54:01 2884 [Note] InnoDB: 5.6.14 started; log sequence number 1625987
2013-12-24 16:54:02 2884 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a9f27fcc-6cf6-11e3-8964-842b2b9bacef.
2013-12-24 16:54:02 2884 [Note] Server hostname (bind-address): '*'; port: 3306
2013-12-24 16:54:02 2884 [Note] IPv6 is available.
2013-12-24 16:54:02 2884 [Note] - '::' resolves to '::';
2013-12-24 16:54:02 2884 [Note] Server socket created on IP: '::'.
2013-12-24 16:54:02 2884 [Note] Event Scheduler: Loaded 0 events
2013-12-24 16:54:02 2884 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.14' socket: '' port: 3306 MySQL Community Server (GPL)
2013-12-24 17:59:36 2884 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown
2013-12-24 17:59:36 2884 [Note] Giving 0 client threads a chance to die gracefully
2013-12-24 17:59:36 2884 [Note] Event Scheduler: Purging the queue. 0 events
2013-12-24 17:59:36 2884 [Note] Shutting down slave threads
2013-12-24 17:59:36 2884 [Note] Forcefully disconnecting 0 remaining clients
2013-12-24 17:59:36 2884 [Note] Binlog end
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'partition'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
...
Here's the output:
Attempting to start MySQL service...
5:55:47 PM [mysql] Status change detected: running
5:55:52 PM [mysql] Status change detected: stopped
5:55:52 PM [mysql] Error: MySQL shutdown unexpectedly.
5:55:52 PM [mysql] This may be due to a blocked port, missing dependencies,
5:55:52 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:55:52 PM [mysql] Press the Logs button to view error logs and check
5:55:52 PM [mysql] the Windows Event Viewer for more clues
5:55:52 PM [mysql] If you need more help, copy and post this
5:55:52 PM [mysql] entire log window on the forums
And here's the log:
2013-12-24 16:53:59 2884 [Note] Plugin 'FEDERATED' is disabled.
2013-12-24 16:54:00 b5c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-12-24 16:54:00 2884 [Note] InnoDB: The InnoDB memory heap is disabled
2013-12-24 16:54:00 2884 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-12-24 16:54:00 2884 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-12-24 16:54:00 2884 [Note] InnoDB: Not using CPU crc32 instructions
2013-12-24 16:54:00 2884 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-12-24 16:54:00 2884 [Note] InnoDB: Completed initialization of buffer pool
2013-12-24 16:54:00 2884 [Note] InnoDB: Highest supported file format is Barracuda.
2013-12-24 16:54:01 2884 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=1625987
2013-12-24 16:54:01 2884 [Warning] InnoDB: Starting to delete and rewrite log files.
2013-12-24 16:54:01 2884 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2013-12-24 16:54:01 2884 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
2013-12-24 16:54:01 2884 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2013-12-24 16:54:01 2884 [Warning] InnoDB: New log files created, LSN=1625987
2013-12-24 16:54:01 2884 [Note] InnoDB: 128 rollback segment(s) are active.
2013-12-24 16:54:01 2884 [Note] InnoDB: Waiting for purge to start
2013-12-24 16:54:01 2884 [Note] InnoDB: 5.6.14 started; log sequence number 1625987
2013-12-24 16:54:02 2884 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a9f27fcc-6cf6-11e3-8964-842b2b9bacef.
2013-12-24 16:54:02 2884 [Note] Server hostname (bind-address): '*'; port: 3306
2013-12-24 16:54:02 2884 [Note] IPv6 is available.
2013-12-24 16:54:02 2884 [Note] - '::' resolves to '::';
2013-12-24 16:54:02 2884 [Note] Server socket created on IP: '::'.
2013-12-24 16:54:02 2884 [Note] Event Scheduler: Loaded 0 events
2013-12-24 16:54:02 2884 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.14' socket: '' port: 3306 MySQL Community Server (GPL)
2013-12-24 17:59:36 2884 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown
2013-12-24 17:59:36 2884 [Note] Giving 0 client threads a chance to die gracefully
2013-12-24 17:59:36 2884 [Note] Event Scheduler: Purging the queue. 0 events
2013-12-24 17:59:36 2884 [Note] Shutting down slave threads
2013-12-24 17:59:36 2884 [Note] Forcefully disconnecting 0 remaining clients
2013-12-24 17:59:36 2884 [Note] Binlog end
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'partition'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-12-24 17:59:36 2884 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
...