[ATrpms-users] FC3 0.20 success, but with a mysql command
brendan at zen.org
Thu Sep 14 16:31:13 CEST 2006
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:
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
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;
and then make mythbackend do its stuff in front of me so I knew it'd
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 +
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.
More information about the atrpms-users