Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Users

mirobridge - bad table name mythconverg.deloldrecorded

 

 

MythTV users RSS feed   Index | Next | Previous | View Threaded


brian at bigkitty

Sep 5, 2010, 9:22 AM

Post #1 of 3 (183 views)
Permalink
mirobridge - bad table name mythconverg.deloldrecorded

I upgraded to trunk revision 26128 this morning and mirobridge now hangs
when run trying to access a table that doesn't exist
'mythconverg.deloldrecorded'. I'm guessing it should be looking for
mythconverg.oldrecorded, however, my Python experience is non-existent
and nothing is jumping out as I scan through the code. Anyone else
experiencing this or is should I be looking at mysql instead?

Output as follows (-n to preclude the miro file download messages):

[mythtv [at] athen .mythtv]$ python
/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py
-c 9999:9999 -Vn
2010-09-05 08:13:54,345 - mirobridge - INFO - Using python library
'pyparsing' version 1.5.0
2010-09-05 08:13:55.367 Python Database Connection: Using connection
settings from /home/mythtv/.mythtv/config.xml
2010-09-05 08:13:56,825 - mirobridge - INFO - Miro Bridge version v0.6.3
with Miro version 3.0.2
2010-09-05 08:13:56,826 - mirobridge - INFO - Using
mirobridge_interpreter_3_0_0
2010-09-05 08:13:56,917 - mirobridge - INFO - Miro Version (3.0.2 r9d00ca9f)
2010-09-05 08:13:56,917 - mirobridge - INFO - Base Miro Video Directory
(/storage01/media/miro)
2010-09-05 08:13:56,917 - mirobridge - INFO -

==========================================================================================
Listed below are the types and base directories that will be use for
processing.
The list reflects your current configuration for the
'athena.bigkitty.org' back end
and whether a directory is a 'SG' (storage group) or not.
Note: All directories are from settings in the MythDB specific to
hostname (athena.bigkitty.org).
------------------------------------------------------------------------------------------
Type: Default - SG-YES - Directory: (/video2/)
Type: Cover art - SG-YES - Directory:
(/storage01/media/mythtv.metadata/coverart/)
Type: Fan art - SG-YES - Directory:
(/storage01/media/mythtv.metadata/fanart/)
Type: Banners - SG-YES - Directory:
(/storage01/media/mythtv.metadata/banners/)
Type: Screenshots - SG-YES - Directory:
(/storage01/media/mythtv.metadata/screenshots/)
Type: Video - SG-YES - Directory: (/storage01/media/movies/)
------------------------------------------------------------------------------------------
If a directory you set from a separate Front end is not displayed it means
that the directory is not accessible from this backend OR
you must add the missing directories using the Front end on this Back end.
Front end settings are host machine specific.
==========================================================================================

2010-09-05 08:13:57,465 - mirobridge - INFO - Starting Miro Frontend and
Backend
2010-09-05 08:13:57,496 INFO Starting up Miro
2010-09-05 08:13:57,497 INFO Version: 3.0.2
2010-09-05 08:13:57,504 INFO OS: Linux
2.6.34.6-47.fc13.x86_64 x86_64
2010-09-05 08:13:57,505 INFO Revision:
ssh://wguaraldi [at] pcf1/var/git/miro - 9d00ca9f
2010-09-05 08:13:57,506 INFO Builder:
mockbuild [at] x86-02
2010-09-05 08:13:57,507 INFO Build Time: 1275591127.75
2010-09-05 08:13:57,507 INFO Starting event loop thread
2010-09-05 08:13:57,509 INFO Restoring database...
2010-09-05 08:13:57,510 INFO Sqlite3 version: 3.6.22
2010-09-05 08:13:57,511 INFO Pysqlite version: 2.4.1
2010-09-05 08:13:57,511 INFO opening database
/home/mythtv/.miro/sqlitedb
2010-09-05 08:13:57,652 TIMING Database upgrade time: 0.142
2010-09-05 08:13:57,661 DBLOG start database log entries
2010-09-05 08:13:57,662 DBLOG * Sat May 22 14:39:02 2010: Upgraded
database from version 105 to 110
2010-09-05 08:13:57,662 DBLOG end database log entries
2010-09-05 08:13:57,964 INFO setup tabs...
2010-09-05 08:13:57,973 INFO setup theme...
2010-09-05 08:13:58,015 INFO Checking movies directory
'/storage01/media/miro/'...
Startup success.
Traceback (most recent call last):
File
"/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
line 2640, in <module>
main()
File
"/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
line 2317, in main
videostodelete = getOldrecordedOrphans()
File
"/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
line 1113, in getOldrecordedOrphans
oldrecorded_array = list(mythdb.searchOldRecorded(chanid=channel_id, ))
File "/usr/lib/python2.6/site-packages/MythTV/utility.py", line 145,
in __call__
yield self.dbclass.fromRaw(row, self.inst)
File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 107,
in fromRaw
cls._setClassDefs(db)
File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 250,
in _setClassDefs
super(DBDataWrite, cls)._setClassDefs(db)
File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 73,
in _setClassDefs
cls._field_order = db.tablefields[cls._table]
File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 798,
in __getitem__
raise MythDBError(MythDBError.DB_RAW, e.args)
MythTV.exceptions.MythDBError: MySQL error: MySQL error 1146: Table
'mythconverg.deloldrecorded' doesn't exist

Brian
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


raymond at wagnerrp

Sep 5, 2010, 1:33 PM

Post #2 of 3 (180 views)
Permalink
Re: mirobridge - bad table name mythconverg.deloldrecorded [In reply to]

On 9/5/2010 12:22, Brian Ruth wrote:
> Traceback (most recent call last):
> File
> "/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
> line 2640, in <module>
> main()
> File
> "/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
> line 2317, in main
> videostodelete = getOldrecordedOrphans()
> File
> "/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
> line 1113, in getOldrecordedOrphans
> oldrecorded_array =
> list(mythdb.searchOldRecorded(chanid=channel_id, ))
> File "/usr/lib/python2.6/site-packages/MythTV/utility.py", line 145,
> in __call__
> yield self.dbclass.fromRaw(row, self.inst)
> File "/usr/lib/python2.6/site-packages/MythTV/database.py", line
> 107, in fromRaw
> cls._setClassDefs(db)
> File "/usr/lib/python2.6/site-packages/MythTV/database.py", line
> 250, in _setClassDefs
> super(DBDataWrite, cls)._setClassDefs(db)
> File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 73,
> in _setClassDefs
> cls._field_order = db.tablefields[cls._table]
> File "/usr/lib/python2.6/site-packages/MythTV/database.py", line
> 798, in __getitem__
> raise MythDBError(MythDBError.DB_RAW, e.args)
> MythTV.exceptions.MythDBError: MySQL error: MySQL error 1146: Table
> 'mythconverg.deloldrecorded' doesn't exist

Fixed in r26135. Thanks for the catch.
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


brian at bigkitty

Sep 5, 2010, 2:18 PM

Post #3 of 3 (173 views)
Permalink
Re: mirobridge - bad table name mythconverg.deloldrecorded [In reply to]

On 9/5/2010 4:33 PM, Raymond Wagner wrote:
> On 9/5/2010 12:22, Brian Ruth wrote:
>> Traceback (most recent call last):
>> File
>> "/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
>> line 2640, in<module>
>> main()
>> File
>> "/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
>> line 2317, in main
>> videostodelete = getOldrecordedOrphans()
>> File
>> "/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
>> line 1113, in getOldrecordedOrphans
>> oldrecorded_array =
>> list(mythdb.searchOldRecorded(chanid=channel_id, ))
>> File "/usr/lib/python2.6/site-packages/MythTV/utility.py", line 145,
>> in __call__
>> yield self.dbclass.fromRaw(row, self.inst)
>> File "/usr/lib/python2.6/site-packages/MythTV/database.py", line
>> 107, in fromRaw
>> cls._setClassDefs(db)
>> File "/usr/lib/python2.6/site-packages/MythTV/database.py", line
>> 250, in _setClassDefs
>> super(DBDataWrite, cls)._setClassDefs(db)
>> File "/usr/lib/python2.6/site-packages/MythTV/database.py", line 73,
>> in _setClassDefs
>> cls._field_order = db.tablefields[cls._table]
>> File "/usr/lib/python2.6/site-packages/MythTV/database.py", line
>> 798, in __getitem__
>> raise MythDBError(MythDBError.DB_RAW, e.args)
>> MythTV.exceptions.MythDBError: MySQL error: MySQL error 1146: Table
>> 'mythconverg.deloldrecorded' doesn't exist
>
> Fixed in r26135. Thanks for the catch.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Thanks - the db error is fixed but unfortunately it uncovered another issue:

2010-09-05 17:07:09,762 - mirobridge - INFO - Used file
(/storage01/media/miro/AppJudgement/appjudgment--0211--ip_chu_retinagames2--hd720p30.h264.mp4)
to created symlink (/video2/9999_20100829231820.mp4)
2010-09-05 17:07:09,762 INFO Used file
(/storage01/media/miro/AppJudgement/appjudgment--0211--ip_chu_retinagames2--hd720p30.h264.mp4)
to created symlink (/video2/9999_20100829231820.mp4)
2010-09-05 17:07:09.830 Python Database Connection: Using connection
settings from /home/mythtv/.mythtv/config.xml
Traceback (most recent call last):
File
"/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
line 2641, in <module>
main()
File
"/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
line 2608, in main
if not updateMythRecorded(unwatched):
File
"/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py",
line 1747, in updateMythRecorded
Recorded().create(records[0])
File "/usr/lib/python2.6/site-packages/MythTV/altdict.py", line 27,
in __getattr__
raise AttributeError(str(name))
AttributeError: create

Associated video is:
newly-downloaded 72.9MB Gorgeous Games for iPhone 4's Retina
Screen! Osmos and Real Racing - AppJudgment
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

MythTV users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.