API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 16th, 2020
127
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.55 KB | None | 0 0
raw download clone embed print report
  1. Mar 16 13:58:50 vaio systemd[1]: Started Database driven EPG Data collector.
  2. Mar 16 13:58:51 vaio epgd: Trying to re-connect to database!
  3. Mar 16 13:58:51 vaio epgd: Calling mysql_init(23535)
  4. Mar 16 13:58:51 vaio epgd: Loading '/etc/epgd/channelmap.conf'
  5. Mar 16 13:58:51 vaio epgd: 134 channel mappings read.
  6. Mar 16 13:58:51 vaio epgd: Creating procedure 'mergeepg'
  7. Mar 16 13:58:51 vaio epgd: 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 = unix_timestamp()$where$ e.source = 'vdr' and$ e.updflg in ('D','R') and$ e.useid != e.masterid and$ e.starttime + e.duration >= unix_timestamp();$/*$* cleanup broken Links$*/$update$ events t$ inner join$($ select$ v.masterid,$ e.starttime,$ e.comptitle,$ e.compshorttext,$ e.updflg$ from$ events v$ left join$ events e$ on e.masterid = v.useid and v.masterid != e.masterid and e.updflg in ('T','C') and ifnull(e.delflg,'N') = 'N'$ where$ v.updflg in('L') and$ v.starttime + v.duration >= unix_timestamp()$) s$on t.masterid=s.masterid$set$ t.useid = t.masterid,$ t.updflg = case when t.delflg = 'Y' then 'D' else 'A' end,$ t.updsp = unix_timestamp()$where$ s.updflg is Null or$ abs(s.starttime - t.starttime) > 21600 or$ (abs(s.starttime - t.starttime) > 3600 and$ getlvrmin(0,0,0,0,$ getcrosslvr(s.comptitle,t.comptitle),$ getcrosslvr(s.comptitle,t.compshorttext),$ getcrosslvr(s.compshorttext,t.comptitle),$ getcrosslvr(s.compshorttext,t.compshorttext)) >= 60);$/*$* cleanup broken Targets$*/$update$ events t$ inner join$($ select$ e.masterid,$ v.updflg$ from$ events e$ left join$ events v$ on e.masterid = v.useid and v.masterid != e.masterid and v.updflg = 'L'$ where$ e.updflg in('C','T') and$ e.starttime + e.duration >= unix_timestamp()$) s$on t.masterid=s.masterid$set$ t.useid = t.masterid,$ t.updflg = case when t.delflg = 'Y' then 'D' else 'R' end,$ t.updsp = unix_timestamp()$where$ s.updflg is Null;$/*$* reset tables$*/$truncate snapshot;$truncate analyse;$/*$* prepare snapshot$*/$insert into snapshot$select$ distinct ev.channelid, ev.source, masterid, ev.eventid, useid, starttime, duration, title, comptitle, shorttext, compshorttext, ev.updsp,$ case when episodecompname is Null then Null else 'X' end episodecompname,$ case when ev.source = 'vdr' then Null else cm.merge end merge,$ case when ev.imagecount >0 then 'X' else Null end images$from$ events ev$ inner join channelmap cm on ( ev.channelid = cm.channelid )$where$ ( ev.source = cm.source or ev.source = 'vdr' )$ AND$ ev.updflg in ('I','A','R','S')$ AND$ ev.starttime between unix_timestamp() - ev.duration and unix_timestamp() + 259200$ AND$ cm.merge in(1,2);$/*$* do the magic$*/$set @pk1 ='';$set @rn1 =10000;$set @lvmin ='';$insert ignore into analyse$SELECT channelid, vdr_masterid, vdr_eventid, vdr_starttime, vdr_duration, vdr_title, vdr_shorttext, ext_masterid, ext_eventid, ext_starttime, ext_duration, ext_title, ext_shorttext, ext_episodecompname, ext_merge, ext_images, lvmin,$ epi+img+sht + ranklv as rank$FROM$($ SELECT channelid, vdr_masterid, vdr_eventid, vdr_starttime, vdr_duration, vdr_title, vdr_shorttext, ext_masterid, ext_eventid, ext_starttime, ext_duration, ext_title, ext_shorttext, ext_episodecompname, ext_merge, ext_images, lvmin,$ case when ext_episodecompname is not Null then 0 else (case @epi when 'a' then 1000 when 'b' then 100 when 'c' then 10 else 0 end) end epi,$ case when ext_images is not Null then 0 else (case @img when 'a' then 1000 when 'b' then 100 when 'c' then 10 else 0 end) end img,$ case when ext_shorttext is not Null then 0 else (case @sht when 'a' then 1000 when 'b' then 100 when 'c' then 10 else 0 end) end sht,$ @rn1 := if(@pk1=concat(channelid,vdr_eventid,ext_source), if(@lv=lvmin, @rn1, @rn1+10000),10000+ext_merge) as ranklv,$ @pk1 := concat(channelid,vdr_eventid,ext_source),$ @lv := lvmin$ FROM$ ($ select$ vdr.channelid,$ vdr.masterid vdr_masterid, vdr.eventid vdr_eventid, vdr.starttime vdr_starttime, vdr.duration vdr_duration, vdr.title vdr_title, vdr.shorttext vdr_shorttext,$ ext.masterid ext_masterid, ext.eventid ext_eventid, ext.starttime ext_starttime, ext.duration ext_duration, ext.title ext_title, ext.shorttext ext_shorttext,$ ext.source ext_source,ext.episode ext_episodecompname, ext.merge ext_merge, ext.images ext_images,$ getlvrmin(vdr.starttime,ext.starttime,vdr.duration,ext.duration,$ getcrosslvr(vdr.comptitle,ext.comptitle),$ getcrosslvr(vdr.comptitle,ext.compshorttext),$ getcrosslvr(vdr.compshorttext,ext.comptitle),$ getcrosslvr(vdr.compshorttext,ext.compshorttext)$ ) lvmin$ from$ snapshot vdr$ inner join$ snapshot ext$ on vdr.channelid = ext.channelid and$ vdr.starttime - ext.starttime between -1200 and +1200 and$ (vdr.duration+1) / (ext.duration+1) * 100 between 50 and 200$ where$ vdr.source = 'vdr'$ AND$ vdr.source <> ext.source$ ORDER BY channelid,vdr_eventid,ext_merge desc,lvmin$ ) A$ where lvmin <= 60$) B$order by channelid,vdr_eventid,rank;$/*$* update mergesp$*/$update$ channelmap cm,$ (select channelid,max(vdr_starttime) merge_sp from analyse group by channelid) an$set$ cm.mergesp = an.merge_sp$where$ an.channelid = cm.channelid and$ an.merge_sp > cm.mergesp;$/*$* update useid on vdr events$*/$update$ events ev,$ analyse an$set$ ev.useid = an.ext_masterid$where$ ev.masterid = vdr_masterid and$ ev.channelid = an.channelid;$/*$* update useid on ext events$*/$update$ events ext,$ events vdr$set$ ext.useid = case when ext.updflg in('I','R') then vdr.masterid else ext.useid end,$ ext.updflg = case when ext.updflg in('I','R') then 'C' else 'T' end,$ ext.updsp = case when ext.updflg in('I','R') then unix_timestamp() else ext.updsp end$where$ ext.masterid = vdr.useid and$ ext.channelid = vdr.channelid and$ ext.updflg in('I','A','R','S') and$ ext.source <> vdr.source and$ vdr.source = 'vdr';$/*$* update all other relevant updflg and updsp$*/$update$ events ev,$ (select distinct channelid,mergesp from channelmap where source != 'vdr') cm$set$ ev.updflg = case when ev.source = 'vdr' and ev.masterid != ev.useid then 'L'$ when ev.source = 'vdr' and ev.masterid = ev.useid then 'A'$ when ev.source != 'vdr' and ev.updflg = 'S' then 'I'$ when ev.source != 'vdr' then 'R'$ end,$ ev.updsp = case when source = 'vdr' and ev.masterid = ev.useid and ev.updflg = 'A' then ev.updsp$ else unix_timestamp()$ end$where$ ev.channelid = cm.channelid and$ ev.starttime < cm.mergesp + ev.duration/10 and$ ( ev.source = 'vdr' and ev.updflg in ('I','A') or$ ev.source != 'vdr' and ev.updflg in ('A','S') );$/*$* reinitialize prior removed dvb events$*/$update$ events ev,$ (select distinct channelid,mergesp from channelmap where source != 'vdr') cm$set$ ev.updflg = 'A',$ ev.useid = ev.masterid,$ ev.updsp = unix_timestamp()$where$ ev.channelid = cm.channelid and$ ev.starttime < cm.mergesp + ev.duration/10 and$ ev.source = 'vdr' and$ ev.updflg in ('R');$/*$* get startrun / lastrun$*/$SET startrun = (select unix_timestamp());$SET lastrun = (select value from parameters where owner = 'epgd' and name = 'mergeStart');$/*$* truncate useevents if needed$*/$IF lastrun = 0 then truncate table useevents;$END IF;$/*$* update useevents$*/$insert into$ useevents( cnt_source, cnt_channelid, cnt_eventid, cnt_masterid, cnt_useid, sub_source, sub_eventid, all_updsp, cnt_updflg, cnt_delflg, cnt_fileref, cnt_tableid, cnt_version, sub_title, sub_shorttext, sub_comptitle, sub_compshorttext, sub_genre, sub_country, sub_year, cnt_starttime, cnt_duration, cnt_parentalrating, cnt_vps, cnt_contents, sub_category, sub_shortdescription, sub_shortreview, sub_tipp, sub_rating, sub_numrating, sub_txtrating, sub_topic, sub_longdescription, sub_complongdescription, cnt_longdescription, sub_moderator, sub_guest, sub_actor, sub_producer, sub_other, sub_director, sub_commentator, sub_screenplay, sub_camera, sub_music, sub_audio, sub_flags, sub_imagecount, sub_scrseriesid, sub_scrseriesepisode, sub_scrmovieid, sub_scrsp, sub_episodecompn
  8. Mar 16 13:58:51 vaio epgd: SQL-Error in 'executeSqlFile()' - PROCEDURE mergeepg already exists (1304)
  9. Mar 16 13:58:51 vaio epgd: Creating procedure 'reverseepg'
  10. Mar 16 13:58:51 vaio epgd: 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$where$ ev.source = 'vdr' and$ ev.channelid = cm.channelid;$/*$* events zurücksetzen Teil 2$*/$update$ events ev,$ (select distinct mergesp,merge,channelid,source from channelmap) cm$set$ useid = masterid,$ updflg =$ case$ when ev.delflg = 'Y' then 'D'$ when ev.source = 'vdr' then 'P'$ when ev.source != 'vdr' and merge > 1 then 'S'$ else 'A'$ end$where$ ev.source = cm.source and$ ev.channelid = cm.channelid;$END$$' - PROCEDURE reverseepg already exists (1304)
  11. Mar 16 13:58:51 vaio epgd: SQL-Error in 'executeSqlFile()' - PROCEDURE reverseepg already exists (1304)
  12. Mar 16 13:58:51 vaio epgd: Creating function 'getupdflg'
  13. Mar 16 13:58:51 vaio epgd: 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$' - FUNCTION getupdflg already exists (1304)
  14. Mar 16 13:58:51 vaio epgd: SQL-Error in 'executeSqlFile()' - FUNCTION getupdflg already exists (1304)
  15. Mar 16 13:58:51 vaio epgd: Creating function 'getcrosslvr'
  16. Mar 16 13:58:51 vaio epgd: 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 shorter = comp1; set longer = comp2; set complenght = char_length(comp2);$ELSEIF char_length(comp2) = 0 then$ set ratio = 999;$ set shorter = comp2; set longer = comp1; set complenght = char_length(comp1);$ELSEIF 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 or char_length(comp1) = 0 or char_length(comp2) = 0 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$' - FUNCTION getcrosslvr already exists (1304)
  17. Mar 16 13:58:51 vaio epgd: SQL-Error in 'executeSqlFile()' - FUNCTION getcrosslvr already exists (1304)
  18. Mar 16 13:58:51 vaio epgd: Creating function 'getlvrmin'
  19. 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)
  20. Mar 16 13:58:51 vaio epgd: SQL-Error in 'executeSqlFile()' - FUNCTION getlvrmin already exists (1304)
  21. Mar 16 13:58:51 vaio epgd: Using scraping language en
  22. Mar 16 13:58:51 vaio epgd: TVDB scraper connected
  23. Mar 16 13:58:51 vaio epgd: MOVIEDB scraper connected
  24. Mar 16 13:58:51 vaio epgd: Retry #1 failed, retrying in 60 seconds!
  25. Mar 16 13:58:51 vaio epgd: Closing mysql connection and calling mysql_thread_end(23535)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!