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

Hika van den Hoven hikavdh at gmail.com
Mon Jan 18 15:24:53 UTC 2021


Hoi Philipp,

Monday, January 18, 2021, 8:27:57 AM, you wrote:

> 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

Another possible thing is that creation op progrogram_id from title is
case sensitive. So even when they use different capitalization, Myth
thinks it another series. Easy to overlook.
I do not think this also goes for recognition of subtitles.


Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens



More information about the mythtv-users mailing list