mysqlcheck errors

[ramindia]

Hi


I was checking with mysql

I always get the below errors, iam doing this when the call center offline.

is this any major errors those are, or just ignorable ?

any suggestions

mysqlcheck --password=password --auto-repair --all-databases
asterisk.call_log OK
asterisk.conferences OK
asterisk.inbound_numbers OK
asterisk.live_channels
warning : 2 clients are using or haven't closed the table properly
status : OK
asterisk.live_inbound OK
asterisk.live_inbound_log OK
asterisk.live_sip_channels
warning : 2 clients are using or haven't closed the table properly
status : OK
asterisk.park_log OK
asterisk.parked_channels OK
asterisk.phone_favorites OK
asterisk.phones OK
asterisk.recording_log
warning : 1 client is using or hasn't closed the table properly
status : OK
asterisk.server_performance
warning : 2 clients are using or haven't closed the table properly
status : OK
asterisk.server_updater
warning : 2 clients are using or haven't closed the table properly
status : OK
asterisk.servers OK
asterisk.system_settings OK
asterisk.vicidial_agent_log OK
asterisk.vicidial_auto_calls OK
asterisk.vicidial_call_times OK
asterisk.vicidial_callbacks OK
asterisk.vicidial_campaign_hotkeys OK
asterisk.vicidial_campaign_server_stats OK
asterisk.vicidial_campaign_stats OK
asterisk.vicidial_campaign_statuses OK
asterisk.vicidial_campaigns
warning : 1 client is using or hasn't closed the table properly
status : OK
asterisk.vicidial_closer_log OK
asterisk.vicidial_conferences OK
asterisk.vicidial_dnc OK
asterisk.vicidial_hopper OK
asterisk.vicidial_inbound_groups OK
asterisk.vicidial_lead_filters OK
asterisk.vicidial_lead_recycle OK
asterisk.vicidial_list OK
asterisk.vicidial_list_pins OK
asterisk.vicidial_lists OK
asterisk.vicidial_live_agents OK
asterisk.vicidial_log OK
asterisk.vicidial_manager OK
asterisk.vicidial_pause_codes OK
asterisk.vicidial_phone_codes OK
asterisk.vicidial_postal_codes OK
asterisk.vicidial_remote_agents OK
asterisk.vicidial_scripts OK
asterisk.vicidial_server_trunks OK
asterisk.vicidial_state_call_times OK
asterisk.vicidial_stations OK
asterisk.vicidial_statuses OK
asterisk.vicidial_user_groups OK
asterisk.vicidial_user_log
warning : 1 client is using or hasn't closed the table properly
status : OK
asterisk.vicidial_users OK
asterisk.vicidial_xfer_log OK
asterisk.web_client_sessions
warning : 1 client is using or hasn't closed the table properly
status : OK


ram

[aster1]

I dont think this warning does any harm . It looks like tables are being used while you are running mysqlcheck

[mflorell]

If possible, run that with mysql shut down or with remote logging turned off, doing it during production hours can actually lead to more DB corruption.