[mythtv-users] Duplicate detection not working for some recordings

[Philipp Hahn]

Hello Peter,

Am 10.01.21 um 18:11 schrieb Peter Bennett:
> On 1/10/21 11:58 AM, Philipp Hahn wrote:
>> I'm trying to understand why MythTV plans to re-record an episode I 
>> still have.
>>
>> I've read <https://www.mythtv.org/wiki/Duplicate_matching> but I 
>> cannot figure it out myself. (I live in Germany and I'm using 
>> 'tv_grab_eu_epgdata' as my listing provider, so no "programid"):
>>
>>
>> This is my recording rule, which should record every showing, but 
>> skips duplicates based on "subtitle" only:
>>
>>> MariaDB [mythconverg]> SELECT * FROM record WHERE title='Hawaii Five-0';
...
>> That episode is aired again the following week:
>>
>>> MariaDB [mythconverg]> SELECT * FROM program WHERE title='Hawaii 
>>> Five-0' AND subtitle='Der Passagier auf 4C';
...
>> And the earliest showing is scheduled for recording:
>>
>>> MariaDB [mythconverg]> SELECT * FROM oldrecorded WHERE title='Hawaii 
>>> Five-0' AND subtitle='Der Passagier auf 4C';
...
>> But I already have this episode recorded:
>>
>>> MariaDB [mythconverg]> SELECT * FROM recorded WHERE title='Hawaii 
>>> Five-0' AND subtitle='Der Passagier auf 4C';
>>> +--------+---------------------+---------------------+---------------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------+----------+----------+---------+---------+------------+-------------+----------+----------+-----------+-----------+-----------------+---------------------+------------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+--------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+---------------------+------------+------------+-----------+ 
>>>
>>> | chanid | starttime           | endtime             | title | 
>>> subtitle             | description | season | episode | category | 
>>> hostname | bookmark | editing | cutlist | autoexpire | commflagged | 
>>> recgroup | recordid | seriesid  | programid | inetref         | 
>>> lastmodified        | filesize   | stars | previouslyshown | 
>>> originalairdate | preserve | findid | deletepending | transcoder | 
>>> timestretch | recpriority | basename                 | 
>>> progstart           | progend             | playgroup | profile | 
>>> duplicate | transcoded | watched | storagegroup | bookmarkupdate | 
>>> recgroupid | recordedid | inputname |
>>> +--------+---------------------+---------------------+---------------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------+----------+----------+---------+---------+------------+-------------+----------+----------+-----------+-----------+-----------------+---------------------+------------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+--------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+---------------------+------------+------------+-----------+ 
>>>
>>> |  55626 | 2020-02-12 01:38:00 | 2020-02-12 02:20:00 | Hawaii Five-0 
>>> | Der Passagier auf 4C | Dem Exmarineoffizier Steve McGarrett wird 
>>> von der Gouverneurin von Hawaii die Leitung einer Sondereinheit zur 
>>> Bekämpfung des organisierten Verbrechens auf Hawaii übertragen. Dafür 
>>> nimmt er den ehemaligen Polizisten Chin Ho Kelly, den Polizisten 
>>> Danny "Danno" Williams und die junge Polizistin Kona "Kono" Kalakaua 
>>> in sein Team auf.    |     10 |       3 | Action   | barrel |        
>>> 0 |       0 |       0 |          0 |           1 | US Crime |       
>>> 85 | 173914608 |           | ttvdb.py_164541 | 2020-02-13 20:51:57 | 
>>> 1329837461 |     0 |               0 | 2019-01-01 |        0 |      0 
>>> |             0 |          0 |           1 |           0 | 
>>> 55626_20200212013800.m4v | 2020-02-12 01:40:00 | 2020-02-12 02:15:00 
>>> | Default   | Default |         0 |          1 | 0 | Crime        | 
>>> 0000-00-00 00:00:00 |          5 |       4853 | Input 1   |
>>> +--------+---------------------+---------------------+---------------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------+----------+----------+---------+---------+------------+-------------+----------+----------+-----------+-----------+-----------------+---------------------+------------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+--------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+---------------------+------------+------------+-----------+ 
>>>
>>> 1 row in set (0.005 sec)
>>
>>
>> This (currently) if the only episode scheduled for re-recording, but 
>> I've seen this (strange) behavior for other episodes of this and other 
>> series before.
>>
...
>> What am I missing?
>>
...
> The key here is the column "duplicate" in recorded and oldrecorded. 
> duplicate = 0 means record again, 1 means do not. I see that duplicate 
> is 0 in your oldrecorded table, so those will record again. Duplicate 
> can be set to zero because the recording was bad (could be a few seconds 
> or minutes missing), or you if used the "allow rerecord" menu option or 
> "delete and allow rerecord".

Thank you, that was the missing link.

Philipp