vicidial.org

VICIDIAL astGUIclient discussion forum

Skip to content

Vicidial.org Home      Vicidial Forum      Vicidial Wiki      Vicidial Issue Tracker      astGUIclient Project Page


Errors during mysqlcheck and repair

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Post a reply

Errors during mysqlcheck and repair

Postby Trying » Sun Apr 13, 2014 7:28 am

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
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa
Top

Re: Errors during mysqlcheck and repair

Postby glenewhittenberg » Fri Apr 18, 2014 5:47 am

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
Single Server:
SuSE 12.3 (x86_64) : ViciBox v.5.0.2-130821 : Asterisk 1.8.26.1-vici : astGUI 2.8b0.5 : SVN = 2088
Mysql 5.5.33-MariaDB-log : Xeon E5-2620, 4x 8GB ECC 1600 RAM, 4x 2TB WD RE4 SATA3 RAID10
glenewhittenberg
 
Posts: 54
Joined: Fri Jan 03, 2014 1:15 am
Top

Re: Errors during mysqlcheck and repair

Postby Trying » Fri Apr 18, 2014 6:07 am

Error: mysqlcheck doesn't support multiple contradicting commands.


MySQL does not like that command
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa
Top

Re: Errors during mysqlcheck and repair

Postby glenewhittenberg » Fri Apr 18, 2014 6:42 am

my bad.

Code: Select all
/usr/bin/mysqlcheck -u root -p --auto-repair --check --all-databases
Single Server:
SuSE 12.3 (x86_64) : ViciBox v.5.0.2-130821 : Asterisk 1.8.26.1-vici : astGUI 2.8b0.5 : SVN = 2088
Mysql 5.5.33-MariaDB-log : Xeon E5-2620, 4x 8GB ECC 1600 RAM, 4x 2TB WD RE4 SATA3 RAID10
glenewhittenberg
 
Posts: 54
Joined: Fri Jan 03, 2014 1:15 am
Top

Re: Errors during mysqlcheck and repair

Postby boybawang » Fri Apr 18, 2014 7:09 am

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
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 989
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines
Top

Re: Errors during mysqlcheck and repair

Postby glenewhittenberg » Fri Apr 18, 2014 7:13 am

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/
Single Server:
SuSE 12.3 (x86_64) : ViciBox v.5.0.2-130821 : Asterisk 1.8.26.1-vici : astGUI 2.8b0.5 : SVN = 2088
Mysql 5.5.33-MariaDB-log : Xeon E5-2620, 4x 8GB ECC 1600 RAM, 4x 2TB WD RE4 SATA3 RAID10
glenewhittenberg
 
Posts: 54
Joined: Fri Jan 03, 2014 1:15 am
Top

Re: Errors during mysqlcheck and repair

Postby glenewhittenberg » Fri Apr 18, 2014 7:28 am

Whats you MySQL or MariaDB version? Is MyISAM your storage engine?
Single Server:
SuSE 12.3 (x86_64) : ViciBox v.5.0.2-130821 : Asterisk 1.8.26.1-vici : astGUI 2.8b0.5 : SVN = 2088
Mysql 5.5.33-MariaDB-log : Xeon E5-2620, 4x 8GB ECC 1600 RAM, 4x 2TB WD RE4 SATA3 RAID10
glenewhittenberg
 
Posts: 54
Joined: Fri Jan 03, 2014 1:15 am
Top
Post a reply

Return to Support

Who is online

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

Powered by phpBB® Forum Software © phpBB Group