[solved]Phpmyadmin won't start
Posted: 13. June 2012 15:44
Hi Apache Friends,
I'm grateful in advance if anyone can help me on this one.
I've been using Xampp for some time now with no issues. Today my computer restarted after I changed a windows setting (unrelated to xampp) - with Xampp (Apache and MySql) running. After restart I am not able to open Phpmyadmin. The error I see is
"Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly."
MySql and Apache both start OK and I am able to run my applications. I just can't open Phpmyadmin because of the above error.
The Mysql log files shows:
120613 22:07:10 [Note] Plugin 'FEDERATED' is disabled.
120613 22:07:10 InnoDB: The InnoDB memory heap is disabled
120613 22:07:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:07:10 InnoDB: Compressed tables use zlib 1.2.3
120613 22:07:10 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:07:10 InnoDB: Completed initialization of buffer pool
120613 22:07:10 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!
120613 22:07:10 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...
120613 22:07:11 InnoDB: Waiting for the background threads to start
120613 22:07:12 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:07:12 [Note] Event Scheduler: Loaded 0 events
120613 22:07:12 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
120613 22:08:16 [Note] Plugin 'FEDERATED' is disabled.
120613 22:08:16 InnoDB: The InnoDB memory heap is disabled
120613 22:08:16 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:08:16 InnoDB: Compressed tables use zlib 1.2.3
120613 22:08:16 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:08:16 InnoDB: Completed initialization of buffer pool
120613 22:08:16 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!
120613 22:08:16 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...
120613 22:08:17 InnoDB: Waiting for the background threads to start
120613 22:08:18 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:08:18 [Note] Event Scheduler: Loaded 0 events
120613 22:08:18 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
120613 22:09:35 [Note] Plugin 'FEDERATED' is disabled.
120613 22:09:35 InnoDB: The InnoDB memory heap is disabled
120613 22:09:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:09:35 InnoDB: Compressed tables use zlib 1.2.3
120613 22:09:35 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:09:35 InnoDB: Completed initialization of buffer pool
120613 22:09:35 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!
120613 22:09:35 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...
120613 22:09:36 InnoDB: Waiting for the background threads to start
120613 22:09:37 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:09:37 [Note] Event Scheduler: Loaded 0 events
120613 22:09:37 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
It seems this same log sequence has been occuring for some weeks now so I am not sure that is the issue.
Are there any other log files I need to check? I haven't changed any config settings or passwords in some months.
Any help at all would be appreciated as I am trying to avoid having to dump this Xampp install and start again.
Gen
I'm grateful in advance if anyone can help me on this one.
I've been using Xampp for some time now with no issues. Today my computer restarted after I changed a windows setting (unrelated to xampp) - with Xampp (Apache and MySql) running. After restart I am not able to open Phpmyadmin. The error I see is
"Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly."
MySql and Apache both start OK and I am able to run my applications. I just can't open Phpmyadmin because of the above error.
The Mysql log files shows:
120613 22:07:10 [Note] Plugin 'FEDERATED' is disabled.
120613 22:07:10 InnoDB: The InnoDB memory heap is disabled
120613 22:07:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:07:10 InnoDB: Compressed tables use zlib 1.2.3
120613 22:07:10 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:07:10 InnoDB: Completed initialization of buffer pool
120613 22:07:10 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!
120613 22:07:10 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...
120613 22:07:11 InnoDB: Waiting for the background threads to start
120613 22:07:12 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:07:12 [Note] Event Scheduler: Loaded 0 events
120613 22:07:12 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
120613 22:08:16 [Note] Plugin 'FEDERATED' is disabled.
120613 22:08:16 InnoDB: The InnoDB memory heap is disabled
120613 22:08:16 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:08:16 InnoDB: Compressed tables use zlib 1.2.3
120613 22:08:16 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:08:16 InnoDB: Completed initialization of buffer pool
120613 22:08:16 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!
120613 22:08:16 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...
120613 22:08:17 InnoDB: Waiting for the background threads to start
120613 22:08:18 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:08:18 [Note] Event Scheduler: Loaded 0 events
120613 22:08:18 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
120613 22:09:35 [Note] Plugin 'FEDERATED' is disabled.
120613 22:09:35 InnoDB: The InnoDB memory heap is disabled
120613 22:09:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:09:35 InnoDB: Compressed tables use zlib 1.2.3
120613 22:09:35 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:09:35 InnoDB: Completed initialization of buffer pool
120613 22:09:35 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!
120613 22:09:35 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...
120613 22:09:36 InnoDB: Waiting for the background threads to start
120613 22:09:37 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:09:37 [Note] Event Scheduler: Loaded 0 events
120613 22:09:37 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
It seems this same log sequence has been occuring for some weeks now so I am not sure that is the issue.
Are there any other log files I need to check? I haven't changed any config settings or passwords in some months.
Any help at all would be appreciated as I am trying to avoid having to dump this Xampp install and start again.
Gen