[mythtv-users] mythtv schema upgrade, from v1227 -> v1264, FAILs @ v1262: "Data truncated for column 'data' at row 1"

dch8758 at eml.cc dch8758 at eml.cc
Mon Jan 9 20:22:26 UTC 2012


i'm setting up a standalone mythbackend on a remote server.

on the server,

	uname -rmo
		3.1.0-1.2-xen x86_64 GNU/Linux
	lsb_release -dir
		Distributor ID: SUSE LINUX
		Description:    openSUSE 12.1 (x86_64)
		Release:        12.1
	rpm -qa | grep -i myth
		libmyth-0_24-0.24.1-6.2.x86_64
		mythtv-0_24-backend-0.24.1-6.2.x86_64
		mythtv-0_24-common-0.24.1-6.2.x86_64

i've setup the DB, and granted permissions.

@ my desktop,

	uname -rmo
		3.1.0-1.2-desktop x86_64 GNU/Linux
	lsb_release -dir
		Distributor ID: SUSE LINUX
		Description:    openSUSE 12.1 (x86_64)
		Release:        12.1
	rpm -qa | grep -i myth-setup
		mythtv-0_24-setup-0.24.1-6.2.x86_64

i exec myth-setup.  it connects as expected to the remote backend.

i'm notified that the schema's outdated, and init the offered upgrade
from v1227 -> v1264.  the process gets as far as schema v1261 then dies:

	mythtv-setup
		2012-01-09 08:11:38.113 Using runtime prefix = /usr
		2012-01-09 08:11:38.113 Using configuration directory =
		/home/dch/.mythtv
		2012-01-09 08:11:38.114 Using localhost value of
		dchDesk.home.loc
		2012-01-09 08:11:38.114 Testing network connectivity to
		'mediascr.home.loc'
		2012-01-09 08:11:38.267 New DB connection, total: 1
		2012-01-09 08:11:38.271 Connected to database
		'mythtv_db' at host: mediascr.home.loc
		2012-01-09 08:11:38.277 Closing DB connection named
		'DBManager0'
		2012-01-09 08:11:38.278 Connected to database
		'mythtv_db' at host: mediascr.home.loc
		2012-01-09 08:11:38.281 Current locale en_US
		2012-01-09 08:11:38.281 Reading locale defaults from
		/usr/share/mythtv//locales/en_us.xml
		2012-01-09 08:11:38.518 ScreenSaverX11Private:
		XScreenSaver support enabled
		2012-01-09 08:11:38.519 ScreenSaverX11Private: Gnome
		screen saver support enabled
		2012-01-09 08:11:38.520 DPMS is active.
		2012-01-09 08:11:38.774 Desktop video mode: 1920x1080
		60.000 Hz
		2012-01-09 08:11:38.829 Loading en_us translation for
		module mythfrontend
		2012-01-09 08:11:38.921 Using Frameless Window
		2012-01-09 08:11:38.921 Using Full Screen Window
		2012-01-09 08:11:38.929 Using the Qt painter
		2012-01-09 08:11:39.669 Current MythTV Schema Version
		(DBSchemaVer): 1226
		2012-01-09 08:11:39.669 MythTV database schema is old.
		Waiting to see if DB is being upgraded.
		2012-01-09 08:11:40.669 New DB connection, total: 2
		2012-01-09 08:11:40.671 Connected to database
		'mythtv_db' at host: mediascr.home.loc
		2012-01-09 08:11:40.677 Waiting for Database Backup to
		complete.
		2012-01-09 08:11:41.681 Waiting for Database Backup to
		complete.
		2012-01-09 08:11:42.686 Waiting for Database Backup to
		complete.
		2012-01-09 08:11:43.690 Waiting for Database Backup to
		complete.
		2012-01-09 08:11:44.694 Waiting for Database Backup to
		complete.
		2012-01-09 08:11:45.699 Waiting for Database Backup to
		complete.
		2012-01-09 08:11:45.699 Timed out waiting.
		2012-01-09 08:11:45.723 SG(DB Backups) Error: Unable to
		find any Storage Group Directories.  Using hardcoded
		default value of '/mnt/store'
		2012-01-09 08:11:45.723 SG(DB Backups) Error:
		FindNextDirMostFree: '/mnt/store' does not exist!
		2012-01-09 08:11:45.727 Backing up database with script:
		'/usr/share/mythtv/mythconverg_backup.pl'
		2012-01-09 08:11:46.138 Database Backup complete.
		2012-01-09 08:11:46.140 Backed up database to file:
		'/tmp/mythtv_db-1226-20120109081145.sql.gz'
		2012-01-09 08:11:57.572 Newest MythTV Schema Version :
		1264
		2012-01-09 08:11:57.581 Upgrading to MythTV schema
		version 1227
		2012-01-09 08:11:58.054 New DB connection, total: 3
		2012-01-09 08:11:58.056 Connected to database
		'mythtv_db' at host: mediascr.home.loc
		2012-01-09 08:11:58.059 Upgrading to MythTV schema
		version 1228
		...
		2012-01-09 08:12:02.799 Upgrading to MythTV schema
		version 1236
		2012-01-09 08:12:02.799 New DB connection, total: 4
		2012-01-09 08:12:02.805 Connected to database
		'mythtv_db' at host: mediascr.home.loc
		2012-01-09 08:12:02.808 Upgrading to MythTV schema
		version 1237
		...
		2012-01-09 08:12:11.267 Upgrading to MythTV schema
		version 1261
		2012-01-09 08:12:11.271 Upgrading to MythTV schema
		version 1262
		2012-01-09 08:12:15.150 DB Error (Performing database
		upgrade):
		Query was: ALTER TABLE settings MODIFY COLUMN data
		VARCHAR(16000)     NOT NULL default '';
		Error was: Driver error was [2/1265]:
		QMYSQL: Unable to execute query
		Database error was:
		Data truncated for column 'data' at row 1

		new version: 1262
		2012-01-09 08:12:15.150 Database Schema upgrade FAILED,
		unlocking.
		2012-01-09 08:12:15.151 Couldn't upgrade database to new
		schema.

how can I workaround the broken schema upgrade step?

dch


More information about the mythtv-users mailing list