[mythtv-users] upgrade database schema from 1224 to 1242 fails

Michael T. Dean mtdean at thirdcontact.com
Tue Aug 25 06:12:13 UTC 2009


On 08/25/2009 01:27 AM, Michael T. Dean wrote:
> On 08/25/2009 12:59 AM, Kevin Johnson wrote:
>> I recently tried upgrading to .22 using trunk because I had a few 
>> things that I thought an upgrade might help.
>>
>> Now i am in real trouble.  I am using mythbuntu 9.04
>>
>> I installed all the packages.  When I enter mythtv-setup, it want to 
>> upgrade.  I choose okay and it kicks out and ask me if I want to run 
>> mythfilldatabase.  Of couse that fails to.
>> If I run mythbackend from the command line, this is the last part of 
>> the output.
>>
>> Please help.
>>
>> A database backup might be a good idea
>> Are you sure you want to upgrade? [no]  yes
>> 2009-08-24 21:52:50.166 Newest Schema Version : 1242
>> 2009-08-24 21:52:50.172 Upgrading to schema version 1225
>> 2009-08-24 21:52:50.174 DB Error (Performing database upgrade): Query 
>> was: CREATE TABLE bad_people AS SELECT * FROM people; Error was: 
>> Driver error was [2/1050]:
>> QMYSQL3: Unable to execute statement
>> Database error was:
>> Table 'bad_people' already exists
>>  
>> new version: 1225
>> 2009-08-24 21:52:50.174 Database Schema upgrade FAILED, unlocking.
>> 2009-08-24 21:52:50.175 Couldn't upgrade database to new schema
>
> That error is caused by the previous upgrade failure.
>
> Any chance you have the log from the original upgrade?

Meaning that it looks like you re-ran mythtv-setup or mythbackend to get 
the log output showing the failure for pasting into the e-mail.  
Instead, it's now giving a different error that's being caused by the 
"unfinished" state of the database upgrade.

Mike


More information about the mythtv-users mailing list