5.5.30 ERROR in mysql_error.log on fresh install

Problems with the Windows version of XAMPP, questions, comments, and anything related.

5.5.30 ERROR in mysql_error.log on fresh install

Postby m2mc » 22. October 2015 15:00

Hi,
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
m2mc
 
Posts: 1
Joined: 22. October 2015 14:52
Operating System: Windows

Re: 5.5.30 ERROR in mysql_error.log on fresh install

Postby Altrea » 22. October 2015 21:30

If everything is running, all is fine.
I haven't yet played that much with the MariaDB releases of XAMPP so i cannot say whether or not this errors are there by default.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 49 guests