Mysql unable to start

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Mysql unable to start

Postby Nickdearoj » 28. February 2015 16:34

Error are as below:
2015-02-28 23:05:58 1218 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.
150228 23:05:58 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150228 23:05:58 [Note] InnoDB: The InnoDB memory heap is disabled
150228 23:05:58 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
150228 23:05:58 [Note] InnoDB: Memory barrier is not used
150228 23:05:58 [Note] InnoDB: Compressed tables use zlib 1.2.3
150228 23:05:58 [Note] InnoDB: Not using CPU crc32 instructions
150228 23:05:58 [Note] InnoDB: Initializing buffer pool, size = 16.0M
150228 23:05:58 [Note] InnoDB: Completed initialization of buffer pool
150228 23:05:59 [Note] InnoDB: Highest supported file format is Barracuda.
150228 23:05:59 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665314 in the ib_logfiles!
150228 23:05:59 [Note] InnoDB: Database was not shutdown normally!
150228 23:05:59 [Note] InnoDB: Starting crash recovery.
150228 23:05:59 [Note] InnoDB: Reading tablespace information from the .ibd files...
150228 23:05:59 [Note] InnoDB: Restoring possible half-written data pages
150228 23:05:59 [Note] InnoDB: from the doublewrite buffer...
150228 23:06:00 [Note] InnoDB: 128 rollback segment(s) are active.
150228 23:06:00 [Note] InnoDB: Waiting for purge to start
150228 23:06:00 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-71.0 started; log sequence number 1665314
150228 23:06:00 [Note] Plugin 'FEEDBACK' is disabled.
150228 23:06:00 [Note] Server socket created on IP: '::'.
150228 23:06:00 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
150228 23:06:01 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
150228 23:06:01 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
150228 23:06:01 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
150228 23:06:01 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.0.16-MariaDB' socket: '' port: 3307 mariadb.org binary distribution
2015-02-28 23:07:50 bbc 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.
150228 23:07:50 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150228 23:07:50 [Note] InnoDB: The InnoDB memory heap is disabled
150228 23:07:50 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
150228 23:07:50 [Note] InnoDB: Memory barrier is not used
150228 23:07:50 [Note] InnoDB: Compressed tables use zlib 1.2.3
150228 23:07:50 [Note] InnoDB: Not using CPU crc32 instructions
150228 23:07:50 [Note] InnoDB: Initializing buffer pool, size = 16.0M
150228 23:07:50 [Note] InnoDB: Completed initialization of buffer pool
150228 23:07:50 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
150228 23:07:50 [ERROR] InnoDB: The system tablespace must be writable!
150228 23:07:50 [ERROR] Plugin 'InnoDB' init function returned error.
150228 23:07:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150228 23:07:50 [Note] Plugin 'FEEDBACK' is disabled.
150228 23:07:50 [ERROR] Unknown/unsupported storage engine: InnoDB
150228 23:07:50 [ERROR] Aborting

150228 23:07:50 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete


Already run mysql_upgrade.exe but still can't solve the problem?

Previously i did install an older version of MariaDB using the .msi older version file but then i uninstall it already.

Note: Using XAMPP v5.6.3 and MariaDB 10.0.16.
Nickdearoj
 
Posts: 1
Joined: 28. February 2015 16:20
Operating System: Windows 7

Re: Mysql unable to start

Postby Nobbie » 28. February 2015 21:14

Nickdearoj wrote:Note: Using XAMPP v5.6.3 and MariaDB 10.0.16.


No support here for MariaDB.
Nobbie
 
Posts: 8766
Joined: 09. March 2008 13:04


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 4 guests