[mythtv-users] mysql borked after upgrade to 0.18.1

Tom Hines tomhines at gmail.com
Wed Jul 6 09:41:33 EDT 2005


Hello.  I just tried to upgrade my mythv from 0.17 to 0.18.1 with
"apt-get install mythtv-suite", but the mysql schema upgrade failed
and now mysql is borked and mythbackend won't run.  From
mythbackend.log:

----------
2005-07-06 08:54:49.366 New DB connection, total: 1
2005-07-06 08:54:49.641 Setting Lock for Database Schema upgrade. If you see a l
ong pause here it means the Schema is already locked and is being upgraded by an
other Myth process.
2005-07-06 08:54:49.709 New DB connection, total: 2
2005-07-06 08:54:49.714 Upgrading to schema version 1072
2005-07-06 08:54:49.797 DB Error (Performing database upgrade): 
Query was: ALTER TABLE program ADD COLUMN manualid INT UNSIGNED NOT NULL DEFAULT
 0; 
Error was: Driver error was [2/1016]:
QMYSQL3: Unable to execute query
Database error was:
Can't open file: 'program.MYD'. (errno: 145)
 
new version: 1072
2005-07-06 08:54:49.815 Database Schema upgrade FAILED, unlocking.
2005-07-06 08:54:49.827 Couldn't upgrade database to new schema
----------

I have these installed:

mysql-server-3.23.58-16.FC3.1
mysql-3.23.58-16.FC3.1
php-mysql-4.3.11-2.6
libdbi-dbd-mysql-0.6.5-9
mysql-devel-3.23.58-16.FC3.1

uname -a
Linux tomvo.tomhines.net 2.6.11-1.27_FC3 #1 Tue May 17 20:27:37 EDT
2005 i686 i686 i386 GNU/Linux

Running FC3 on a VIA M 10K

Anyone know what went wrong?  Or how I can fix it other than
rebuilding the database?

Thanks,
Tom


More information about the mythtv-users mailing list