Im Betrieb fällt uns zwar nichts Negatives auf, aber das syslog ist seit ein paar Tagen voll mit solchen Fehlermeldungen:
Code
Oct 27 00:12:30 localhost vdr: epg2vdr: SQL-Error in 'execute(stmt_execute)' - Table 'epg2vdr.useevents' doesn't exist in engine (1932) 'Table 'epg2vdr.useevents' doesn't exist in engine' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext, starttime, duration, parentalrating, vps, contents, description, mergesource, longdescription from eventsview where channelid = ? and updsp > ? and UPDFLG in ('A','L','P','C','D','R')]
...
Oct 27 09:27:49 localhost epgd: SQL-Error in 'delete from useevents where cnt_starttime+cnt_duration < 1572143267' - Index useevents is corrupted (1712)
Oct 27 09:27:49 localhost epgd: SQL-Error in 'deleteWhere()' - Index useevents is corrupted (1712) '' [delete from useevents where cnt_starttime+cnt_duration < 1572143267]
...
Oct 27 09:22:40 localhost vdr: epg2vdr: SQL-Error in 'execute(store_result)' - Index useevents is corrupted (1712) 'Index useevents is corrupted' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext, starttime, duration, parentalrating, vps, contents, description, mergesource, longdescription from eventsview where channelid = ? and updsp > ? and UPDFLG in ('A','L','P','C','D','R')]
Was kann ich da jetzt machen? (Bin kein SQL-Guru, schon gar nicht auf der Kommandozeile.)
Edit:
Die Tabelle ist tatsächlich nicht da - es ist nicht nur der "Index corrupted":
Code
MariaDB [epg2vdr]> check table useevents;
+-------------------+-------+----------+---------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------+-------+----------+---------------------------------------------------+
| epg2vdr.useevents | check | Error | Table 'epg2vdr.useevents' doesn't exist in engine |
| epg2vdr.useevents | check | status | Operation failed |
+-------------------+-------+----------+---------------------------------------------------+
2 rows in set (0.00 sec)
Warum fehlt denn jetzt plötzlich die Tabelle?
Und viel wichtiger - wie kriege ich sie wieder her?