Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Error in MySQL log files: Incorrect definition of table mysql.event  (Read 4149 times)

0 Members and 1 Guest are viewing this topic.

vichithrakumart

  • Guest
The following error can be found in /var/log/mysql.log:

Code: [Select]
[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
MySQL was replaced with MariaDB some time ago or MySQL/MariaDB was upgraded to a higher version.

During the upgrade of MySQL/MariaDB, mysql_upgrade command was not executed or was executed with errors.

To resolve the issue

1. Log in to the server via SSH

2. create a backup of /var/lib/mysql

Code: [Select]
# cp -a /var/lib/mysql/ /var/lib/mysql_backup/
3. Start mysql_upgrade with admin user credentials:

Code: [Select]
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
4. Restart MySQL service:

Code: [Select]
# service mysql restart