Am Dienstag, den 05.05.2009, 11:43 +0200 schrieb Marco Göbenich:
> > Got a problem with the OLDEPG data using two VDR's.
> > While each reads the EPG from it's channels it uses some 32 bit
> > integer as eventid, but this eventid is not unique when using more than
> > one VDR, so in my OLDEPG table are double epgeventid's stored.
> > This results in double displayed recordings, one with the right data and
> > one with the wrong data.
The xxv-eventid are merged by channel-id and vdr-eventid, and should be
unique if data(NID-TID-SID) from channel unique ...
What is the biggest eventid from EPG, i think it's could overlapping
with older recordings id.
mysql> SELECT SQL_CACHE max(eventid) from EPG;
Maybe help the attached patch, it's separating eventid between EPG and
recordings more precisely.
Table OLDEPG should deleted,
#> /etc/init.d/xxvd stop
#> mysql -u root xxv -e "delete from OLDEPG;"
#> /etc/init.d/xxvd start
Andreas
Index: EPG.pm
===================================================================
--- EPG.pm (Revision 1413)
+++ EPG.pm (Arbeitskopie)
@@ -536,6 +536,7 @@
# Make a fix format 0xCCCCEEEE : C-Channelid (high-word), E-Eventid(low-word) => real-eventid = uniqueid & FFFF
my $eventid = (($vid & 0xFF) << 24) | ((($id[-3] + $id[-2] + $id[-1]) & 0x3FFF) << 16) | ($epgid & 0xFFFF);
+ $eventid &= 0x6FFFFFFF; # Keep 0x70000000 .... free for recording events
return $eventid;
}
Index: RECORDS.pm
===================================================================
--- RECORDS.pm (Revision 1413)
+++ RECORDS.pm (Arbeitskopie)
@@ -1680,7 +1680,7 @@
};
$attr->{eventid} = $self->{dbh}->selectrow_arrayref('SELECT SQL_CACHE max(eventid)+1 from OLDEPG')->[0];
- $attr->{eventid} = 1000000000 if(not defined $attr->{eventid} or $attr->{eventid} < 1000000000 );
+ $attr->{eventid} = 0x70000000 if(not defined $attr->{eventid} or $attr->{eventid} < 0x6FFFFFFF );
lg sprintf('Create event "%s" into OLDEPG', $subtitle ? $title .'~'. $subtitle : $title);
_______________________________________________
vdr mailing list
vdr@xxxxxxxxxxx
http://www.linuxtv.org/cgi-bin/mailman/listinfo/vdr
