Hi !
Nach dem Update der Leap-Version 15.3 auf 15.4 habe ich Probleme mit
epg2vdr, obwohl angeblich laut rpm die mariadb-Version mit 3.1.13
gleich geblieben ist.
Auch an der vdr-Version habe ich mit 2.4.8 nichts geändert.
Ich nutze die git-Version von vdr-epg-daemon sowie dem vdr-Plugin.
Es gibt folgende Fehlermeldungen (siehe den Anhang), die auch nach einem
epgd-dropall beim ersten Starten vom Daemon kommen:
Jun 13 14:21:04 pcmisch epgd[1324]: Trying to re-connect to database!
Jun 13 14:21:04 pcmisch epgd[1324]: Calling mysql_init(1324)
Jun 13 14:21:04 pcmisch epgd[1324]: Loading '/etc/epgd/channelmap.conf'
Jun 13 14:21:04 pcmisch epgd[1324]: 103 channel mappings read.
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show procedure status where name = 'mergeepg']
Jun 13 14:21:04 pcmisch epgd[1324]: Procedure check of 'mergeepg' failed
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show procedure status where name = 'mergeepg']
Jun 13 14:21:04 pcmisch epgd[1324]: Procedure check of 'mergeepg' failed
Jun 13 14:21:04 pcmisch epgd[1324]: Creating procedure 'mergeepg'
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'CREATE PROCEDURE mergeepg ()$BEGIN$/*$* declare variables$*/$DECLARE startrun INT;$DECLARE lastrun INT;$/*$* configure merge$*/$set @epi ='a';$set @img ='b';$set @sht ='';$/*$* fix useid = 0$*/$update events set useid = masterid where useid = 0;$/*$* cleanup deleted Links$*/$update$ events e$set$ e.useid = e.masterid,$ e.updsp>
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'executeSqlFile()' - Cannot load from mysql.proc. The table is probably corrupted (1728)
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show procedure status where name = 'reverseepg']
Jun 13 14:21:04 pcmisch epgd[1324]: Procedure check of 'reverseepg' failed
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show procedure status where name = 'reverseepg']
Jun 13 14:21:04 pcmisch epgd[1324]: Procedure check of 'reverseepg' failed
Jun 13 14:21:04 pcmisch epgd[1324]: Creating procedure 'reverseepg'
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'CREATE PROCEDURE reverseepg ()$BEGIN$/*$* channelmap zurücksetzen$*/$update channelmap set mergesp = 0;$/*$* events zurücksetzen Teil 1$*/$update$ events ev,$ (select distinct channelid from channelmap where source <> 'vdr' ) cm$set$ useid = masterid,$ updflg =$ case$ when ev.delflg = 'Y' then 'D'$ else 'I'$ end$wher>
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'executeSqlFile()' - Cannot load from mysql.proc. The table is probably corrupted (1728)
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show function status where name = 'getupdflg']
Jun 13 14:21:04 pcmisch epgd[1324]: Function check of 'getupdflg' failed
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show function status where name = 'getupdflg']
Jun 13 14:21:04 pcmisch epgd[1324]: Function check of 'getupdflg' failed
Jun 13 14:21:04 pcmisch epgd[1324]: Creating function 'getupdflg'
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'CREATE FUNCTION getupdflg ( master_id INT(11) )$RETURNS CHAR$NOT DETERMINISTIC$BEGIN$DECLARE upd_flg CHAR;$ SET upd_flg = ($ select case$ when ev.source != 'vdr' and ev.starttime <= cm.mergesp and ev.masterid != ev.useid then 'C'$ when ev.source != 'vdr' and ev.starttime <= cm.mergesp and jo.masterid is not Null then >
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'executeSqlFile()' - Cannot load from mysql.proc. The table is probably corrupted (1728)
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show function status where name = 'getcrosslvr']
Jun 13 14:21:04 pcmisch epgd[1324]: Function check of 'getcrosslvr' failed
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show function status where name = 'getcrosslvr']
Jun 13 14:21:04 pcmisch epgd[1324]: Function check of 'getcrosslvr' failed
Jun 13 14:21:04 pcmisch epgd[1324]: Creating function 'getcrosslvr'
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'CREATE FUNCTION getcrosslvr ( comp1 varchar(300), comp2 varchar(300) )$RETURNS int$NOT DETERMINISTIC$BEGIN$DECLARE ratio DECIMAL(7,2);$DECLARE shorter varchar(300);$DECLARE longer varchar(300);$DECLARE complenght int;$DECLARE crosslv int;$DECLARE crosslvt int;$IF char_length(comp1) = 0 then$ set ratio = 999;$ set short>
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'executeSqlFile()' - Cannot load from mysql.proc. The table is probably corrupted (1728)
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show function status where name = 'getlvrmin']
Jun 13 14:21:04 pcmisch epgd[1324]: Function check of 'getlvrmin' failed
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'execute(stmt_execute)' - Cannot load from mysql.proc. The table is probably corrupted (1728) 'Cannot load from mysql.proc. The table is probably corrupted' [show function status where name = 'getlvrmin']
Jun 13 14:21:04 pcmisch epgd[1324]: Function check of 'getlvrmin' failed
Jun 13 14:21:04 pcmisch epgd[1324]: Creating function 'getlvrmin'
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'CREATE FUNCTION getlvrmin ( vdr_starttime int(10), ext_starttime int(10), vdr_duration int(5), ext_duration int(5), lv1 int(3), lv2 int(3), lv3 int(3), lv4 int(3) )$RETURNS int$NOT DETERMINISTIC$BEGIN$DECLARE delta_st int;$DECLARE delta_du int;$DECLARE lv_time int default 0;$DECLARE lv_min int;$DECLARE lv_dur int;$DECLARE lv_s>
Jun 13 14:21:04 pcmisch epgd[1324]: SQL-Error in 'executeSqlFile()' - Cannot load from mysql.proc. The table is probably corrupted (1728)
Jun 13 14:21:04 pcmisch epgd[1324]: Using scraping language de
Jun 13 14:21:04 pcmisch epgd[1324]: TVDB scraper connected
Jun 13 14:21:04 pcmisch epgd[1324]: MOVIEDB scraper connected
Jun 13 14:21:04 pcmisch epgd[1324]: Info: No external events on database, force initial check!
Jun 13 14:21:04 pcmisch epgd[1324]: Retry #3 failed, retrying in 60 seconds!
Jun 13 14:21:04 pcmisch epgd[1324]: Closing mysql connection and calling mysql_thread_end(1324)
Grüße,
Dirk