[mythtv-users] Mirobridge failing to update mythtv db entries

R.D. Vaughan rdvandroid at gmail.com
Wed Jun 11 16:37:48 UTC 2014 

I've remembered what was done last time.  Tonight I'll send you some cut and paste python code to test the creation of the record through the MythTV python bindings without mirobridge.  Direct SQL in this case does not show much. 

I'm away from my development machine until tonight.  

Doug 

On June 11, 2014 9:35:20 AM EDT, Daniel Frey <dmfrey at gmail.com> wrote:
>On Wed, Jun 11, 2014 at 8:42 AM, Daniel Frey <dmfrey at gmail.com> wrote:
>
>>
>>
>>
>> On Wed, Jun 11, 2014 at 8:39 AM, Daniel Frey <dmfrey at gmail.com>
>wrote:
>>
>>>
>>>
>>>
>>> On Wed, Jun 11, 2014 at 6:18 AM, R.D. Vaughan <rdvandroid at gmail.com>
>>> wrote:
>>>
>>>> Dan, the lxml version would not be the issue. Right now the mailing
>list
>>>> would be the best bet. Is you get no where with that we'll rework
>the
>>>> problem again.
>>>>
>>>> Sure wish my memory was better. Are you adept with databases? At
>least
>>>> the ability to view their contents?
>>>>
>>>> Doug
>>>>
>>>> On June 10, 2014 9:48:49 PM EDT, Daniel Frey <dmfrey at gmail.com>
>wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Jun 10, 2014 at 7:04 PM, rdvAndroid at gmail.com <
>>>>> rdvandroid at gmail.com> wrote:
>>>>>
>>>>>> On 14-06-10 08:54 AM, Daniel Frey wrote:
>>>>>>
>>>>>>> This only started recently, but after running an update on June
>9th,
>>>>>>> 2014.
>>>>>>>
>>>>>>> Mythbuntu 12.04.4 LTS
>>>>>>> MythTV Version : v0.27.1-14-g2720f45
>>>>>>> MythTV Branch : fixes/0.27
>>>>>>> Network Protocol : 77
>>>>>>> Library API : 0.27.20140520-1
>>>>>>>
>>>>>>> Here is the exception. Â The whole log is attached.
>>>>>>>
>>>>>>>
>>>>>>> Traceback (most recent call last):
>>>>>>> Â  File
>"/usr/share/doc/mythtv-backend/contrib/imports/mirobridge/mirobridge.py",
>>>>>>> line 2800, in <module>
>>>>>>> Â  Â  main()
>>>>>>> Â  File
>"/usr/share/doc/mythtv-backend/contrib/imports/mirobridge/mirobridge.py",
>>>>>>> line 2766, in main
>>>>>>> Â  Â  if not updateMythRecorded(unwatched):
>>>>>>> Â  File
>"/usr/share/doc/mythtv-backend/contrib/imports/mirobridge/mirobridge.py",
>>>>>>> line 1828, in updateMythRecorded
>>>>>>> Â  Â  records = createRecordedRecords(item)
>>>>>>> Â  File
>"/usr/share/doc/mythtv-backend/contrib/imports/mirobridge/mirobridge.py",
>>>>>>> line 1414, in createRecordedRecords
>>>>>>> Â  Â  graphics = metadata.getMetadata(sanitiseFileName(item[u'
>>>>>>> channelTitle']))
>>>>>>> Â  File "/usr/share/doc/mythtv-backend/contrib/imports/
>>>>>>> mirobridge/mirobridge/metadata.py", line 172, in getMetadata
>>>>>>> Â  Â  record = self.Record().create(self.makeRecordRule)
>>>>>>> Â  File "/usr/lib/python2.7/dist-packages/MythTV/dataheap.py",
>line
>>>>>>> 161, in __init__
>>>>>>> Â  Â  DBDataWrite.__init__(self, data, db)
>>>>>>> Â  File "/usr/lib/python2.7/dist-packages/MythTV/database.py",
>line
>>>>>>> 317, in __init__
>>>>>>> Â  Â  DBData.__init__(self, data, db)
>>>>>>> Â  File "/usr/lib/python2.7/dist-packages/MythTV/database.py",
>line
>>>>>>> 169, in __init__
>>>>>>> Â  Â  self._setDefs()
>>>>>>> Â  File "/usr/lib/python2.7/dist-packages/MythTV/database.py",
>line
>>>>>>> 305, in _setDefs
>>>>>>> Â  Â  DBData._setDefs(self)
>>>>>>> Â  File "/usr/lib/python2.7/dist-packages/MythTV/database.py",
>line
>>>>>>> 160, in _setDefs
>>>>>>> Â  Â  self.__class__._setClassDefs(self._db)
>>>>>>> Â  File "/usr/lib/python2.7/dist-packages/MythTV/dataheap.py",
>line
>>>>>>> 118, in _setClassDefs
>>>>>>> Â  Â  defaults = cls._template('Default', db=db)
>>>>>>> Â  File "/usr/lib/python2.7/dist-packages/MythTV/dataheap.py",
>line
>>>>>>> 128, in _template
>>>>>>> Â  Â  tmp = cls._fromQuery("WHERE title=?", (name + "
>(Template)",))\
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> My Google Profile <http://www.google.com/profiles/dmfrey>
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> mythtv-users mailing list
>>>>>>> mythtv-users at mythtv.org
>>>>>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>>>>>> http://wiki.mythtv.org/Mailing_List_etiquette
>>>>>>> MythTV Forums: https://forum.mythtv.org
>>>>>>>
>>>>>> Daniel,
>>>>>>     I'm running a close configuration to yourself with two
>exceptions,
>>>>>> Ubuntu 12.10 and Miro 6.0 but the latest compile of 0.27. I doubt
>that
>>>>>> these variations are the issue, The abort is occuring in one of
>the MythTV
>>>>>> python bindings that MiroBridge calls to create a RecordRule that
>so you
>>>>>> can get artwork for the specific Miro Channel. That Miro Channel
>has
>>>>>> graphics on thetvdb.org, Did you add a new Miro Channel lately?
>Of
>>>>>> course an old channel could have new artwork on thetvdb.org
>>>>>>
>>>>>> From the BE you run Mir*obridge, *from the command line run then
>cut
>>>>>> and replace the output into a reply email. Lets eliminate the
>bindings
>>>>>> first.
>>>>>> > mythpython --version
>>>>>>
>>>>>> Example output:
>>>>>> MythTV Python Bindings
>>>>>>   local versions
>>>>>>     bindings version:         0.27.-1.0
>>>>>>     ttvdb version:            1.2.1
>>>>>>     tmdb version:             v0.7.0
>>>>>>   external versions
>>>>>>     lxml version:             2.3.5
>>>>>>     MySQLdb version:          1.2.3.final.0
>>>>>>   protocol versions
>>>>>>     backend:                  77
>>>>>>     schema:                   1317
>>>>>>     music schema:             1018
>>>>>>     netvision schema:         1007
>>>>>>
>>>>>> This sound like an issue with RecordedRule (new artwork) that I
>helped
>>>>>> a user with a number-to-many months ago. It was not a MiroBridge
>bug (no
>>>>>> code changes required). I'm getting old so I can't remember how
>the user
>>>>>> and I resolved the abort. It was on the MythTV user mailing list
>so a
>>>>>> search may find that thread and how the problem was resolved.
>that's
>>>>>> probably ftaser than going through the analysis process again.
>>>>>>
>>>>>> Doug
>>>>>>
>>>>>> _______________________________________________
>>>>>> mythtv-users mailing list
>>>>>> mythtv-users at mythtv.org
>>>>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>>>>> http://wiki.mythtv.org/Mailing_List_etiquette
>>>>>> MythTV Forums: https://forum.mythtv.org
>>>>>>
>>>>>
>>>>>
>>>>> Doug,
>>>>>
>>>>> Looks like lxml is the only version that is not consistent with
>your
>>>>> output:
>>>>>
>>>>> MythTV Python Bindings
>>>>>   local versions
>>>>>     bindings version:         0.27.-1.0
>>>>>     ttvdb version:            1.2.1
>>>>>     tmdb version:             v0.7.0
>>>>>   external versions
>>>>>     lxml version:             2.3.2
>>>>>     MySQLdb version:          1.2.3.final.0
>>>>>   protocol versions
>>>>>     backend:                  77
>>>>>     schema:                   1317
>>>>>     music schema:             1018
>>>>>     netvision schema:         1007
>>>>>
>>>>> This is staring to sound vaguely familiar.  I will start to review
>the
>>>>> mythtv users mailing for what you were referring.  I will also try
>to
>>>>> re-setup the channel as well.
>>>>>
>>>>> Dan
>>>>> --
>>>>> My Google Profile <http://www.google.com/profiles/dmfrey>
>>>>>
>>>>> ------------------------------
>>>>>
>>>>> mythtv-users mailing list
>>>>> mythtv-users at mythtv.org
>>>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>>>>
>>>>> http://wiki.mythtv.org/Mailing_List_etiquette
>>>>> MythTV Forums: https://forum.mythtv.org
>>>>>
>>>>>
>>>> --
>>>> Sent from my Android device with K-9 Mail. Please excuse my
>brevity.
>>>>
>>>> _______________________________________________
>>>> mythtv-users mailing list
>>>> mythtv-users at mythtv.org
>>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>>> http://wiki.mythtv.org/Mailing_List_etiquette
>>>> MythTV Forums: https://forum.mythtv.org
>>>>
>>>>
>>>
>>> Doug,
>>>
>>> Yes, I am a developer and am very familiar with sql databases.
>>>
>>> Dan
>>> --
>>> My Google Profile <http://www.google.com/profiles/dmfrey>
>>>
>>
>>
>> I went back through the mailing list archives and was not noticing
>other
>> users with the same issues.  Most of the entries are very old, say
>back in
>> 2012, 2010 and before.
>>
>> Some other's had python issues, but they were related to invalid data
>in
>> different timezones.
>>
>> Is there an easy way to step through the python as it executing so I
>can
>> watch the execution?
>>
>> --
>> My Google Profile <http://www.google.com/profiles/dmfrey>
>>
>
>I was able to step through the code with the python-pubd debugger. 
>That
>was pretty cool. It seemed that the template for creating the sql
>statement
>was null for creating the recording rule.
>
>I then created the recording rules manually with mysql insert
>statements
>and it runs successfully, however, that issue from a while back where
>the
>recording rules gets duplicated is still present. So it seems that when
>it
>queries the db for the show, a record is not being returned, so it is
>forced to create a new one. I will try to look and see what it is
>querying
>on to determine if the record is found or not.
>
>-- 
>My Google Profile <http://www.google.com/profiles/dmfrey>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://www.mythtv.org/mailman/listinfo/mythtv-users
>http://wiki.mythtv.org/Mailing_List_etiquette
>MythTV Forums: https://forum.mythtv.org

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140611/8856b2eb/attachment-0001.html>

More information about the mythtv-users mailing list