[mythtv-users] Mysql problem upgrading from 0.18 -> 0.19

Rod Rod at Rods.id.au
Wed Feb 15 23:42:05 UTC 2006


Hello

I cannot get mythbackend to start, MySQL keeps barfing with the 
following problem

> 2006-02-16 05:36:24.375 Using runtime prefix = /usr
> 2006-02-16 05:36:24.800 New DB connection, total: 1
> 2006-02-16 05:36:24.971 Connected to database 'mythconverg' at host: 
> localhost
> 2006-02-16 05:36:25.210 Enabling Settings Cache.
> 2006-02-16 05:36:25.261 Clearing Settings Cache.
> 2006-02-16 05:36:25.261 Disabling Settings Cache.
> 2006-02-16 05:36:25.262 Clearing Settings Cache.
> 2006-02-16 05:36:25.433 MSqlQuery: SELECT data FROM settings WHERE 
> value  = 'DBS
> chemaVer' AND hostname = 'shadow' ;
> 2006-02-16 05:36:25.462 MSqlQuery: SELECT data FROM settings WHERE 
> value = 'DBSchemaVer' AND hostname IS NULL;
> 2006-02-16 05:36:25.470 Current Schema Version: 1099
> 2006-02-16 05:36:25.471 MSqlQuery: ALTER DATABASE mythconverg DEFAULT 
> CHARACTER SET latin1;
> 2006-02-16 05:36:25.473 Newest Schema Version : 1123
> 2006-02-16 05:36:25.474 New DB connection, total: 2
> 2006-02-16 05:36:25.478 Connected to database 'mythconverg' at host: 
> localhost
> 2006-02-16 05:36:25.504 MSqlQuery: CREATE TABLE IF NOT EXISTS 
> schemalock ( schemalock int(1));
> 2006-02-16 05:36:25.505 Setting Lock for Database Schema upgrade. If 
> you see a long pause here it means the Schema is alre
> ady locked and is being upgraded by another Myth process.
> 2006-02-16 05:36:25.527 MSqlQuery: LOCK TABLE schemalock WRITE;
> 2006-02-16 05:36:25.536 New DB connection, total: 3
> 2006-02-16 05:36:25.540 Connected to database 'mythconverg' at host: 
> localhost
> 2006-02-16 05:36:25.542 MSqlQuery: SELECT data FROM settings WHERE 
> value  = 'DBSchemaVer' AND hostname = 'shadow' ;
> 2006-02-16 05:36:25.543 MSqlQuery: SELECT data FROM settings WHERE 
> value = 'DBSchemaVer' AND hostname IS NULL;
> 2006-02-16 05:36:25.584 Upgrading to schema version 1100
> 2006-02-16 05:36:25.642 MSqlQuery: ALTER TABLE videosource ADD COLUMN 
> useeit SMALLINT NOT NULL DEFAULT 0;
> 2006-02-16 05:36:25.709 DB Error (Performing database upgrade):
> Query was: ALTER TABLE videosource ADD COLUMN useeit SMALLINT NOT NULL 
> DEFAULT 0;
> Error was: Driver error was [2/1067]:
> QMYSQL3: Unable to execute query
> Database error was:
> Invalid default value for 'freqtable'
>
> new version: 1100
> 2006-02-16 05:36:25.714 Database Schema upgrade FAILED, unlocking.
> 2006-02-16 05:36:25.715 MSqlQuery: UNLOCK TABLES;
> 2006-02-16 05:36:25.716 Couldn't upgrade database to new schema


    At this point, Mythbackend shuts down.

    mysql version is mysql-500

mysqlrepair mythconverg

    This gives no errors.



More information about the mythtv-users mailing list