missing InnoDB (partitioned) tables(s) ?

[Miko M]

Has anyone experienced missing InnoDB (partitioned) tables(s) after a disk has been full?

I know, it may sound weird…

Basically I’ve been testing a little bit, “no space left on device” occurred (my fault!), I’ve deleted a few files and space was reclaimed immediately.

However I’ve noticed that a few partitioned tables have been missing (!)
There are ibd files (every partition is a single file) but neither .par nor .frm files
There are no records about these (missing) tables in information_schema.table.

Not all the partitioned tables have been affected; some of them are fine.

By the way; I’ve developed a stored procedure that adds and drops a new (hourly) partition and it is triggered by event trigger (every 30 min).
Another stored procedure drops the oldest partition as soon as the table space usage exceeded a configurable threshold ( > data_length + B.index_length from information_schema.TABLES)

MySQL version: Maria DB 10.0.14

Thanks,

Miko

cat /var/log/mysqld_err.log | grep event_info
2014-12-09 14:09:15 7fcd46ccd700 InnoDB: Error: Write to file ./dbs/event_info#P#P2014120915.ibd failed at offset 839909376.
FAILFAIL141209 14:09:15 [ERROR] mysqld: The table 'event_info' is full
141209 14:09:15 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:09:15 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:09:16 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:09:16 [ERROR] mysqld: The table 'event_info' is full
141209 14:09:16 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:09:16 [ERROR] mysqld: The table 'event_info' is full
(...)
FAIL141209 14:15:11 [ERROR] mysqld: The table 'event_info' is full
FAILFAILFAILFAILFAIL141209 14:15:12 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:12 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:15:12 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:12 [ERROR] mysqld: The table 'event_info' is full
FAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAIL141209 14:15:13 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:15:13 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:13 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:15:13 [ERROR] mysqld: The table 'event_info' is full
FAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAIL141209 14:15:14 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:15:14 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:14 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:15:14 [ERROR] mysqld: The table 'event_info' is full
FAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAIL141209 14:15:15 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:15 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:15:15 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:15 [ERROR] mysqld: The table 'event_info' is full
FAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAIL141209 14:15:16 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:16 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:15:16 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:16 [ERROR] mysqld: The table 'event_info' is full
FAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAILFAIL141209 14:15:17 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:17 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 14:15:17 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 14:15:17 [ERROR] mysqld: The table 'event_info' is full
2014-12-09 17:53:52 7f4c50db3700 InnoDB: Error: Write to file ./dbs/event_info#P#P2014120918.ibd failed at offset 5182062592.
FAILFAILFAIL141209 17:53:52 [ERROR] mysqld: The table 'event_info' is full
141209 17:53:52 [ERROR] mysqld: The table 'event_info' is full
141209 17:53:52 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:52 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:53 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 17:53:53 [ERROR] mysqld: The table 'event_info' is full
141209 17:53:53 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:53 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:54 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 17:53:54 [ERROR] mysqld: The table 'event_info' is full
141209 17:53:54 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:54 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:55 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 17:53:55 [ERROR] mysqld: The table 'event_info' is full
141209 17:53:55 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:55 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:56 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 17:53:56 [ERROR] mysqld: The table 'event_info' is full
141209 17:53:56 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:56 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:57 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 17:53:57 [ERROR] mysqld: The table 'event_info' is full
141209 17:53:57 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:57 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:58 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 17:53:58 [ERROR] mysqld: The table 'event_info' is full
141209 17:53:58 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:58 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:59 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 17:53:59 [ERROR] mysqld: The table 'event_info' is full
141209 17:53:59 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:53:59 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:54:00 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 17:54:00 [ERROR] mysqld: The table 'event_info' is full
141209 17:54:00 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:54:01 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:54:01 [ERROR] mysqld: The table 'event_info' is full
(...)
FAIL141209 17:54:38 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:54:39 [ERROR] mysqld: The table 'event_info' is full
FAILFAIL141209 17:54:39 [ERROR] mysqld: The table 'event_info' is full
141209 17:54:39 [ERROR] mysqld: The table 'event_info' is full
FAIL141209 17:54:39 [ERROR] mysqld: The table 'event_info' is full
141209 17:54:51 [ERROR] Event Scheduler: [user123@%][dbs.update_info] Error writing file './dbs/#sql-event_info.frm' (Errcode: 28 "No space left on device")
141209 17:54:51 [ERROR] Event Scheduler: [user123@%][dbs.update_info] Error on rename of './dbs/#sql-event_info.frm' to './dbs/event_info.frm' (Errcode: 2 "No such file or directory")
141209 18:04:23 [ERROR] Event Scheduler: [user123@%][dbs.Memory_info] Table 'dbs.event_info' doesn't exist
(...)
141210 19:34:23 [ERROR] Event Scheduler: [user123@%][dbs.Memory_info] Table 'dbs.event_info' doesn't exist