Hallo zusammen,
hat evtl. jemand eine Idee warum ich folgende Fehlermeldungen bekomme?
Kann epgd die Prozeduren (wenn sie bereits existieren nicht löschen?)
Der DB User hat eigentlich volle Rechte:
MySQL 5.7.29-0ubuntu0.16.04
epgd version 1.1.159-GITb00d26e from 29.02.2020
Code
Mar 16 13:58:50 vaio systemd[1]: Started Database driven EPG Data collector.
Mar 16 13:58:51 vaio epgd: Trying to re-connect to database!
Mar 16 13:58:51 vaio epgd: Calling mysql_init(23535)
Mar 16 13:58:51 vaio epgd: Loading '/etc/epgd/channelmap.conf'
Mar 16 13:58:51 vaio epgd: 134 channel mappings read.
Mar 16 13:58:51 vaio epgd: Creating procedure 'mergeepg'
...
Mar 16 13:58:51 vaio epgd: Creating function 'getlvrmin'
Mar 16 13:58:51 vaio epgd: 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_sum int;$$IF vdr_duration = ext_duration then set delta_du = 100;$ELSEIF vdr_duration > ext_duration then set delta_du = round(vdr_duration/ext_duration*100,0);$ELSE set delta_du = round(ext_duration/vdr_duration*100,0);$END IF;$$IF delta_du > 184 then set lv_dur = 50;$ELSEIF delta_du > 168 then set lv_dur = 40;$ELSEIF delta_du > 152 then set lv_dur = 30;$ELSEIF delta_du > 136 then set lv_dur = 20;$ELSEIF delta_du > 120 then set lv_dur = 10;$ELSE set lv_dur = 0;$END IF;$$IF vdr_starttime = ext_starttime then set delta_st = 100;$ELSEIF vdr_starttime > ext_starttime then set delta_st = vdr_starttime-ext_starttime;$ELSE set delta_st = ext_starttime-vdr_starttime;$END IF;$$IF delta_st <= 600 then$ IF delta_st > 540 then set lv_time = 50;$ ELSEIF delta_st > 480 then set lv_time = 40;$ ELSEIF delta_st > 420 then set lv_time = 30;$ ELSEIF delta_st > 360 then set lv_time = 20;$ ELSEIF delta_st > 300 then set lv_time = 10;$ ELSE set lv_time = 0;$ END IF;$$ set lv_min = LEAST(lv1,lv2,lv3,lv4);$$ set lv_sum = lv_time + lv_dur + lv_min;$$ELSEIF lv_dur + lv1 + lv4 <= 60 then set lv_sum = 60;$ELSEIF lv1 <= 30 and vdr_starttime = ext_starttime then set lv_sum = 60;$ELSEIF lv1 <= 30 and vdr_duration/abs(vdr_starttime-ext_starttime) >= 2.5 then set lv_sum = 60;$ELSE set lv_sum = 99;$END IF;$$RETURN lv_sum;$$END$' - FUNCTION getlvrmin already exists (1304)
Mar 16 13:58:51 vaio epgd: SQL-Error in 'executeSqlFile()' - FUNCTION getlvrmin already exists (1304)
Mar 16 13:58:51 vaio epgd: Using scraping language en
Mar 16 13:58:51 vaio epgd: TVDB scraper connected
Mar 16 13:58:51 vaio epgd: MOVIEDB scraper connected
Mar 16 13:58:51 vaio epgd: Retry #1 failed, retrying in 60 seconds!
Mar 16 13:58:51 vaio epgd: Closing mysql connection and calling mysql_thread_end(23535)
Alles anzeigen
volles Log https://pastebin.com/fiuTq37S