Thread "*CRISIS* - Lost Database Table ?!"

Hi everyone!

With no apperant cause, ILIAS seems to have lost a database object. Until now, it appears its the only object missing.

When creating a new user (either as an admin or by way of manual registration) ILIAS dumps an error: (after removing irrelavant information) Can't find file: 'mail_obj_data_seq' (errno: 2)

I was looking into the mysql/ilias directory. mail_obj_data_seq.frm and mail_obj_data_seq.myd are there. mail_obj_data_seq.myi is missing.

Also, when running mysqlcheck (for checkup and also auto-repair) the following appears:

Repairing tables
ilias.mail_obj_data_seq
Error    : Can't find file: 'mail_obj_data_seq' (errno: 2)
status   : Operation failed

How screwed is my ILIAS LMS now? :(

(It runs on AWS amazon, I have snapshots of the EBS but unforunately, only ".sql" backup file from November 2016).

It depends. First of all this is a MySQL issue, I guess your DB crashed due to whatever reasons. Can you track this down to some kind of event on the server? In general the table mail_obj_data_seq is "only" a sequence table holding the highest ID of table mail_obj_data. And for MyISAM the mail_obj_data_seq.myd file holds the data and mail_obj_data_seq.myi "only" index information. If really only "mail_obj_data_seq.myi" is broken it should not be that much of trouble.

You find some information about restoring tables at the MySQL site: https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html