[mythtv-users] Duplicate recordings showing up?

[Mark Wormgoor]

Hi,

Since a couple of days, my recorded programs is showing some shows
twice. These are entries that I've scheduled manually (i.e. channel x,
day y from xx:xx - xx:xx) and not via the program guide.

I'm running the latest 0.21-fixes from ATrpms:
MythTV Version   : 20441M
MythTV Branch    : branches/release-0-21-fixes
Library API      : 0.21.20080304-1
Network Protocol : 40

I'm recording everything on a slave backend. The master backend does not
have any capture devices.

Both shows listed have the same recording ID. They point to the same
file on disk. I've checked the recorded table, and that only lists the
show once. I've also checked through telnet to the mythbackend:6544
(using QUERY_RECORDINGS Delete - the same command mythweb uses) and that
returns the show twice. I've restarted both backends, but that hasn't
helped.

I've setup a debugging on record,file,database and found that it's 
caused by the following query:
"SELECT 
recorded.chanid,recorded.starttime,recorded.endtime,recorded.title,recorded.subtitle,recorded.description,recorded.hostname,channum,name,callsign,commflagged,cutlist,recorded.autoexpire,editing,bookmark,recorded.category,recorded.recgroup,record.dupin,record.dupmethod,recorded.recordid,channel.outputfilters,recorded.seriesid,recorded.programid,recorded.filesize, 
recorded.lastmodified, recorded.findid, recorded.originalairdate, 
recorded.playgroup, recorded.basename, recorded.progstart, 
recorded.progend, recorded.stars, recordedprogram.audioprop+0, 
recordedprogram.videoprop+0, recordedprogram.subtitletypes+0, 
transcoded, recorded.recpriority, watched, recorded.preserve, 
recorded.storagegroup FROM recorded LEFT JOIN record ON 
recorded.recordid = record.recordid LEFT JOIN channel ON recorded.chanid 
= channel.chanid LEFT JOIN recordedprogram ON  ( recorded.chanid = 
recordedprogram.chanid AND   recorded.progstart = 
recordedprogram.starttime ) WHERE ( recorded.deletepending = 0 OR 
   DATE_ADD(recorded.lastmodified, INTERVAL 5 MINUTE) <= NOW()       ) 
ORDER BY recorded.starttime 
DESC,atsc_major_chan,atsc_minor_chan,channum,callsign"

However, I don't understand how this can return duplicate rows as there 
are only left joins in here, and the show does not appear twice in the 
recorded table. Some further googling turned up this:
http://bugs.mysql.com/bug.php?id=31203
Since Mysql 5.0.12, the above left join syntax is no longer supported.

Kind regards,

Mark Wormgoor