[mythtv-users] What to do if your upgrade fails (was Re: 0.22 database schema upgrade fails driver not loaded)

Michael T. Dean mtdean at thirdcontact.com
Fri Nov 6 17:30:35 UTC 2009


On 11/05/2009 11:59 PM, Michael T. Dean wrote:
> On 11/05/2009 10:19 PM, Michael T. Dean wrote:
>> After looking at Chris's backup, I found that the schema was modified 
>> in such a way that it causes problems that prevent the DB upgrade 
>> from succeeding.
> On deeper inspection, it seems that the relevant "modification" is 
> missing tables.  The tables are mostly missing due to some corruption 
> or DB issue.
>
> Though I haven't found/fixed the bug, yet, it seems that there's a bug 
> in Qt-MySQL drivers that kills the QSqlDatabase if a query attempts to 
> touch a non-existent table or column

FWIW, it's actually not killing our DB connection--just the error message.

> --thus the error message (from his original post):
>>> 2009-11-05 13:37:05.121 Newest MythTV Schema Version : 1244
>>> QSqlQuery::exec: database not open
>>> 2009-11-05 13:37:09.922 DB Error (Unable to perform test for 
>>> database corruption before character set conversion.):
>>> Query was:
>>>
>>> Driver error was [1/-1]:
>>> Driver not loaded
>>> Database error was:
>>> Driver not loaded
>>>
>>> 2009-11-05 13:37:09.923 Database Schema upgrade FAILED, unlocking.
>>> 2009-11-05 13:37:09.924 Couldn't upgrade database to new schema
> I'm looking into it to see if I can fix the bug for Qt, but I don't 
> think there's anything at all (that's sane that) we could do to work 
> around the bug in Myth code.

And, now, it seems there may be something we can do in Myth to get a 
better error message.  Still have to figure out what.

Mike


More information about the mythtv-users mailing list