Page 1 of 1

Error: MySQL shutdown unexpectedly.

PostPosted: 28. July 2013 09:41
by matasbar
Hello,

I was doing some WordPress stuff, everything worked fine. But the next day, the MYSQL could not be started. I am not familiar with such things, so I just reinstalled the XAMPP. I had to create a new database in order to continue working with WordPress. It worked fine until I turned off my computer... The following day MYSQL could not be started again. I hope you guys can help me out.

Code: Select all
11:32:58  [mysql]    Error: MySQL shutdown unexpectedly.
11:32:58  [mysql]    This may be due to a blocked port, missing dependencies,
11:32:58  [mysql]    improper privileges, a crash, or a shutdown by another method.
11:32:58  [mysql]    Press the Logs button to view error logs and check
11:32:58  [mysql]    the Windows Event Viewer for more clues
11:32:58  [mysql]    If you need more help, copy and post this
11:32:58  [mysql]    entire log window on the forums


Code: Select all
2013-07-27 16:43:36 7020 [Note] Plugin 'FEDERATED' is disabled.
2013-07-27 16:43:36 16c0 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-07-27 16:43:36 7020 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-27 16:43:36 7020 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-27 16:43:36 7020 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-27 16:43:36 7020 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-27 16:43:36 7020 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-27 16:43:36 7020 [Note] InnoDB: Completed initialization of buffer pool
2013-07-27 16:43:36 7020 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2013-07-27 16:43:36 7020 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2013-07-27 16:43:36 7020 [Note] InnoDB: Database physically writes the file full: wait...
2013-07-27 16:43:36 7020 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2013-07-27 16:43:37 7020 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
2013-07-27 16:43:37 7020 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2013-07-27 16:43:37 7020 [Warning] InnoDB: New log files created, LSN=45781
2013-07-27 16:43:37 7020 [Note] InnoDB: Doublewrite buffer not found: creating new
2013-07-27 16:43:37 7020 [Note] InnoDB: Doublewrite buffer created
2013-07-27 16:43:39 7020 [Note] InnoDB: 128 rollback segment(s) are active.
2013-07-27 16:43:39 7020 [Warning] InnoDB: Creating foreign key constraint system tables.
2013-07-27 16:43:39 7020 [Note] InnoDB: Foreign key constraint system tables created
2013-07-27 16:43:39 7020 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-07-27 16:43:39 7020 [Note] InnoDB: Tablespace and datafile system tables created.
2013-07-27 16:43:39 7020 [Note] InnoDB: Waiting for purge to start
2013-07-27 16:43:39 7020 [Note] InnoDB: 5.6.11 started; log sequence number 0
2013-07-27 16:43:39 7020 [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: 8b342d4d-f6c2-11e2-869b-e81132c12440.
2013-07-27 16:43:39 7020 [Note] Server hostname (bind-address): '*'; port: 3306
2013-07-27 16:43:39 7020 [Note] IPv6 is available.
2013-07-27 16:43:39 7020 [Note]   - '::' resolves to '::';
2013-07-27 16:43:39 7020 [Note] Server socket created on IP: '::'.
2013-07-27 16:43:39 7020 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2013-07-27 16:43:39 7020 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2013-07-27 16:43:39 7020 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2013-07-27 16:43:39 7020 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2013-07-27 16:43:39 7020 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2013-07-27 16:43:39 7020 [Note] Event Scheduler: Loaded 0 events
2013-07-27 16:43:39 7020 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.11'  socket: ''  port: 3306  MySQL Community Server (GPL)
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_options" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_users" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_usermeta" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_terms" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_term_taxonomy" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_posts" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_term_relationships" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_comments" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:37 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:37 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_postmeta" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:47 3b4 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:47 3b4 InnoDB: Recalculation of persistent statistics requested for table "wordpress"."wp_options" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2013-07-27 17:16:49 1a34 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:49 1a34 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_commentmeta" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:49 1d14 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:49 1d14 InnoDB: Error: Fetch of persistent statistics requested for table "wordpress"."wp_commentmeta" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-07-27 17:16:51 3b4 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:16:51 3b4 InnoDB: Recalculation of persistent statistics requested for table "wordpress"."wp_posts" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2013-07-27 17:17:01 3b4 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:17:01 3b4 InnoDB: Recalculation of persistent statistics requested for table "wordpress"."wp_usermeta" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2013-07-27 17:17:11 3b4 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:17:11 3b4 InnoDB: Recalculation of persistent statistics requested for table "wordpress"."wp_options" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2013-07-27 17:23:39 3b4 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:23:39 3b4 InnoDB: Recalculation of persistent statistics requested for table "wordpress"."wp_postmeta" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2013-07-27 17:23:39 3b4 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-07-27 17:23:39 3b4 InnoDB: Recalculation of persistent statistics requested for table "wordpress"."wp_posts" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2013-07-28 11:07:31 7884 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:07:32 1544 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-07-28 11:07:32 7884 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:07:32 7884 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:07:32 7884 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:07:32 7884 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:07:32 7884 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:07:32 7884 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:07:32 7884 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:07:32 7884 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:07:32 7884 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:07:32 7884 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:07:32 7884 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:07:32 7884 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:17:02 7832 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:17:02 1f4c 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-07-28 11:17:02 7832 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:17:02 7832 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:17:02 7832 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:17:02 7832 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:17:02 7832 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:17:02 7832 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:17:03 7832 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:17:03 7832 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:17:03 7832 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:17:03 7832 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:17:03 7832 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:17:03 7832 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:19:49 6624 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:19:49 1148 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-07-28 11:19:49 6624 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:19:49 6624 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:19:49 6624 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:19:49 6624 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:19:49 6624 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:19:49 6624 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:19:49 6624 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:19:49 6624 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:19:49 6624 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:19:49 6624 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:19:49 6624 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:19:49 6624 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:19:58 7128 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:19:58 18ec 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-07-28 11:19:58 7128 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:19:58 7128 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:19:58 7128 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:19:58 7128 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:19:58 7128 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:19:58 7128 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:19:58 7128 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:19:58 7128 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:19:58 7128 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:19:58 7128 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:19:58 7128 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:19:58 7128 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:27:57 7276 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:27:57 1544 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-07-28 11:27:57 7276 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:27:57 7276 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:27:57 7276 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:27:57 7276 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:27:57 7276 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:27:57 7276 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:27:57 7276 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:27:57 7276 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:27:57 7276 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:27:57 7276 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:27:57 7276 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:27:57 7276 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:47 940 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:47 cc8 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-07-28 11:32:47 940 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:47 940 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:47 940 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:47 940 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:47 940 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:47 940 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:47 940 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:47 940 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:47 940 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:47 940 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:47 940 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:47 940 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:48 3444 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:48 1a58 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-07-28 11:32:48 3444 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:48 3444 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:48 3444 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:48 3444 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:48 3444 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:48 3444 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:48 3444 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:48 3444 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:48 3444 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:48 3444 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:48 3444 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:48 3444 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:49 7244 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:49 1d9c 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-07-28 11:32:49 7244 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:49 7244 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:49 7244 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:49 7244 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:49 7244 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:49 7244 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:49 7244 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:49 7244 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:49 7244 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:49 7244 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:49 7244 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:49 7244 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:49 8060 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:49 1a88 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-07-28 11:32:49 8060 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:49 8060 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:49 8060 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:49 8060 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:49 8060 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:49 8060 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:49 8060 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:50 8060 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:50 8060 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:50 8060 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:50 8060 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:50 8060 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:50 4668 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:50 1bcc 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-07-28 11:32:50 4668 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:50 4668 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:50 4668 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:50 4668 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:50 4668 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:50 4668 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:50 4668 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:50 4668 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:50 4668 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:50 4668 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:50 4668 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:50 4668 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
2013-07-28 11:32:50 7252 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:50 9d4 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-07-28 11:32:50 7252 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:50 7252 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:50 7252 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:50 7252 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:50 7252 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:50 7252 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:50 7252 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:50 7252 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:50 7252 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:50 7252 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:50 7252 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:50 7252 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:51 6280 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:51 1cc0 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-07-28 11:32:51 6280 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:51 6280 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:51 6280 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:51 6280 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:51 6280 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:51 6280 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:51 6280 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:51 6280 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:51 6280 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:51 6280 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:51 6280 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:51 6280 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:52 7616 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:52 180c 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-07-28 11:32:52 7616 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:52 7616 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:52 7616 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:52 7616 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:52 7616 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:52 7616 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:52 7616 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:52 7616 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:52 7616 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:52 7616 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:52 7616 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:52 7616 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:52 7848 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:52 19b8 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-07-28 11:32:52 7848 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:52 7848 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:52 7848 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:52 7848 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:52 7848 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:52 7848 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:52 7848 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:52 7848 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:52 7848 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:52 7848 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:52 7848 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:52 7848 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:52 6364 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:52 17cc 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-07-28 11:32:52 6364 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:52 6364 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:52 6364 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:52 6364 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:52 6364 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:52 6364 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:52 6364 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:52 6364 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:52 6364 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:52 6364 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:52 6364 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:52 6364 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:54 7600 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:54 5b4 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-07-28 11:32:54 7600 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:54 7600 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:54 7600 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:54 7600 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:54 7600 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:54 7600 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:54 7600 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:54 7600 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:54 7600 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:54 7600 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:54 7600 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:54 7600 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:55 7052 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:55 d30 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-07-28 11:32:55 7052 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:55 7052 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:55 7052 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:55 7052 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:55 7052 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:55 7052 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:55 7052 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:55 7052 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:55 7052 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:55 7052 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:55 7052 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:55 7052 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:56 7428 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:56 1c3c 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-07-28 11:32:56 7428 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:56 7428 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:56 7428 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:56 7428 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:56 7428 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:56 7428 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:56 7428 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:56 7428 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:56 7428 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:56 7428 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:56 7428 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:56 7428 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2013-07-28 11:32:57 6020 [Note] Plugin 'FEDERATED' is disabled.
2013-07-28 11:32:57 19c0 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-07-28 11:32:57 6020 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-28 11:32:57 6020 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-28 11:32:57 6020 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-28 11:32:57 6020 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-28 11:32:57 6020 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-07-28 11:32:57 6020 [Note] InnoDB: Completed initialization of buffer pool
2013-07-28 11:32:57 6020 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-28 11:32:57 6020 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 2884023 in the ib_logfiles!
2013-07-28 11:32:57 6020 [Note] InnoDB: Database was not shutdown normally!
2013-07-28 11:32:57 6020 [Note] InnoDB: Starting crash recovery.
2013-07-28 11:32:57 6020 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-07-28 11:32:58 6020 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: .\mysql\slave_relay_log_info.ibd. Cannot open tablespace wordpress/wp_terms which uses space ID: 3 at filepath: .\wordpress\wp_terms.ibd
InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.


It's a big log, I cut some of the parts that repeated in the log, so that the message can be posted here. I hope this is an easy fix and I am very looking forward to your support.

Thanks,
Matas

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 28. July 2013 17:41
by hackattack142
Hello,

Does it help if you run MySQL as a Windows Service (Green check under the Service column in the XAMPP Control Panel)?

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 29. July 2013 14:41
by fiona0028009
I have the same problem!

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 29. July 2013 14:50
by Altrea
fiona0028009 wrote:I have the same problem!

So you should answer the same questions

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 30. July 2013 10:05
by 3-4-SAD
Hello matasbar.

I see no one answered to Your question.
Have you managed to solve that issue. I am having the same problem and after every system reset I can't start MySQL

Thanx in addvance!

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 30. July 2013 10:53
by fiona0028009
Altrea wrote:
fiona0028009 wrote:I have the same problem!

So you should answer the same questions


Yes, I did find a way to solve my problem.
First stop the service on the xampp control panel,
then click on the red cross on the left to install the service on your computer,
then the icon will become a green tick,
then start the service.

It should be working alright.

Excuse me for my English is not that good, and feel free to leave message if you have any question. =)

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 30. July 2013 15:11
by 3-4-SAD
Sorry man. Which red cross do you mean? I have no red crosses in XAMPP Control Panel...

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 30. July 2013 18:53
by awudoin
I am experiencing this same problem. MySQL was working but has since given the same error after shutting it down and restarting it today. I have tried installing it as a service (which is does) but it still won't start.

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 01. August 2013 12:33
by 3-4-SAD
Has anybody solved this issue?

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 02. August 2013 00:31
by MasterCedie
im using xampp-win32-1.8.3-beta-----

First install your MySQL as service by clicking the red X button on the left side of the MySQL

then go to C:\xampp\mysql\data\mysql
you will find some data that causes the error:(example)
" InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_table_stats.ibd "

temporarily MOVE (not delete) all of them to a backup folder(could be in desktop or other place) EXCEPT for these files:
db.frm
db.MRD
db.MYI
db.opt
user.frm
user.MYD
user.MYI

after that, start your MySQL and enjoy :D
~already fixed mine


if my suggestion didn't work, just copy again the files u move ,.... :D

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 23. December 2014 14:54
by jpoa7
I also don't have red x in my xampp control panel, so i have another solution. I changed port number of mysql service in xampp and now it's running. To change port just click on Config button and choose my.ini to opet the config file in notepad. Then change port from 3306 to some other number (I've changed it to 3305 and it's working). :wink:

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 14. January 2015 10:56
by Budi.hd
i have the same problem. The problem started after i restart my server. i have tried the solutions above but still don't fix the problem. Is there any other way to fix the problem?

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 11. July 2015 20:25
by martin.tremblay
I had the same problem.

I started XAMPP Control Panel with 'run as administrator' and it solved the problem. The little red cross also appeared.

Good luck