[mythtv-users] dataase wont upgrade
Richard Morton
richard.e.morton at gmail.com
Thu Dec 30 23:55:19 UTC 2010
On 30 December 2010 23:54, Richard Morton <richard.e.morton at gmail.com> wrote:
> 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:~$
>
myth at myth-server:~$ sudo mythbackend
[sudo] password for myth:
2010-12-30 21:38:18.430 mythbackend version: fixes/0.24 [2f3a2f8] www.mythtv.org
2010-12-30 21:38:18.430 Using runtime prefix = /usr
2010-12-30 21:38:18.430 Using configuration directory = /home/myth/.mythtv
2010-12-30 21:38:18.440 Empty LocalHostName.
2010-12-30 21:38:18.440 Using localhost value of myth-server
2010-12-30 21:38:18.462 New DB connection, total: 1
2010-12-30 21:38:18.464 Connected to database 'mythconverg' at host: localhost
2010-12-30 21:38:18.469 Closing DB connection named 'DBManager0'
2010-12-30 21:38:18.469 Connected to database 'mythconverg' at host: localhost
2010-12-30 21:38:18.470 Current locale EN_GB
2010-12-30 21:38:18.470 Reading locale defaults from
/usr/share/mythtv//locales/en_gb.xml
2010-12-30 21:38:18.476 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:38:18.476 MythTV database schema is old. Waiting to see
if DB is being upgraded.
2010-12-30 21:38:19.476 New DB connection, total: 2
2010-12-30 21:38:19.476 Connected to database 'mythconverg' at host: localhost
2010-12-30 21:38:19.479 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:38:20.480 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:38:21.482 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:38:22.483 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:38:23.485 Current MythTV Schema Version (DBSchemaVer): 1257
2010-12-30 21:38:23.485 Timed out waiting.
2010-12-30 21:38:23.494 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2010-12-30 21:38:48.718 Database Backup complete.
2010-12-30 21:38:48.719 Backed up database to file:
'/var/lib/mythtv/backups/mythconverg-1257-20101230213823.sql.gz'
2010-12-30 21:38:48.733 Console is non-interactive, can't prompt user...
2010-12-30 21:38:48.733 Upgrading.
2010-12-30 21:38:48.733 Newest MythTV Schema Version : 1264
2010-12-30 21:38:48.736 Upgrading to MythTV schema version 1258
2010-12-30 21:38:48.736 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:38:48.736 Database Schema upgrade FAILED, unlocking.
2010-12-30 21:38:48.736 Couldn't upgrade database to new schema
More information about the mythtv-users
mailing list