[mythtv-users] No recordings shown? and OpenDatabase(), db object is not valid!

[Mike Dent]

Hi,
just now I moved from watching a video in mythvideo to "Watch
Recordings". Instead of seeing the usual list of recordings I just saw
the template
with no text, or recordings etc. I've left it sat like that for some
time and decided to check the frontend log.

This is a FE only box, Acer Revo with mythtv 0.22

In the log at the time of looking at the recordings I see:-

2010-01-03 11:31:39.800 Unable to find image file: No Cover
QSqlDatabasePrivate::removeDatabase: connection 'DBManager1' is still
in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name
'DBManager1', old connection removed.
2010-01-03 11:31:43.143 New DB connection, total: 2
2010-01-03 11:31:43.145 Connected to database 'mythconverg' at host: 192.168.1.6
2010-01-03 11:31:43.150 Loading window theme from
/usr/share/mythtv/themes/MythCenter-wide/recordings-ui.xml
2010-01-03 11:31:43.151 Loading window theme from
/usr/share/mythtv/themes/default-wide/recordings-ui.xml
2010-01-03 11:31:43.530 MSqlDatabase::OpenDatabase(), db object is not valid!
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2010-01-03 11:31:43.607 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

2010-01-03 11:31:43.663 Database not open while trying to load
setting: DisplayGroupTitleSort
2010-01-03 11:31:44.479 MSqlDatabase::OpenDatabase(), db object is not valid!
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2010-01-03 11:31:44.530 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

QSqlQuery::prepare: database not open
2010-01-03 11:31:44.580 Error preparing query: SELECT recordid, type,
maxepisodes, avg_delay, next_record, last_record, last_delete FROM
record;
2010-01-03 11:31:44.580 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

2010-01-03 11:31:44.593 MSqlDatabase::OpenDatabase(), db object is not valid!
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2010-01-03 11:31:44.643 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

QSqlQuery::prepare: database not open
2010-01-03 11:31:44.694 Error preparing query: SELECT status FROM
jobqueue WHERE type = :TYPE AND chanid = :CHANID AND starttime =
:STARTTIME;
2010-01-03 11:31:44.694 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

2010-01-03 11:31:44.747 DB Error (Error in JobQueue::GetJobStatus()):
Query was:

Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

2010-01-03 11:31:44.748 MSqlDatabase::OpenDatabase(), db object is not valid!
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2010-01-03 11:31:44.799 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

QSqlQuery::prepare: database not open
2010-01-03 11:31:44.849 Error preparing query: SELECT basename FROM
recorded WHERE chanid = :CHANID AND       starttime = :STARTTIME;
2010-01-03 11:31:44.849 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded



This eventually settles down to:-

QSqlQuery::prepare: database not open
2010-01-03 11:47:28.607 Error preparing query: SELECT DISTINCT dirname
FROM storagegroup
2010-01-03 11:47:28.607 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

2010-01-03 11:47:28.607 DB Error (StorageGroup::StorageGroup()):
Query was:

Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

2010-01-03 11:47:28.609 MSqlDatabase::OpenDatabase(), db object is not valid!
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2010-01-03 11:47:28.660 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded

QSqlQuery::prepare: database not open
2010-01-03 11:47:28.710 Error preparing query: SELECT DISTINCT dirname
FROM storagegroup
2010-01-03 11:47:28.710 Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded


I restated the FE process and although it would display the recordings
this time, it would not play anything. It appeared to lock up.
I restarted the FE process again and this time it works?! I've no idea
what is happening.

I am running mythtv 0.22-fixes 22994

Mike