Database Crash - Repair Failed

[zenithbsolutions]

Hi,

I've got a server crashed and tried to repair the tables and found a corrupt table "vicidial_live_agents"

Code: Select all

Repairing tables
asterisk.vicidial_live_agents
Error    : Incorrect file format 'vicidial_live_agents'
error    : Corrupt

Tried to repair it from the table.

Code: Select all

MariaDB [asterisk]> check table vicidial_live_agents;
+-------------------------------+-------+----------+----------------------------------------------+
| Table                         | Op    | Msg_type | Msg_text                                     |
+-------------------------------+-------+----------+----------------------------------------------+
| asterisk.vicidial_live_agents | check | Error    | Incorrect file format 'vicidial_live_agents' |
| asterisk.vicidial_live_agents | check | error    | Corrupt                                      |
+-------------------------------+-------+----------+----------------------------------------------+
2 rows in set (0.00 sec)

MariaDB [asterisk]> repair table vicidial_live_agents;
+-------------------------------+--------+----------+----------------------------------------------+
| Table                         | Op     | Msg_type | Msg_text                                     |
+-------------------------------+--------+----------+----------------------------------------------+
| asterisk.vicidial_live_agents | repair | Error    | Incorrect file format 'vicidial_live_agents' |
| asterisk.vicidial_live_agents | repair | error    | Corrupt                                      |
+-------------------------------+--------+----------+----------------------------------------------+
2 rows in set (0.00 sec)

MariaDB [asterisk]> repair table vicidial_live_agents use_frm;
+-------------------------------+--------+----------+---------------------------------------------------------------+
| Table                         | Op     | Msg_type | Msg_text                                                      |
+-------------------------------+--------+----------+---------------------------------------------------------------+
| asterisk.vicidial_live_agents | repair | Error    | Got an error evaluating stored expression current_timestamp() |
| asterisk.vicidial_live_agents | repair | error    | Corrupt                                                       |
+-------------------------------+--------+----------+---------------------------------------------------------------+
2 rows in set (0.00 sec)

Now I'm getting an error

Got an error evaluating stored expression current_timestamp()

while repairing.

Kindly help me how to resolve it.

Installation : vicibox 8.0.1
VERSION: 2.14-664a
BUILD: 180310-2321
© 2018 ViciDial Group



Thank you

[williamconley]

Truncate the table. Check for full HD

[zenithbsolutions]

Awesome! & Thanks William this resolved my issue....

[williamconley]

I'd be looking at how it happened. Consider replacing your HD if you don't have a smoking gun somewhere (like a power outage).