View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 20 posts ] 
Go to page 1, 2  Next

Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Wed Jun 03, 2015 10:32 pm 
Offline
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location: Orlando FL
So I got an error that my backup partition was 98% full. I also discovered using xymon that MySQL database is heading towards filling the drive as well.

Here's the graph:
https://www.dropbox.com/s/43yvr59z854ju ... h.png?dl=0

Here is the err file https://www.dropbox.com/s/d7vxog4fk9gup ... i.txt?dl=0

OK how do I fix this?

_________________
My System


Top
 Profile  
 
PostPosted: Sat Jun 06, 2015 9:32 pm 
Offline
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
 Profile  
 
PostPosted: Sat Jun 06, 2015 9:40 pm 
Offline
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
 Profile  
 
PostPosted: Sat Jun 06, 2015 9:44 pm 
Offline
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
 Profile  
 
PostPosted: Sun Jun 07, 2015 12:37 pm 
Offline
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
 Profile  
 
PostPosted: Mon Jun 08, 2015 9:39 pm 
Offline
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
 Profile  
 
PostPosted: Mon Jun 08, 2015 9:43 pm 
Offline
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
 Profile  
 
PostPosted: Tue Jun 23, 2015 9:05 pm 
Offline
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location: Orlando FL
update: my /data/srv/mysql drive is almost full now too. [img] https://www.dropbox.com/s/f1d1w7uvn18f4 ... .png?raw=1
[/img]

_________________
My System


Top
 Profile  
 
PostPosted: Wed Jun 24, 2015 9:01 am 
Offline
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=+logging

If thats the case you could truncate the log tables.

Just a thought. Also what version are you running?


Top
 Profile  
 
PostPosted: Wed Jun 24, 2015 9:23 pm 
Offline
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
 Profile  
 
PostPosted: Thu Jun 25, 2015 8:20 am 
Offline
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
 Profile  
 
PostPosted: Thu Jun 25, 2015 3:32 pm 
Offline
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
 Profile  
 
PostPosted: Fri Jun 26, 2015 5:40 am 
Offline
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
 Profile  
 
PostPosted: Fri Jun 26, 2015 7:23 am 
Offline
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
 Profile  
 
PostPosted: Fri Jun 26, 2015 1:44 pm 
Offline
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
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 20 posts ] 
Go to page 1, 2  Next



All times are UTC - 6 hours




Who is online

Users browsing this forum: Google [Bot] and 14 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu