145 Table './asterisk/kvstore' is marked as crashed and should be repaired
При подключении к FreePBX появляется ошибка:
FATAL ERROR FreePBX is Unable to Continue SQLSTATE[HY000]: General error: 145 Table './asterisk/kvstore' is marked as crashed and should be repaired Trace Back /var/www/html/admin/config.php:302 die_freepbx() [0]: FreePBX is Unable to Continue [1]: SQLSTATE[HY000]: General error: 145 Table './asterisk/kvstore' is marked as crashed and should be repaired
Проверяем БД
mysqlcheck -u root -p<password> --check asterisk
Нажмите, чтобы отобразить
Нажмите, чтобы скрыть
asterisk.admin warning : 5 clients are using or haven't closed the table properly status : OK asterisk.ampusers OK asterisk.announcement OK asterisk.arimanager OK asterisk.backup OK asterisk.backup_cache warning : 2 clients are using or haven't closed the table properly status : 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.certman_cas OK asterisk.certman_certs OK asterisk.certman_mapping OK asterisk.cidlookup OK asterisk.cidlookup_incoming OK asterisk.cronmanager warning : 4 clients are using or haven't closed the table properly status : OK asterisk.custom_destinations OK asterisk.custom_extensions OK asterisk.cxpanel_conference_rooms OK asterisk.cxpanel_email OK asterisk.cxpanel_phone_number OK asterisk.cxpanel_queues OK asterisk.cxpanel_recording_agent OK asterisk.cxpanel_server OK asterisk.cxpanel_users OK asterisk.cxpanel_voicemail_agent 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 warning : 2 clients are using or haven't closed the table properly status : 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_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.directory_details OK asterisk.directory_entries OK asterisk.disa OK asterisk.events 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 warning : 1 client is using or hasn't closed the table properly status : OK asterisk.freepbx_users_settings warning : 1 client is using or hasn't closed the table properly status : 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 warning : Table is marked as crashed warning : 1 client is using or hasn't closed the table properly error : Record at pos: 880864 is not remove-marked error : record delete-link-chain corrupted error : Corrupt 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 warning : 4 clients are using or haven't closed the table properly status : OK asterisk.modules OK asterisk.notifications warning : 4 clients are using or haven't closed the table properly status : 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.parkplus OK asterisk.pbook OK asterisk.pbook_directory 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.recordings OK asterisk.ringgroups OK asterisk.setcid OK asterisk.sip OK asterisk.sipsettings OK asterisk.superfecta_mf OK asterisk.superfecta_mf_child OK asterisk.superfecta_to_incoming OK asterisk.superfectacache OK asterisk.superfectaconfig OK asterisk.timeconditions OK asterisk.timegroups_details OK asterisk.timegroups_groups OK asterisk.trunk_dialpatterns OK asterisk.trunks OK asterisk.ucp_sessions warning : 1 client is using or hasn't closed the table properly status : OK asterisk.users warning : 3 clients are using or haven't closed the table properly status : OK asterisk.vmblast OK asterisk.vmblast_groups OK asterisk.voicemail_admin OK asterisk.webrtc_clients OK
Исправляем SQL таблицу
mysql -b -u root -p<password> -D asterisk -e "REPAIR TABLE kvstore" -u root
+------------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+--------+----------+----------+ | asterisk.kvstore | repair | status | OK | +------------------+--------+----------+----------+