mysql not working. XAMPP 1.8.1, Control Panel 3 [solved]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql not working. XAMPP 1.8.1, Control Panel 3 [solved]

Postby godheaper » 30. October 2012 08:44

when i start the control panel, usually i click each services which is apache and mysql. the apache starts with no problem.
but the mysql has this error. (eventhough yesterday i tried it for the 1st time and starts)

121029 13:39:35 [Note] Plugin 'FEDERATED' is disabled.
121029 13:39:35 InnoDB: The InnoDB memory heap is disabled
121029 13:39:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121029 13:39:35 InnoDB: Compressed tables use zlib 1.2.3
121029 13:39:35 InnoDB: Initializing buffer pool, size = 16.0M
121029 13:39:35 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
121029 13:39:35 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
121029 13:39:36 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
121029 13:39:36 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
121029 13:39:37 InnoDB: Waiting for the background threads to start
121029 13:39:38 InnoDB: 1.1.8 started; log sequence number 0
121029 13:39:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121029 13:39:38 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121029 13:39:38 [Note] Server socket created on IP: '0.0.0.0'.
121029 13:39:40 [Note] Event Scheduler: Loaded 0 events
121029 13:39:40 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
121030 13:43:22 [Note] Plugin 'FEDERATED' is disabled.
121030 13:43:22 InnoDB: The InnoDB memory heap is disabled
121030 13:43:22 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 13:43:22 InnoDB: Compressed tables use zlib 1.2.3
121030 13:43:22 InnoDB: Initializing buffer pool, size = 16.0M
121030 13:43:22 InnoDB: Completed initialization of buffer pool
121030 13:43:22 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!
121030 13:43:22 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...
121030 13:43:23 InnoDB: Waiting for the background threads to start
121030 13:43:24 InnoDB: 1.1.8 started; log sequence number 1620550
121030 13:43:24 [ERROR] Aborting

121030 13:43:24 InnoDB: Starting shutdown...
121030 13:43:24 InnoDB: Shutdown completed; log sequence number 1620550
121030 13:43:24 [Note]
121030 13:43:45 [Note] Plugin 'FEDERATED' is disabled.
121030 13:43:45 InnoDB: The InnoDB memory heap is disabled
121030 13:43:45 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 13:43:45 InnoDB: Compressed tables use zlib 1.2.3
121030 13:43:45 InnoDB: Initializing buffer pool, size = 16.0M
121030 13:43:45 InnoDB: Completed initialization of buffer pool
121030 13:43:45 InnoDB: highest supported file format is Barracuda.
121030 13:43:46 InnoDB: Waiting for the background threads to start
121030 13:43:47 InnoDB: 1.1.8 started; log sequence number 1620550
121030 13:43:47 [ERROR] Aborting

121030 13:43:47 InnoDB: Starting shutdown...
121030 13:43:47 InnoDB: Shutdown completed; log sequence number 1620550
121030 13:43:47 [Note]
121030 13:45:41 [Note] Plugin 'FEDERATED' is disabled.
121030 13:45:41 InnoDB: The InnoDB memory heap is disabled
121030 13:45:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 13:45:41 InnoDB: Compressed tables use zlib 1.2.3
121030 13:45:41 InnoDB: Initializing buffer pool, size = 16.0M
121030 13:45:41 InnoDB: Completed initialization of buffer pool
121030 13:45:41 InnoDB: highest supported file format is Barracuda.
121030 13:45:41 InnoDB: Waiting for the background threads to start
121030 13:45:42 InnoDB: 1.1.8 started; log sequence number 1620550
121030 13:45:42 [ERROR] Aborting

121030 13:45:42 InnoDB: Starting shutdown...
121030 13:45:43 InnoDB: Shutdown completed; log sequence number 1620550
121030 13:45:43 [Note]
121030 13:48:47 [Note] Plugin 'FEDERATED' is disabled.
121030 13:48:47 InnoDB: The InnoDB memory heap is disabled
121030 13:48:47 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 13:48:47 InnoDB: Compressed tables use zlib 1.2.3
121030 13:48:47 InnoDB: Initializing buffer pool, size = 16.0M
121030 13:48:47 InnoDB: Completed initialization of buffer pool
121030 13:48:47 InnoDB: highest supported file format is Barracuda.
121030 13:48:47 InnoDB: Waiting for the background threads to start
121030 13:48:48 InnoDB: 1.1.8 started; log sequence number 1620550
121030 13:48:48 [ERROR] Aborting

121030 13:48:48 InnoDB: Starting shutdown...
121030 13:48:49 InnoDB: Shutdown completed; log sequence number 1620550
121030 13:48:49 [Note]
121030 13:50:21 [Note] Plugin 'FEDERATED' is disabled.
121030 13:50:21 InnoDB: The InnoDB memory heap is disabled
121030 13:50:21 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 13:50:21 InnoDB: Compressed tables use zlib 1.2.3
121030 13:50:21 InnoDB: Initializing buffer pool, size = 16.0M
121030 13:50:21 InnoDB: Completed initialization of buffer pool
121030 13:50:21 InnoDB: highest supported file format is Barracuda.
121030 13:50:21 InnoDB: Waiting for the background threads to start
121030 13:50:22 InnoDB: 1.1.8 started; log sequence number 1620550
121030 13:50:22 [ERROR] Aborting

121030 13:50:22 InnoDB: Starting shutdown...
121030 13:50:23 InnoDB: Shutdown completed; log sequence number 1620550
121030 13:50:23 [Note]
121030 14:17:55 [Note] Plugin 'FEDERATED' is disabled.
121030 14:17:55 InnoDB: The InnoDB memory heap is disabled
121030 14:17:55 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 14:17:55 InnoDB: Compressed tables use zlib 1.2.3
121030 14:17:55 InnoDB: Initializing buffer pool, size = 16.0M
121030 14:17:55 InnoDB: Completed initialization of buffer pool
121030 14:17:56 InnoDB: highest supported file format is Barracuda.
121030 14:17:56 InnoDB: Waiting for the background threads to start
121030 14:17:57 InnoDB: 1.1.8 started; log sequence number 1620550
121030 14:17:57 [ERROR] Aborting

121030 14:17:57 InnoDB: Starting shutdown...
121030 14:17:57 InnoDB: Shutdown completed; log sequence number 1620550
121030 14:17:57 [Note]
121030 14:20:10 [Note] Plugin 'FEDERATED' is disabled.
121030 14:20:10 InnoDB: The InnoDB memory heap is disabled
121030 14:20:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 14:20:10 InnoDB: Compressed tables use zlib 1.2.3
121030 14:20:10 InnoDB: Initializing buffer pool, size = 16.0M
121030 14:20:10 InnoDB: Completed initialization of buffer pool
121030 14:20:10 InnoDB: highest supported file format is Barracuda.
121030 14:20:10 InnoDB: Waiting for the background threads to start
121030 14:20:11 InnoDB: 1.1.8 started; log sequence number 1620550
121030 14:20:11 [ERROR] Aborting

121030 14:20:11 InnoDB: Starting shutdown...
121030 14:20:12 InnoDB: Shutdown completed; log sequence number 1620550
121030 14:20:12 [Note]
121030 14:20:25 [Note] Plugin 'FEDERATED' is disabled.
121030 14:20:25 InnoDB: The InnoDB memory heap is disabled
121030 14:20:25 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 14:20:25 InnoDB: Compressed tables use zlib 1.2.3
121030 14:20:25 InnoDB: Initializing buffer pool, size = 16.0M
121030 14:20:25 InnoDB: Completed initialization of buffer pool
121030 14:20:25 InnoDB: highest supported file format is Barracuda.
121030 14:20:26 InnoDB: Waiting for the background threads to start
121030 14:20:27 InnoDB: 1.1.8 started; log sequence number 1620550
121030 14:20:27 [ERROR] Aborting

121030 14:20:27 InnoDB: Starting shutdown...
121030 14:20:27 InnoDB: Shutdown completed; log sequence number 1620550
121030 14:20:27 [Note]
121030 14:24:36 [Note] Plugin 'FEDERATED' is disabled.
121030 14:24:36 InnoDB: The InnoDB memory heap is disabled
121030 14:24:36 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 14:24:36 InnoDB: Compressed tables use zlib 1.2.3
121030 14:24:36 InnoDB: Initializing buffer pool, size = 16.0M
121030 14:24:36 InnoDB: Completed initialization of buffer pool
121030 14:24:37 InnoDB: highest supported file format is Barracuda.
121030 14:24:37 InnoDB: Waiting for the background threads to start
121030 14:24:38 InnoDB: 1.1.8 started; log sequence number 1620550
121030 14:24:38 [ERROR] Aborting

121030 14:24:38 InnoDB: Starting shutdown...
121030 14:24:38 InnoDB: Shutdown completed; log sequence number 1620550
121030 14:24:38 [Note]
121030 14:29:03 [Note] Plugin 'FEDERATED' is disabled.
121030 14:29:03 InnoDB: The InnoDB memory heap is disabled
121030 14:29:03 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 14:29:03 InnoDB: Compressed tables use zlib 1.2.3
121030 14:29:03 InnoDB: Initializing buffer pool, size = 16.0M
121030 14:29:03 InnoDB: Completed initialization of buffer pool
121030 14:29:03 InnoDB: highest supported file format is Barracuda.
121030 14:29:04 InnoDB: Waiting for the background threads to start
121030 14:29:05 InnoDB: 1.1.8 started; log sequence number 1620550
121030 14:29:05 [ERROR] Aborting

121030 14:29:05 InnoDB: Starting shutdown...
121030 14:29:05 InnoDB: Shutdown completed; log sequence number 1620550
121030 14:29:05 [Note]


Please provide solution.. :oops:
godheaper
 
Posts: 2
Joined: 30. October 2012 08:32
XAMPP Version: 5.6.3
Operating System: Windows 7

Re: mysql not working. XAMPP 1.8.1, Control Panel 3

Postby JonB » 31. October 2012 18:14

Please post the tail of the MySQL error log -

\xampp\mysql\data\mysql_error.log
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: mysql not working. XAMPP 1.8.1, Control Panel 3

Postby godheaper » 01. November 2012 10:09

sorry, nvm.. I resolved this by reinstalling the xampp itself. Thanks Jon
godheaper
 
Posts: 2
Joined: 30. October 2012 08:32
XAMPP Version: 5.6.3
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 76 guests