mySQL shutdown unexpectedly error

[littlebiglui]

Hi all,

Anyone knows the solution for this problem?

I can't start mySQL on XAMPP 5.6.14

2015-11-03 15:21:19 cbc 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.
151103 15:21:19 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151103 15:21:19 [Note] InnoDB: The InnoDB memory heap is disabled
151103 15:21:19 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151103 15:21:19 [Note] InnoDB: Memory barrier is not used
151103 15:21:19 [Note] InnoDB: Compressed tables use zlib 1.2.3
151103 15:21:19 [Note] InnoDB: Not using CPU crc32 instructions
151103 15:21:19 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151103 15:21:19 [Note] InnoDB: Completed initialization of buffer pool
151103 15:21:19 [Note] InnoDB: Highest supported file format is Barracuda.
151103 15:21:19 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 21381565 in the ib_logfiles!
151103 15:21:19 [Note] InnoDB: Database was not shutdown normally!
151103 15:21:19 [Note] InnoDB: Starting crash recovery.
151103 15:21:19 [Note] InnoDB: Reading tablespace information from the .ibd files...
151103 15:21:19 [Note] InnoDB: Restoring possible half-written data pages
151103 15:21:19 [Note] InnoDB: from the doublewrite buffer...
151103 15:21:20 [Note] InnoDB: 128 rollback segment(s) are active.
151103 15:21:20 [Note] InnoDB: Waiting for purge to start
151103 15:21:20 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 21381565
151103 15:21:20 [Note] Plugin 'FEEDBACK' is disabled.
151103 15:21:20 [Note] Server socket created on IP: '::'.
151103 15:21:20 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
151103 15:21:20 [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
151103 15:21:20 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
151103 15:21:20 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
151103 15:21:20 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
151103 15:21:20 [Note] Started replication for '151102 19:35:25 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
151103 15:21:20 [ERROR] Master '151102 19:35:25 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
151103 15:21:20 [Note] Master '151102 19:35:25 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-151102@002019@003a35@003a25@0020@005bnote@005d@0020d@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' position: 4
151103 15:21:20 [ERROR] Master '151102 19:35:25 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
151103 15:21:20 [ERROR] Master '151102 19:35:25 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
151103 15:21:20 [Note] Master '151102 19:35:25 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
151103 15:21:20 [Note] Master '151102 19:35:25 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
151103 15:21:20 [Note] Started replication for 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
'
151103 15:21:20 [ERROR] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
151103 15:21:20 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e0@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000001' position: 4
151103 15:21:20 [ERROR] mysqld.exe: File 'D:\xampp\mysql\data\master-2015@002d11@002d02@002019@003a35@003a30@002010b0@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' not found (Errcode: 2 "No such file or directory")
151103 15:21:20 [ERROR] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
151103 15:21:20 [ERROR] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
151103 15:21:20 [ERROR] Failed to create a new master info file (file 'D:\xampp\mysql\data\master-2015@002d11@002d02@002019@003a35@003a30@002010b0@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info', errno 2)
151103 15:21:20 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
151103 15:21:20 [ERROR] Initialized Master_info from 'master-2015@002d11@002d02@002019@003a35@003a30@002010b0@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' failed
151103 15:21:20 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
151103 15:21:20 [ERROR] mysqld.exe: File 'D:\xampp\mysql\data\master-2015@002d11@002d02@002019@003a35@003a30@002010b0@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022monofase@0022@002e@0022mfe_session@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info' not found (Errcode: 2 "No such file or directory")
151103 15:21:20 [ERROR] Failed to create a new master info file (file 'D:\xampp\mysql\data\master-2015@002d11@002d02@002019@003a35@003a30@002010b0@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022monofase@0022@002e@0022mfe_session@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info', errno 2)
151103 15:21:20 [ERROR] Initialized Master_info from 'master-2015@002d11@002d02@002019@003a35@003a30@002010b0@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022monofase@0022@002e@0022mfe_session@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info' failed
151103 15:21:20 [ERROR] mysqld.exe: File 'D:\xampp\mysql\data\master-2015@002d11@002d02@002019@003a35@003a30@002010b0@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' not found (Errcode: 2 "No such file or directory")
151103 15:21:20 [ERROR] Failed to create a new master info file (file 'D:\xampp\mysql\data\master-2015@002d11@002d02@002019@003a35@003a30@002010b0@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info', errno 2)
151103 15:21:20 [ERROR] Initialized Master_info from 'master-2015@002d11@002d02@002019@003a35@003a30@002010b0@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' failed

[codeuser]

I am also having the same issue on Windows Pro 10 had to move back to 5.6.12 as 5.6.14 seemed very unstable at the moment

[littlebiglui]

I had re-install a later version now and is 100% working.

Thanks!

[codeuser]

okay! What version did you re-install if it's before 5.6.14 then this issue is not fixed!!
You just rolled back to a later version like 5.6.12 of even later then that and someone
still needs to investigate this within
Release 5.6.14


Thanks!
codeuser

[littlebiglui]

The other one available in download page, xampp-win32-5.5.30-0-VC11-installer.exe