ERROR 1577 (HY000): Cannot proceed because system tables used by Event Schedule
mysql> select *from information_schema.events;
ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start
mysql> show variables like 'event_scheduler';
+-----------------+----------+
| Variable_name | Value |
+-----------------+----------+
| event_scheduler | DISABLED |
+-----------------+----------+
1 row in set (0.00 sec)
mysql> select * from mysql.event;
Empty set (0.00 sec)
log中
2015-08-28 06:56:41 1628 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(16), found type char(80).
2015-08-28 06:56:41 1628 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type char(77), found type char(141).
2015-08-28 06:56:41 1628 [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','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_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','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_A
2015-08-28 06:56:41 1628 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2015-08-28 06:56:41 1628 [Note] /data/program/mysql/mysql-5.6.20/bin/mysqld: ready for connections.
Version: '5.6.20' socket: '/data/instance/mysql-5.6/mysqld.sock' port: 3306 Source distribution
需要對錶進行修復
mysql_upgrade
ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start
mysql> show variables like 'event_scheduler';
+-----------------+----------+
| Variable_name | Value |
+-----------------+----------+
| event_scheduler | DISABLED |
+-----------------+----------+
1 row in set (0.00 sec)
mysql> select * from mysql.event;
Empty set (0.00 sec)
log中
2015-08-28 06:56:41 1628 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(16), found type char(80).
2015-08-28 06:56:41 1628 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type char(77), found type char(141).
2015-08-28 06:56:41 1628 [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','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_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','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_A
2015-08-28 06:56:41 1628 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2015-08-28 06:56:41 1628 [Note] /data/program/mysql/mysql-5.6.20/bin/mysqld: ready for connections.
Version: '5.6.20' socket: '/data/instance/mysql-5.6/mysqld.sock' port: 3306 Source distribution
需要對錶進行修復
mysql_upgrade
轉載請註明源出處
QQ 273002188 歡迎一起學習
QQ 群 236941212
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25099483/viewspace-1787968/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Dynamics CRM the field cannot be deleted because it is used in one or more process的解決方法delete
- Error:Cannot build artifact xxx:war exploded‘ because it is included into a circular dependencyErrorUI
- MySQL 使用 show tables 時出現 ERROR 1449 (HY000) 問題MySqlError
- Java could not be located. OPatch cannot proceed!.OPatch failedJavaAI
- ERROR 1661 (HY000): Cannot execute statement: impossible to write to binaryError
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- 從原始碼解析ERROR 1129 (HY000):Host is blocked because of many connection errors原始碼ErrorBloC
- mysql計劃任務:event scheduleMySql
- ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corruptedErrorMySql
- CMake Error: add_executable cannot create target ““ because another target with the same name已解決Error
- the --skip-grant-tables option so it cannot
- Linux:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannLinuxErrorMySqlServer
- Percona MySQL 5.6 語句加鎖報錯"ERROR 1665 (HY000): Cannot execute statement"MySqlError
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- Error: The action can not be performed because ...could not be locked?ErrorORM
- name server cannot be used, reason: Temporary failure in name resolutionServerAI
- exp tables sh: Syntax error: `(' is not expectedError
- v$system_event解析
- 提交App中斷出現 Cannot proceed with delivery an existing transporter instanAPP
- pod》error:The dependency `` is not used in any concrete targetError
- 解決 TypeError: Type aliases cannot be used with isinstance(). 辦法Error
- expdp report error when export tablesErrorExport
- alter system events與alter system event的區別
- Oracle System Event TriggersOracle
- ERROR 1010 (HY000): Error dropping databaseErrorDatabase
- System Error CodesError
- ORA-02429: cannot drop index used for enforcement of unique/primary keyIndex
- Msg 3702:Cannot drop the database 'gcard' because it is currently in use.DatabaseGC
- throw er; // Unhandled 'error' eventError
- "alter system kill session" can crash the instance if IO slaves usedSession
- CRS-4534: Cannot communicate with Event Manager
- ERROR 1524 (HY000): Plugin is not loadedErrorPlugin
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- Uncaught Error: Cannot instantiate interfaceError
- ‘error: ‘‘this‘‘ cannot be implicitly captured in this context‘ErrorAPTContext
- Material type ROH cannot be used with item category L (plant T001)Go
- WCF The service cannot be activated because it does not support ASP.NET compatibilityASP.NET
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase