[mythtv-users] mirobridge - bad table name mythconverg.deloldrecorded

Brian Ruth brian at bigkitty.org
Sun Sep 5 16:22:24 UTC 2010


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 athena .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@pcf1.pculture.org/var/git/miro - 9d00ca9f
2010-09-05 08:13:57,506 INFO     Builder: 
mockbuild at x86-02.phx2.fedoraproject.org
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


More information about the mythtv-users mailing list