[mythtv-users] 0.23 to 0.24 upgrade; database wont upgrade

Richard Morton richard.e.morton at gmail.com
Thu Dec 30 22:26:31 UTC 2010


ok, so long story short; had a pretty linuxy day. Woke up this morning
to find a broken myth system.

<long story>

In fact it would only get as far as a busybox prompt on boot. I knew I
had had issues with booting the box off certain versions of ubuntu
live cd. downloaded the latest and booted it off usb to try and fix
the drive. wouldnt boot; got to a syslinux error; that I eventually
found here (4 hours later):
https://bugs.launchpad.net/ubuntu/+source/syslinux/+bug/617779

I had also spent some time trying to boot off cds; but the cds wouldnt
pass checksums. When installing it crashed out with an i/o error.
tried several disks and eventually found the above bug.

It seems I have a busted dvd drive (its not used very much, just on
installs) and a busted hdd. while also finding a bug in syslinux...
talk about being struck down with a bad case of luck.

</longstory>

So now I have a fresh 10.10 install, with medibuntu, mythbuntu repos,
nvidia all installed. And it has the same media drives, ip address and
hostname.

First things first I backed up my database backups...

I installed 0.24, plugins etc.

used mythconverg_restore to put back the database backup from my old
0.23 system (the one that just died) and ran mythbackend to do the
database upgrade. it failed. console output is below; --verbose
database follows that.

I stopped the background process

I have looked at the credentials in mysql.txt and config.xml and they
work (I have looked in both /home/username and /etc/mythtv). I have
even tried changing these details to the correct root details (dont
worry, they've been changed back).

Sometimes a table called internetcontent is created, sometimes not.
Once I have seen them, it then complains that internetcontent exists;
so I removed it. then it complained that internetcontentarticles
exists; but this has never existed of been created.

however now it is saying it is internetcontent that exists (it doesnt).

Help!!!

thanks in advance - hope you're all having great celebrations.

R



myth at myth-server:~$ sudo mythbackend
2010-12-30 21:53:34.522 mythbackend version: fixes/0.24 [2f3a2f8] www.mythtv.org
2010-12-30 21:53:34.522 Using runtime prefix = /usr
2010-12-30 21:53:34.522 Using configuration directory = /home/myth/.mythtv
2010-12-30 21:53:34.523 DBUserName is not set in mysql.txt
2010-12-30 21:53:34.523 DBPassword is not set in mysql.txt
2010-12-30 21:53:34.523 Empty LocalHostName.
2010-12-30 21:53:34.523 Using localhost value of myth-server
2010-12-30 21:53:34.531 New DB connection, total: 1
2010-12-30 21:53:34.534 Unable to connect to database!
2010-12-30 21:53:34.534 Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'root'@'localhost' (using password: NO)

................................................................................
2010-12-30 21:53:36.579 UPnPautoconf() - No UPnP backends found
2010-12-30 21:53:36.580 No UPnP backends found

No UPnP backends found

Would you like to configure the database connection now? [no]
[console is not interactive, using default 'no']
2010-12-30 21:53:36.580 Deleting UPnP client...
2010-12-30 21:53:37.578 Failed to init MythContext.
myth at myth-server:~$ sudo mythbackend
2010-12-30 21:54:25.171 mythbackend version: fixes/0.24 [2f3a2f8] www.mythtv.org
2010-12-30 21:54:25.171 Using runtime prefix = /usr
2010-12-30 21:54:25.171 Using configuration directory = /home/myth/.mythtv
2010-12-30 21:54:25.172 DBUserName is not set in mysql.txt
2010-12-30 21:54:25.172 DBPassword is not set in mysql.txt
2010-12-30 21:54:25.172 Empty LocalHostName.
2010-12-30 21:54:25.172 Using localhost value of myth-server
2010-12-30 21:54:25.180 New DB connection, total: 1
2010-12-30 21:54:25.183 Unable to connect to database!
2010-12-30 21:54:25.183 Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'root'@'localhost' (using password: NO)

................................................................................
2010-12-30 21:54:27.229 UPnPautoconf() - No UPnP backends found
2010-12-30 21:54:27.229 No UPnP backends found

No UPnP backends found

Would you like to configure the database connection now? [no]
[console is not interactive, using default 'no']
2010-12-30 21:54:27.229 Deleting UPnP client...
2010-12-30 21:54:28.227 Failed to init MythContext.
myth at myth-server:~$ sudo mythbackend
2010-12-30 21:55:06.579 mythbackend version: fixes/0.24 [2f3a2f8] www.mythtv.org
2010-12-30 21:55:06.579 Using runtime prefix = /usr
2010-12-30 21:55:06.579 Using configuration directory = /home/myth/.mythtv
2010-12-30 21:55:06.580 Empty LocalHostName.
2010-12-30 21:55:06.580 Using localhost value of myth-server
2010-12-30 21:55:06.588 New DB connection, total: 1
2010-12-30 21:55:06.590 Connected to database 'mythconverg' at host: localhost
2010-12-30 21:55:06.594 Closing DB connection named 'DBManager0'
2010-12-30 21:55:06.594 Connected to database 'mythconverg' at host: localhost
2010-12-30 21:55:06.595 Current locale EN_GB
2010-12-30 21:55:06.595 Reading locale defaults from
/usr/share/mythtv//locales/en_gb.xml
2010-12-30 21:55:06.603 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:55:06.603 MythTV database schema is old. Waiting to see
if DB is being upgraded.
2010-12-30 21:55:07.603 New DB connection, total: 2
2010-12-30 21:55:07.603 Connected to database 'mythconverg' at host: localhost
2010-12-30 21:55:07.605 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:55:08.607 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:55:09.608 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:55:10.610 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:55:11.611 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:55:11.612 Timed out waiting.
2010-12-30 21:55:11.619 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2010-12-30 21:55:30.233 Database Backup complete.
2010-12-30 21:55:30.233 Backed up database to file:
'/var/lib/mythtv/backups/mythconverg-1257-20101230215511.sql.gz'
2010-12-30 21:55:30.247 Console is non-interactive, can't prompt user...
2010-12-30 21:55:30.247 Upgrading.
2010-12-30 21:55:30.248 Newest MythTV Schema Version : 1264
2010-12-30 21:55:30.252 Upgrading to MythTV schema version 1258
2010-12-30 21:55:30.252 DB Error (Performing database upgrade):
Query was: CREATE TABLE internetcontent ( name VARCHAR(255) NOT NULL,
thumbnail VARCHAR(255),  type SMALLINT(3) NOT NULL,  author
VARCHAR(128) NOT NULL,  description TEXT NOT NULL,  commandline TEXT
NOT NULL,  version DOUBLE NOT NULL,  updated TIMESTAMP NOT NULL,
search BOOL NOT NULL,  tree BOOL NOT NULL,  podcast BOOL NOT NULL,
download BOOL NOT NULL,  host  VARCHAR(128));
Error was: Driver error was [2/1050]:
QMYSQL: Unable to execute query
Database error was:
Table 'internetcontent' already exists

new version: 1258
2010-12-30 21:55:30.252 Database Schema upgrade FAILED, unlocking.
2010-12-30 21:55:30.252 Couldn't upgrade database to new schema
myth at myth-server:~$ sudo mythbackend
2010-12-30 22:00:24.725 mythbackend version: fixes/0.24 [2f3a2f8] www.mythtv.org
2010-12-30 22:00:24.725 Using runtime prefix = /usr
2010-12-30 22:00:24.725 Using configuration directory = /home/myth/.mythtv
2010-12-30 22:00:24.726 Empty LocalHostName.
2010-12-30 22:00:24.726 Using localhost value of myth-server
2010-12-30 22:00:24.733 New DB connection, total: 1
2010-12-30 22:00:24.736 Connected to database 'mythconverg' at host: localhost
2010-12-30 22:00:24.740 Closing DB connection named 'DBManager0'
2010-12-30 22:00:24.740 Connected to database 'mythconverg' at host: localhost
2010-12-30 22:00:24.741 Current locale EN_GB
2010-12-30 22:00:24.741 Reading locale defaults from
/usr/share/mythtv//locales/en_gb.xml
2010-12-30 22:00:24.748 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:00:24.748 MythTV database schema is old. Waiting to see
if DB is being upgraded.
2010-12-30 22:00:25.748 New DB connection, total: 2
2010-12-30 22:00:25.749 Connected to database 'mythconverg' at host: localhost
2010-12-30 22:00:25.751 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:00:26.753 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:00:27.754 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:00:28.756 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:00:29.757 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:00:29.758 Timed out waiting.
2010-12-30 22:00:29.766 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2010-12-30 22:00:49.381 Database Backup complete.
2010-12-30 22:00:49.381 Backed up database to file:
'/var/lib/mythtv/backups/mythconverg-1257-20101230220029.sql.gz'
2010-12-30 22:00:49.396 Console is non-interactive, can't prompt user...
2010-12-30 22:00:49.396 Upgrading.
2010-12-30 22:00:49.396 Newest MythTV Schema Version : 1264
2010-12-30 22:00:49.400 Upgrading to MythTV schema version 1258
2010-12-30 22:00:49.401 DB Error (Performing database upgrade):
Query was: CREATE TABLE internetcontent ( name VARCHAR(255) NOT NULL,
thumbnail VARCHAR(255),  type SMALLINT(3) NOT NULL,  author
VARCHAR(128) NOT NULL,  description TEXT NOT NULL,  commandline TEXT
NOT NULL,  version DOUBLE NOT NULL,  updated TIMESTAMP NOT NULL,
search BOOL NOT NULL,  tree BOOL NOT NULL,  podcast BOOL NOT NULL,
download BOOL NOT NULL,  host  VARCHAR(128));
Error was: Driver error was [2/1050]:
QMYSQL: Unable to execute query
Database error was:
Table 'internetcontent' already exists

new version: 1258
2010-12-30 22:00:49.401 Database Schema upgrade FAILED, unlocking.
2010-12-30 22:00:49.401 Couldn't upgrade database to new schema
myth at myth-server:~$


More information about the mythtv-users mailing list