Power failure

Hello,

We had a power failure and since then I keep receiving email messages such as :

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 126 Incorrect key file for table './asterisk/kvstore.MYI'; try to repair it' in /var/www/html/admin/libraries/BMO/DB_Helper.class.php:232
Stack trace:
#0 /var/www/html/admin/libraries/BMO/DB_Helper.class.php(232): PDOStatement->execute(Array)
#1 /var/www/html/admin/modules/dashboard/Dashboard.class.php(186): DB_Helper->setConfig('latestsysinfo', Array)
#2 /var/www/html/admin/modules/dashboard/Dashboard.class.php(208): Dashboard->genSysInfo()
#3 /var/www/html/admin/modules/dashboard/Dashboard.class.php(161): Dashboard->getSysInfo()
#4 /var/www/html/admin/modules/dashboard/scheduler.php(16): Dashboard->runTrigger()
#5 {main}
 thrown in /var/www/html/admin/libraries/BMO/DB_Helper.class.php on line 232

or

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 126 Incorrect key file for table './asterisk/kvstore.MYI'; try to repair it' in /var/www/html/admin/libraries/BMO/DB_Helper.class.php:213
Stack trace:
#0 /var/www/html/admin/libraries/BMO/DB_Helper.class.php(213): PDOStatement->execute(Array)
#1 /var/www/html/admin/modules/dashboard/Dashboard.class.php(186): DB_Helper->setConfig('latestsysinfo', Array)
#2 /var/www/html/admin/modules/dashboard/Dashboard.class.php(208): Dashboard->genSysInfo()
#3 /var/www/html/admin/modules/dashboard/Dashboard.class.php(161): Dashboard->getSysInfo()
#4 /var/www/html/admin/modules/dashboard/scheduler.php(16): Dashboard->runTrigger()
#5 {main}
 thrown in /var/www/html/admin/libraries/BMO/DB_Helper.class.php on line 213

Any idea how to fix this?

mysqlcheck --auto-repair -c -o --all-databases

I did, here’s the output:

mysqlcheck --auto-repair -c -o --all-databases
asterisk.admin                                     OK
asterisk.ampusers                                  OK
asterisk.announcement                              OK
asterisk.backup                                    OK
asterisk.backup_cache                              OK
asterisk.backup_details                            OK
asterisk.backup_items                              OK
asterisk.backup_server_details                     OK
asterisk.backup_servers                            OK
asterisk.backup_template_details                   OK
asterisk.backup_templates                          OK
asterisk.callback                                  OK
asterisk.callrecording                             OK
asterisk.callrecording_module                      OK
asterisk.cidlookup                                 OK
asterisk.cidlookup_incoming                        OK
asterisk.cronmanager                               OK
asterisk.custom_destinations                       OK
asterisk.custom_extensions                         OK
asterisk.customcontexts_contexts                   OK
asterisk.customcontexts_contexts_list              OK
asterisk.customcontexts_includes                   OK
asterisk.customcontexts_includes_list              OK
asterisk.customcontexts_module                     OK
asterisk.dahdi                                     OK
asterisk.dahdi_advanced                            OK
asterisk.dahdi_advanced_modules                    OK
asterisk.dahdi_analog                              OK
asterisk.dahdi_configured_locations                OK
asterisk.dahdi_modules                             OK
asterisk.dahdi_spans                               OK
asterisk.dahdichandids                             OK
asterisk.daynight                                  OK
asterisk.devices                                   OK
asterisk.digium_phones_alerts                      OK
asterisk.digium_phones_customapp_settings          OK
asterisk.digium_phones_customapps                  OK
asterisk.digium_phones_device_alerts               OK
asterisk.digium_phones_device_customapps           OK
asterisk.digium_phones_device_externallines        OK
asterisk.digium_phones_device_logos                OK
asterisk.digium_phones_device_networks             OK
asterisk.digium_phones_device_phonebooks           OK
asterisk.digium_phones_device_ringtones            OK
asterisk.digium_phones_device_settings             OK
asterisk.digium_phones_device_statuses             OK
asterisk.digium_phones_devices                     OK
asterisk.digium_phones_extension_settings          OK
asterisk.digium_phones_externalline_settings       OK
asterisk.digium_phones_externallines               OK
asterisk.digium_phones_firmware                    OK
asterisk.digium_phones_firmware_packages           OK
asterisk.digium_phones_general                     OK
asterisk.digium_phones_lines                       OK
asterisk.digium_phones_logos                       OK
asterisk.digium_phones_network_settings            OK
asterisk.digium_phones_networks                    OK
asterisk.digium_phones_phonebook_entries           OK
asterisk.digium_phones_phonebook_entry_settings    OK
asterisk.digium_phones_phonebooks                  OK
asterisk.digium_phones_queues                      OK
asterisk.digium_phones_ringtones                   OK
asterisk.digium_phones_status_entries              OK
asterisk.digium_phones_status_settings             OK
asterisk.digium_phones_statuses                    OK
asterisk.digium_phones_voicemail_translations      OK
asterisk.digiumaddoninstaller_addons               OK
asterisk.digiumaddoninstaller_addons_downloads     OK
asterisk.digiumaddoninstaller_downloads            OK
asterisk.digiumaddoninstaller_downloads_ast_versions OK
asterisk.digiumaddoninstaller_downloads_bits       OK
asterisk.digiumaddoninstaller_registers            OK
asterisk.digiumaddoninstaller_system               OK
asterisk.directory_details                         OK
asterisk.directory_entries                         OK
asterisk.disa                                      OK
asterisk.endpoint_basefiles_211                    OK
asterisk.endpoint_buttons_211                      OK
asterisk.endpoint_ext_buttons                      OK
asterisk.endpointman_brand_list                    OK
asterisk.endpointman_custom_configs                OK
asterisk.endpointman_global_vars                   OK
asterisk.endpointman_line_list                     OK
asterisk.endpointman_mac_list                      OK
asterisk.endpointman_model_list                    OK
asterisk.endpointman_oui_list                      OK
asterisk.endpointman_product_list                  OK
asterisk.endpointman_template_list                 OK
asterisk.extensionroutes                           OK
asterisk.extensions                                OK
asterisk.fax_details                               OK
asterisk.fax_incoming                              OK
asterisk.fax_users                                 OK
asterisk.featurecodes                              OK
asterisk.findmefollow                              OK
asterisk.freepbx_log                               OK
asterisk.freepbx_settings                          OK
asterisk.freepbx_users                             OK
asterisk.freepbx_users_settings                    OK
asterisk.globals                                   OK
asterisk.hotelwakeup                               OK
asterisk.hotelwakeup_calls                         OK
asterisk.iax                                       OK
asterisk.iaxsettings                               OK
asterisk.incoming                                  OK
asterisk.indications_zonelist                      OK
asterisk.ivr_details                               OK
asterisk.ivr_entries                               OK
asterisk.kvstore                                   OK
asterisk.language_incoming                         OK
asterisk.languages                                 OK
asterisk.logfile_logfiles                          OK
asterisk.logfile_settings                          OK
asterisk.manager                                   OK
asterisk.meetme                                    OK
asterisk.miscapps                                  OK
asterisk.miscdests                                 OK
asterisk.module_xml                                OK
asterisk.modules                                   OK
asterisk.motif                                     OK
asterisk.notifications                             OK
asterisk.outbound_route_patterns                   OK
asterisk.outbound_route_sequence                   OK
asterisk.outbound_route_trunks                     OK
asterisk.outbound_routes                           OK
asterisk.outroutemsg                               OK
asterisk.paging_autoanswer                         OK
asterisk.paging_config                             OK
asterisk.paging_groups                             OK
asterisk.pagingpro                                 OK
asterisk.pagingpro_core_routing                    OK
asterisk.pagingpro_scheduler_crons                 OK
asterisk.pagingpro_scheduler_events                OK
asterisk.pagingpro_scheduler_exclusions            OK
asterisk.pagingpro_scheduler_range                 OK
asterisk.parkplus                                  OK
asterisk.phpagiconf                                OK
asterisk.pinset_usage                              OK
asterisk.pinsets                                   OK
asterisk.pjsip                                     OK
asterisk.presencestate_list                        OK
asterisk.presencestate_prefs                       OK
asterisk.queuemetrics_options                      OK
asterisk.queueprio                                 OK
asterisk.queues_config                             OK
asterisk.queues_details                            OK
asterisk.qxact_agent_actions                       OK
asterisk.qxact_agent_calls                         OK
asterisk.qxact_calls                               OK
asterisk.qxact_reports                             OK
asterisk.qxact_system_events                       OK
asterisk.recording_report                          OK
asterisk.recordings                                OK
asterisk.restapi_general                           OK
asterisk.restapi_log_event_details                 OK
asterisk.restapi_log_events                        OK
asterisk.restapi_token_details                     OK
asterisk.restapi_token_user_mapping                OK
asterisk.restapi_tokens                            OK
asterisk.restapps_settings                         OK
asterisk.restapps_stats                            OK
asterisk.ringgroups                                OK
asterisk.setcid                                    OK
asterisk.sip                                       OK
asterisk.sipsettings                               OK
asterisk.sng_mcu_details                           OK
asterisk.sng_mcu_entries                           OK
asterisk.superfecta_mf                             OK
asterisk.superfecta_mf_child                       OK
asterisk.superfecta_to_incoming                    OK
asterisk.superfectacache                           OK
asterisk.superfectaconfig                          OK
asterisk.sysadmin_options                          OK
asterisk.sysadmin_update_log                       OK
asterisk.timeconditions                            OK
asterisk.timegroups_details                        OK
asterisk.timegroups_groups                         OK
asterisk.trunk_dialpatterns                        OK
asterisk.trunks                                    OK
asterisk.tts                                       OK
asterisk.ttsengines                                OK
asterisk.users                                     OK
asterisk.vmblast                                   OK
asterisk.vmblast_groups                            OK
asterisk.vmnotify                                  OK
asterisk.vmnotify_events                           OK
asterisk.vmnotify_notifications                    OK
asterisk.voicemail_admin                           OK
asterisk.vqplus_callback_calls                     OK
asterisk.vqplus_callback_config                    OK
asterisk.vqplus_callback_log                       OK
asterisk.webrtc_clients                            OK
asterisk.webrtc_settings                           OK
asteriskcdrdb.cdr                                  OK
asteriskcdrdb.cel                                  OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
note     : The storage engine for the table doesn't support optimize
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
note     : The storage engine for the table doesn't support optimize
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK

And I’m still getting the same emails

Well, googling that error gives heaps of suggestions how to repair it. It does mean that that database table is corrupt.

amportal a m mysql> repair table kvstore extended; +------------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+--------+----------+----------+ | asterisk.kvstore | repair | status | OK | +------------------+--------+----------+----------+ 1 row in set (0.02 sec)

mysql>

That should fix it.