Package: mariadb-server-10.1 Version: 10.1.23-9+deb9u1 Severity: normal Hi,
after upgrading to stretch from a jessie that already had MariaDB 10.0 (10.0.30-0+deb8u2 to 10.1.23-9+deb9u1), MariaDB complains on startup in the error.log: 2017-07-01 15:14:37 7fb55d15d700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2017-07-01 15:14:37 7fb55d15d700 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. Can I ignore this? If no, how do I fix this? Does this happen often enough so that an automatic table structure migration is in order? Greetings Marc -- System Information: Debian Release: 9.0 APT prefers stable APT policy: (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 4.11.8-zgsrv20080 (SMP w/2 CPU cores; PREEMPT) Locale: LANG=en_DK.utf8, LC_CTYPE=en_DK.utf8 (charmap=UTF-8), LANGUAGE=en_DK.utf8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages mariadb-server-10.1 depends on: ii adduser 3.115 ii debconf [debconf-2.0] 1.5.61 ii galera-3 25.3.19-2 ii gawk 1:4.1.4+dfsg-1 ii init-system-helpers 1.48 ii iproute2 4.9.0-1 ii libaio1 0.3.110-3 ii libc6 2.24-11+deb9u1 ii libdbi-perl 1.636-1+b1 ii libpam0g 1.1.8-3.6 ii libstdc++6 6.3.0-18 ii libsystemd0 232-25 ii lsb-base 9.20161125 ii lsof 4.89+dfsg-0.1 ii mariadb-client-10.1 10.1.23-9+deb9u1 ii mariadb-common 10.1.23-9+deb9u1 ii mariadb-server-core-10.1 10.1.23-9+deb9u1 ii passwd 1:4.4-4.1 ii perl 5.24.1-3 ii psmisc 22.21-2.1+b2 ii rsync 3.1.2-1 ii socat 1.7.3.1-2+b1 ii zlib1g 1:1.2.8.dfsg-5 Versions of packages mariadb-server-10.1 recommends: pn libhtml-template-perl <none> Versions of packages mariadb-server-10.1 suggests: ii bsd-mailx [mailx] 8.1.2-0.20160123cvs-4 pn mariadb-test <none> pn netcat-openbsd <none> pn tinyca <none> -- Configuration Files: /etc/mysql/mariadb.conf.d/50-server.cnf changed: [server] [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking key_buffer_size = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam_recover_options = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/log/mysql/error.log expire_logs_days = 10 max_binlog_size = 100M character-set-server = utf8mb4 collation-server = utf8mb4_general_ci [embedded] [mariadb] [mariadb-10.1] -- debconf information: mariadb-server-10.1/old_data_directory_saved: mariadb-server-10.1/postrm_remove_databases: false mariadb-server-10.1/nis_warning:
