5.5.30 ERROR in mysql_error.log on fresh install
Posted: 22. October 2015 15:00Hi,
I downloaded 5.5.30 which lists content including mariadb.
XAMPP for Windows 5.5.30
Includes: Apache 2.4.17, MariaDB 10.0.17, PHP 5.5.30, phpMyAdmin 4.5.0.2, OpenSSL 1.0.1, XAMPP Control Panel 3.2.1, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.56 (with mod_proxy_ajp as connector), Strawberry Perl 7.0.56 Portable
After install:
2015-10-22 09:30:20 c900 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.
151022 9:30:20 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151022 9:30:20 [Note] InnoDB: The InnoDB memory heap is disabled
151022 9:30:20 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151022 9:30:20 [Note] InnoDB: Memory barrier is not used
151022 9:30:20 [Note] InnoDB: Compressed tables use zlib 1.2.3
151022 9:30:20 [Note] InnoDB: Not using CPU crc32 instructions
151022 9:30:20 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151022 9:30:20 [Note] InnoDB: Completed initialization of buffer pool
151022 9:30:20 [Note] InnoDB: Highest supported file format is Barracuda.
151022 9:30:20 [Note] InnoDB: 128 rollback segment(s) are active.
151022 9:30:20 [Note] InnoDB: Waiting for purge to start
151022 9:30:20 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1665234
151022 9:30:20 [Note] Plugin 'FEEDBACK' is disabled.
151022 9:30:20 [Note] Server socket created on IP: '::'.
151022 9:30:20 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
151022 9:30: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
151022 9:30:20 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
151022 9:30:20 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
151022 9:30:20 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
151022 9:30:26 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
2015-10-22 09:30:26 a9e4 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
2015-10-22 09:30:26 a9e4 InnoDB: Error: Fetch of persistent statistics requested for table "phpmyadmin"."pma_navigationhiding" 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.
2015-10-22 09:30:26 a9e4 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
2015-10-22 09:30:26 a9e4 InnoDB: Error: Fetch of persistent statistics requested for table "phpmyadmin"."pma_usergroups" 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.
2015-10-22 09:30:26 a9e4 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
2015-10-22 09:30:26 a9e4 InnoDB: Error: Fetch of persistent statistics requested for table "phpmyadmin"."pma_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.
151022 9:30:27 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
151022 9:30:48 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
edit:
I also noticed that the httpd.exe was left running after the install exitted and i had to kill that process in order to start apache.
I found an mysql_upgrade.exe in the bin dir and ran it, restarted the db and there are no errors. Not sure if this was the correct step to do
I downloaded 5.5.30 which lists content including mariadb.
XAMPP for Windows 5.5.30
Includes: Apache 2.4.17, MariaDB 10.0.17, PHP 5.5.30, phpMyAdmin 4.5.0.2, OpenSSL 1.0.1, XAMPP Control Panel 3.2.1, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.56 (with mod_proxy_ajp as connector), Strawberry Perl 7.0.56 Portable
After install:
2015-10-22 09:30:20 c900 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.
151022 9:30:20 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151022 9:30:20 [Note] InnoDB: The InnoDB memory heap is disabled
151022 9:30:20 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151022 9:30:20 [Note] InnoDB: Memory barrier is not used
151022 9:30:20 [Note] InnoDB: Compressed tables use zlib 1.2.3
151022 9:30:20 [Note] InnoDB: Not using CPU crc32 instructions
151022 9:30:20 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151022 9:30:20 [Note] InnoDB: Completed initialization of buffer pool
151022 9:30:20 [Note] InnoDB: Highest supported file format is Barracuda.
151022 9:30:20 [Note] InnoDB: 128 rollback segment(s) are active.
151022 9:30:20 [Note] InnoDB: Waiting for purge to start
151022 9:30:20 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1665234
151022 9:30:20 [Note] Plugin 'FEEDBACK' is disabled.
151022 9:30:20 [Note] Server socket created on IP: '::'.
151022 9:30:20 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
151022 9:30: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
151022 9:30:20 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
151022 9:30:20 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
151022 9:30:20 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
151022 9:30:26 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
2015-10-22 09:30:26 a9e4 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
2015-10-22 09:30:26 a9e4 InnoDB: Error: Fetch of persistent statistics requested for table "phpmyadmin"."pma_navigationhiding" 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.
2015-10-22 09:30:26 a9e4 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
2015-10-22 09:30:26 a9e4 InnoDB: Error: Fetch of persistent statistics requested for table "phpmyadmin"."pma_usergroups" 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.
2015-10-22 09:30:26 a9e4 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
2015-10-22 09:30:26 a9e4 InnoDB: Error: Fetch of persistent statistics requested for table "phpmyadmin"."pma_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.
151022 9:30:27 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
151022 9:30:48 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
edit:
I also noticed that the httpd.exe was left running after the install exitted and i had to kill that process in order to start apache.
I found an mysql_upgrade.exe in the bin dir and ran it, restarted the db and there are no errors. Not sure if this was the correct step to do