MySQL EventID 10 Errors

shvercer · Post by **shvercer** » Tue Apr 17, 2012 12:29 pm

I keep on getting these SQL errors that are registering in the Event Logs. Is there any way to fix this issue to make them stop appearing?

Error Log Snapshot:
-----------------------
Level Date and Time Source Event ID Task Category
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'setup_timers' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'setup_instruments' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'threads' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'performance_timers' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_history' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_current' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'setup_consumers' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_history_long' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'rwlock_instances' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'mutex_instances' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'file_instances' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'cond_instances' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
Error 4/17/2012 2:11:21 PM MySQL 100 None "Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com. "
---------------------------------------------------------------------------------------------------

Regards

Post by **jordansparks** » Tue Apr 17, 2012 1:10 pm

Yes. First, verify that you are using MySQL 5.5, not 5.0. If you are not using 5.5, do not continue with the instructions below.

Download our installer.
http://www.opendental.com/trial.html
Right click, run as Admin. Ensure that all the paths are correct in that window. Take your time to do this right, especially if you are not familiar with our installer.
Uncheck all boxes along the left except MySQL 5.5 grant tables. Click Install.

shvercer · Post by **shvercer** » Thu Apr 19, 2012 3:52 pm

I've started over with a fresh installation on Windows Server 2008 R2 and left all the settings on default and I'm still getting the same error. I assume that the MySQL that came as part of the Trial Version is the correct one. The errors still appear like before.

Post by **jsalmon** » Thu Apr 19, 2012 4:48 pm

This is a known bug to MySQL, they suggest running mysql_upgrade (which is located in the bin folder of the installation path of MySQL). Just run that exe in cmd and the errors should stop occurring.

Post by **jordansparks** » Fri Apr 20, 2012 12:34 pm

It looks like there's a possibility that it's due to the grant tables that we distribute as part of our installer. We will be researching this immediately.

Post by **jordansparks** » Mon Apr 23, 2012 9:32 am

Ok, we got it figured out. Performance schema is something that we just don't use. The error messages are just on startup of MySQL. They are harmless can can be ignored. If they really bother you, you can run mysql_upgrade. We will be posting instructions in our manual within about a week.

joshuab · Post by **joshuab** » Tue May 01, 2012 7:04 am

Noticed the same errors while troubleshooting some performance issues (OD 12.1.16.0). They do appear to only be during mysql start. Glad to know they're harmless - will ignore (and not run the upgrade).

Justin Shafer · Post by **Justin Shafer** » Wed Jul 25, 2012 8:40 am

Sony Markose is still crashing..I am going to completely reinstall OD and MySQL... Then restore the DB..

Good to delete c:\programdata\mysql after the uninstall, but before the new install of mysql...

That is where all those tables are stored.

Updating to 5.5.26.. So far so good...

The errors are gone when you restart the service... Time to cross fingers.

Justin Shafer · Post by **Justin Shafer** » Wed Jul 25, 2012 10:12 am

Aww his server was just crashing... Optiplex 980 with a Kernel Power event.. I thought it was just OD crashing when entering notes from a Workstation....

Did a bios upgrade... Everything else is updated...

Cross fingers...

Justin Shafer · Post by **Justin Shafer** » Sat Sep 01, 2012 11:46 pm

So far so good.. I guess the bios upgrade helped.. Good.

Open Dental

MySQL EventID 10 Errors

MySQL EventID 10 Errors

Re: MySQL EventID 10 Errors

Re: MySQL EventID 10 Errors

Re: MySQL EventID 10 Errors

Re: MySQL EventID 10 Errors

Re: MySQL EventID 10 Errors

Re: MySQL EventID 10 Errors

Re: MySQL EventID 10 Errors

Re: MySQL EventID 10 Errors

Re: MySQL EventID 10 Errors