[mythtv-users] dataase wont upgrade
Richard Morton
richard.e.morton at gmail.com
Thu Dec 30 23:54:02 UTC 2010
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:~$
$ sudo mythbackend --verbose database
[sudo] password for myth:
2010-12-30 22:21:55.536 mythbackend version: fixes/0.24 [2f3a2f8] www.mythtv.org
2010-12-30 22:21:55.536 Using runtime prefix = /usr
2010-12-30 22:21:55.536 Using configuration directory = /home/myth/.mythtv
2010-12-30 22:21:55.536 Empty LocalHostName.
2010-12-30 22:21:55.537 Using localhost value of myth-server
2010-12-30 22:21:55.537 Clearing Settings Cache.
2010-12-30 22:21:55.537 Clearing Settings Cache.
2010-12-30 22:21:55.544 New DB connection, total: 1
2010-12-30 22:21:55.547 Connected to database 'mythconverg' at host: localhost
2010-12-30 22:21:55.551 Closing DB connection named 'DBManager0'
2010-12-30 22:21:55.551 Clearing Settings Cache.
2010-12-30 22:21:55.551 Connected to database 'mythconverg' at host: localhost
2010-12-30 22:21:55.552 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'language' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-30 22:21:55.553 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'country' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-30 22:21:55.553 Current locale EN_GB
2010-12-30 22:21:55.553 Reading locale defaults from
/usr/share/mythtv//locales/en_gb.xml
2010-12-30 22:21:55.554 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'freqtable' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:21:55.554 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'freqtable' AND hostname IS NULL <<<< Returns 1
row(s)
2010-12-30 22:21:55.554 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'iso639language0' AND hostname = 'myth-server'
<<<< Returns 1 row(s)
2010-12-30 22:21:55.555 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'iso639language1' AND hostname = 'myth-server'
<<<< Returns 1 row(s)
2010-12-30 22:21:55.555 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'tvformat' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:21:55.555 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'tvformat' AND hostname IS NULL <<<< Returns 1
row(s)
2010-12-30 22:21:55.556 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'vbiformat' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:21:55.556 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'vbiformat' AND hostname IS NULL <<<< Returns 1
row(s)
2010-12-30 22:21:55.556 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'prefdupmethod' AND hostname = 'myth-server'
<<<< Returns 0 row(s)
2010-12-30 22:21:55.557 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'prefdupmethod' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-30 22:21:55.557 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'country' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-30 22:21:55.557 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dateformat' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-30 22:21:55.557 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'enablemheg' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-30 22:21:55.558 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'language' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-30 22:21:55.558 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'mytharchivevideoformat' AND hostname =
'myth-server' <<<< Returns 1 row(s)
2010-12-30 22:21:55.558 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'shortdateformat' AND hostname = 'myth-server'
<<<< Returns 1 row(s)
2010-12-30 22:21:55.559 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'timeformat' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-30 22:21:55.559 Enabling Settings Cache.
2010-12-30 22:21:55.559 Clearing Settings Cache.
2010-12-30 22:21:55.559 Disabling Settings Cache.
2010-12-30 22:21:55.559 Clearing Settings Cache.
2010-12-30 22:21:55.559 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaautoupgrade' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:21:55.560 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaautoupgrade' AND hostname IS NULL <<<<
Returns 0 row(s)
2010-12-30 22:21:55.560 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:21:55.560 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-30 22:21:55.560 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:21:55.560 MythTV database schema is old. Waiting to see
if DB is being upgraded.
2010-12-30 22:21:56.560 New DB connection, total: 2
2010-12-30 22:21:56.561 Connected to database 'mythconverg' at host: localhost
2010-12-30 22:21:56.561 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:21:56.562 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-30 22:21:56.562 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:21:56.563 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-30 22:21:56.563 DBUtil::BackupInProgress(): Found database
backup end time of 2010-12-30T22:00:49 later than start time of
2010-12-30T22:00:29, therefore backup is not running.
2010-12-30 22:21:56.563 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-30 22:21:56.563 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-30 22:21:56.563 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:21:56.564 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-30 22:21:56.564 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:21:56.564 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-30 22:21:57.564 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:21:57.564 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-30 22:21:57.565 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:21:57.565 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-30 22:21:57.565 DBUtil::BackupInProgress(): Found database
backup end time of 2010-12-30T22:00:49 later than start time of
2010-12-30T22:00:29, therefore backup is not running.
2010-12-30 22:21:57.565 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-30 22:21:57.565 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-30 22:21:57.566 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:21:57.566 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-30 22:21:57.566 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:21:57.566 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-30 22:21:58.566 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:21:58.567 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-30 22:21:58.567 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:21:58.567 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-30 22:21:58.567 DBUtil::BackupInProgress(): Found database
backup end time of 2010-12-30T22:00:49 later than start time of
2010-12-30T22:00:29, therefore backup is not running.
2010-12-30 22:21:58.568 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-30 22:21:58.568 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-30 22:21:58.568 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:21:58.568 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-30 22:21:58.568 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:21:58.568 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-30 22:21:59.569 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:21:59.569 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-30 22:21:59.569 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:21:59.570 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-30 22:21:59.570 DBUtil::BackupInProgress(): Found database
backup end time of 2010-12-30T22:00:49 later than start time of
2010-12-30T22:00:29, therefore backup is not running.
2010-12-30 22:21:59.570 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-30 22:21:59.570 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-30 22:21:59.570 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:21:59.570 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-30 22:21:59.570 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:21:59.571 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-30 22:22:00.571 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:22:00.571 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-30 22:22:00.572 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:22:00.572 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-30 22:22:00.572 DBUtil::BackupInProgress(): Found database
backup end time of 2010-12-30T22:00:49 later than start time of
2010-12-30T22:00:29, therefore backup is not running.
2010-12-30 22:22:00.572 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-30 22:22:00.572 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-30 22:22:00.572 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:22:00.573 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-30 22:22:00.573 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 22:22:00.573 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-30 22:22:00.573 Timed out waiting.
2010-12-30 22:22:00.574 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'disableautomaticbackup' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:22:00.574 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'disableautomaticbackup' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-30 22:22:00.576 MSqlQuery::exec(DBManager0) SELECT CONCAT('`',
INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA, '`.`',
INFORMATION_SCHEMA.TABLES.TABLE_NAME, '`') AS
`TABLE_NAME` FROM INFORMATION_SCHEMA.TABLES WHERE
INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA = DATABASE() AND
INFORMATION_SCHEMA.TABLES.TABLE_TYPE = 'BASE TABLE' <<<< Returns 110
row(s)
2010-12-30 22:22:00.577 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'databasebackupscript' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:22:00.577 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'databasebackupscript' AND hostname IS NULL
<<<< Returns 0 row(s)
2010-12-30 22:22:00.578 MSqlQuery::exec(DBManager1) DELETE FROM
settings WHERE value = 'BackupDBLastRunStart' AND hostname is NULL;
2010-12-30 22:22:00.578 MSqlQuery::exec(DBManager1) INSERT INTO
settings (value,data ) VALUES ( 'BackupDBLastRunStart', '2010-12-30
22:22:00' );
2010-12-30 22:22:00.579 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:22:00.579 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-30 22:22:00.580 MSqlQuery::exec(DBManager1) SELECT DISTINCT
dirname FROM storagegroup WHERE groupname = 'DB Backups' AND hostname
= 'myth-server' <<<< Returns 1 row(s)
2010-12-30 22:22:00.581 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdbscriptargs' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:22:00.581 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdbscriptargs' AND hostname IS NULL <<<<
Returns 0 row(s)
2010-12-30 22:22:00.581 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:22:00.582 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-30 22:22:00.582 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2010-12-30 22:22:19.197 Database Backup complete.
2010-12-30 22:22:19.198 Backed up database to file:
'/var/lib/mythtv/backups/mythconverg-1257-20101230222200.sql.gz'
2010-12-30 22:22:19.199 MSqlQuery::exec(DBManager1) DELETE FROM
settings WHERE value = 'BackupDBLastRunEnd' AND hostname is NULL;
2010-12-30 22:22:19.199 MSqlQuery::exec(DBManager1) INSERT INTO
settings (value,data ) VALUES ( 'BackupDBLastRunEnd', '2010-12-30
22:22:19' );
2010-12-30 22:22:19.200 MSqlQuery::exec(DBManager0) DELETE FROM
housekeeping WHERE tag = 'BackupDB' ;
2010-12-30 22:22:19.200 MSqlQuery::exec(DBManager0) INSERT INTO
housekeeping(tag,lastrun) values('BackupDB' ,now()) ;
2010-12-30 22:22:19.212 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbmsversionoverride' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-30 22:22:19.213 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbmsversionoverride' AND hostname IS NULL <<<<
Returns 0 row(s)
2010-12-30 22:22:19.213 MSqlQuery::exec(DBManager0) SELECT VERSION();
<<<< Returns 1 row(s)
2010-12-30 22:22:19.213 Console is non-interactive, can't prompt user...
2010-12-30 22:22:19.213 Upgrading.
2010-12-30 22:22:19.214 MSqlQuery::exec(DBManager1) ALTER DATABASE
mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
2010-12-30 22:22:19.214 Newest MythTV Schema Version : 1264
2010-12-30 22:22:19.214 MSqlQuery::exec(DBManager1) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-30 22:22:19.214 MSqlQuery::exec(DBManager1) LOCK TABLE schemalock WRITE;
2010-12-30 22:22:19.215 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-30 22:22:19.215 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-30 22:22:19.218 MSqlQuery::exec(DBManager0) SELECT CONCAT('`',
INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA, '`.`',
INFORMATION_SCHEMA.TABLES.TABLE_NAME, '`') AS
`TABLE_NAME` FROM INFORMATION_SCHEMA.TABLES WHERE
INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA = DATABASE() AND
INFORMATION_SCHEMA.TABLES.TABLE_TYPE = 'BASE TABLE' <<<< Returns 110
row(s)
2010-12-30 22:22:19.218 Upgrading to MythTV schema version 1258
2010-12-30 22:22:19.218 MSqlQuery::exec(DBManager0) 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));
2010-12-30 22:22:19.218 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:22:19.218 Database Schema upgrade FAILED, unlocking.
2010-12-30 22:22:19.219 MSqlQuery::exec(DBManager1) UNLOCK TABLES;
2010-12-30 22:22:19.219 Enabling Settings Cache.
2010-12-30 22:22:19.219 Clearing Settings Cache.
2010-12-30 22:22:19.219 Couldn't upgrade database to new schema
2010-12-30 22:22:19.219 Destroying MythDBPrivate
myth at myth-server:~$
More information about the mythtv-users
mailing list