Database issues

  • Resolved barryalbert

    (@barryalbert)


    6 years, 2 months ago

    It seems to be a corrupt cerber_log table. I just wanted to let you know in case other users have the same problems and its not just an isolated event. I had to create a new database and move over all of the tables except the cerber ones and then reinstall cerber. I could not find anything that would repair the cerber_log table.

    When trying to export I received this message:

    Unable to export a dump of –database name here–:
    mysqldump: Got error: 1033: Incorrect information in file: ‘./–database name here–/cerber_lab_ip.frm’ when using LOCK TABLES

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter barryalbert

    (@barryalbert)

    I have had a second database failure. The error is “cerber_lab_ip” (table) does not exist. I am upgrading our MySQL server, but its an older one, 5.5.55.

    Plugin Author gioni

    (@gioni)

    It looks like you have an issue with the hard disk of the server. Probably some of the database files are corrupted or disk is full.

    You can ignore those table doesn’t exist errors since the plugin automatically recreates tables if it doesn’t find them. You can also manually repair the tables on the Tools admin page. All tables are MySQL version agnostic.

    Thread Starter barryalbert

    (@barryalbert)

    Thanks…I am not sure whats going on. Plenty of storage space on a dedicated server. This is just a FYI in case there is an issue. It sounds like this is on my end.

    Plugin Author gioni

    (@gioni)

    There are plenty of underlying database/disk/OS technologies that could cause this issue. The plugin code is not the cause in your case.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database issues’ is closed to new replies.