vicidial.org

VICIDIAL astGUIclient discussion forum
http://forum.eflo.net/VICIDIALforum/

Errors during mysqlcheck and repair

http://forum.eflo.net/VICIDIALforum/viewtopic.php?f=4&t=32828

Page 1 of 1

Errors during mysqlcheck and repair

PostPosted: Sun Apr 13, 2014 7:28 am
by Trying
Is the below something to be worried about?

performance_schema.cond_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_current
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_history
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_history_long
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_by_instance
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_by_thread_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_global_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_summary_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_summary_by_instance
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.mutex_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.performance_timers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.rwlock_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_consumers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_instruments
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_timers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.threads
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt

Repairing tables
performance_schema.cond_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_current
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_history
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_history_long
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_by_instance
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_by_thread_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_global_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_summary_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_summary_by_instance
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.mutex_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.performance_timers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.rwlock_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_consumers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_instruments
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_timers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.threads
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt

Re: Errors during mysqlcheck and repair

PostPosted: Fri Apr 18, 2014 5:47 am
by glenewhittenberg
I do not get anything like that when on my servers. It would concern me if I did though. What is your output when you run this? (Backup Backup Backup :P )

Code: Select all
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

Re: Errors during mysqlcheck and repair

PostPosted: Fri Apr 18, 2014 6:07 am
by Trying
Error: mysqlcheck doesn't support multiple contradicting commands.


MySQL does not like that command

Re: Errors during mysqlcheck and repair

PostPosted: Fri Apr 18, 2014 6:42 am
by glenewhittenberg
my bad.

Code: Select all
/usr/bin/mysqlcheck -u root -p --auto-repair --check --all-databases

Re: Errors during mysqlcheck and repair

PostPosted: Fri Apr 18, 2014 7:09 am
by boybawang
Trying wrote:Is the below something to be worried about?

performance_schema.cond_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_current
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_history
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_history_long
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_by_instance
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_by_thread_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_global_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_summary_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_summary_by_instance
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.mutex_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.performance_timers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.rwlock_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_consumers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_instruments
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_timers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.threads
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt

Repairing tables
performance_schema.cond_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_current
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_history
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_history_long
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_by_instance
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_by_thread_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.events_waits_summary_global_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_summary_by_event_name
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.file_summary_by_instance
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.mutex_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.performance_timers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.rwlock_instances
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_consumers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_instruments
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.setup_timers
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt
performance_schema.threads
Error : Unknown table engine 'PERFORMANCE_SCHEMA'
error : Corrupt



do a myisamchk

Re: Errors during mysqlcheck and repair

PostPosted: Fri Apr 18, 2014 7:13 am
by glenewhittenberg
is there even and asterisk database on this server?

Here is a post from Matt B

Another MYSQL repair for vicidial/asterisk

1. stop sql

/etc/init.d/mysql stop

2. change dir to asterisk database

cd /var/lib/mysql/asterisk

3. look at log for crashed table(s)

myisamchk *.MYI > /root/myisamchk.log

4. repair database

myisamchk --silent --force --fast --update-state \ --key_buffer_size=512M --sort_buffer_size=512M \ --read_buffer_size=4M --write_buffer_size=4M <crashed table name>.MYI

5. when it is done repairing, start mysql again

/etc/init.d/mysql start

Matt Borchert
Support Staff - ViciDial Group and ViciHosting
8601 4th St. N. - Suite 304 - Saint Petersburg, FL 33702 USA
Email: support@vicidial.com - Web: http://www.vicidial.com/

Re: Errors during mysqlcheck and repair

PostPosted: Fri Apr 18, 2014 7:28 am
by glenewhittenberg
Whats you MySQL or MariaDB version? Is MyISAM your storage engine?
All times are UTC - 5 hours
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/