Today i wanted to work on my website after 2 weeks of vacation. My laptop (Acer aspire v15 nitro - black edition) has been in sleeping mode while the servers where running. But after i launched Apache (launches perfectly), i wanted to launch MySQL too, that didn't work out well.
After i click on "Start" .. it will run for some seconds and then it stops running, giving the next bug in the log:
11:58:06 [mysql] Error: MySQL shutdown unexpectedly.
11:58:06 [mysql] This may be due to a blocked port, missing dependencies,
11:58:06 [mysql] improper privileges, a crash, or a shutdown by another method.
11:58:06 [mysql] Press the Logs button to view error logs and check
11:58:06 [mysql] the Windows Event Viewer for more clues
11:58:06 [mysql] If you need more help, copy and post this
11:58:06 [mysql] entire log window on the forums
I tried many things, like deleting the "ibdata1" file and restart XAMP - no effect
Also tried to change the port of the MySQL and launching the MySQL upgrade didnt show any effects.
This is what the error log looks like:
2016-05-09 12:38:00 1ce0 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.
160509 12:38:00 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160509 12:38:00 [Note] InnoDB: The InnoDB memory heap is disabled
160509 12:38:00 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160509 12:38:00 [Note] InnoDB: Memory barrier is not used
160509 12:38:00 [Note] InnoDB: Compressed tables use zlib 1.2.3
160509 12:38:00 [Note] InnoDB: Not using CPU crc32 instructions
160509 12:38:00 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160509 12:38:00 [Note] InnoDB: Completed initialization of buffer pool
160509 12:38:00 [Note] InnoDB: Highest supported file format is Barracuda.
160509 12:38:00 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 73591974 in the ib_logfiles!
160509 12:38:00 [Note] InnoDB: Database was not shutdown normally!
160509 12:38:00 [Note] InnoDB: Starting crash recovery.
160509 12:38:00 [Note] InnoDB: Reading tablespace information from the .ibd files...
160509 12:38:00 [Note] InnoDB: Restoring possible half-written data pages
160509 12:38:00 [Note] InnoDB: from the doublewrite buffer...
160509 12:38:01 [Note] InnoDB: 128 rollback segment(s) are active.
160509 12:38:01 [Note] InnoDB: Waiting for purge to start
160509 12:38:01 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 73591974
160509 12:38:01 [Note] Plugin 'FEEDBACK' is disabled.
160509 12:38:01 [Note] Server socket created on IP: '::'.
160509 12:38:01 [Warning] 'db' entry '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_d IR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2@51110 9:19:23 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
151110 9:19:23 [ERROR] Incorrect definition of table mysql.event: expected' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry ''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','IGNOR@TIONS','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',' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'ql40','ansi','no_auto_value_on_zero','no_backslash_escapes','strict_trans_tables','strict_a
151110 9:19:23 [error] event scheduler: an error occurred when initializing system tables. disabli ng the Event Scheduler.
151110 9:19:23 [Warnin@'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','MYS' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '.
version: '10.0.17-mariadb' socket: '' port: 3306 mariadb.org binary distribution
151209 9:38:40 [error] missing system table mysql.roles_mapping; please run mysql_upgrade to create it
151209 9:38:40 [ERROR] Incorrect definition of@ave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
151110 9:19:23 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'ed_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_ba CKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A@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_UNSIGN' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '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_F@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'),' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'ystem tables. disabling the event scheduler.
151209 9:38:40 [warning] failed to load slave replication state from table mysql.gtid_slave_pos: 1146: table 'mysql.gtid_slave_pos' doesn't exist
151209 9:38:40 [Note] c:\xampp\mysql\bin\mysq@323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
151209 9:38:40 [ERROR] Event Scheduler: An error occurred when initializing s' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '_table_stats" is binary(4) not null but should be int not null (type mismatch).
2015-12-09 09:45:27 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress"."wp_opti ons" but the required system tables mysql.innodb@nnections.
Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-12-09 09:45:27 8f4c InnoDB: Error: Column last_update in table "mysql"."innodb' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'odb_table_stats" is binary(4) not null but should be int not null (type mismatch).
2015-12-09 09:45:27 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress"."wp_p osts" but the required system tables mysql.innod@ql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2015-12-09 09:45:27 8f4c InnoDB: Error: Column last_update in table "mysql"."inn' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'nodb_table_stats" is binary(4) not null but should be int not null (type mismatch).
2015-12-09 09:45:27 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress"."wp_ postmeta" but the required system tables mysql.i@sql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2015-12-09 09:45:27 8f4c InnoDB: Error: Column last_update in table "mysql"."in' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).
2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress". "wp_terms" but the required system tables mysql.@d mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2015-12-09 09:45:28 8f4c InnoDB: Error: Column last_update in table "mysql"' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).
2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress" ."wp_term_taxonomy" but the required system tabl@nd mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2015-12-09 09:45:28 8f4c InnoDB: Error: Column last_update in table "mysql' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'le "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).
2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requested for table "w ordpress"."wp_term_relationships" but the requir@e_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2015-12-09 09:45:28 8f4c InnoDB: Error: Column last_update in tab' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '_update in table "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).
2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requeste d for table "wordpress"."wp_users" but the requi@ql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2015-12-09 09:45:28 8f4c InnoDB: Error: Column last' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 't_update in table "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).
2015-12-09 09:45:29 8f4c innodb: error: fetch of persistent statistics request ed for table "wordpress"."wp_usermeta" but the r@sql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2015-12-09 09:45:29 8f4c InnoDB: Error: Column las' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry ' last_update in table "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).
2015-12-09 09:45:29 8f4c innodb: error: fetch of persistent statistics req uested for table "wordpress"."wp_comments" but t@s mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2015-12-09 09:45:29 8f4c InnoDB: Error: Column' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
160509 12:38: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
160509 12:38:01 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
160509 12:38:01 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
160509 12:38:01 [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.
160509 12:38:01 [Note] Started replication for '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
160509 12:38:01 [ERROR] Master '160420 14:08:50 [Note] c:\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
160509 12:38:01 [Note] Master '160420 14:08:50 [Note] c:\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-160420@002014@003a08@003a50@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' position: 4
160509 12:38:01 [ERROR] Master '160420 14:08:50 [Note] c:\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
160509 12:38:01 [ERROR] Master '160420 14:08:50 [Note] c:\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
160509 12:38:01 [Note] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
160509 12:38:01 [Note] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
160509 12:38:01 [Note] Started replication for 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
'
160509 12:38:01 [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
160509 12:38:01 [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
160509 12:38:01 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@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")
160509 12:38:01 [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
160509 12:38:01 [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
160509 12:38:01 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@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)
160509 12:38:01 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
160509 12:38:01 [ERROR] Initialized Master_info from 'master-2016@002d04@002d20@002014@003a09@003a06@00207d70@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
160509 12:38:01 [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
160509 12:38:01 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022wordpress@0022@002e@0022wp_options@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info' not found (Errcode: 2 "No such file or directory")
160509 12:38:01 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022wordpress@0022@002e@0022wp_options@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info', errno 2)
160509 12:38:01 [ERROR] Initialized Master_info from 'master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022wordpress@0022@002e@0022wp_options@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info' failed
160509 12:38:01 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@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")
160509 12:38:01 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@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)
160509 12:38:01 [ERROR] Initialized Master_info from 'master-2016@002d04@002d20@002014@003a09@003a06@00207d70@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
Hope you guys can help me out.
Regards,
Davey
(i recovered the XAMPP folder from a backup created on 27th of April)