epgd: Funktioniert nur für wenige Programme

henfri · 5. Mai 2015

Hallo,

ich nutze epgd (epgd version 0.2.2 from 01.02.2015) mit tvm.diff.
Eigentlich denke ich, alles korrekt eingerichtet zu haben. Ein kleiner Test:

Code

syslog nach epg gefiltert:
May  5 21:32:05 homeserver vdr: [11971] epg data writer thread started (pid=19901, tid=11971, prio=low)
May  5 21:32:05 homeserver vdr: [11971] epg data writer thread ended (pid=19901, tid=11971)

Code

root@homeserver:/etc/epgd# epgd-tool -check-events
--------------
SELECT count(1),source FROM events group by source
--------------


count(1)        source
108942  tvm
172095  vdr
root@homeserver:/etc/epgd# sudo epgd-tool -check-pic
--------------
SELECT count(1) FROM images WHERE image IS NOT NULL
--------------


count(1)
8555

Alles anzeigen

EPG2VDR Plugin ist installiert (vdr-epg-daemon-0.2.2.git20150223.1049).

Code

grep -i epg /var/lib/vdr/setup.conf
EPGBugfixLevel = 3
EPGLanguages =
EPGLinger = 0
EPGScanTimeout = 0
epg2vdr.ActiveOnEpgd = 1
epg2vdr.Blacklist = 0
epg2vdr.DbHost = localhost
epg2vdr.DbName = epg2vdr
epg2vdr.DbPass = epg
epg2vdr.DbPort = 3306
epg2vdr.DbUser = epg2vdr
epg2vdr.LoadImages = 1
epg2vdr.LogLevel = 2
epg2vdr.MasterMode = 0
epg2vdr.ScheduleBoot = 0
epg2vdr.ShowInMainMenu = 1

Alles anzeigen

Allerdings haben nur wenige Sender einen EPG im VDR:
Radio Bremen, SR-Fernsehen, B5 aktuell, B5 plus, Bayern 1-3, ...
Die könnten auch alle auf einigen, wenigen Transpondern liegen und er epg könnte noch über DVB kommen.

Weder ein 'update' noch ein 'neu laden' im EPG2VDR Menü helfen.

Wie kann ich den Fehler weiter eingrenzen? Hat jemand einen Verdacht für mich?
(anbei noch meine Konfigurationsdateien)

Gruß,
Hendrik

CKone · 6. Mai 2015

~~also zuerst fällt mal auf das du keine channelmap.conf in deinem Ordner abgelegt hast. Das geht aber nicht einher mit den Events die du in deiner DB hast.~~
sorry, hab nicht richtig geschaut.

Was sagt das log des epg2vdr plugin beim reload, connected sich das korrekt auf die DB?

Denke die Events kommen tatsächlich aus dem VDR und nicht aus der DB, die gehen durch Blacklist = 0 an der DB vorbei.

Christian

henfri · 6. Mai 2015

Hallo Christian,

vielen Dank für deine Antwort.
Beim Reload findet sich im log:

Code

May  6 17:42:02 homeserver vdr: [30825] epg data writer thread started (pid=19901, tid=30825, prio=low)
May  6 17:42:02 homeserver vdr: [30825] epg data writer thread ended (pid=19901, tid=30825)
May  6 17:42:26 homeserver vdr: [19901] info: EPG komplett neu einlesen
May  6 17:42:28 homeserver vdr: epg2vdr: --- EPG reload started ---
May  6 17:42:28 homeserver vdr: epg2vdr: Starting cleanup of images in '/var/cache/vdr/epgimages'
May  6 17:42:29 homeserver vdr: epg2vdr: Statement 'select fileref from imagerefs where imagename = ?' with (1) in parameters and (1) out bindings prepared
May  6 17:42:30 homeserver vdr: epg2vdr: Remove all symlinks
May  6 17:43:03 homeserver vdr: epg2vdr: Cleanup finished, removed (0) images and (45594) symlinks
May  6 17:43:03 homeserver vdr: epg2vdr: Removing all events from epg
May  6 17:43:03 homeserver vdr: epg2vdr: Update EPG, reloading all events
May  6 17:43:07 homeserver vdr: epg2vdr: Processed channel 'S19.2E-1-1055-5503' - 'Deluxe Music HD' with 42 updates
May  6 17:43:09 homeserver vdr: epg2vdr: Processed channel 'S19.2E-1-1066-28654' - 'MTV Hits' with 200 updates
May  6 17:43:09 homeserver vdr: epg2vdr: Processed channel 'S19.2E-1-1066-28656' - 'VH1' with 49 updates
May  6 17:43:09 homeserver vdr: epg2vdr: Processed channel 'S19.2E-1-1066-28659' - 'MTV ROCKS' with 49 updates
May  6 17:43:10 homeserver vdr: epg2vdr: Processed channel 'S19.2E-1-1068-28601' - 'MTV Live HD OBSOLETE' with 293 updates
May  6 17:43:19 homeserver vdr: epg2vdr: Processed channel 'S19.2E-1-1093-28486' - 'SR Fernsehen' with 2961 updates
May  6 17:43:19 homeserver vdr: epg2vdr: Processed channel 'S19.2E-1-1115-13103' - 'Welt der Wunder' with 102 updates
May  6 17:43:19 homeserver vdr: epg2vdr: Processed channel 'S19.2E-133-1-342' - '' with 0 updates
May  6 17:43:19 homeserver vdr: epg2vdr: Processed channel 'S19.2E-133-1-352' - 'FCA - HSV OBSOLETE' with 0 updates
May  6 17:43:19 homeserver vdr: epg2vdr: Processed channel 'S19.2E-133-1-363' - 'Sky Racer OBSOLETE' with 0 updates
May  6 17:43:19 homeserver vdr: epg2vdr: Processed channel 'S19.2E-133-1-373' - 'Spieldaten OBSOLETE' with 0 updates
May  6 17:43:19 homeserver vdr: epg2vdr: Processed channel 'S19.2E-133-10-102' - 'Sky HD FanZone' with 10 updates
May  6 17:43:21 homeserver vdr: epg2vdr: Processed channel 'S19.2E-133-10-125' - 'AXN HD' with 120 updates
May  6 17:43:21 homeserver vdr: epg2vdr: Processed channel 'S19.2E-133-10-307' - 'Sky Bundesliga HD 6' with 5 updates
...
May  6 17:46:07 homeserver vdr: epg2vdr: Processed channel 'S19.2E-1-1011-11110' - 'ZDF HD' with 634 updates
May  6 17:46:08 homeserver vdr: epg2vdr: Processed channel 'S19.2E-1-1079-28006' - 'ZDF' with 535 updates
...
May  6 17:54:35 homeserver vdr: epg2vdr: Updated all 312 channels, 116891 events (0 deletions) in 692.408 seconds
May  6 17:54:35 homeserver vdr: [8164] epg data writer thread started (pid=19901, tid=8164, prio=low)
May  6 17:54:36 homeserver vdr: [8164] epg data writer thread ended (pid=19901, tid=8164)
May  6 17:54:36 homeserver vdr: epg2vdr: Load images from database
May  6 17:58:00 homeserver vdr: [19541] EPGSearch: search timer update started
May  6 17:58:00 homeserver vdr: [19932] EPGSearch: timer conflict check started
May  6 17:58:01 homeserver vdr: [19932] EPGSearch: timer conflict check finished
May  6 17:58:01 homeserver vdr: [19541] EPGSearch: search timer update finished
May  6 18:02:45 homeserver vdr: epg2vdr: Got 0 images from database in 490 seconds (0 updates, 0 new)
May  6 18:02:45 homeserver vdr: epg2vdr: --- EPG reload finished ---
May  6 18:04:36 homeserver vdr: [15815] epg data writer thread started (pid=19901, tid=15815, prio=low)
May  6 18:04:36 homeserver vdr: [15815] epg data writer thread ended (pid=19901, tid=15815)

Alles anzeigen

Das sieht doch alles gut aus, oder?

Gruß,
Hendrik

schneisa · 6. Mai 2015

Mir fehlt da das Updaten der Daten von tvm.

Kannst du epgd mal neu starten. Da muss was von tvm auftauchen.

Viele Grüße
schneisa

louis · 6. Mai 2015

Zitat von schneisa

Mir fehlt da das Updaten der Daten von tvm.

Das taucht im epgd log auf, epg2vdr ist es egal woher die Daten kommen Das "epgd-tool -check-events" aus dem ersten Posting zeigt ja auch, dass die Quelle korrekt geladen wurde.

henfri: hast du mal deine epg.data bei gestopptem VDR komplett gelöscht? Das wäre das einzige, das mir noch einfällt...

Ciao Louis

louis · 6. Mai 2015

PS: die "ganz sichere" Vorgehensweise ist eigentlich die folgende:

- VDR der auf epgd zugreift stoppen
- epg.data im entsprechenden Verzeichnis löschen
- epgd stoppen
- "epg2vdr" Datenbank komplett droppen
- epgd starten und warten, bis die Daten vom externen Provider initial eingelesen sind (Log beobachten)
- vdr starten und ein bisschen rumzappen

So hat das bei mir bei meinen diversen Neueinrichtungen eigentlich immer geklappt.

Ciao Louis

henfri · 6. Mai 2015

Hallo,

danke für eure Tipps.

Code

stop vdr
/etc/init.d/epgd stop
epgd-dropall
---------------------
-- Drop all tables --
-- (except images) --
---------------------
Are you sure? [y/N] y
Tables droped!
---------------------
-- Drop procedures --
---------------------
Are you sure? [y/N] y
-------------------
--  Drop images  --
-------------------
In most cases you dont need to drop the image table.
Drop image tables? [y/N] y
Table images droped!
 rm /var/cache/vdr/epg.data


epgd-tool -drop-all


Clean the complete epg2vdr Database?


Are You sure? [yes/no]: y


--------------
DROP TABLE events
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'events'
--------------
DROP TABLE fileref
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'fileref'
--------------
DROP TABLE images
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'images'
--------------
DROP TABLE imagerefs
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'imagerefs'
--------------
DROP TABLE channelmap
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'channelmap'
--------------
DROP TABLE episodes
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'episodes'
--------------
DROP TABLE vdrs
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'vdrs'
--------------
DROP TABLE components
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'components'
--------------
DROP TABLE parameters
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'parameters'
--------------
DROP TABLE analyse
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'analyse'
--------------
DROP TABLE snapshot
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'snapshot'
--------------
DROP VIEW eventsview
--------------


ERROR 1051 (42S02) at line 1: Unknown table 'eventsview'
--------------
DROP PROCEDURE reverseepg
--------------


ERROR 1305 (42000) at line 1: PROCEDURE epg2vdr.reverseepg does not exist
--------------
DROP PROCEDURE mergeepg
--------------


ERROR 1305 (42000) at line 1: PROCEDURE epg2vdr.mergeepg does not exist
--------------
DROP FUNKTION getupdflg
--------------


ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FUNKTION getupdflg' at line 1
--------------
DROP FUNKTION getcrosslvr
--------------


ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FUNKTION getcrosslvr' at line 1
--------------
DROP FUNKTION getlvrmin
--------------


ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FUNKTION getlvrmin' at line 1


Delete all EPG Pictures from epg2vdr Database?


Are You sure? [yes/no]: y


--------------
DROP TABLE images
--------------

Alles anzeigen

Jetzt gab es beim letzten Kommando ja einige fehler. Liegt das an dem vorherigen epgd-dropall?

Wie sollte ich die Datenbank am Besten löschen&neu erzeugen?

Gruß,
Hendrik

louis · 6. Mai 2015

Zitat von henfri

Jetzt gab es beim letzten Kommando ja einige fehler. Liegt das an dem vorherigen epgd-dropall?

Jo, das war doppelt gemoppelt...du hattest ja schon alle Tabellen gelöscht.

Zitat von henfri

Wie sollte ich die Datenbank am Besten löschen&neu erzeugen?

Einfach den epgd neu starten. Der legt dann alle Tabellen automatisch an. Mit einem

Code

tail -f /var/log/messages | grep epgd

siehst du das auch alles

Ciao Louis

CKone · 7. Mai 2015

Und deine Empfangsart ist astra 19.2, nicht das du irgend ne channelmap eingeworfen hast du gar nicht zu deiner channels.conf passt?

Weil nen epgdata account hast du ja auch nicht, obwohl alle Kanäle konfiguriert sind.

Christian

henfri · 7. Mai 2015

Hallo,

ja, ich nutze Astra 19.2. Ich bin nicht sicher, woher die EPGData-Konfiguration kommt. Es ist sehr lange her, dass ich epgd ursprünglich konfiguriert habe.
Ich habe jetzt gerade mal den syslog durchsucht. Da fällt schon einiges auf:

Code

May  4 22:25:39 homeserver kernel: [1936650.152255] epgd[28137]: segfault at 8 ip 000000000043cd0c sp 00007fff2164d9b0 error 4 in epgd[400000+8f000]

Das ist aber schon etwas her...

Code

May  6 07:58:17 homeserver logger: Starting epgdata2vdr
May  6 22:24:03 homeserver epgd: Set locale to 'de_DE.UTF-8'
May  6 22:24:03 homeserver epgd: detected UTF-8
May  6 22:24:03 homeserver epgd: Loading uuid from '/etc/epgd/uuid' succeeded [C41CACF2-A85D-4FE5-8197-6E43EEB1FB59]
May  6 22:24:03 homeserver epgd: Error: Opening plugin directory '/root/epgd/vdr-epg-daemon-0.2.2.git20150223.1049/debian/tmp/usr/lib/epgd/plugins' failed, No such file
 or directory

Das ist schon sehr komisch... An dem Ort wurde epgd (von dpkg-buildpackage) kompiliert. Aber warum meint EPGD dass dies das "plugin directory" ist?

Code

May  6 22:24:03 homeserver epgd: Read 26 option from /etc/epgd/epgd.conf
May  6 22:24:04 homeserver epgd: SQL client character now 'utf8'
May  6 22:24:04 homeserver epgd: Initialy creating table 'vdrs'
May  6 22:24:04 homeserver epgd: create table vdrs(uuid VARCHAR(40), inssp INT(11), updsp INT(11), name VARCHAR(100), version VARCHAR(100), dbapi INT(11) unsigned, last
upd INT(11), nextupd INT(11), state VARCHAR(20), master VARCHAR(1), ip VARCHAR(20), PRIMARY KEY(uuid DESC)) ENGINE InnoDB;
May  6 22:24:04 homeserver epgd: create index idxstate on vdrs(state);
May  6 22:24:05 homeserver 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
May  6 22:24:05 homeserver 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
May  6 22:24:05 homeserver epgd: Statement 'update vdrs set updsp = ?, name = ?, version = ?, dbapi = ?, lastupd = ?, nextupd = ?, state = ?, master = ?, ip = ? where u
uid = ?;' with (10) in parameters and (0) out bindings prepared
May  6 22:24:05 homeserver epgd: State now 'init'
May  6 22:24:05 homeserver epgd: Initialy creating table 'channelmap'
May  6 22:24:05 homeserver epgd: create table channelmap(extid VARCHAR(10), channelid VARCHAR(50), source VARCHAR(20), channelname VARCHAR(100), vps INT(11), merge INT(
11), mergesp INT(11), inssp INT(11), updsp INT(11), updflg VARCHAR(1), PRIMARY KEY(extid DESC, channelid DESC, source DESC)) ENGINE InnoDB;
May  6 22:24:05 homeserver epgd: create index idxsourceExtid on channelmap(source, extid);
May  6 22:24:06 homeserver epgd: create index idxsource on channelmap(source);
May  6 22:24:06 homeserver epgd: create index idxupdflg on channelmap(updflg);
May  6 22:24:07 homeserver epgd: create index idxsourcechannelid on channelmap(source, channelid);
May  6 22:24:07 homeserver epgd: create index idxmergesp on channelmap(mergesp);
May  6 22:24:08 homeserver epgd: create index idxchannelid on channelmap(channelid);
May  6 22:24:08 homeserver 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
May  6 22:24:08 homeserver 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
May  6 22:24:08 homeserver 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
May  6 22:24:08 homeserver epgd: Initialy creating table 'fileref'
May  6 22:24:08 homeserver epgd: create table fileref(name VARCHAR(100), source VARCHAR(10), inssp INT(11), updsp INT(11), extid VARCHAR(10), fileref VARCHAR(100), tag
VARCHAR(100), PRIMARY KEY(name DESC, source DESC)) ENGINE InnoDB;
May  6 22:24:08 homeserver epgd: create index idxSourceFileref on fileref(source, fileref);
May  6 22:24:09 homeserver epgd: create index idxFileref on fileref(fileref);
May  6 22:24:09 homeserver epgd: Statement 'select name, source, inssp, updsp, extid, fileref, tag from fileref where name = ? and source = ?;' with (2) in parameters a
nd (7) out bindings prepared
May  6 22:24:09 homeserver epgd: Statement 'insert into fileref set name = ?, source = ?, inssp = ?, updsp = ?, extid = ?, fileref = ?, tag = ?;' with (7) in parameters
 and (0) out bindings prepared
May  6 22:24:09 homeserver epgd: Statement 'update fileref set updsp = ?, extid = ?, fileref = ?, tag = ? where name = ? and source = ?;' with (6) in parameters and (0)
 out bindings prepared
May  6 22:24:09 homeserver epgd: Initialy creating table 'images'
May  6 22:24:09 homeserver epgd: create table images(imagename VARCHAR(100), inssp INT(11), updsp INT(11), image MEDIUMBLOB, PRIMARY KEY(imagename DESC)) ENGINE InnoDB;
May  6 22:24:10 homeserver epgd: Statement 'select imagename, inssp, updsp, image from images where imagename = ?;' with (1) in parameters and (4) out bindings prepared
May  6 22:24:10 homeserver epgd: Statement 'insert into images set imagename = ?, inssp = ?, updsp = ?, image = ?;' with (4) in parameters and (0) out bindings prepared
May  6 22:24:10 homeserver epgd: Statement 'update images set updsp = ?, image = ? where imagename = ?;' with (3) in parameters and (0) out bindings prepared
May  6 22:24:10 homeserver epgd: Initialy creating table 'imagerefs'
May  6 22:24:10 homeserver epgd: create table imagerefs(eventid INT(11) unsigned, lfn INT(11), inssp INT(11), updsp INT(11), source VARCHAR(10), fileref VARCHAR(100), i
magename VARCHAR(100), PRIMARY KEY(eventid DESC, lfn DESC)) ENGINE InnoDB;
May  6 22:24:11 homeserver epgd: create index idxlfn on imagerefs(lfn);
May  6 22:24:11 homeserver epgd: create index idxname on imagerefs(imagename);
May  6 22:24:12 homeserver epgd: Statement 'select eventid, lfn, inssp, updsp, source, fileref, imagename from imagerefs where eventid = ? and lfn = ?;' with (2) in par
ameters and (7) out bindings prepared
May  6 22:24:12 homeserver epgd: Statement 'insert into imagerefs set eventid = ?, lfn = ?, inssp = ?, updsp = ?, source = ?, fileref = ?, imagename = ?;' with (7) in p
arameters and (0) out bindings prepared
May  6 22:24:12 homeserver epgd: Statement 'update imagerefs set updsp = ?, source = ?, fileref = ?, imagename = ? where eventid = ? and lfn = ?;' with (6) in parameter
s and (0) out bindings prepared
May  6 22:24:12 homeserver epgd: Initialy creating table 'episodes'
May  6 22:24:12 homeserver epgd: create table episodes(compname VARCHAR(100), comppartname VARCHAR(200), lang VARCHAR(10), inssp INT(11), updsp INT(11), link INT(11), s
hortname VARCHAR(100), episodename VARCHAR(100), partname VARCHAR(300), season INT(11), part INT(11), parts INT(11), number INT(11), extracol1 VARCHAR(250), extracol2 V
ARCHAR(250), extracol3 VARCHAR(250), comment VARCHAR(250), PRIMARY KEY(compname DESC, comppartname DESC, lang DESC)) ENGINE InnoDB;
May  6 22:24:12 homeserver epgd: create index idxupdsp on episodes(updsp);
May  6 22:24:13 homeserver epgd: Statement 'select compname, comppartname, lang, inssp, updsp, link, shortname, episodename, partname, season, part, parts, number, extr
acol1, extracol2, extracol3, comment from episodes where compname = ? and comppartname = ? and lang = ?;' with (3) in parameters and (17) out bindings prepared
May  6 22:24:13 homeserver epgd: Statement 'insert into episodes set compname = ?, comppartname = ?, lang = ?, inssp = ?, updsp = ?, link = ?, shortname = ?, episodenam
e = ?, partname = ?, season = ?, part = ?, parts = ?, number = ?, extracol1 = ?, extracol2 = ?, extracol3 = ?, comment = ?;' with (17) in parameters and (0) out binding
s prepared
May  6 22:24:13 homeserver epgd: Statement 'update episodes set updsp = ?, link = ?, shortname = ?, episodename = ?, partname = ?, season = ?, part = ?, parts = ?, numb
er = ?, extracol1 = ?, extracol2 = ?, extracol3 = ?, comment = ? where compname = ? and comppartname = ? and lang = ?;' with (16) in parameters and (0) out bindings pre
pared
May  6 22:24:13 homeserver epgd: Initialy creating table 'events'
May  6 22:24:13 homeserver epgd: create table events(eventid INT(11) unsigned, channelid VARCHAR(50), masterid INT(11) unsigned not null auto_increment, useid INT(11) u
nsigned, source VARCHAR(10), fileref VARCHAR(50), inssp INT(10), updsp INT(10), updflg VARCHAR(1), delflg VARCHAR(1), tableid INT(2), version INT(3), title VARCHAR(200)
, comptitle VARCHAR(200), shorttext VARCHAR(300), compshorttext VARCHAR(300), longdescription TEXT(25000), starttime INT(10), duration INT(5), parentalrating INT(2), vp
s INT(10), shortdescription VARCHAR(3000), actor VARCHAR(3000), audio VARCHAR(50), category VARCHAR(50), country VARCHAR(50), director VARCHAR(250), flags VARCHAR(100),
 genre VARCHAR(100), info TEXT(10000), music VARCHAR(250), producer TEXT(1000), screenplay VARCHAR(500), shortreview VARCHAR(500), tipp VARCHAR(250), topic VARCHAR(500)
, year VARCHAR(10), rating VARCHAR(250), fsk VARCHAR(2), movieid VARCHAR(20), moderator VARCHAR(250), other TEXT(2000), guest TEXT(1000), camera TEXT(1000), extepnum IN
T(4), imagecount INT(2), episode VARCHAR(250), episodepart VARCHAR(250), episodelang VARCHAR(3), scrseriesid INT(11), scrseriesepisode INT(11), scrmovieid INT(11), scrs
p INT(11), PRIMARY KEY(eventid DESC, channelid DESC), KEY(masterid DESC)) ENGINE InnoDB;
May  6 22:24:13 homeserver epgd: create index idxcomptitle on events(comptitle);
May  6 22:24:14 homeserver epgd: create index idxsource on events(source);
May  6 22:24:15 homeserver epgd: create index idxfilerefsource on events(fileref, source);
May  6 22:24:17 homeserver epgd: create index idxchannelid on events(channelid);
May  6 22:24:17 homeserver epgd: create index idxuseid on events(useid);
May  6 22:24:18 homeserver epgd: create index idxuseidchannelid on events(useid, channelid);
May  6 22:24:19 homeserver epgd: create index idxupdflgupdsp on events(updflg, updsp);
May  6 22:24:20 homeserver epgd: create index idxsourcechannelid on events(source, channelid);
May  6 22:24:20 homeserver epgd: create index idxscrsp on events(scrsp);
May  6 22:24:21 homeserver epgd: create index idxsourceupdsp on events(source, updsp);
May  6 22:24:22 homeserver epgd: create index idxscrseriesid on events(scrseriesid);
May  6 22:24:22 homeserver epgd: Statement 'select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitl
e, 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, episode
lang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;' with (2) in parameters and (53) out bindings prepared
May  6 22:24:22 homeserver epgd: Statement 'insert into events set eventid = ?, channelid = ?, useid = ?, source = ?, fileref = ?, inssp = ?, updsp = ?, updflg = ?, del
flg = ?, tableid = ?, version = ?, title = ?, comptitle = ?, shorttext = ?, compshorttext = ?, longdescription = ?, starttime = ?, duration = ?, parentalrating = ?, vps
 = ?, shortdescription = ?, actor = ?, audio = ?, category = ?, country = ?, director = ?, flags = ?, genre = ?, info = ?, music = ?, producer = ?, screenplay = ?, shor
treview = ?, 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
May  6 22:24:22 homeserver 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 = ?, scrserie
sid = ?, scrseriesepisode = ?, scrmovieid = ?, scrsp = ? where eventid = ? and channelid = ?;' with (51) in parameters and (0) out bindings prepared
May  6 22:24:22 homeserver epgd: Initialy creating table 'components'
May  6 22:24:22 homeserver epgd: create table components(eventid INT(11) unsigned, channelid VARCHAR(50), stream INT(3), type INT(3), lang VARCHAR(8), description VARCH
AR(100), inssp INT(11), updsp INT(11), PRIMARY KEY(eventid DESC, channelid DESC, stream DESC, type DESC, lang DESC, description DESC)) ENGINE InnoDB;
May  6 22:24:23 homeserver 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
May  6 22:24:23 homeserver epgd: Statement 'insert into components set eventid = ?, channelid = ?, stream = ?, type = ?, lang = ?, description = ?, inssp = ?, updsp = ?
;' with (8) in parameters and (0) out bindings prepared
May  6 22:24:23 homeserver 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
May  6 22:24:23 homeserver epgd: Initialy creating table 'parameters'
May  6 22:24:23 homeserver epgd: create table parameters(owner VARCHAR(40), name VARCHAR(40), inssp INT(11), updsp INT(11), value VARCHAR(100), PRIMARY KEY(owner DESC,
name DESC)) ENGINE InnoDB;
May  6 22:24:23 homeserver epgd: Statement 'select owner, name, inssp, updsp, value from parameters where owner = ? and name = ?;' with (2) in parameters and (5) out bi
ndings prepared
May  6 22:24:23 homeserver epgd: Statement 'insert into parameters set owner = ?, name = ?, inssp = ?, updsp = ?, value = ?;' with (5) in parameters and (0) out binding
s prepared
May  6 22:24:23 homeserver epgd: Statement 'update parameters set updsp = ?, value = ? where owner = ? and name = ?;' with (4) in parameters and (0) out bindings prepar
ed
May  6 22:24:26 homeserver epgd: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'scrsp' in 'field list' (1054) 'Unknown column 'scrsp' in 'field list'' [select u
uid, 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 = ?;]
May  6 22:24:26 homeserver kernel: [2109314.164732] epgd[19035]: segfault at 8 ip 000000000043cd0c sp 00007fff65c69f20 error 4 in epgd[400000+8f000]
May  7 08:07:50 homeserver logger: Starting epgdata2vdr

Alles anzeigen

Das sieht auch erstmal gut aus, soweit ich das verstehe. Doch dann gibt es wieder einen segfault.

Wenn ich nach Segfault suche, dann findet sich:

Code

May  4 22:04:52 homeserver kernel: [1935403.031389] epgd[5744]: segfault at 8 ip 000000000043cd0c sp 00007fff567704a0 error 4 in epgd[400000+8f000]
May  4 22:09:11 homeserver kernel: [1935661.968533] epgd[15205]: segfault at 8 ip 000000000043cd0c sp 00007fffd98323a0 error 4 in epgd[400000+8f000]
May  4 22:09:57 homeserver kernel: [1935708.243514] epgd[15719]: segfault at 8 ip 000000000043cd0c sp 00007fff11916fd0 error 4 in epgd[400000+8f000]
May  4 22:23:16 homeserver kernel: [1936506.631551] epgd[26129]: segfault at 8 ip 000000000043cd0c sp 00007fff42e94240 error 4 in epgd[400000+8f000]
May  4 22:24:05 homeserver kernel: [1936556.110204] epgd[26666]: segfault at 8 ip 000000000043cd0c sp 00007fff447dea60 error 4 in epgd[400000+8f000]
May  4 22:25:39 homeserver kernel: [1936650.152255] epgd[28137]: segfault at 8 ip 000000000043cd0c sp 00007fff2164d9b0 error 4 in epgd[400000+8f000]
May  6 22:24:26 homeserver kernel: [2109314.164732] epgd[19035]: segfault at 8 ip 000000000043cd0c sp 00007fff65c69f20 error 4 in epgd[400000+8f000]

Das bedeutet, dass ich seitdem ich epgd neu kompiliert habe (ich wollte sicher gehen nicht einen schon gefixten Bug zu suchen), segfaults habe. Das ist aber wohl nicht das eigentliche Problem denn mit der vorherigen Installation von epgd hatte ich keine Segfaults (wären im log) und dennoch war der EPG leer.

Gebaut habe ich den EPGD nach dieser Anleitung unter Ubuntu 14.04: [HowTow] Installation epgd auf Ubuntu 12.04 LTS - kommentiertes Install-Log/Schritt-fuer-Schritt

Gruß,
Hendrik

henfri · 11. Mai 2015

Hallo Louis, hallo Christian,

habt ihr noch eine Idee, was ich noch machen kann?

Gruß,
Hendrik

CKone · 11. Mai 2015

wenn du mir mal Zugriff auf port 22 und 3306 geben könntest würde ich mir das in den nächsten Tagen mal ansehen, der vdr läuft auf nem anderen Host - auf den dann gfs auch?

Christian

henfri · 17. Mai 2015

Hallo Christian,

vielen Dank für dein Angebot.
Aber es läuft jetzt. Ich habe die DB noch einmal gelöscht, alle Konfigurationsdateien auch. Dann habe ich neu gestartet. Jetzt läuft es.
Leider kann ich nicht mehr sagen, woran es lag.

Gruß,
Hendrik

epgd: Funktioniert nur für wenige Programme

Jetzt mitmachen!

Teilen