При подключении к 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       |
+------------------+--------+----------+----------+