[mythtv-users] Myth Database Upgrade failed preventing 0.22 from starting on gentoo.

John Drescher drescherjm at gmail.com
Sat Dec 5 18:07:36 UTC 2009


I am having problems upgrading my database on gentoo for 0.22 because
it appears mythbackend is causing my database to go back from latin1
to utf8

jmd0 mythtv # mysql -umythtv -pmythtv mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.84-log Gentoo Linux mysql-5.0.84-r1

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> DROP DATABASE mythconverg;
Query OK, 111 rows affected (0.08 sec)

mysql> CREATE DATABASE mythconverg;
Query OK, 1 row affected (0.00 sec)

mysql> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
Query OK, 1 row affected (0.00 sec)

mysql> exit
Bye

jmd0 mythtv # mysql -umythtv -p mythconverg -e 'status;'
Enter password:
--------------
mysql  Ver 14.12 Distrib 5.0.84, for pc-linux-gnu (x86_64) using readline 5.2

Connection id:          9
Current database:       mythconverg
Current user:           mythtv at localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.84-log Gentoo Linux mysql-5.0.84-r1
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 6 min 21 sec

Threads: 1  Questions: 1312  Slow queries: 0  Opens: 523  Flush
tables: 1  Open tables: 1  Queries per second avg: 3.444
--------------

jmd0 mythtv # ~john/scripts/mythconverg_restore.pl --filename
mythconverg-to_uncorrupt.sql

Successfully restored backup.
jmd0 mythtv # mysql -umythtv -p mythconverg -e 'status;'
Enter password:
--------------
mysql  Ver 14.12 Distrib 5.0.84, for pc-linux-gnu (x86_64) using readline 5.2

Connection id:          12
Current database:       mythconverg
Current user:           mythtv at localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.84-log Gentoo Linux mysql-5.0.84-r1
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 7 min 37 sec

Threads: 1  Questions: 2578  Slow queries: 0  Opens: 749  Flush
tables: 1  Open tables: 5  Queries per second avg: 5.641
--------------


jmd0 mythtv # mythbackend
2009-12-05 13:05:09.643 mythbackend version:
branches/release-0-22-fixes [exported] www.mythtv.org
2009-12-05 13:05:09.644 Using runtime prefix = /usr
2009-12-05 13:05:09.644 Using configuration directory = /root/.mythtv
2009-12-05 13:05:09.644 Using localhost value of jmd0
2009-12-05 13:05:09.648 New DB connection, total: 1
2009-12-05 13:05:09.652 Connected to database 'mythconverg' at host: jmd0
2009-12-05 13:05:09.652 Closing DB connection named 'DBManager0'
2009-12-05 13:05:09.652 Connected to database 'mythconverg' at host: jmd0
2009-12-05 13:05:09.655 Current MythTV Schema Version (DBSchemaVer): 1215
2009-12-05 13:05:09.655 MythTV database schema is old. Waiting to see
if DB is being upgraded.
2009-12-05 13:05:10.655 New DB connection, total: 2
2009-12-05 13:05:10.656 Connected to database 'mythconverg' at host: jmd0
2009-12-05 13:05:10.658 Current MythTV Schema Version (DBSchemaVer): 1215
2009-12-05 13:05:11.660 Current MythTV Schema Version (DBSchemaVer): 1215
2009-12-05 13:05:12.663 Current MythTV Schema Version (DBSchemaVer): 1215
2009-12-05 13:05:13.665 Current MythTV Schema Version (DBSchemaVer): 1215
2009-12-05 13:05:14.667 Current MythTV Schema Version (DBSchemaVer): 1215
2009-12-05 13:05:14.667 Timed out waiting.
2009-12-05 13:05:14.674 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd0_vg_0/videos' does not exist!
2009-12-05 13:05:14.675 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg1_1/videos' does not exist!
2009-12-05 13:05:14.675 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg_1/videos' does not exist!
2009-12-05 13:05:14.818 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg1_2/videos' does not exist!
2009-12-05 13:05:14.818 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg2_1/videos' does not exist!
2009-12-05 13:05:14.819 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg3_1/videos' does not exist!
2009-12-05 13:05:14.819 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg3_2/videos' does not exist!
2009-12-05 13:05:15.450 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2009-12-05 13:05:25.771 Database Backup complete.
2009-12-05 13:05:25.773 Backed up database to file:
'/mnt/mythtv/jmd0_vg_2t0_1/videos/mythconverg-1215-20091205130515.sql.gz'

Warning: MythTV wants to upgrade your database,
for the TV schema, from 1215 to 1244.

Database Host: jmd0
Database Name: mythconverg

If your system becomes unstable, a database backup is located in
/mnt/mythtv/jmd0_vg_2t0_1/videos/mythconverg-1215-20091205130515.sql.gz


Shall I upgrade this database? [yes]
2009-12-05 13:05:27.059 Newest MythTV Schema Version : 1244
2009-12-05 13:05:27.345 Database corruption detected. Unable to
proceed with database upgrade. (Table: people, Warnings: 289)
2009-12-05 13:05:27.345 Your database must be fixed before you can
upgrade beyond 0.21-fixes. Please see
http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding for
information on fixing your database.
2009-12-05 13:05:27.345 Database Schema upgrade FAILED, unlocking.
2009-12-05 13:05:27.345 Couldn't upgrade database to new schema
jmd0 mythtv # mysql -umythtv -p mythconverg -e 'status;'
Enter password:
--------------
mysql  Ver 14.12 Distrib 5.0.84, for pc-linux-gnu (x86_64) using readline 5.2

Connection id:          18
Current database:       mythconverg
Current user:           mythtv at localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.84-log Gentoo Linux mysql-5.0.84-r1
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 8 min 53 sec

Threads: 1  Questions: 3763  Slow queries: 0  Opens: 1205  Flush
tables: 1  Open tables: 64  Queries per second avg: 7.060



-- 
John M. Drescher


More information about the mythtv-users mailing list