MySQL Forums
Forum List  »  InnoDB

Can't start the MySQL service - Error with InnoDB
Posted by: L Lopes
Date: April 16, 2013 03:15AM

Hello,

I have an installation of MySQL 5.6 which has been working fine, until today.
When I started windows the MySQL service did not start, so I tried to start it from the console with mysqld. From there I got these errors and warnings:

-------------------------------------

C:\Users\NE-MK>mysqld
2013-04-16 09:50:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
2013-04-16 09:50:51 1800 [Warning] Can't create test file C:\Program Files\MySQL
\MySQL Server 5.6\data\NE-MK-PC.lower-test
2013-04-16 09:50:51 1800 [Warning] Can't create test file C:\Program Files\MySQL
\MySQL Server 5.6\data\NE-MK-PC.lower-test
2013-04-16 09:50:51 1800 [Note] Plugin 'FEDERATED' is disabled.
2013-04-16 09:50:51 1800 [Note] InnoDB: The InnoDB memory heap is disabled
2013-04-16 09:50:51 1800 [Note] InnoDB: Mutexes and rw_locks use Windows interlo
cked functions
2013-04-16 09:50:51 1800 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-04-16 09:50:51 1800 [Note] InnoDB: CPU does not support crc32 instructions
2013-04-16 09:50:51 1800 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-04-16 09:50:51 1800 [Note] InnoDB: Completed initialization of buffer pool
2013-04-16 09:50:51 1800 [ERROR] InnoDB: read can't be opened in .\ibdata1 mode
2013-04-16 09:50:51 1800 [ERROR] InnoDB: The system tablespace must be writable!

2013-04-16 09:50:51 1800 [ERROR] Plugin 'InnoDB' init function returned error.
2013-04-16 09:50:51 1800 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGIN
E failed.
2013-04-16 09:50:51 1800 [ERROR] Unknown/unsupported storage engine: InnoDB
2013-04-16 09:50:51 1800 [ERROR] Aborting

2013-04-16 09:50:51 1800 [Note] Binlog end
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'partition'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_FT_INSERTED'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD
'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_METRICS'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET
'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_CMP'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'INNODB_TRX'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'BLACKHOLE'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'ARCHIVE'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'MRG_MYISAM'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'MyISAM'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'MEMORY'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'CSV'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'sha256_password'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'mysql_old_password'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'mysql_native_password'
2013-04-16 09:50:51 1800 [Note] Shutting down plugin 'binlog'
2013-04-16 09:50:51 1800 [Note] mysqld: Shutdown complete

------------------------------

I have googled for similar errors. I tried for example deleting iblogfile0 and iblogfile1, but it didn't change anything.

Anyway, until yesterday everything was working fine. Yesterday all I did was to create some new databases, provide some extra privileges to a user, insert some data to one of the databases and change the charset of annother one from UTF8 to latin1 (with collation latin1_swedish_ci).

I would appreciate any help with this issue.

Thanks.

Filipe

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't start the MySQL service - Error with InnoDB
7061
April 16, 2013 03:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.