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.