Author |
Message |
mattbatt
|
Posted: Wed Jun 03, 2015 10:32 pm |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
|
Top |
|
|
mattbatt
|
Posted: Sat Jun 06, 2015 9:32 pm |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
Here are the warnings I found. Code: 140713 23:13:01 [Note] Event Scheduler: Purging the queue. 0 events 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 183 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 172 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 141 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 133 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 88 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 20 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 17 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 15 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 14 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 12 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 6 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 5 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 4 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 3 user: 'mythtv'
140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 2 user: 'mythtv'
140713 23:13:03 InnoDB: Starting shutdown... 140713 23:13:04 InnoDB: Shutdown completed; log sequence number 2982779 140713 23:13:04 [Note] /usr/bin/mysqld: Shutdown complete
140713 23:13:04 mysqld_safe mysqld from pid file /data/srv/mysql/gimli.pid ended 140713 23:13:51 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql 140713 23:13:55 InnoDB: The InnoDB memory heap is disabled 140713 23:13:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140713 23:13:55 InnoDB: Compressed tables use zlib 1.2.7 140713 23:13:56 InnoDB: Initializing buffer pool, size = 128.0M 140713 23:13:56 InnoDB: Completed initialization of buffer pool 140713 23:13:56 InnoDB: highest supported file format is Barracuda. 140713 23:13:59 InnoDB: Waiting for the background threads to start 140713 23:14:00 InnoDB: 1.1.8 started; log sequence number 2982779 140713 23:14:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140713 23:14:00 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140713 23:14:00 [Note] Server socket created on IP: '0.0.0.0'. 140713 23:14:02 [Note] Event Scheduler: Loaded 0 events 140713 23:14:02 [Note] /usr/bin/mysqld: ready for connections. Version: '5.5.28' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution 140713 23:19:27 [Note] /usr/bin/mysqld: Normal shutdown
140713 23:19:27 [Note] Event Scheduler: Purging the queue. 0 events 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 37 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 24 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 21 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 20 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 19 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 18 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 16 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 15 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 14 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 13 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 12 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 10 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 9 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 8 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 7 user: 'mythtv'
140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 4 user: 'mythtv'
140713 23:19:29 InnoDB: Starting shutdown... 140713 23:19:29 InnoDB: Shutdown completed; log sequence number 2982779 140713 23:19:29 [Note] /usr/bin/mysqld: Shutdown complete
140713 23:19:29 mysqld_safe mysqld from pid file /data/srv/mysql/gimli.pid ended 140714 00:45:55 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql
Code: 140714 140714 3:02:56 [ERROR] Invalid (old?) table or database name 'lost+found' 140714 10:20:57 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql 140714 10:21:00 InnoDB: The InnoDB memory heap is disabled 140714 10:21:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140714 10:21:00 InnoDB: Compressed tables use zlib 1.2.7 140714 10:21:00 InnoDB: Initializing buffer pool, size = 128.0M 140714 10:21:01 InnoDB: Completed initialization of buffer pool 140714 10:21:01 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140714 10:21:01 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140714 10:21:05 InnoDB: Waiting for the background threads to start 140714 10:21:06 InnoDB: 1.1.8 started; log sequence number 3282695 140714 10:21:06 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140714 10:21:06 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140714 10:21:06 [Note] Server socket created on IP: '0.0.0.0'. 140714 10:21:07 [Note] Event Scheduler: Loaded 0 events 140714 10:21:07 [Note] /usr/bin/mysqld: ready for connections. Version: '5.5.28' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution 140714 23:04:05 [Note] /usr/bin/mysqld: Normal shutdown
_________________ My System
|
|
Top |
|
|
mattbatt
|
Posted: Sat Jun 06, 2015 9:40 pm |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
these keep repeating Code: 2015-03-31 00:15:35 1542 [Note] RSA private key file not found: /data/srv/mysql//private_key.pem. Some authentication plugins will not work. 2015-03-31 00:15:35 1542 [Note] RSA public key file not found: /data/srv/mysql//public_key.pem. Some authentication plugins will not work. 2015-03-31 00:15:35 1542 [Note] Server hostname (bind-address): '*'; port: 3306 2015-03-31 00:15:35 1542 [Note] IPv6 is available. 2015-03-31 00:15:35 1542 [Note] - '::' resolves to '::'; 2015-03-31 00:15:35 1542 [Note] Server socket created on IP: '::'. 2015-03-31 00:15:36 1542 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2015-03-31 00:15:36 1542 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2015-03-31 00:15:36 1542 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:36 1542 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:36 1542 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:36 1542 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11). 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:37 1542 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure 2015-03-31 00:15:37 1542 [Note] Event Scheduler: Loaded 0 events 2015-03-31 00:15:37 1542 [Note] /usr/bin/mysqld: ready for connections. Version: '5.6.23' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2015-03-31 00:55:06 1542 [Note] /usr/bin/mysqld: Normal shutdown
2015-03-31 00:55:06 1542 [Note] Giving 6 client threads a chance to die gracefully 2015-03-31 00:55:06 1542 [Note] Event Scheduler: Purging the queue. 0 events 2015-03-31 00:55:06 1542 [Note] Shutting down slave threads 2015-03-31 00:55:08 1542 [Note] Forcefully disconnecting 2 remaining clients 2015-03-31 00:55:08 1542 [Warning] /usr/bin/mysqld: Forcing close of thread 24 user: 'mythtv'
2015-03-31 00:55:08 1542 [Warning] /usr/bin/mysqld: Forcing close of thread 11430 user: 'mythtv'
2015-03-31 00:55:08 1542 [Note] Binlog end 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'partition' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_METRICS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMP' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_TRX' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'InnoDB' 2015-03-31 00:55:08 1542 [Note] InnoDB: FTS optimize thread exiting. 2015-03-31 00:55:08 1542 [Note] InnoDB: Starting shutdown... 2015-03-31 00:55:09 1542 [Note] InnoDB: Shutdown completed; log sequence number 45612514 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'BLACKHOLE' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'ARCHIVE' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'CSV' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'MEMORY' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'MRG_MYISAM' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'MyISAM' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'sha256_password' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'mysql_old_password' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'mysql_native_password' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'binlog' 2015-03-31 00:55:09 1542 [Note] /usr/bin/mysqld: Shutdown complete
150331 00:55:10 mysqld_safe mysqld from pid file /data/srv/mysql/gimli.pid ended 150331 00:56:17 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql 2015-03-31 00:56:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-03-31 00:56:19 1523 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-03-31 00:56:19 1523 [Note] InnoDB: The InnoDB memory heap is disabled 2015-03-31 00:56:19 1523 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-03-31 00:56:19 1523 [Note] InnoDB: Memory barrier is not used 2015-03-31 00:56:19 1523 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-03-31 00:56:19 1523 [Note] InnoDB: Using Linux native AIO 2015-03-31 00:56:19 1523 [Note] InnoDB: Not using CPU crc32 instructions 2015-03-31 00:56:19 1523 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-03-31 00:56:20 1523 [Note] InnoDB: Completed initialization of buffer pool 2015-03-31 00:56:20 1523 [Note] InnoDB: Highest supported file format is Barracuda. 2015-03-31 00:56:30 1523 [Note] InnoDB: 128 rollback segment(s) are active. 2015-03-31 00:56:30 1523 [Note] InnoDB: Waiting for purge to start 2015-03-31 00:56:30 1523 [Note] InnoDB: 5.6.23 started; log sequence number 45612514 2015-03-31 00:56:30 1523 [Note] RSA private key file not found: /data/srv/mysql//private_key.pem. Some authentication plugins will not work. 2015-03-31 00:56:30 1523 [Note] RSA public key file not found: /data/srv/mysql//public_key.pem. Some authentication plugins will not work. 2015-03-31 00:56:30 1523 [Note] Server hostname (bind-address): '*'; port: 3306 2015-03-31 00:56:30 1523 [Note] IPv6 is available. 2015-03-31 00:56:30 1523 [Note] - '::' resolves to '::'; 2015-03-31 00:56:30 1523 [Note] Server socket created on IP: '::'. 2015-03-31 00:56:30 1523 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2015-03-31 00:56:30 1523 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11). 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
_________________ My System
|
|
Top |
|
|
mattbatt
|
Posted: Sat Jun 06, 2015 9:44 pm |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
I think this might be the key "please use mysql upgrade to fix this error. How do I do that? Code: 2015-03-31 00:56:30 1523 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2015-03-31 00:56:30 1523 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error.
_________________ My System
|
|
Top |
|
|
tscholl
|
Posted: Sun Jun 07, 2015 12:37 pm |
|
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location:
Lexington, Ky
|
Almost sounds like a wrong version of the database was restored.
|
|
Top |
|
|
mattbatt
|
Posted: Mon Jun 08, 2015 9:39 pm |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
Here is the last two days entries into /data/srv/mysql/gimli.err I notice that all of these errors show up around the time I shut down LinHES. Code: 2015-06-07 00:38:19 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:19 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:19 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:19 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."music_radios" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."music_radios" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."music_radios" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:25 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:25 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:25 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:25 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."record_tmp" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."record_tmp" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."record_tmp" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:31 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:31 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:31 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:31 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherscreens" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherscreens" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherscreens" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:40 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:38:41 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:41 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:42 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:42 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2015-06-07 00:46:32 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:46:33 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:46:33 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:46:59 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:47:00 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:47:00 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 01:00:49 1668 [Note] /usr/bin/mysqld: Normal shutdown
2015-06-07 01:00:49 1668 [Note] Giving 4 client threads a chance to die gracefully 2015-06-07 01:00:49 1668 [Note] Event Scheduler: Purging the queue. 0 events 2015-06-07 01:00:50 1668 [Note] Shutting down slave threads 2015-06-07 01:00:52 1668 [Note] Forcefully disconnecting 4 remaining clients 2015-06-07 01:00:52 1668 [Warning] /usr/bin/mysqld: Forcing close of thread 3660402 user: 'mythtv'
2015-06-07 01:00:52 1668 [Warning] /usr/bin/mysqld: Forcing close of thread 3609483 user: 'mythtv'
2015-06-07 01:00:52 1668 [Warning] /usr/bin/mysqld: Forcing close of thread 3654003 user: 'mythtv'
2015-06-07 01:00:52 1668 [Warning] /usr/bin/mysqld: Forcing close of thread 3660345 user: 'mythtv'
2015-06-07 01:00:52 1668 [Note] Binlog end 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'partition' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_METRICS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMP' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_TRX' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'InnoDB' 2015-06-07 01:00:53 1668 [Note] InnoDB: FTS optimize thread exiting. 2015-06-07 01:00:53 1668 [Note] InnoDB: Starting shutdown... 2015-06-07 01:00:59 1668 [Note] InnoDB: Shutdown completed; log sequence number 59573264 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'BLACKHOLE' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'ARCHIVE' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'CSV' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'MEMORY' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'MRG_MYISAM' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'MyISAM' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'sha256_password' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'mysql_old_password' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'mysql_native_password' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'binlog' 2015-06-07 01:00:59 1668 [Note] /usr/bin/mysqld: Shutdown complete
150607 01:01:00 mysqld_safe mysqld from pid file /data/srv/mysql/gimli.pid ended 150607 01:06:43 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql 2015-06-07 01:06:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-06-07 01:06:49 1544 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-06-07 01:06:49 1544 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-07 01:06:49 1544 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-06-07 01:06:49 1544 [Note] InnoDB: Memory barrier is not used 2015-06-07 01:06:49 1544 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-06-07 01:06:49 1544 [Note] InnoDB: Using Linux native AIO 2015-06-07 01:06:49 1544 [Note] InnoDB: Not using CPU crc32 instructions 2015-06-07 01:06:49 1544 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-06-07 01:06:49 1544 [Note] InnoDB: Completed initialization of buffer pool 2015-06-07 01:06:50 1544 [Note] InnoDB: Highest supported file format is Barracuda. 2015-06-07 01:06:56 1544 [Note] InnoDB: 128 rollback segment(s) are active. 2015-06-07 01:06:56 1544 [Note] InnoDB: Waiting for purge to start 2015-06-07 01:06:56 1544 [Note] InnoDB: 5.6.23 started; log sequence number 59573264 2015-06-07 01:06:56 1544 [Note] RSA private key file not found: /data/srv/mysql//private_key.pem. Some authentication plugins will not work. 2015-06-07 01:06:56 1544 [Note] RSA public key file not found: /data/srv/mysql//public_key.pem. Some authentication plugins will not work. 2015-06-07 01:06:56 1544 [Note] Server hostname (bind-address): '*'; port: 3306 2015-06-07 01:06:56 1544 [Note] IPv6 is available. 2015-06-07 01:06:56 1544 [Note] - '::' resolves to '::'; 2015-06-07 01:06:56 1544 [Note] Server socket created on IP: '::'. 2015-06-07 01:06:59 1544 [Note] Event Scheduler: Loaded 0 events 2015-06-07 01:06:59 1544 [Note] /usr/bin/mysqld: ready for connections. Version: '5.6.23' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2015-06-08 00:38:32 1544 [ERROR] Invalid (old?) table or database name 'lost+found'
_________________ My System
|
|
Top |
|
|
mattbatt
|
Posted: Mon Jun 08, 2015 9:43 pm |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
BTW I did do the database upgrade as suggested in the error log, however it was very quiet so I'm not sure what it did if anything.
_________________ My System
|
|
Top |
|
|
mattbatt
|
Posted: Tue Jun 23, 2015 9:05 pm |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
|
Top |
|
|
tscholl
|
Posted: Wed Jun 24, 2015 9:01 am |
|
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location:
Lexington, Ky
|
Do you have backend logging to the database enabled? I had a problem with this awhile back and had a discussion on how to disable it. http://forum.linhes.org/viewtopic.php?f ... t=+loggingIf thats the case you could truncate the log tables. Just a thought. Also what version are you running?
|
|
Top |
|
|
mattbatt
|
Posted: Wed Jun 24, 2015 9:23 pm |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
8.3 everything should be up to date. I'll give that a try soon. Would the logging have turned it'self on a few months ago or when I upgraded to 8.3 . That's about when the problems started.
_________________ My System
|
|
Top |
|
|
tscholl
|
Posted: Thu Jun 25, 2015 8:20 am |
|
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location:
Lexington, Ky
|
I wouldn't think so unless you have a custom script somewhere. Log into mysql
mysql -umythtv -p mythconverg
select * from logging
will tell you whats there.
TRUNCATE TABLE logging;
should clear the logging table if it has data there,
|
|
Top |
|
|
mattbatt
|
Posted: Thu Jun 25, 2015 3:32 pm |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
Well my mythbackend.log is only 444Kb so that's not nearly as big as my sudo log 70Mb. There is still something making my backups huge.
_________________ My System
|
|
Top |
|
|
mattbatt
|
Posted: Fri Jun 26, 2015 5:40 am |
|
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location:
Orlando FL
|
it looks like the partition for /data/srv/mysql is getting filled by ibdata1, ib_logfile0 and ib_logfile1 can anyone else confirm these are or are not normal sizes for these files? Code: # ls -lha total 116M drwx------ 10 mysql root 4.0K Jun 23 19:04 . drwxr-xr-x 5 root root 4.0K Apr 22 20:56 .. -rw-rw---- 1 mysql mysql 56 Mar 27 00:40 auto.cnf -rw-rw---- 1 mysql root 1.5M Jun 26 00:06 gimli.err -rw-rw---- 1 mysql mysql 5 Jun 23 19:04 gimli.pid -rw-rw---- 1 mysql mysql 18M Jun 26 00:06 ibdata1 -rw-rw---- 1 mysql mysql 48M Jun 26 00:06 ib_logfile0 -rw-rw---- 1 mysql mysql 48M Mar 27 00:40 ib_logfile1 drwx------ 2 mysql mysql 4.0K Jun 7 00:46 lost@002bfound drwx------ 2 root root 16K Jul 10 2014 lost+found drwx------ 2 mysql root 4.0K Jun 7 00:47 mysql -rw-r--r-- 1 root root 6 Jun 7 00:47 mysql_upgrade_info drwx------ 2 mysql mysql 20K Jun 26 00:06 mythconverg drwx------ 2 mysql mysql 4.0K Jul 14 2014 ncid drwx------ 2 mysql mysql 4.0K Jun 7 00:46 performance_schema drwx------ 2 mysql root 4.0K Jan 8 2014 test drwx------ 2 mysql mysql 4.0K Jul 14 2014 zm
_________________ My System
|
|
Top |
|
|
brfransen
|
Posted: Fri Jun 26, 2015 7:23 am |
|
Joined: Fri Jul 21, 2006 11:12 pm
Posts: 1194
Location:
SC
|
Those are all about the same size on my system. mythconverg is where you will probably find what the largest table are. Use sudo ncdu /data/srv/mysql (install if needed: pacman -S ncdu) to find the largest files.
|
|
Top |
|
|
bgrant3406
|
Posted: Fri Jun 26, 2015 1:44 pm |
|
Joined: Tue Jul 01, 2014 6:49 am
Posts: 92
|
Took a quick peek at my Mythconverg directory and here is what I see, I have about 400 SD/HD recordings stored as a point of reference, my "iblog" files are in the same range (if not identical) to what you have posted. Code: [root@mbe mythconverg]# ls -lSh total 234M -rw-rw---- 1 mysql mysql 105M Jun 26 00:10 recordedseek.MYD -rw-rw---- 1 mysql mysql 96M Jun 26 00:10 recordedseek.MYI -rw-rw---- 1 mysql mysql 4.6M Jun 26 05:29 program.MYI -rw-rw---- 1 mysql mysql 4.0M Jun 26 08:59 oldrecorded.MYI -rw-rw---- 1 mysql mysql 3.6M Jun 26 05:29 credits.MYI -rw-rw---- 1 mysql mysql 3.3M Jun 26 05:29 program.MYD -rw-rw---- 1 mysql mysql 3.3M Jun 26 08:59 oldrecorded.MYD -rw-rw---- 1 mysql mysql 1.9M Jun 26 05:29 people.MYI -rw-rw---- 1 mysql mysql 1.6M Jun 26 05:29 credits.MYD -rw-rw---- 1 mysql mysql 1.4M Jun 26 05:29 people.MYD -rw-rw---- 1 mysql mysql 513K Jun 26 05:29 programgenres.MYD -rw-rw---- 1 mysql mysql 470K Jun 26 05:29 programgenres.MYI -rw-rw---- 1 mysql mysql 428K Jun 26 05:29 programrating.MYI -rw-rw---- 1 mysql mysql 400K Jun 26 05:29 programrating.MYD -rw-rw---- 1 mysql mysql 251K Jun 26 00:10 recordedcredits.MYI -rw-rw---- 1 mysql mysql 224K Jun 26 00:10 record_tmp.ibd -rw-rw---- 1 mysql mysql 192K Jun 26 00:10 music_songs.ibd -rw-rw---- 1 mysql mysql 192K Jun 26 00:10 romdb.ibd -rw-rw---- 1 mysql mysql 176K Jun 26 00:10 gamemetadata.ibd -rw-rw---- 1 mysql mysql 171K Jun 26 00:10 oldprogram.MYD -rw-rw---- 1 mysql mysql 164K Jun 26 00:10 recordedmarkup.MYI -rw-rw---- 1 mysql mysql 150K Jun 26 11:21 recorded.MYD
|
|
Top |
|
|