[ATrpms-users] FC3 0.20 success, but with a mysql command

[Brendan Kehoe]

Using 0.20 under FC3 appears to be going well so far.  (The preview play 
of recorded shows has a very blue-tinted color now.)

After the "smart upgrade" and a reboot, I found that mythfrontend wasn't 
coming up.  It failed to start, as did mythbackend, because of

    2006-09-14 15:14:10.068 Connected to database 'mythconverg' at host:
    localhost
    2006-09-14 15:14:10.070 Upgrading to schema version 1136
    2006-09-14 15:14:10.071 DB Error (Performing database upgrade):
    Query was: ALTER TABLE program ADD listingsource INT NOT NULL
    default '0';
    Error was: Driver error was [2/1060]:
    QMYSQL3: Unable to execute query
    Database error was:
    Duplicate column name 'listingsource'
     
    new version: 1136
    2006-09-14 15:14:10.072 Database Schema upgrade FAILED, unlocking.
    2006-09-14 15:14:10.072 Couldn't upgrade database to new schema

Even though my full dump of mysql before doing all of this doesn't 
actually have 'listingsource' in the program table it emitted.  Weird.

To fix it, I had to do

    mysql -umysql -p mysql mythconverg
     > alter table program drop listingsource;
     > quit

and then make mythbackend do its stuff in front of me so I knew it'd 
actually succeeded:

    sudo mythbackend

Once that was happy having done a bunch of upgrades to schema versions 
incrementing to 1160, it finally calmed after emitting

    2006-09-14 15:20:19.384 AutoExpire: Required Free Space: 2.1 GB
    w/freq: 10 min
    2006-09-14 15:20:21.298 Reschedule requested for id -1.
    2006-09-14 15:20:21.795 Scheduled 260 items in 0.5 = 0.15 match +
    0.35 place
    2006-09-14 15:20:21.801 Seem to be woken up by USER

With that, I did a Ctrl-C and restarted it with

    sudo /sbin/service mythbackend restart

Now it's up and humming.