[mythtv-users] Database not upgrading in trunk

[Michael T. Dean]

On 09/07/2009 04:09 PM, Steve Reilly wrote:
> Nik Gibson wrote:
>   
>> On Sep 7, 2009, at 3:10 PM, Steve Reilly wrote:
>>     
>>> nik gibson wrote:
>>>       
>>>> Normally when I upgrade to a new myth version the database
>>>> automatically upgrades when the backend starts but after my last
>>>> couple upgrades the frontend complains about an old db version and no
>>>> upgrade occurs.
>>>>
>>>> Is there anyway to force a database schema upgrade?  I've had a couple
>>>> backend crashes in the last couple weeks and I wondering if it's due
>>>> to the database schema being old as the frontend states.  I'm running
>>>> the most recent mythbuntu weekly build of trunk.
>>>>
>>>> This is from the mythfrontend log:
>>>>
>>>> 009-09-07 13:19:13.290 Current Schema Version: 1244
>>>> 2009-09-07 13:19:13.350 Registering Internal as a media playback plugin.
>>>> 2009-09-07 13:19:13.395 MonitorRegisterExtensions(0x100, gif,jpg,png)
>>>> 2009-09-07 13:19:13.601 Current Schema Version: 1016
>>>> 2009-09-07 13:19:13.601 Database schema is old. Waiting to see if DB
>>>> is being upgraded.
>>>> 2009-09-07 13:19:14.673 Current Schema Version: 1016
>>>> 2009-09-07 13:19:15.676 Current Schema Version: 1016
>>>> 2009-09-07 13:19:16.680 Current Schema Version: 1016
>>>> 2009-09-07 13:19:16.680 Timed out waiting.
>>>>         
>>> i upgraded trunk a couple days ago and same as you running mythbuntu
>>> weekly builds.  got a pop up saying old database, "upgrade?"  bottom of
>>> screen had to move choice to yes, then it asked again same question if i
>>> remember correctly. checking logs, looks like im at schema 1017 now..
>>> after that had no problems.  is that what happened to you?
>> I upgraded remotely through the command line so I didn't get any popups.
>> Did you use synaptic for your upgrade?
> nope, ssh from another box, but when i rebooted my mythbox (kernel
> upgrade) and mythfrontend started, thats when mythfrontend asked me to
> upgrade database...... first ive ever seen anything like it. was
> successful as far as i can tell, it hasnt asked again anyway. note: ive
> *been* running trunk for 6 months maybe, this wasnt an upgrade from .21
> to trunk. just a regular mythbuntu dailies trunk update.

Re-reading, I see that in nik's original post he mentioned an "error" in 
mythfrontend logs...  What he showed was not an error, but--because that 
was mythfrontend--he should have seen an error next saying, "Couldn't 
upgrade database to new schema, exiting." and then mythfrontend should 
have shut down.

This /still/ goes back to my other reply--WARNING: 0.21-fixes to trunk 
DB upgrade takes a long time.  So, don't mess with it/kill process/...  
Be patient and let the upgrade (being performed by mythbackend) complete.

Mike