Link to home
Start Free TrialLog in
Avatar of sharingsunshine
sharingsunshineFlag for United States of America

asked on

Incorrect definition of table mysql.proc

I  have setup a test LAMP site on VMware Workstation 12 using Centos 6.  I found out I have a problem by trying to update a field and the update not being honored.  Looking at the logs this is what it says after a restart on mysqld 5.5.48:

170214  7:55:14  InnoDB: Shutdown completed; log sequence number 18256669930
170214  7:55:14 [Note] /usr/libexec/mysqld: Shutdown complete

170214 07:55:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170214 07:55:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170214  7:55:14 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 7942 ...
170214  7:55:14 [Note] Plugin 'FEDERATED' is disabled.
170214  7:55:14 InnoDB: The InnoDB memory heap is disabled
170214  7:55:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170214  7:55:14 InnoDB: Compressed tables use zlib 1.2.3
170214  7:55:14 InnoDB: Using Linux native AIO
170214  7:55:14 InnoDB: Initializing buffer pool, size = 128.0M
170214  7:55:14 InnoDB: Completed initialization of buffer pool
170214  7:55:14 InnoDB: highest supported file format is Barracuda.
170214  7:55:14  InnoDB: Waiting for the background threads to start
170214  7:55:15 InnoDB: 5.5.48 started; log sequence number 18256669930
170214  7:55:15 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170214  7:55:15 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170214  7:55:15 [Note] Server socket created on IP: '0.0.0.0'.
170214  7:55:15 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
170214  7:55:15 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
170214  7:55:15 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
170214  7:55:15 [Note] Event Scheduler: Loaded 0 events
170214  7:55:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.48'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170214  7:55:40 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).

Open in new window


What can I do to fix this situation?

Thanks,
Avatar of gheist
gheist
Flag of Belgium image

You can use supported MySQl 5.1 included with CentOS, REMi repositories are known source of dependency problems.
Avatar of sharingsunshine

ASKER

Thanks for the suggestion and the warning of REMI I will definitely avoid them in the future.

Now how do I downgrade to 5.1?
Since you are just starting - just reinstall machine.
I am not just starting out.  This DB is the product of a lengthy upgrade to a higher version of my existing s/w.  

It wasn't an easy upgrade and I had to devote several hours due to the amount of transactions that had to be converted.


Is there a way to upgrade the DB without having to start completely over?
Back up /var/lib/mysql and restore on a fresh centos with factory shipped mysql.
In-place upgrade of data takes very long, migration via replication is less intrusive.
I am using VMware Workstation Pro 12 so to make a fresh centos is about 6 hours of work unless you know of an appliance I can download and use that has Centos 6 and MySQL.  If not, I wlll need to do the in-place upgrade method.  Can you tell me the steps even though it is longer?
ASKER CERTIFIED SOLUTION
Avatar of gheist
gheist
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial