Problem mit epgd / mysql

thorsten.gehrig · 22. März 2015

Hi Leute,
ich habe seid kurzem im Log das hier:
Mar 22 08:56:25 hdvdr epgd: SQL-Error in 'execute(stmt_execute)' - Thread stack overrun: 9728 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack. (1436) 'Thread stack overrun: 9728 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.' [call mergeepg]

Kann mir irgendjemand sagen was das bedeutet und wie ich es löse?
Ich habe schon "mysqld --thread_stack=256000" probiert ... aber das scheint nicht zureichen... muss ich das als Startparameter in die mysql.init reinsetzen?

Gruß
Thorsten

3PO · 22. März 2015

Wenn überhaupt, dann würde das in die my.cnf gehören, allerdings kann ich leider in dem wirklich "großzügigen" Logfile, das Du gepostet hast nicht erkennen, wo der Fehler liegt.

thorsten.gehrig · 22. März 2015

Hi C3PO,
mehr Meldungen gab es im log nicht... naja - jetzt habe ich my.cnf geändert (threat_stack von 128k auf 256k).

Jetzt kriege ich diese "Warning, size of 200 for 'comppartname' exeeded"

Code

Mar 22 12:57:16 hdvdr epgd: Set locale to 'de_DE.UTF-8'
Mar 22 12:57:16 hdvdr epgd: detected UTF-8
Mar 22 12:57:16 hdvdr epgd: Loading uuid from '/etc/epgd/uuid' succeeded [69914D49-ECCE-491A-BFF5-9EC94F73C320]
Mar 22 12:57:16 hdvdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Mar 22 12:57:16 hdvdr epgd: Read 26 option from /etc/epgd/epgd.conf
Mar 22 12:57:16 hdvdr epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Mar 22 12:57:16 hdvdr epgd: SQL client character now 'utf8'
Mar 22 12:57:16 hdvdr epgd: State now 'init'
Mar 22 12:57:16 hdvdr epgd: Loading '/etc/epgd/channelmap.conf'
Mar 22 12:57:16 hdvdr epgd: 170 channel mappings read.
Mar 22 12:57:16 hdvdr epgd: No external events on database, force initial check!
Mar 22 12:57:16 hdvdr epgd: using scrapping language de
Mar 22 12:57:17 hdvdr epgd: tvdb scraper connected
Mar 22 12:57:17 hdvdr epgd: moviedb scraper connected
Mar 22 12:57:17 hdvdr epgd: Scheduled next update in 10 second(s)
Mar 22 12:57:17 hdvdr epgd: State now 'standby'
Mar 22 12:57:24 hdvdr vdr: [1974] changing pids of channel 242 from 401+401=2:402=deu@3:0:0 to 501+501=2:502=deu@3:0:0
Mar 22 12:57:27 hdvdr epgd: State now 'busy (events)'
Mar 22 12:57:27 hdvdr epgd: Starting cleanup of events
Mar 22 12:57:27 hdvdr epgd: Delete fileref [substr(name,1,8) <= '20150321']
Mar 22 12:57:27 hdvdr epgd: Delete events [starttime+duration < 1427003847]
Mar 22 12:57:28 hdvdr epgd: Cleanup of events finished
Mar 22 12:57:28 hdvdr epgd: EPG Update started
Mar 22 12:57:28 hdvdr epgd: EPG Update finished, loaded 0 files (0.000 KB), 0 non-updates skipped, 0 rejected due to format error.
Mar 22 12:57:28 hdvdr epgd: Starting episode download ...
Mar 22 12:57:28 hdvdr epgd: SVDRPCL: connected to eplists.constabel.net:2006 'eplists.constabel.net EpisodesListsServer 0.0.5-beta6; Sun Mar 22 12:57:28 2015'
Mar 22 12:57:28 hdvdr epgd: Got 'Setting encoding to utf8'
Mar 22 12:57:28 hdvdr epgd: Requesting episode changes of last 103 minutes
Mar 22 12:57:29 hdvdr epgd: Received 1 episode files
Mar 22 12:57:29 hdvdr epgd: Starting episode lookup ...
Mar 22 12:57:31 hdvdr epgd: Warning, size of 200 for 'comppartname' exeeded [ALSSAMSLAPTOPGESTOHLENWIRDVERSUCHTDIETRUPPEDENDIEBAUFZUSPÜRENWÄHRENDDESSENKOMMTSPENCERNICHTINSEINELIEBLINGSSPIELHALLEREINSOLANGEERNICHTINBEGLEITUNGEINESKINDESISTERHATGLÜCKALSGUPPYEINENBABYSITTERBRAUCHT]
Mar 22 12:57:31 hdvdr epgd: Warning, size of 200 for 'comppartname' exeeded [ALSSAMERFÄHRTDASSIHREMUTTERINLASVEGASIMGEFÄNGNISSITZTPACKTDIETRUPPEIHREWERTVOLLSTENSACHENEINUNDVERPFÄNDETSIEUMGELDFÜRDIEKAUTIONAUFZUTREIBENGASTDARSTELLERDIEBESETZUNGDERHISTORYCHANNELSERIEDIEDREIVOM]
Mar 22 12:57:35 hdvdr epgd: Warning, size of 200 for 'comppartname' exeeded [UNSEREFREUNDELASSENSICHDARAUFEINFÜRTAUSENDDOLLARAUFDERGEBURTSTAGSFEIERDESVIERJÄHRIGENSOHNESVONSIKOWITZEHEMALIGEMMITBEWOHNEREINLIEDZUSINGENDOCHIHRPEINLICHERAUFTRITTLANDETPROMPTIMINTERNETUNDWIRDDERTOTA]
Mar 22 12:57:35 hdvdr epgd: Warning, size of 200 for 'comppartname' exeeded [NACHDEMZOEYVERGEBLICHVERSUCHTHATMITDEMSTRENGENVERANSTALTERDESWOHLTÄTIGKEITSLAUFSZUSPRECHENHILFTSIELOLADASUNABSICHTLICHZUGESAGTESPENDENGELDAUFZUBRINGENAUßERDEMKOMMENQUINNUNDLOGANSICHNÄHERVERSUCHENESABERG]
Mar 22 12:57:35 hdvdr epgd: Lookup done for 1334 series, matched 2474 parts by compare and 231 parts by lv in 6 seconds; Updated 0
Mar 22 12:57:35 hdvdr epgd: Calling 'mergeepg'
Mar 22 12:57:41 hdvdr epgd: 'mergeepg' suceeded
Mar 22 12:57:41 hdvdr epgd: State now 'busy (images)'

Alles anzeigen

Außerdem scheint er keine TVM Daten einzulesen:

Code

root@hdvdr:/etc/epgd# epgd-showmerge 
mysql: Unknown OS character set 'ISO-8859-15'.
mysql: Switching to the default character set 'latin1'.
+---------------+--------+
| count(source) | source |
+---------------+--------+
|         19315 | vdr    |
+---------------+--------+
mysql: Unknown OS character set 'ISO-8859-15'.
mysql: Switching to the default character set 'latin1'.
+----------+--------+--------+
| count(*) | source | updflg |
+----------+--------+--------+
|       15 | vdr    | D      |
|    17912 | vdr    | I      |
|      123 | vdr    | P      |
|       27 | vdr    | R      |
+----------+--------+--------+

Alles anzeigen

Wie kann man das einlesen der TVM-Daten Debugger?

Danke & Gruß
Thorsten

3PO · 22. März 2015

Zitat von thorsten.gehrig

Hi C3PO,
mehr Meldungen gab es im log nicht... naja - jetzt habe ich my.cnf geändert (threat_stack von 128k auf 256k). ...

Und was passiert, wenn Du den Eintrag ganz weg lässt?

thorsten.gehrig · 22. März 2015

ich hab den "thread_stack" mal auszementiert und neu gestartet: keine Änderung
ich hab jetzt sogar ein Abo bei epgData abgeschlossen... und den vdr-epg-daemon vom Yard neu installiert (also ohne tvm).
bisher keine Veränderung

3PO · 22. März 2015

"Yard" <-- Sagt mit nichts, was soll das sein??

thorsten.gehrig · 22. März 2015

(sorry - typo oder autokorrektur)
yaVDR

TheChief · 22. März 2015

Naja, die Warnings kann man ignorieren, da ist einfach das Feld zu kurz.

Ansonsten, was heisst denn keine Änderung? Was geht denn jetzt nicht? Ggfs. mal channelmap posten.

thorsten.gehrig · 22. März 2015

Was geht nicht: scheinbar wird nichts von der EPG-quelle eingelesen.
müsste epgd-showmerge nicht mehr bringen als das was oben ist?

Mich nervt mein VDR gerade richtig an. Scheinbar hab ich auch "irgendwo" das normale EPG vom Sat-Empfang ausgeschaltet - jetzt habe ich gar kein EPG mehr.
Damit laufen auch alle meine Autotimer nicht mehr

Bin für jeden Tipp dankbar.
ich habe das ebbd-loglevel mal auf 2 gesetzt:

Code

Mar 22 13:38:13 hdvdr epgd: detected UTF-8
Mar 22 13:38:13 hdvdr epgd: Loading uuid from '/etc/epgd/uuid' succeeded [69914D49-ECCE-491A-BFF5-9EC94F73C320]
Mar 22 13:38:13 hdvdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Mar 22 13:38:13 hdvdr epgd: Read 26 option from /etc/epgd/epgd.conf
Mar 22 13:38:13 hdvdr epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Mar 22 13:38:13 hdvdr epgd: SQL client character now 'utf8'
Mar 22 13:38:13 hdvdr epgd: Statement 'select uuid, inssp, updsp, name, version, dbapi, lastupd, nextupd, state, master, ip from vdrs where uuid = ?;' with (1) in parameters and (11) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into vdrs set uuid = ?, inssp = ?, updsp = ?, name = ?, version = ?, dbapi = ?, lastupd = ?, nextupd = ?, state = ?, master = ?, ip = ?;' with (11) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update vdrs set updsp = ?, name = ?, version = ?, dbapi = ?, lastupd = ?, nextupd = ?, state = ?, master = ?, ip = ? where uuid = ?;' with (10) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: State now 'init'
Mar 22 13:38:13 hdvdr epgd: Statement 'select extid, channelid, source, channelname, vps, merge, mergesp, inssp, updsp, updflg from channelmap where extid = ? and channelid = ? and source = ?;' with (3) in parameters and (10) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into channelmap set extid = ?, channelid = ?, source = ?, channelname = ?, vps = ?, merge = ?, mergesp = ?, inssp = ?, updsp = ?, updflg = ?;' with (10) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update channelmap set channelname = ?, vps = ?, merge = ?, mergesp = ?, updsp = ?, updflg = ? where extid = ? and channelid = ? and source = ?;' with (9) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select name, source, inssp, updsp, extid, fileref, tag from fileref where name = ? and source = ?;' with (2) in parameters and (7) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into fileref set name = ?, source = ?, inssp = ?, updsp = ?, extid = ?, fileref = ?, tag = ?;' with (7) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update fileref set updsp = ?, extid = ?, fileref = ?, tag = ? where name = ? and source = ?;' with (6) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select imagename, inssp, updsp, image from images where imagename = ?;' with (1) in parameters and (4) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into images set imagename = ?, inssp = ?, updsp = ?, image = ?;' with (4) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update images set updsp = ?, image = ? where imagename = ?;' with (3) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select eventid, lfn, inssp, updsp, source, fileref, imagename from imagerefs where eventid = ? and lfn = ?;' with (2) in parameters and (7) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into imagerefs set eventid = ?, lfn = ?, inssp = ?, updsp = ?, source = ?, fileref = ?, imagename = ?;' with (7) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update imagerefs set updsp = ?, source = ?, fileref = ?, imagename = ? where eventid = ? and lfn = ?;' with (6) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select compname, comppartname, lang, inssp, updsp, link, shortname, episodename, partname, season, part, parts, number, extracol1, extracol2, extracol3, comment from episodes where compname = ? and comppartname = ? and lang = ?;' with (3) in parameters and (17) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into episodes set compname = ?, comppartname = ?, lang = ?, inssp = ?, updsp = ?, link = ?, shortname = ?, episodename = ?, partname = ?, season = ?, part = ?, parts = ?, number = ?, extracol1 = ?, extracol2 = ?, extracol3 = ?, comment = ?;' with (17) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update episodes set updsp = ?, link = ?, shortname = ?, episodename = ?, partname = ?, season = ?, part = ?, parts = ?, number = ?, extracol1 = ?, extracol2 = ?, extracol3 = ?, comment = ? where compname = ? and comppartname = ? and lang = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;' with (2) in parameters and (53) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into events set eventid = ?, channelid = ?, useid = ?, source = ?, fileref = ?, inssp = ?, updsp = ?, updflg = ?, delflg = ?, tableid = ?, version = ?, title = ?, comptitle = ?, shorttext = ?, compshorttext = ?, longdescription = ?, starttime = ?, duration = ?, parentalrating = ?, vps = ?, shortdescription = ?, actor = ?, audio = ?, category = ?, country = ?, director = ?, flags = ?, genre = ?, info = ?, music = ?, producer = ?, screenplay = ?, shortreview = ?, tipp = ?, topic = ?, year = ?, rating = ?, fsk = ?, movieid = ?, moderator = ?, other = ?, guest = ?, camera = ?, extepnum = ?, imagecount = ?, episode = ?, episodepart = ?, episodelang = ?, scrseriesid = ?, scrseriesepisode = ?, scrmovieid = ?, scrsp = ?;' with (52) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update events set useid = ?, source = ?, fileref = ?, updsp = ?, updflg = ?, delflg = ?, tableid = ?, version = ?, title = ?, comptitle = ?, shorttext = ?, compshorttext = ?, longdescription = ?, starttime = ?, duration = ?, parentalrating = ?, vps = ?, shortdescription = ?, actor = ?, audio = ?, category = ?, country = ?, director = ?, flags = ?, genre = ?, info = ?, music = ?, producer = ?, screenplay = ?, shortreview = ?, tipp = ?, topic = ?, year = ?, rating = ?, fsk = ?, movieid = ?, moderator = ?, other = ?, guest = ?, camera = ?, extepnum = ?, imagecount = ?, episode = ?, episodepart = ?, episodelang = ?, scrseriesid = ?, scrseriesepisode = ?, scrmovieid = ?, scrsp = ? where eventid = ? and channelid = ?;' with (51) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select eventid, channelid, stream, type, lang, description, inssp, updsp from components where eventid = ? and channelid = ? and stream = ? and type = ? and lang = ? and description = ?;' with (6) in parameters and (8) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into components set eventid = ?, channelid = ?, stream = ?, type = ?, lang = ?, description = ?, inssp = ?, updsp = ?;' with (8) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update components set updsp = ? where eventid = ? and channelid = ? and stream = ? and type = ? and lang = ? and description = ?;' with (7) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select owner, name, inssp, updsp, value from parameters where owner = ? and name = ?;' with (2) in parameters and (5) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into parameters set owner = ?, name = ?, inssp = ?, updsp = ?, value = ?;' with (5) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update parameters set updsp = ?, value = ? where owner = ? and name = ?;' with (4) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select uuid, rec_path, rec_start, event_id, channel_id, scrapinfo_movie_id, scrapinfo_series_id, scrapinfo_episode_id, scrap_new, scrsp, rec_title, rec_subtitle, rec_duration, movie_id, series_id, episode_id from recordings where uuid = ? and rec_path = ? and rec_start = ?;' with (3) in parameters and (16) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into recordings set uuid = ?, rec_path = ?, rec_start = ?, event_id = ?, channel_id = ?, scrapinfo_movie_id = ?, scrapinfo_series_id = ?, scrapinfo_episode_id = ?, scrap_new = ?, scrsp = ?, rec_title = ?, rec_subtitle = ?, rec_duration = ?, movie_id = ?, series_id = ?, episode_id = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update recordings set event_id = ?, channel_id = ?, scrapinfo_movie_id = ?, scrapinfo_series_id = ?, scrapinfo_episode_id = ?, scrap_new = ?, scrsp = ?, rec_title = ?, rec_subtitle = ?, rec_duration = ?, movie_id = ?, series_id = ?, episode_id = ? where uuid = ? and rec_path = ? and rec_start = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select extid from channelmap where channelid = ? and source <> ? and updflg <> 'D'' with (2) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select extid, channelid, source, updflg from channelmap' with (0) in parameters and (4) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update events set updsp = ?, episode = ?, episodepart = ?, episodelang = ? where eventid = ? and channelid = ?' with (6) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select eventid, channelid, compshorttext, episodepart, episodelang from events where comptitle = ?' with (1) in parameters and (5) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select count(1) from events where source = ? and updsp > ?' with (2) in parameters and (1) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select max(updsp) from episodes' with (0) in parameters and (1) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select distinct compname from episodes' with (0) in parameters and (1) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select comppartname, lang from episodes where compname = ?' with (1) in parameters and (2) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select episodename, partname, lang from episodes where compname = ? and comppartname = ?' with (2) in parameters and (3) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select count(1) from recordings where scrap_new = ?' with (1) in parameters and (1) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select uuid, rec_path, rec_start, event_id, channel_id, scrapinfo_movie_id, scrapinfo_series_id, scrapinfo_episode_id, rec_title, rec_subtitle, rec_duration from recordings where scrap_new = ?' with (1) in parameters and (11) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select scrseriesid, scrseriesepisode, scrmovieid from events where masterid = ? and channelid = ? and (scrseriesid is not null or scrmovieid is not null)' with (2) in parameters and (3) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select series_id, episode_id, movie_id from recordings where uuid != ? and rec_path  like  ? and rec_start = ? and (series_id > 0 or movie_id > 0)' with (3) in parameters and (3) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Error reading '/etc/epgd/channelmap.conf' No such file or directory!
Mar 22 13:38:13 hdvdr epgd: Statement 'select name from fileref where source = ? and fileref = ?' with (2) in parameters and (1) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select name from fileref where source = ? order by name desc' with (1) in parameters and (1) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select channelid, mergesp, merge from channelmap where source = ? and extid = ?' with (2) in parameters and (3) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select name, tag from fileref where source = 'epgdata' and name like ?' with (1) in parameters and (2) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update events set delflg = ?, updflg = ?, fileref = ?, updsp = ? where fileref = ? and source = ? and updflg in ('A','L','P','R','I')' with (6) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show procedure status where name = 'mergeepg'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show procedure status where name = 'mergeepg'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show procedure status where name = 'reverseepg'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show procedure status where name = 'reverseepg'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show function status where name = 'getupdflg'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show function status where name = 'getupdflg'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show function status where name = 'getcrosslvr'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show function status where name = 'getcrosslvr'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show function status where name = 'getlvrmin'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'show function status where name = 'getlvrmin'' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: No external events on database, force initial check!
Mar 22 13:38:13 hdvdr epgd: using scrapping language de
Mar 22 13:38:13 hdvdr epgd: Statement 'select series_id, series_name, series_last_scraped, series_last_updated, series_overview, series_firstaired, series_network, series_imdb_id, series_genre, series_rating, series_status from series where series_id = ?;' with (1) in parameters and (11) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into series set series_id = ?, series_name = ?, series_last_scraped = ?, series_last_updated = ?, series_overview = ?, series_firstaired = ?, series_network = ?, series_imdb_id = ?, series_genre = ?, series_rating = ?, series_status = ?;' with (11) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update series set series_name = ?, series_last_scraped = ?, series_last_updated = ?, series_overview = ?, series_firstaired = ?, series_network = ?, series_imdb_id = ?, series_genre = ?, series_rating = ?, series_status = ? where series_id = ?;' with (11) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select episode_id, episode_number, season_number, episode_name, episode_overview, episode_firstaired, episode_gueststars, episode_rating, episode_last_updated, series_id from series_episode where episode_id = ?;' with (1) in parameters and (10) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into series_episode set episode_id = ?, episode_number = ?, season_number = ?, episode_name = ?, episode_overview = ?, episode_firstaired = ?, episode_gueststars = ?, episode_rating = ?, episode_last_updated = ?, series_id = ?;' with (10) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update series_episode set episode_number = ?, season_number = ?, episode_name = ?, episode_overview = ?, episode_firstaired = ?, episode_gueststars = ?, episode_rating = ?, episode_last_updated = ?, series_id = ? where episode_id = ?;' with (10) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select series_id, season_number, episode_id, actor_id, media_type, media_url, media_width, media_height, media_rating, media_content from series_media where series_id = ? and season_number = ? and episode_id = ? and actor_id = ? and media_type = ?;' with (5) in parameters and (10) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;' with (10) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update series_media set media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ? where series_id = ? and season_number = ? and episode_id = ? and actor_id = ? and media_type = ?;' with (10) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select actor_id, actor_name, actor_role, actor_sortorder from series_actor where actor_id = ?;' with (1) in parameters and (4) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into series_actor set actor_id = ?, actor_name = ?, actor_role = ?, actor_sortorder = ?;' with (4) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update series_actor set actor_name = ?, actor_role = ?, actor_sortorder = ? where actor_id = ?;' with (4) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;' with (2) in parameters and (53) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into events set eventid = ?, channelid = ?, useid = ?, source = ?, fileref = ?, inssp = ?, updsp = ?, updflg = ?, delflg = ?, tableid = ?, version = ?, title = ?, comptitle = ?, shorttext = ?, compshorttext = ?, longdescription = ?, starttime = ?, duration = ?, parentalrating = ?, vps = ?, shortdescription = ?, actor = ?, audio = ?, category = ?, country = ?, director = ?, flags = ?, genre = ?, info = ?, music = ?, producer = ?, screenplay = ?, shortreview = ?, tipp = ?, topic = ?, year = ?, rating = ?, fsk = ?, movieid = ?, moderator = ?, other = ?, guest = ?, camera = ?, extepnum = ?, imagecount = ?, episode = ?, episodepart = ?, episodelang = ?, scrseriesid = ?, scrseriesepisode = ?, scrmovieid = ?, scrsp = ?;' with (52) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update events set useid = ?, source = ?, fileref = ?, updsp = ?, updflg = ?, delflg = ?, tableid = ?, version = ?, title = ?, comptitle = ?, shorttext = ?, compshorttext = ?, longdescription = ?, starttime = ?, duration = ?, parentalrating = ?, vps = ?, shortdescription = ?, actor = ?, audio = ?, category = ?, country = ?, director = ?, flags = ?, genre = ?, info = ?, music = ?, producer = ?, screenplay = ?, shortreview = ?, tipp = ?, topic = ?, year = ?, rating = ?, fsk = ?, movieid = ?, moderator = ?, other = ?, guest = ?, camera = ?, extepnum = ?, imagecount = ?, episode = ?, episodepart = ?, episodelang = ?, scrseriesid = ?, scrseriesepisode = ?, scrmovieid = ?, scrsp = ? where eventid = ? and channelid = ?;' with (51) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select compname, comppartname, lang, inssp, updsp, link, shortname, episodename, partname, season, part, parts, number, extracol1, extracol2, extracol3, comment from episodes where compname = ? and comppartname = ? and lang = ?;' with (3) in parameters and (17) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into episodes set compname = ?, comppartname = ?, lang = ?, inssp = ?, updsp = ?, link = ?, shortname = ?, episodename = ?, partname = ?, season = ?, part = ?, parts = ?, number = ?, extracol1 = ?, extracol2 = ?, extracol3 = ?, comment = ?;' with (17) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update episodes set updsp = ?, link = ?, shortname = ?, episodename = ?, partname = ?, season = ?, part = ?, parts = ?, number = ?, extracol1 = ?, extracol2 = ?, extracol3 = ?, comment = ? where compname = ? and comppartname = ? and lang = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select uuid, rec_path, rec_start, event_id, channel_id, scrapinfo_movie_id, scrapinfo_series_id, scrapinfo_episode_id, scrap_new, scrsp, rec_title, rec_subtitle, rec_duration, movie_id, series_id, episode_id from recordings where uuid = ? and rec_path = ? and rec_start = ?;' with (3) in parameters and (16) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into recordings set uuid = ?, rec_path = ?, rec_start = ?, event_id = ?, channel_id = ?, scrapinfo_movie_id = ?, scrapinfo_series_id = ?, scrapinfo_episode_id = ?, scrap_new = ?, scrsp = ?, rec_title = ?, rec_subtitle = ?, rec_duration = ?, movie_id = ?, series_id = ?, episode_id = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update recordings set event_id = ?, channel_id = ?, scrapinfo_movie_id = ?, scrapinfo_series_id = ?, scrapinfo_episode_id = ?, scrap_new = ?, scrsp = ?, rec_title = ?, rec_subtitle = ?, rec_duration = ?, movie_id = ?, series_id = ?, episode_id = ? where uuid = ? and rec_path = ? and rec_start = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: tvdb scraper connected
Mar 22 13:38:13 hdvdr epgd: Statement 'select movie_id, movie_title, movie_original_title, movie_tagline, movie_overview, movie_adult, movie_collection_id, movie_collection_name, movie_budget, movie_revenue, movie_genres, movie_homepage, movie_release_date, movie_runtime, movie_popularity, movie_vote_average from movie where movie_id = ?;' with (1) in parameters and (16) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into movie set movie_id = ?, movie_title = ?, movie_original_title = ?, movie_tagline = ?, movie_overview = ?, movie_adult = ?, movie_collection_id = ?, movie_collection_name = ?, movie_budget = ?, movie_revenue = ?, movie_genres = ?, movie_homepage = ?, movie_release_date = ?, movie_runtime = ?, movie_popularity = ?, movie_vote_average = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update movie set movie_title = ?, movie_original_title = ?, movie_tagline = ?, movie_overview = ?, movie_adult = ?, movie_collection_id = ?, movie_collection_name = ?, movie_budget = ?, movie_revenue = ?, movie_genres = ?, movie_homepage = ?, movie_release_date = ?, movie_runtime = ?, movie_popularity = ?, movie_vote_average = ? where movie_id = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select actor_id, actor_name from movie_actor where actor_id = ?;' with (1) in parameters and (2) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into movie_actor set actor_id = ?, actor_name = ?;' with (2) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update movie_actor set actor_name = ? where actor_id = ?;' with (2) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select movie_id, actor_id, actor_role from movie_actors where movie_id = ? and actor_id = ?;' with (2) in parameters and (3) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into movie_actors set movie_id = ?, actor_id = ?, actor_role = ?;' with (3) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update movie_actors set actor_role = ? where movie_id = ? and actor_id = ?;' with (3) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select movie_id, actor_id, media_type, media_url, media_width, media_height, media_content from movie_media where movie_id = ? and actor_id = ? and media_type = ?;' with (3) in parameters and (7) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into movie_media set movie_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_content = ?;' with (7) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update movie_media set media_url = ?, media_width = ?, media_height = ?, media_content = ? where movie_id = ? and actor_id = ? and media_type = ?;' with (7) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;' with (2) in parameters and (53) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into events set eventid = ?, channelid = ?, useid = ?, source = ?, fileref = ?, inssp = ?, updsp = ?, updflg = ?, delflg = ?, tableid = ?, version = ?, title = ?, comptitle = ?, shorttext = ?, compshorttext = ?, longdescription = ?, starttime = ?, duration = ?, parentalrating = ?, vps = ?, shortdescription = ?, actor = ?, audio = ?, category = ?, country = ?, director = ?, flags = ?, genre = ?, info = ?, music = ?, producer = ?, screenplay = ?, shortreview = ?, tipp = ?, topic = ?, year = ?, rating = ?, fsk = ?, movieid = ?, moderator = ?, other = ?, guest = ?, camera = ?, extepnum = ?, imagecount = ?, episode = ?, episodepart = ?, episodelang = ?, scrseriesid = ?, scrseriesepisode = ?, scrmovieid = ?, scrsp = ?;' with (52) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update events set useid = ?, source = ?, fileref = ?, updsp = ?, updflg = ?, delflg = ?, tableid = ?, version = ?, title = ?, comptitle = ?, shorttext = ?, compshorttext = ?, longdescription = ?, starttime = ?, duration = ?, parentalrating = ?, vps = ?, shortdescription = ?, actor = ?, audio = ?, category = ?, country = ?, director = ?, flags = ?, genre = ?, info = ?, music = ?, producer = ?, screenplay = ?, shortreview = ?, tipp = ?, topic = ?, year = ?, rating = ?, fsk = ?, movieid = ?, moderator = ?, other = ?, guest = ?, camera = ?, extepnum = ?, imagecount = ?, episode = ?, episodepart = ?, episodelang = ?, scrseriesid = ?, scrseriesepisode = ?, scrmovieid = ?, scrsp = ? where eventid = ? and channelid = ?;' with (51) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'select uuid, rec_path, rec_start, event_id, channel_id, scrapinfo_movie_id, scrapinfo_series_id, scrapinfo_episode_id, scrap_new, scrsp, rec_title, rec_subtitle, rec_duration, movie_id, series_id, episode_id from recordings where uuid = ? and rec_path = ? and rec_start = ?;' with (3) in parameters and (16) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'insert into recordings set uuid = ?, rec_path = ?, rec_start = ?, event_id = ?, channel_id = ?, scrapinfo_movie_id = ?, scrapinfo_series_id = ?, scrapinfo_episode_id = ?, scrap_new = ?, scrsp = ?, rec_title = ?, rec_subtitle = ?, rec_duration = ?, movie_id = ?, series_id = ?, episode_id = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: Statement 'update recordings set event_id = ?, channel_id = ?, scrapinfo_movie_id = ?, scrapinfo_series_id = ?, scrapinfo_episode_id = ?, scrap_new = ?, scrsp = ?, rec_title = ?, rec_subtitle = ?, rec_duration = ?, movie_id = ?, series_id = ?, episode_id = ? where uuid = ? and rec_path = ? and rec_start = ?;' with (16) in parameters and (0) out bindings prepared
Mar 22 13:38:13 hdvdr epgd: moviedb scraper connected
Mar 22 13:38:13 hdvdr epgd: Scheduled next update in 10 second(s)
Mar 22 13:38:13 hdvdr epgd: State now 'standby'
Mar 22 13:38:23 hdvdr epgd: State now 'busy (events)'
Mar 22 13:38:23 hdvdr epgd: Starting cleanup of events
Mar 22 13:38:23 hdvdr epgd: Delete fileref [substr(name,1,8) <= '20150321']
Mar 22 13:38:23 hdvdr epgd: Delete events [starttime+duration < 1427006303]
Mar 22 13:38:23 hdvdr epgd: Cleanup of events finished
Mar 22 13:38:23 hdvdr epgd: EPG Update started
Mar 22 13:38:23 hdvdr epgd: EPG Update finished, loaded 0 files (0.000 KB), 0 non-updates skipped, 0 rejected due to format error.
Mar 22 13:38:23 hdvdr epgd: Starting episode download ...
Mar 22 13:38:24 hdvdr epgd: SVDRPCL: connected to eplists.constabel.net:2006 'eplists.constabel.net EpisodesListsServer 0.0.5-beta6; Sun Mar 22 13:38:24 2015'
Mar 22 13:38:24 hdvdr epgd: Got 'Setting encoding to utf8'
Mar 22 13:38:24 hdvdr epgd: Requesting episode changes of last 103 minutes
Mar 22 13:38:24 hdvdr epgd: Received 0 episode files
Mar 22 13:38:24 hdvdr epgd: Starting episode lookup ...
Mar 22 13:38:24 hdvdr epgd: Lookup done for 1334 series, matched 0 parts by compare and 0 parts by lv in 0 seconds; Updated 0
Mar 22 13:38:24 hdvdr epgd: Calling 'mergeepg'
Mar 22 13:38:24 hdvdr epgd: Statement 'call mergeepg' with (0) in parameters and (0) out bindings prepared
Mar 22 13:38:24 hdvdr epgd: 'mergeepg' suceeded
Mar 22 13:38:24 hdvdr epgd: State now 'busy (images)'
Mar 22 13:38:24 hdvdr epgd: Starting cleanup of imagerefs
Mar 22 13:38:24 hdvdr epgd: Starting cleanup of images
Mar 22 13:38:24 hdvdr epgd: Image cleanup finished
Mar 22 13:38:24 hdvdr epgd: Start download of new images
Mar 22 13:38:24 hdvdr epgd: Statement 'select imagename, source, fileref from imagerefs where lfn < ? group by imagename' with (1) in parameters and (3) out bindings prepared
Mar 22 13:38:24 hdvdr epgd: Loaded 0 images (0.000 KB), checked 0; 0 failed to load in 0 seconds
Mar 22 13:38:24 hdvdr epgd: State now 'busy (scraping)'
Mar 22 13:38:35 hdvdr epgd: Starting tvscraper scrap process
Mar 22 13:38:35 hdvdr epgd: Scraping new series and episodes
Mar 22 13:38:35 hdvdr epgd: Statement 'select series_last_scraped from series' with (0) in parameters and (1) out bindings prepared
Mar 22 13:38:35 hdvdr epgd: Update of series and episodes done in 0 s, downloaded 0.000 KB
Mar 22 13:38:35 hdvdr epgd: Statement 'select eventid, title, scrsp, season, part, number, shorttext from thetvdbview ' with (0) in parameters and (7) out bindings prepared
Mar 22 13:38:35 hdvdr epgd: 0 new series events to scrap in db
Mar 22 13:38:35 hdvdr epgd: 0 series episodes scraped in 0 s, downloaded 0.000 KB
Mar 22 13:38:35 hdvdr epgd: Scraping new movies
Mar 22 13:38:35 hdvdr epgd: Statement 'select eventid, title, scrsp from events where  category = 'Spielfilm' and scrsp is null and updflg in('A','T','C','P')' with (0) in parameters and (3) out bindings prepared
Mar 22 13:38:35 hdvdr epgd: 0 new movies to scrap in db
Mar 22 13:38:35 hdvdr epgd: 0 movies scraped in 0 s, downloaded 0.000 KB
Mar 22 13:38:35 hdvdr epgd: cleaning up series...
Mar 22 13:38:35 hdvdr epgd: Statement 'select distinct scrseriesid from events where  scrseriesid is not null  and scrseriesid > 0 ' with (0) in parameters and (1) out bindings prepared
Mar 22 13:38:35 hdvdr epgd: Statement 'select distinct series_id from recordings where  series_id is not null  and series_id > 0 ' with (0) in parameters and (1) out bindings prepared
Mar 22 13:38:35 hdvdr epgd: Statement 'select series_id from series where  series_id is not null  and series_id > 0 ' with (0) in parameters and (1) out bindings prepared
Mar 22 13:38:35 hdvdr epgd: 0 outdated series deleted
Mar 22 13:38:35 hdvdr epgd: cleaning up movies...
Mar 22 13:38:35 hdvdr epgd: Statement 'select distinct scrmovieid from events where  scrmovieid is not null  and scrmovieid > 0 ' with (0) in parameters and (1) out bindings prepared
Mar 22 13:38:35 hdvdr epgd: Statement 'select distinct movie_id from recordings where  movie_id is not null  and movie_id > 0 ' with (0) in parameters and (1) out bindings prepared
Mar 22 13:38:35 hdvdr epgd: Statement 'select movie_id from movie where  movie_id is not null  and movie_id > 0 ' with (0) in parameters and (1) out bindings prepared
Mar 22 13:38:35 hdvdr epgd: 0 outdated movies deleted
Mar 22 13:38:35 hdvdr epgd: Scheduled next update in 12 hour(s)
Mar 22 13:38:35 hdvdr epgd: State now 'standby'

Alles anzeigen

TheChief · 22. März 2015

Das Problem steht doch im Log:

Code

Mar 22 13:38:13 hdvdr epgd: Error reading '/etc/epgd/channelmap.conf' No such file or directory!

Wenns keine channelmap gibt oder die Rechte nicht stimmen, funktionierts halt nicht.

Komischerweise war die vorhin noch da:

Code

Mar 22 12:57:16 hdvdr epgd: Loading '/etc/epgd/channelmap.conf'
Mar 22 12:57:16 hdvdr epgd: 170 channel mappings read.

thorsten.gehrig · 22. März 2015

Hm - die war vorhin verlinken zu einer channelmap für TVM - die ist ist jetzt weg da ich auf die ungepatchte epgdata version umgestellt habe.
mal schauen - jetzt holt er erstmal einiges....

Code

oot@hdvdr:~# epgd-showmerge 
mysql: Unknown OS character set 'ISO-8859-15'.
mysql: Switching to the default character set 'latin1'.
+---------------+---------+
| count(source) | source  |
+---------------+---------+
|         42601 | epgdata |
+---------------+---------+

Und ein bisschen EPG wird mir auch schon angezeigt.
Ich denke die channelsmap hole ich mir nochmal aus dem GIT (die jetzige kommt aus dem yaVDR respository)

Danke erstmal... meine Laune wird besser

TheChief · 22. März 2015

Irgendwo im Forum hatte vor kurzem jemand eine aktuelle channelmap für epgdata gepostet.

Problem mit epgd / mysql

Jetzt mitmachen!

Teilen

Benutzer online in diesem Thema