maria-developers team mailing list archive

[Jan Lindström <jan.lindstrom@xxxxxxxxxxx>]

Hi,

These warnings are printed because some of the system table definitions
have been changed, you should run mysql_upgrade and restart should be again
more silent.

R: Jan

On Mon, Jan 11, 2016 at 8:56 AM, Otto Kekäläinen <otto@xxxxxxxxx> wrote:

> Hello!
>
> When testing mysql 5.6 -> mariadb 10.0 I noticed that syslog looks like
> below.
>
> Are any of these errors anything we need to care about?
>
> The databases where completely vanilla out-of-the-box, so I imagine
> all users doing the same upgrade will experience the same error
> messages. I didn't notice that it would have any actual effect on
> anything, these error messages are just a QA signal.
>
>
> Jan 11 00:13:42 sid mysqld[22723]:
> _BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
> Jan 11 00:13:42 sid mysqld[22723]: 160111  0:13:42 [ERROR] mysqld:
> Event Scheduler: An error occurred when initializing system tables.
> Disabling the Event Scheduler.
> Jan 11 00:13:42 sid mysqld[22723]: 2016-01-11 00:13:42 7f6caa5ba700
> InnoDB: Error: Column last_update in table
> "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT
> NOT NULL (type mismatch).
> Jan 11 00:13:42 sid mysqld[22723]: 2016-01-11 00:13:42 7f6caa5ba700
> InnoDB: Error: Fetch of persistent statistics requested for table
> "mysql"."gtid_slave_pos" 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.
> Jan 11 00:13:43 sid mysqld[22723]: 160111  0:13:43 [Note]
> /usr/sbin/mysqld: ready for connections.
> Jan 11 00:13:43 sid mysqld[22723]: Version: '10.0.23-MariaDB-2'
> socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Debian unstable
> Jan 11 00:13:43 sid mysql[22552]: Starting MariaDB database server: mysqld.
> Jan 11 00:13:43 sid systemd[1]: Started LSB: Start and stop the mysql
> database server daemon.
> Jan 11 00:13:43 sid /etc/mysql/debian-start[22771]: Upgrading MySQL
> tables if necessary.
> Jan 11 00:14:00 sid mysqld[22723]: 2016-01-11 00:14:00 7f6caa5ba700
> InnoDB: Error: Column last_update in table
> "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT
> NOT NULL (type mismatch).
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>