Incorrect definition of table mysql.event: expected column 'sql_mode

Discussion in 'Server Operation' started by Julian, May 9, 2017.

  1. Julian

    Julian Member

    Hello,

    I have Centos 7.3 with ISPCONFIG and the mysql died!
    I have the error:
    170509 11:14:54 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 12524 ...
    170509 11:14:54 InnoDB: The InnoDB memory heap is disabled
    170509 11:14:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    170509 11:14:54 InnoDB: Compressed tables use zlib 1.2.7
    170509 11:14:54 InnoDB: Using Linux native AIO
    170509 11:14:54 InnoDB: Initializing buffer pool, size = 128.0M
    170509 11:14:54 InnoDB: Completed initialization of buffer pool
    170509 11:14:54 InnoDB: highest supported file format is Barracuda.
    170509 11:14:54 InnoDB: Waiting for the background threads to start
    170509 11:14:55 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 3220221
    170509 11:14:55 [Note] Plugin 'FEEDBACK' is disabled.
    170509 11:14:55 [Note] Server socket created on IP: '0.0.0.0'.
    170509 11:14:55 [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
    170509 11:14:55 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    170509 11:14:55 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.52-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server


    I cant start mysql anymore?
    Can anyone help me?

    Thank you
     

Share This Page