Mär 27 17:10:27 vdr systemd[1]: Starting Database driven EPG Data collector...
Mär 27 17:10:27 vdr epgd[9701]: Set locale to 'de_DE.UTF-8'
Mär 27 17:10:27 vdr epgd[9701]: detected UTF-8
Mär 27 17:10:27 vdr epgd[9701]: Loading uuid from '/etc/epgd/uuid' succeeded [344B748E-E9CA-4B57-9BB1-82E60329AB4D]
Mär 27 17:10:27 vdr epgd[9701]: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Mär 27 17:10:27 vdr epgd[9701]: Read 26 option from /etc/epgd/epgd.conf
Mär 27 17:10:27 vdr epgd[9701]: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Mär 27 17:10:27 vdr epgd[9701]: SQL client character now 'utf8'
Mär 27 17:10:27 vdr epgd[9701]: State now 'init'
Mär 27 17:10:27 vdr epgd[9701]: Loading '/etc/epgd/channelmap.conf'
Mär 27 17:10:27 vdr epgd[9701]: 103 channel mappings read.
Mär 27 17:10:27 vdr epgd[9701]: Creating function 'getupdflg'
Mär 27 17:10:27 vdr epgd[9701]: 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 'T'
                                     when ev.delflg = 'Y' then 'D'
                                     when ev.source != 'vdr' and ev.starttime <= cm.mergesp and jo.masterid is Null then 'R'
                                     when ev.source != 'vdr' and ev.starttime > cm.mergesp then 'A'
                                     when ev.source = 'vdr' and cm.mergesp is Null then 'P'
                                     when ev.source = 'vdr' and ev.starttime > cm.mergesp then 'I'
                                     when ev.source = 'vdr' and ev.starttime <= cm.mergesp and ev.masterid = ev.useid then 'A'
                                     when ev.source = 'vdr' and ev.starttime <= cm.mergesp and ev.masterid != ev.useid then 'L'
                                   end
                                 from
                                   events ev
                                 left join
                                   events jo
                                 on
                                  ev.masterid = jo.useid and jo.useid != 0 and jo.updflg = 'L'
                                 left join
                                  (select distinct mergesp,channelid from channelmap where channelmap.source != 'vdr') cm
                                 on
                                  ev.channelid = cm.channelid
                                 where
                                  ev.masterid = master_id
                                  limit 1
                                 );
                                 RETURN upd_flg;
                                 END
                                 ' - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) (1418)
Mär 27 17:10:27 vdr epgd[9701]: SQL-Error in 'executeSqlFile()' - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) (1418)
Mär 27 17:10:27 vdr epgd[9701]: Creating function 'getcrosslvr'
Mär 27 17:10:27 vdr epgd[9701]: 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) >= char_length(comp2) then
                                      set ratio = round(char_length(comp1) / char_length(comp2),2);
                                      set shorter = comp2; set longer = comp1; set complenght = char_length(comp1);
                                 else set ratio = round(char_length(comp2) / char_length(comp1),2);
                                      set shorter = comp1; set longer = comp2; set complenght = char_length(comp2);
                                 END IF;
                                 IF comp1 is null or comp2 is null then set crosslv = 99;
                                 ELSEIF comp1 = comp2 then set crosslv = 0;
                                 ELSEIF comp1 is Null or comp2 is Null then set crosslv = 99;
                                 ELSEIF complenght >= 10 and ratio >= 3.2 then set crosslv = 99;
                                 ELSEIF ratio < 1.5 then set crosslv = epglvr(shorter,longer);
                                 ELSE set crosslvt = epglvr(shorter,substr(longer,1,complenght/2));
                                  IF crosslvt < 60 then set crosslv = crosslvt;
                                  ELSE set crosslv = epglvr(substr(longer from complenght/2+1),shorter);
                                  END IF;
                                 END IF;
                                 RETURN crosslv;
                                 END
                                 ' - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) (1418)
Mär 27 17:10:27 vdr epgd[9701]: SQL-Error in 'executeSqlFile()' - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) (1418)
Mär 27 17:10:27 vdr epgd[9701]: Creating function 'getlvrmin'
Mär 27 17:10:27 vdr epgd[9701]: 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 = 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 = 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_duration/abs(vdr_starttime-ext_starttime) >= 2.5 then set lv_sum = 60;
                                 ELSE set lv_sum = 99;
                                 END IF;
                                 
                                 RETURN lv_sum;
                                 
                                 END
                                 ' - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) (1418)
Mär 27 17:10:27 vdr epgd[9701]: SQL-Error in 'executeSqlFile()' - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) (1418)
Mär 27 17:10:27 vdr epgd[9701]: No external events on database, force initial check!
Mär 27 17:10:27 vdr kernel: epgd[9701]: segfault at 8 ip 000000000043e4b0 sp 00007ffc9231e350 error 4 in epgd[400000+94000]
Mär 27 17:10:27 vdr systemd[1]: epgd.service: Control process exited, code=killed status=11
Mär 27 17:10:27 vdr systemd[1]: Failed to start Database driven EPG Data collector.
Mär 27 17:10:27 vdr systemd[1]: epgd.service: Unit entered failed state.
Mär 27 17:10:27 vdr systemd[1]: epgd.service: Failed with result 'signal'.