Asterisk Table Marked as crashed

Any and all non-support discussions

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

Asterisk Table Marked as crashed

Postby ruben23 » Fri Jun 19, 2015 9:19 pm

Version: 2.10b0.5
SVN Version: 2256
DB Schema Version: 1400
DB Schema Update Date: 2015-01-18 11:13:48
Single Server
asterisk 1.8


HI guys any idea on how to resolved crashed asterisk_call.log table being marked as crashed, tried already repairing with this command

Code: Select all
root@ubuntu:~# mysqlcheck -u root -p --auto-repair --optimize --all-databases
Enter password:
asterisk.audio_store_details                       Table is already up to date
asterisk.call_log
Error    : Table './asterisk/call_log' is marked as crashed and last (automatic?) repair failed
Error    : Table 'call_log' is marked as crashed and last (automatic?) repair failed
error    : Corrupt
asterisk.call_log_archive                          Table is already up to date
asterisk.callcard_accounts                         Table is already up to date
asterisk.callcard_accounts_details                 Table is already up to date
asterisk.callcard_log                              Table is already up to date
asterisk.conferences                               Table is already up to date
asterisk.contact_information                       Table is already up to date
asterisk.dialable_inventory_snapshots              Table is already up to date
asterisk.groups_alias                              Table is already up to date
asterisk.inbound_email_attachments                 Table is already up to date
asterisk.inbound_numbers                           Table is already up to date
asterisk.live_channels
note     : The storage engine for the table doesn't support optimize
asterisk.live_inbound                              Table is already up to date
asterisk.live_inbound_log                          Table is already up to date
asterisk.live_sip_channels
note     : The storage engine for the table doesn't support optimize
asterisk.nanpa_prefix_exchanges_fast               Table is already up to date
asterisk.nanpa_prefix_exchanges_master             Table is already up to date
asterisk.nanpa_wired_to_wireless                   Table is already up to date
asterisk.nanpa_wireless_to_wired                   Table is already up to date
asterisk.park_log                                  Table is already up to date
asterisk.parked_channels
note     : The storage engine for the table doesn't support optimize
asterisk.phone_favorites                           Table is already up to date
asterisk.phones                                    Table is already up to date
asterisk.phones_alias                              Table is already up to date
asterisk.recording_log                             Table is already up to date
asterisk.server_performance                        Table is already up to date
asterisk.server_updater
note     : The storage engine for the table doesn't support optimize
asterisk.servers                                   OK
asterisk.system_settings                           OK
asterisk.twoday_call_log                           Table is already up to date
asterisk.twoday_recording_log                      Table is already up to date
asterisk.twoday_vicidial_agent_log                 Table is already up to date
asterisk.twoday_vicidial_closer_log                Table is already up to date
asterisk.twoday_vicidial_log                       Table is already up to date
asterisk.twoday_vicidial_xfer_log                  Table is already up to date
asterisk.user_call_log                             Table is already up to date
asterisk.vicidial_admin_log                        Table is already up to date
asterisk.vicidial_agent_log                        Table is already up to date
asterisk.vicidial_agent_log_archive                Table is already up to date
asterisk.vicidial_agent_skip_log                   Table is already up to date
asterisk.vicidial_agent_sph                        Table is already up to date
asterisk.vicidial_api_log                          Table is already up to date
asterisk.vicidial_api_log_archive                  Table is already up to date
asterisk.vicidial_auto_calls
note     : The storage engine for the table doesn't support optimize
asterisk.vicidial_avatar_audio                     Table is already up to date
asterisk.vicidial_avatars                          Table is already up to date
asterisk.vicidial_call_menu                        Table is already up to date
asterisk.vicidial_call_menu_options                Table is already up to date
asterisk.vicidial_call_notes                       Table is already up to date
asterisk.vicidial_call_notes_archive               Table is already up to date
asterisk.vicidial_call_time_holidays               Table is already up to date
asterisk.vicidial_call_times                       Table is already up to date
asterisk.vicidial_callbacks                        Table is already up to date
asterisk.vicidial_campaign_agents                  Table is already up to date
asterisk.vicidial_campaign_cid_areacodes           Table is already up to date
asterisk.vicidial_campaign_dnc                     Table is already up to date
asterisk.vicidial_campaign_hotkeys                 Table is already up to date
asterisk.vicidial_campaign_server_stats
note     : The storage engine for the table doesn't support optimize
asterisk.vicidial_campaign_stats                   Table is already up to date
asterisk.vicidial_campaign_stats_debug             OK
asterisk.vicidial_campaign_statuses                Table is already up to date
asterisk.vicidial_campaigns                        Table is already up to date
asterisk.vicidial_campaigns_list_mix               Table is already up to date
asterisk.vicidial_carrier_log                      Table is already up to date
asterisk.vicidial_carrier_log_archive              Table is already up to date
asterisk.vicidial_closer_log                       Table is already up to date
asterisk.vicidial_closer_log_archive               Table is already up to date
asterisk.vicidial_comments                         Table is already up to date
asterisk.vicidial_conf_templates                   Table is already up to date
asterisk.vicidial_conferences                      Table is already up to date
asterisk.vicidial_configuration                    Table is already up to date
asterisk.vicidial_cpd_log                          Table is already up to date
asterisk.vicidial_custom_cid                       Table is already up to date
asterisk.vicidial_custom_leadloader_templates      Table is already up to date
asterisk.vicidial_daily_max_stats                  Table is already up to date
asterisk.vicidial_daily_ra_stats                   Table is already up to date
asterisk.vicidial_dial_log
Error    : Table './asterisk/vicidial_dial_log' is marked as crashed and last (automatic?) repair failed
Error    : Table 'vicidial_dial_log' is marked as crashed and last (automatic?) repair failed
error    : Corrupt
asterisk.vicidial_dial_log_archive                 Table is already up to date
asterisk.vicidial_did_agent_log                    Table is already up to date
asterisk.vicidial_did_agent_log_archive            Table is already up to date
asterisk.vicidial_did_log                          Table is already up to date
asterisk.vicidial_did_ra_extensions                Table is already up to date
asterisk.vicidial_dnc                              Table is already up to date
asterisk.vicidial_drop_rate_groups                 Table is already up to date
asterisk.vicidial_email_accounts                   Table is already up to date
asterisk.vicidial_email_list                       Table is already up to date
asterisk.vicidial_email_log                        Table is already up to date
asterisk.vicidial_extension_groups                 Table is already up to date
asterisk.vicidial_filter_phone_groups              Table is already up to date
asterisk.vicidial_filter_phone_numbers             Table is already up to date
asterisk.vicidial_grab_call_log                    Table is already up to date
asterisk.vicidial_hopper
note     : The storage engine for the table doesn't support optimize
asterisk.vicidial_inbound_dids                     Table is already up to date
asterisk.vicidial_inbound_group_agents             Table is already up to date
asterisk.vicidial_inbound_groups                   Table is already up to date
asterisk.vicidial_ivr                              Table is already up to date
asterisk.vicidial_language_phrases                 Table is already up to date
asterisk.vicidial_languages                        Table is already up to date
asterisk.vicidial_lead_filters                     Table is already up to date
asterisk.vicidial_lead_recycle                     Table is already up to date
asterisk.vicidial_lead_search_log                  Table is already up to date
asterisk.vicidial_lead_search_log_archive          Table is already up to date
asterisk.vicidial_list                             Table is already up to date
asterisk.vicidial_list_alt_phones                  Table is already up to date
asterisk.vicidial_list_pins                        Table is already up to date
asterisk.vicidial_list_update_log                  Table is already up to date
asterisk.vicidial_lists                            Table is already up to date
asterisk.vicidial_lists_custom                     Table is already up to date
asterisk.vicidial_lists_fields                     Table is already up to date
asterisk.vicidial_live_agents                      Table is already up to date
asterisk.vicidial_live_inbound_agents              Table is already up to date
asterisk.vicidial_log
Error    : Table './asterisk/vicidial_log' is marked as crashed and last (automatic?) repair failed
Error    : Table 'vicidial_log' is marked as crashed and last (automatic?) repair failed
error    : Corrupt
asterisk.vicidial_log_archive                      Table is already up to date
asterisk.vicidial_log_extended                     Table is already up to date
asterisk.vicidial_log_extended_archive             Table is already up to date
asterisk.vicidial_log_noanswer                     Table is already up to date
asterisk.vicidial_log_noanswer_archive             Table is already up to date
asterisk.vicidial_manager                          Table is already up to date
asterisk.vicidial_manual_dial_queue                Table is already up to date
asterisk.vicidial_monitor_calls                    Table is already up to date
asterisk.vicidial_monitor_log                      Table is already up to date
asterisk.vicidial_music_on_hold                    Table is already up to date
asterisk.vicidial_music_on_hold_files              Table is already up to date
asterisk.vicidial_nanpa_filter_log                 Table is already up to date
asterisk.vicidial_nanpa_prefix_codes               Table is already up to date
asterisk.vicidial_outbound_ivr_log                 Table is already up to date
asterisk.vicidial_outbound_ivr_log_archive         Table is already up to date
asterisk.vicidial_override_ids                     Table is already up to date
asterisk.vicidial_pause_codes                      Table is already up to date
asterisk.vicidial_phone_codes                      Table is already up to date
asterisk.vicidial_postal_codes                     Table is already up to date
asterisk.vicidial_process_trigger_log              Table is already up to date
asterisk.vicidial_process_triggers                 Table is already up to date
asterisk.vicidial_qc_agent_log                     Table is already up to date
asterisk.vicidial_qc_codes                         Table is already up to date
asterisk.vicidial_remote_agent_log                 Table is already up to date
asterisk.vicidial_remote_agents                    Table is already up to date
asterisk.vicidial_report_log                       Table is already up to date
asterisk.vicidial_screen_labels                    Table is already up to date
asterisk.vicidial_scripts                          Table is already up to date
asterisk.vicidial_server_carriers                  Table is already up to date
asterisk.vicidial_server_trunks                    Table is already up to date
asterisk.vicidial_session_data                     Table is already up to date
asterisk.vicidial_shifts                           Table is already up to date
asterisk.vicidial_state_call_times                 Table is already up to date
asterisk.vicidial_stations                         Table is already up to date
asterisk.vicidial_status_categories                Table is already up to date
asterisk.vicidial_statuses                         Table is already up to date
asterisk.vicidial_territories                      Table is already up to date
asterisk.vicidial_timeclock_audit_log              Table is already up to date
asterisk.vicidial_timeclock_log                    Table is already up to date
asterisk.vicidial_timeclock_status                 Table is already up to date
asterisk.vicidial_tts_prompts                      Table is already up to date
asterisk.vicidial_url_log                          Table is already up to date
asterisk.vicidial_urls                             Table is already up to date
asterisk.vicidial_user_closer_log                  Table is already up to date
asterisk.vicidial_user_groups                      Table is already up to date
asterisk.vicidial_user_log                         Table is already up to date
asterisk.vicidial_user_territories                 Table is already up to date
asterisk.vicidial_user_territory_log               Table is already up to date
asterisk.vicidial_users                            Table is already up to date
asterisk.vicidial_voicemail                        Table is already up to date
asterisk.vicidial_webservers                       Table is already up to date
asterisk.vicidial_xfer_log                         Table is already up to date
asterisk.vicidial_xfer_presets                     Table is already up to date
asterisk.vicidial_xfer_stats                       Table is already up to date
asterisk.vtiger_rank_data                          Table is already up to date
asterisk.vtiger_rank_parameters                    Table is already up to date
asterisk.vtiger_vicidial_roles                     Table is already up to date
asterisk.web_client_sessions
note     : The storage engine for the table doesn't support optimize
asterisk.www_phrases                               Table is already up to date
mysql.columns_priv                                 Table is already up to date
mysql.db                                           Table is already up to date
mysql.event                                        Table is already up to date
mysql.func                                         Table is already up to date
mysql.general_log
note     : The storage engine for the table doesn't support optimize
mysql.help_category                                Table is already up to date
mysql.help_keyword                                 Table is already up to date
mysql.help_relation                                Table is already up to date
mysql.help_topic                                   Table is already up to date
mysql.host                                         Table is already up to date
mysql.ndb_binlog_index                             Table is already up to date
mysql.plugin                                       Table is already up to date
mysql.proc                                         Table is already up to date
mysql.procs_priv                                   Table is already up to date
mysql.proxies_priv                                 Table is already up to date
mysql.servers                                      Table is already up to date
mysql.slow_log
note     : The storage engine for the table doesn't support optimize
mysql.tables_priv                                  Table is already up to date
mysql.time_zone                                    Table is already up to date
mysql.time_zone_leap_second                        Table is already up to date
mysql.time_zone_name                               Table is already up to date
mysql.time_zone_transition                         Table is already up to date
mysql.time_zone_transition_type                    Table is already up to date
mysql.user                                         Table is already up to date

Repairing tables
asterisk.call_log
error    : Can't create new tempfile: './asterisk/call_log.TMD'
status   : Operation failed
asterisk.vicidial_dial_log
error    : Can't create new tempfile: './asterisk/vicidial_dial_log.TMD'
status   : Operation failed
asterisk.vicidial_log
error    : Can't create new tempfile: './asterisk/vicidial_log.TMD'
status   : Operation failed



any idea guys how to recover from this serious crashed. The server storage is pretty low i got 30 percent usage only.
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: Asterisk Table Marked as crashed

Postby williamconley » Fri Jun 19, 2015 9:55 pm

mysqlcheck --auto-repair --user=cron -p1234 asterisk call_log

WAIT!! it can take an hour to repair.

verify your HD is not full.

failing that: empty the table. and/or restore from yesterday's backup.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 64 guests