zen.org Communal Weblog

September 14, 2006

MythTV 0.20 upgrade under Fedora Core3

Filed under: — brendan @ 14:36 IST

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.

Many people may not get medical insurance and thus forced to pay for the expensive prescription medications or research how to buy generic medications online. Generic drugs are as safe as other branded counterparts. Only reputable pharmacy produces them such as Cipla. With this in head one can buy lioresal uk in generic online drugstore including free shipping anywhere in the world

Powered by WordPress