MySQL Forums
Forum List  »  Events (Job Scheduler)

Event Scheduler: Failed to open table mysql.event
Posted by: owen 迈克尔
Date: March 05, 2015 02:47AM

MySQL version: 5.6.22-enterprise-commercial-advanced
Opration System: CentOS 7

input command 'service mysql start' in terminal

hint start success, than input commant 'mysql' in terminal

hint error
' Lost connection to MySQL server at 'reading initial communication packet', system error: 104'

see log

150305 03:38:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-03-05 03:38:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-03-05 03:38:06 2637 [Note] Plugin 'FEDERATED' is disabled.
2015-03-05 03:38:06 2637 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-05 03:38:06 2637 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-05 03:38:06 2637 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-03-05 03:38:06 2637 [Note] InnoDB: Memory barrier is not used
2015-03-05 03:38:06 2637 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-05 03:38:06 2637 [Note] InnoDB: Using Linux native AIO
2015-03-05 03:38:06 2637 [Note] InnoDB: Using CPU crc32 instructions
2015-03-05 03:38:06 2637 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-05 03:38:07 2637 [Note] InnoDB: Completed initialization of buffer pool
2015-03-05 03:38:07 2637 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-05 03:38:07 2637 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-05 03:38:07 2637 [Note] InnoDB: Waiting for purge to start
2015-03-05 03:38:07 2637 [Note] InnoDB: 5.6.22 started; log sequence number 1626203
2015-03-05 03:38:07 2637 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-03-05 03:38:07 2637 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-03-05 03:38:07 2637 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-05 03:38:07 2637 [Note] IPv6 is available.
2015-03-05 03:38:07 2637 [Note] - '::' resolves to '::';
2015-03-05 03:38:07 2637 [Note] Server socket created on IP: '::'.
2015-03-05 03:38:09 2637 [ERROR] Event Scheduler: Failed to open table mysql.event
2015-03-05 03:38:09 2637 [ERROR] Event Scheduler: Error while loading from disk.
2015-03-05 03:38:09 2637 [Note] Event Scheduler: Purging the queue. 0 events
2015-03-05 03:38:09 2637 [ERROR] Aborting

2015-03-05 03:38:09 2637 [Note] Binlog end
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'partition'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'ARCHIVE'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-05 03:38:09 2637 [Note] Shutting down plugin 'InnoDB'
2015-03-05 03:38:09 2637 [Note] InnoDB: FTS optimize thread exiting.
2015-03-05 03:38:09 2637 [Note] InnoDB: Starting shutdown...
2015-03-05 03:38:11 2637 [Note] InnoDB: Shutdown completed; log sequence number 1626213
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'MyISAM'
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'CSV'
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'MEMORY'
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'sha256_password'
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'mysql_old_password'
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'mysql_native_password'
2015-03-05 03:38:11 2637 [Note] Shutting down plugin 'binlog'
2015-03-05 03:38:11 2637 [Note] /usr/sbin/mysqld: Shutdown complete

Error in my_thread_global_end(): 1 threads didn't exit
150305 03:38:16 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended

cause:
2015-03-05 03:38:09 2637 [ERROR] Event Scheduler: Failed to open table mysql.event
2015-03-05 03:38:09 2637 [ERROR] Event Scheduler: Error while loading from disk.

How do I need to do to solve this problem?

Options: ReplyQuote


Subject
Views
Written By
Posted
Event Scheduler: Failed to open table mysql.event
5195
March 05, 2015 02:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.