Page 1 of 1

MySQL shutdown unexpectyedly

PostPosted: 08. January 2014 02:01
by starburstq
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'
...

Re: MySQL shutdown unexpectyedly

PostPosted: 08. January 2014 02:06
by JJ_Tagy
starburstq wrote:...
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
...

There's more in that window than this. If you don't see any specific error message, run the control panel with admin rights, and attempt to start. Then copy/paste entire log window (not just the snippet).

Re: MySQL shutdown unexpectyedly

PostPosted: 08. January 2014 02:17
by starburstq
.

Re: MySQL shutdown unexpectyedly

PostPosted: 08. January 2014 02:26
by starburstq
Deleted my previous post in favor of this one: I realized there's a debug mode.

6:25:55 PM [main] Initializing Control Panel
6:25:55 PM [main] Windows Version: Windows 7 Home Premium SP1 64-bit
6:25:55 PM [main] XAMPP Version: 1.8.3
6:25:55 PM [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
6:25:55 PM [main] Running with Administrator rights - good!
6:25:55 PM [main] XAMPP Installation Directory: "c:\xampp\"
6:25:55 PM [main] Checking for prerequisites
6:25:55 PM [main] All prerequisites found
6:25:55 PM [main] Initializing Modules
6:25:55 PM [Apache] Initializing module...
6:25:55 PM [Apache] Checking for module existence...
6:25:55 PM [Apache] Checking for required tools...
6:25:55 PM [Apache] Checking for service (name="Apache2.4"): Service installed
6:25:55 PM [Apache] Service Path: "C:\xampp\apache\bin\httpd.exe" -k runservice
6:25:55 PM [Apache] Checking default ports...
6:25:55 PM [mysql] Initializing module...
6:25:55 PM [mysql] Checking for module existence...
6:25:55 PM [mysql] Checking for required tools...
6:25:55 PM [mysql] Checking for service (name="mysql"): Service installed
6:25:55 PM [mysql] Service Path: C:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql
6:25:55 PM [mysql] Checking default ports...
6:25:55 PM [main] The FileZilla module is disabled
6:25:55 PM [main] The Mercury module is disabled
6:25:55 PM [main] The Tomcat module is disabled
6:25:55 PM [main] Enabling autostart for module "Apache"
6:25:55 PM [main] Enabling autostart for module "MySQL"
6:25:55 PM [main] Starting Check-Timer
6:25:55 PM [main] Control Panel Ready
6:25:56 PM [Apache] Autostart active: starting...
6:25:56 PM [Apache] Checking default ports...
6:25:56 PM [Apache] Attempting to start Apache service...
6:25:56 PM [Apache] Executing "net start "Apache2.4""
6:25:56 PM [Apache] Status change detected: running
6:25:56 PM [mysql] Autostart active: starting...
6:25:56 PM [mysql] Checking default ports...
6:25:56 PM [mysql] Attempting to start MySQL service...
6:25:56 PM [mysql] Executing "net start "mysql""
6:25:57 PM [mysql] Status change detected: running
6:26:02 PM [mysql] Status change detected: stopped
6:26:02 PM [mysql] Error: MySQL shutdown unexpectedly.
6:26:02 PM [mysql] This may be due to a blocked port, missing dependencies,
6:26:02 PM [mysql] improper privileges, a crash, or a shutdown by another method.
6:26:02 PM [mysql] Press the Logs button to view error logs and check
6:26:02 PM [mysql] the Windows Event Viewer for more clues
6:26:02 PM [mysql] If you need more help, copy and post this
6:26:02 PM [mysql] entire log window on the forums
6:26:04 PM [mysql] Return code: 0
6:26:04 PM [Apache] Return code: 0