Re: Corruptions like crazy
I tried the shutdown "service mysqld stop" then did the fix and then restarted with "service mysqld start". I also ran the check to make sure no errors were reprorting. I then did an update with my website (addition to the three mysql tables) and I got the exact same errors as described in post #1. So I decided to look at the /var/log/mysqld.log again. Below is what I see since the shutdown. I don't think these errors relate to my database corruption. However I guess I should figure out how to run the "mysql_upgrade" that it refers too. I installed it with yum. I am not sure if it is referring to "yum update mysql-server". I suspect not.
150429 15:13:53 [Note] /usr/libexec/mysqld: Normal shutdown
150429 15:13:53 InnoDB: Starting shutdown...
150429 15:13:54 InnoDB: Shutdown completed; log sequence number 1588771
150429 15:13:54 [Note] /usr/libexec/mysqld: Shutdown complete
150429 15:13:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150429 15:14:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150429 15:14:19 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
150429 15:14:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
150429 15:14:19 InnoDB: The InnoDB memory heap is disabled
150429 15:14:19 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
150429 15:14:19 InnoDB: Compressed tables use zlib 1.2.3
150429 15:14:19 InnoDB: Using Linux native AIO
150429 15:14:19 InnoDB: Initializing buffer pool, size = 128.0M
150429 15:14:19 InnoDB: Completed initialization of buffer pool
150429 15:14:19 InnoDB: highest supported file format is Barracuda.
150429 15:14:21 InnoDB: Waiting for the background threads to start
150429 15:14:22 InnoDB: 5.5.42 started; log sequence number 1588771
150429 15:14:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150429 15:14:23 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150429 15:14:23 [Note] Server socket created on IP: '0.0.0.0'.
150429 15:14:23 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
150429 15:14:23 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
150429 15:14:23 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
150429 15:14:23 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
150429 15:14:23 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50542. Please use mysql_upgrade to fix this error.
150429 15:14:23 [ERROR] mysql.user has no `Event_priv` column at position 29
150429 15:14:23 [ERROR] Cannot open mysql.event
150429 15:14:23 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
150429 15:14:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.42-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
150429 15:22:25 [ERROR] Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50095, now running 50542. Please use mysql_upgrade to fix this error.
Subject
Written By
Posted
Re: Corruptions like crazy
April 29, 2015 01:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.