[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