Page 1 of 1

asterisk.vicidial_dnc

PostPosted: Fri Apr 03, 2009 11:14 am
by globalme
VERSION: 2.0.4-121 BUILD: 80424-0442

When I tried repairing table vicidial_hopper, its getting hanged.

I tried dropping , but cant drop also.

When I try IP:10000 , webmin page also doesn't open.

Also tried mysqlcheck --auto-repair asterisk -p from root prompt, but no response for long time asterisk.vicidial_dnc.

PostPosted: Fri Apr 03, 2009 12:53 pm
by mflorell
How many records did you have in that table?

How full is your hard drive?

PostPosted: Fri Apr 03, 2009 1:26 pm
by globalme
Anyway to delete or drop the table when system is booting and then create the table manually ?

PostPosted: Fri Apr 03, 2009 4:47 pm
by mflorell
yes, just delete the three vicidial_dnc files in the MySQL data directory and re-create the table.

PostPosted: Fri Apr 03, 2009 7:37 pm
by williamconley
But don't gloss this over, it's important:
mflorell wrote:How many records did you have in that table?

How full is your hard drive?

at the command line:
# df
will give you drive space information.

Also, have you had any "crashes" (power outages and such) recently?