Incorrect definition of table mysql.event
Hello... I have installed MariaDB 10.3.13 in Centos 7. All worked well, but when I execute the following command: "service mariadb status", several errors are shown regarding incorrect definition of table mysql.event and some InnoDB problems. Full command output is this:
root@vps [~]# service mariadb status Redirecting to /bin/systemctl status mariadb.service ● mariadb.service - MariaDB 10.3.13 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: active (running) since Sun 2019-02-24 22:34:04 -03; 1 day 12h ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Main PID: 12247 (mysqld) Status: "Taking your SQL requests now..." CGroup: /system.slice/mariadb.service └─12247 /usr/sbin/mysqld Feb 24 22:46:39 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:39 32 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name tabl...ql_upgrade Feb 24 22:46:39 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:39 32 [ERROR] InnoDB: Column last_update in table `mysql`.`innodb_table_stats` is INT UNSIGNED NOT...mismatch). Feb 24 22:46:39 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:39 32 [ERROR] InnoDB: Fetch of persistent statistics requested for table `horde`.`horde_dav_schema...s instead. Feb 24 22:46:40 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:40 37 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100...this error Feb 24 22:46:40 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:40 37 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14...EATE','POS Feb 24 22:46:41 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:41 45 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14...EATE','POS Feb 24 22:49:43 vps.desytec.com mysqld[12247]: 2019-02-24 22:49:43 47 [Warning] Access denied for user 'admin'@'localhost' (using password: YES) Feb 24 22:49:43 vps.desytec.com mysqld[12247]: 2019-02-24 22:49:43 48 [Warning] Access denied for user 'admin'@'localhost' (using password: YES) Feb 24 22:49:57 vps.desytec.com mysqld[12247]: 2019-02-24 22:49:57 55 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name tabl...ql_upgrade Feb 24 22:49:57 vps.desytec.com mysqld[12247]: 2019-02-24 22:49:57 55 [ERROR] InnoDB: Column last_update in table `mysql`.`innodb_table_stats` is INT UNSIGNED NOT...mismatch). Hint: Some lines were ellipsized, use -l to show in full. root@vps [~]#
Can you help me to solve those problems?
Regards Jaime
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.