epgd: SQL-Error in 'create index idxstate on vdrs(state);' - Table storage engine for 'vdrs' doesn't have this option

henfri · 8. September 2014

Hallo,

leider war meine mysql-Datenbank korrupt. Ich habe sie deshalb neu erstellt.
Leider funktioniert epgd seitdem nicht mehr. Ich habe die Datenbank allerdings sowohl manuell als auch mit dem epgd-tool neu erstellt. Dennoch bekomme ich diese Fehlermeldung:

Code

Sep  8 23:52:25 homeserver epgd: Set locale to 'de_DE.UTF-8'
Sep  8 23:52:25 homeserver epgd: detected UTF-8
Sep  8 23:52:25 homeserver epgd: Loading uuid from '/etc/epgd/uuid' succeeded [C41CACF2-A85D-4FE5-8197-6E43EEB1FB59]
Sep  8 23:52:25 homeserver epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Sep  8 23:52:25 homeserver epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Sep  8 23:52:25 homeserver epgd: Read 26 option from /etc/epgd/epgd.conf
Sep  8 23:52:25 homeserver epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Sep  8 23:52:25 homeserver epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Sep  8 23:52:25 homeserver epgd: SQL client character now 'utf8'
Sep  8 23:52:25 homeserver epgd: create index idxstate on vdrs(state);
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'create index idxstate on vdrs(state);' - Table storage engine for 'vdrs' doesn't have this option (1031)
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'vdrs' doesn't have this option (1031) '' [create index idxstate on vdrs(state);]

Alles anzeigen

(und weitere, s.u.).

Ich hab jetzt schon lange gesucht. Kann mir jemand einen Tipp geben?

Gruß&Danke,
Hendrik

Code

Sep  8 23:52:25 homeserver epgd: Set locale to 'de_DE.UTF-8'
Sep  8 23:52:25 homeserver epgd: detected UTF-8
Sep  8 23:52:25 homeserver epgd: Loading uuid from '/etc/epgd/uuid' succeeded [C41CACF2-A85D-4FE5-8197-6E43EEB1FB59]
Sep  8 23:52:25 homeserver epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Sep  8 23:52:25 homeserver epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Sep  8 23:52:25 homeserver epgd: Read 26 option from /etc/epgd/epgd.conf
Sep  8 23:52:25 homeserver epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Sep  8 23:52:25 homeserver epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Sep  8 23:52:25 homeserver epgd: SQL client character now 'utf8'
Sep  8 23:52:25 homeserver epgd: create index idxstate on vdrs(state);
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'create index idxstate on vdrs(state);' - Table storage engine for 'vdrs' doesn't have this option (1031)
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'vdrs' doesn't have this option (1031) '' [create index idxstate on vdrs(state);]
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'execute(stmt_execute)' - Got error -1 from storage engine (1030) 'Got error -1 from storage engine' [insert into vdrs set uuid = ?, inssp = ?, updsp = ?, name = ?, version = ?, dbapi = ?, lastupd = ?, nextupd = ?, state = ?, master = ?, ip = ?;]
Sep  8 23:52:25 homeserver epgd: State now 'init'
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'execute(stmt_execute)' - Got error -1 from storage engine (1030) 'Got error -1 from storage engine' [insert into vdrs set uuid = ?, inssp = ?, updsp = ?, name = ?, version = ?, dbapi = ?, lastupd = ?, nextupd = ?, state = ?, master = ?, ip = ?;]
Sep  8 23:52:25 homeserver epgd: create index idxsourceExtid on channelmap(source, extid);
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'create index idxsourceExtid on channelmap(source, extid);' - Table storage engine for 'channelmap' doesn't have this option (1031)
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'channelmap' doesn't have this option (1031) '' [create index idxsourceExtid on channelmap(source, extid);]
Sep  8 23:52:25 homeserver epgd: create index idxSourceFileref on fileref(source, fileref);
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'create index idxSourceFileref on fileref(source, fileref);' - Table storage engine for 'fileref' doesn't have this option (1031)
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'fileref' doesn't have this option (1031) '' [create index idxSourceFileref on fileref(source, fileref);]
Sep  8 23:52:25 homeserver epgd: create index idxlfn on imagerefs(lfn);
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'create index idxlfn on imagerefs(lfn);' - Table storage engine for 'imagerefs' doesn't have this option (1031)
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'imagerefs' doesn't have this option (1031) '' [create index idxlfn on imagerefs(lfn);]
Sep  8 23:52:25 homeserver epgd: create index idxupdsp on episodes(updsp);
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'create index idxupdsp on episodes(updsp);' - Table storage engine for 'episodes' doesn't have this option (1031)
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'episodes' doesn't have this option (1031) '' [create index idxupdsp on episodes(updsp);]
Sep  8 23:52:25 homeserver epgd: create index idxcomptitle on events(comptitle);
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'create index idxcomptitle on events(comptitle);' - Table storage engine for 'events' doesn't have this option (1031)
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'events' doesn't have this option (1031) '' [create index idxcomptitle on events(comptitle);]
Sep  8 23:52:25 homeserver epgd: create index idxuuid on recordings(uuid);
Sep  8 23:52:26 homeserver epgd: SQL-Error in 'create index idxuuid on recordings(uuid);' - Table storage engine for 'recordings' doesn't have this option (1031)
Sep  8 23:52:26 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'recordings' doesn't have this option (1031) '' [create index idxuuid on recordings(uuid);]
Sep  8 23:52:26 homeserver epgd: create index idxvdr_masterid on analyse(vdr_masterid);
Sep  8 23:52:26 homeserver epgd: SQL-Error in 'create index idxvdr_masterid on analyse(vdr_masterid);' - Table storage engine for 'analyse' doesn't have this option (1031)
Sep  8 23:52:26 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'analyse' doesn't have this option (1031) '' [create index idxvdr_masterid on analyse(vdr_masterid);]
Sep  8 23:52:26 homeserver epgd: create index idxchannelid on snapshot(channelid);
Sep  8 23:52:26 homeserver epgd: SQL-Error in 'create index idxchannelid on snapshot(channelid);' - Table storage engine for 'snapshot' doesn't have this option (1031)
Sep  8 23:52:26 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'snapshot' doesn't have this option (1031) '' [create index idxchannelid on snapshot(channelid);]
Sep  8 23:52:26 homeserver kernel: [605101.765824] epgd[1140]: segfault at 8 ip 000000000043cc50 sp 00007fffaeb25ae0 error 4 in epgd[400000+8f000]

Alles anzeigen

henfri · 10. September 2014

Hm, keine Ideen?

seahawk1986 · 10. September 2014

Ohne zu wissen wie du deine Datenbank konfiguriert hast weiß ich auch nur das, was im Log steht:

Code

Sep  8 23:52:25 homeserver epgd: SQL-Error in 'create index idxstate on vdrs(state);' - Table storage engine for 'vdrs' doesn't have this option (1031)
Sep  8 23:52:25 homeserver epgd: SQL-Error in 'createIndices()' - Table storage engine for 'vdrs' doesn't have this option (1031) '' [create index idxstate on vdrs(state);]

Was hast du denn als Storage Engine konfiguriert und welche Version von MySQL bzw. MariaDB nutzt du?

henfri · 10. September 2014

Hallo seahawk,

danke für deine Antwort.
Ich benutze Ubuntu 14.04 und da wird -glaube ich- InnoDB genutzt.
Die einzige Besonderheit ist

Code

/mnt/Stick/mysql on /var/lib/mysql type none (rw,bind)

womit ich die DB auf einen Stick ausgelagert habe.
Seitdem habe ich auch die Probleme, bzw. als die Datenbank defekt war habe ich die Gelegenheit genutzt die neue DB auf dem Stick neu anzulegen.

Unten die Konfiguration des sql-Servers.

Gruß und Danke für die Hilfe,
Hendrik

Code

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock




[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0


[mysqld]
innodb_force_recovery = 1
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
query_cache_limit       = 1M
query_cache_size        = 16M
log_error = /var/log/mysql/error.log
expire_logs_days        = 10
max_binlog_size         = 100M






[mysqldump]
quick
quote-names
max_allowed_packet      = 16M


[code=sql]


[isamchk]
key_buffer              = 16M


...in conf.d...
[mysqld_safe]
syslog

Alles anzeigen

seahawk1986 · 10. September 2014

Zitat von henfri

womit ich die DB auf einen Stick ausgelagert habe.

Die Dateien aus dem Verzeichnis hast du aber schon bei gestopptem MySQL in den entsprechenden Ordner auf dem Stick kopiert?

Zitat von henfri

Ich benutze Ubuntu 14.04 und da wird -glaube ich- InnoDB genutzt.

Besser keine Vermutungen anstellen, wenn man einfach nachsehen kann - was steht denn im Log von MySQL (vermutlich /var/log/mysql)? Da sieht man doch normalerweise was er nutzt und ob es Fehler gibt...

henfri · 10. September 2014

Hallo,

na, die DB war korrupt. Daher habe ich mit einem neuen Ordner auf dem Stick angefangen.
Aber dein Tipp, mal ins Log zu gucken war gut (natürlich hatte ich vorher oft rein gegeguckt, aber seit der mysql wieder läuft halt nur noch ins syslog und nicht mehr in den sql-log).
Die Datenbank war noch nicht funktionsfähig. Der obige Fehler war ein Hinweis darauf, dass in die DB nicht geschrieben werden konnte.
Habe ich beheben können. Läuft.

Danke!

Gruß,
Hendrik

epgd: SQL-Error in 'create index idxstate on vdrs(state);' - Table storage engine for 'vdrs' doesn't have this option

Jetzt mitmachen!

Teilen