MythTV 0.20 upgrade under Fedora Core3
Using to MythTV 0.20 under FC3 appears to be going well so far.
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. Almost happy; bugs include:
- the preview play of recorded shows has a very blue-tinted color now
- mythmusic fails cuz libmythmusic.so can’t resolve mm_support (possibly cuz of libexif and the fact I’m running FC3 vs FC5, supposedly)
Otherwise, so far so good. Others are having some trouble with this new version, though, so I wouldn’t jump on it yet.
