[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