[mythtv-users] SegFault - after upgrading to 0.21 - mythtv-setup - HELP

Tue Jun 24 04:53:26 UTC 2008

Hope someone can help me. I'm stuck dead in the water.

I just upgraded to .21 on gentoo and receive a segfault when starting
up mythtv-setup (or any myth app for that matter)

Perhaps it has something to do with this:
====
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.storagegroup' doesn't exist
=====

I also looked for references in the archives to  MSqlQuery since that
was the last message before segfault

I haven't changed anything and it looks like it tried to convert to
the new database format.

Here's the verbose all dump:

========
# mythtv-setup --verbose all
Session management error: Authentication Rejected, reason : None of
the authentication protocols specified are supported and host-based
authentication failed
2008-06-23 21:41:05.569 Using runtime prefix = /usr, libdir = /usr/lib
2008-06-23 21:41:05.583 XScreenSaver support enabled
2008-06-23 21:41:05.583 DPMS is disabled.
2008-06-23 21:41:05.608 Empty LocalHostName.
2008-06-23 21:41:05.608 Using localhost value of killtivo
2008-06-23 21:41:05.611 MCP::DefaultUPnP() - No default UPnP backend
2008-06-23 21:41:05.611 Testing network connectivity to 192.168.0.8
2008-06-23 21:41:05.654 New DB connection, total: 1
2008-06-23 21:41:05.716 Connected to database 'mythconverg' at host: 192.168.0.8
2008-06-23 21:41:05.716 Closing DB connection named 'DBManager0'
2008-06-23 21:41:05.716 Clearing Settings Cache.
2008-06-23 21:41:05.717 Screen 0 dim: 1024x768.
2008-06-23 21:41:05.717 Screen 1 dim: 640x480.
2008-06-23 21:41:05.717 Primary screen 0.
2008-06-23 21:41:05.718 Connected to database 'mythconverg' at host: 192.168.0.8
2008-06-23 21:41:05.719 MSqlQuery: SELECT data FROM settings WHERE
value = 'RunFrontendInWindow' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.719 Using screen 0, 1024x768 at 0,0
2008-06-23 21:41:05.719 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiOffsetX' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.720 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiOffsetY' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.720 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiResolution' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.720 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiResolution' AND hostname IS NULL;
2008-06-23 21:41:05.721 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiWidth' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.721 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiHeight' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.725 Enabling Settings Cache.
2008-06-23 21:41:05.725 Clearing Settings Cache.
2008-06-23 21:41:05.727 MSqlQuery: CREATE TABLE IF NOT EXISTS
schemalock ( schemalock int(1));
2008-06-23 21:41:05.742 MSqlQuery: LOCK TABLE schemalock WRITE;
2008-06-23 21:41:05.744 New DB connection, total: 2
2008-06-23 21:41:05.745 Connected to database 'mythconverg' at host: 192.168.0.8
2008-06-23 21:41:05.745 MSqlQuery: SELECT data FROM settings WHERE
value = 'DBSchemaVer' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.746 MSqlQuery: SELECT data FROM settings WHERE
value = 'DBSchemaVer' AND hostname IS NULL;
2008-06-23 21:41:05.746 MSqlQuery: UNLOCK TABLES;
2008-06-23 21:41:05.746 Current Schema Version: 1160
2008-06-23 21:41:05.746 MSqlQuery: SELECT data FROM settings WHERE
value = 'MythFillFixProgramIDsHasRunOnce' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.747 MSqlQuery: SELECT data FROM settings WHERE
value = 'DBMSVersionOverride' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.747 MSqlQuery: SELECT data FROM settings WHERE
value = 'DBMSVersionOverride' AND hostname IS NULL;
2008-06-23 21:41:05.748 MSqlQuery: SELECT VERSION();
2008-06-23 21:41:05.748 MSqlQuery: DELETE FROM settings WHERE value =
'BackupDBLastRunStart' AND hostname is NULL;
2008-06-23 21:41:05.749 MSqlQuery: INSERT INTO settings
(value,data,hostname ) VALUES ( 'BackupDBLastRunStart', '2008-06-23
21:41:05', NULL );
2008-06-23 21:41:05.749 Clearing Settings Cache.
2008-06-23 21:41:05.749 Clearing Settings Cache.
2008-06-23 21:41:05.749 MSqlQuery: SELECT data FROM settings WHERE
value = 'DBSchemaVer' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.750 MSqlQuery: SELECT data FROM settings WHERE
value = 'DBSchemaVer' AND hostname IS NULL;
2008-06-23 21:41:05.750 MSqlQuery: SELECT DISTINCT dirname FROM
storagegroup WHERE groupname = 'DB Backups' AND hostname = 'killtivo'
2008-06-23 21:41:05.750 DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'DB
Backups' AND hostname = 'killtivo'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2008-06-23 21:41:05.750 New DB connection, total: 3
2008-06-23 21:41:05.751 Connected to database 'mythconverg' at host: 192.168.0.8
2008-06-23 21:41:05.752 MSqlQuery: SELECT data FROM settings WHERE
value = 'RecordFilePrefix' AND hostname = 'killtivo' ;
2008-06-23 21:41:05.752 SG(DB Backups) Error: Directory value for
Default Storage Group is empty.  Using old 'RecordFilePrefix' value of
'/content/video/mythtv'
2008-06-23 21:41:05.763 SG(DB Backups): FindNextDirMostFree: Starting'
2008-06-23 21:41:05.783 SG(DB Backups): FindNextDirMostFree:
'/content/video/mythtv' has 62652312 KiB free
2008-06-23 21:41:05.783 SG(DB Backups): FindNextDirMostFree: Using
'/content/video/mythtv'
2008-06-23 21:41:05.783 Backing up database with command: mysqldump
--defaults-extra-file='/tmp/mythtv_db_backup_conf_6Bv1T9'
--host='192.168.0.8' --user='mythtv' --add-drop-table --add-locks
--allow-keywords --complete-insert --extended-insert --lock-tables
--no-create-db --quick 'mythconverg' >
'/content/video/mythtv/mythconverg-1160-20080623214105.sql'
2>/dev/null
2008-06-23 21:41:05.783 Backing up database to file:
/content/video/mythtv/mythconverg-1160-20080623214105.sql
2008-06-23 21:41:11.664 Compressing database backup file.
2008-06-23 21:41:14.919 Database Backup filename:
/content/video/mythtv/mythconverg-1160-20080623214105.sql.gz
2008-06-23 21:41:14.920 Database Backup complete.
2008-06-23 21:41:14.931 MSqlQuery: DELETE FROM settings WHERE value =
'BackupDBLastRunEnd' AND hostname is NULL;
2008-06-23 21:41:14.933 MSqlQuery: INSERT INTO settings
(value,data,hostname ) VALUES ( 'BackupDBLastRunEnd', '2008-06-23
21:41:14', NULL );
2008-06-23 21:41:14.933 Clearing Settings Cache.
2008-06-23 21:41:14.933 Clearing Settings Cache.
2008-06-23 21:41:14.934 MSqlQuery: DELETE FROM housekeeping WHERE tag
= 'BackupDB' ;
2008-06-23 21:41:14.935 MSqlQuery: INSERT INTO
housekeeping(tag,lastrun) values('BackupDB' ,now()) ;
2008-06-23 21:41:14.935 MSqlQuery: SELECT data FROM settings WHERE
value = 'DBSchemaAutoUpgrade' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.935 MSqlQuery: SELECT data FROM settings WHERE
value = 'DBSchemaAutoUpgrade' AND hostname IS NULL;
2008-06-23 21:41:14.945 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiVidModeResolution' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.946 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiVidModeRefreshRate' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.956 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiVidModeRefreshRate' AND hostname IS NULL;
2008-06-23 21:41:14.957 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiVidModeForceAspect' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.957 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiVidModeForceAspect' AND hostname IS NULL;
2008-06-23 21:41:14.967 MSqlQuery: SELECT data FROM settings WHERE
value = 'DisplaySizeResolution' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.967 MSqlQuery: SELECT data FROM settings WHERE
value = 'DisplaySizeResolution' AND hostname IS NULL;
2008-06-23 21:41:14.967 MSqlQuery: SELECT data FROM settings WHERE
value = 'DisplaySizeWidth' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.968 MSqlQuery: SELECT data FROM settings WHERE
value = 'DisplaySizeWidth' AND hostname IS NULL;
2008-06-23 21:41:14.968 MSqlQuery: SELECT data FROM settings WHERE
value = 'DisplaySizeHeight' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.968 MSqlQuery: SELECT data FROM settings WHERE
value = 'DisplaySizeHeight' AND hostname IS NULL;
2008-06-23 21:41:14.969 MSqlQuery: SELECT data FROM settings WHERE
value = 'TVVidModeResolution' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.969 MSqlQuery: SELECT data FROM settings WHERE
value = 'TVVidModeRefreshRate' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.970 MSqlQuery: SELECT data FROM settings WHERE
value = 'TVVidModeForceAspect' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.970 MSqlQuery: SELECT data FROM settings WHERE
value = 'VidModeResolution0' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.970 MSqlQuery: SELECT data FROM settings WHERE
value = 'VidModeResolution0' AND hostname IS NULL;
2008-06-23 21:41:14.971 MSqlQuery: SELECT data FROM settings WHERE
value = 'VidModeWidth0' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.971 MSqlQuery: SELECT data FROM settings WHERE
value = 'VidModeHeight0' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.972 MSqlQuery: SELECT data FROM settings WHERE
value = 'TVVidModeResolution0' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.972 MSqlQuery: SELECT data FROM settings WHERE
value = 'TVVidModeRefreshRate0' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.973 MSqlQuery: SELECT data FROM settings WHERE
value = 'TVVidModeForceAspect0' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.974 max_width: 1024 max_height: 768
2008-06-23 21:41:14.974 MSqlQuery: SELECT data FROM settings WHERE
value = 'UseVideoModes' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.975 Screen 0 dim: 1024x768.
2008-06-23 21:41:14.975 Screen 1 dim: 640x480.
2008-06-23 21:41:14.975 Primary screen 0.
2008-06-23 21:41:14.976 MSqlQuery: SELECT data FROM settings WHERE
value = 'RunFrontendInWindow' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.976 Using screen 0, 1024x768 at 0,0
2008-06-23 21:41:14.976 MSqlQuery: SELECT data FROM settings WHERE
value = 'Style' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.977 MSqlQuery: SELECT data FROM settings WHERE
value = 'Theme' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.988 Switching to square mode (MythCenter)
2008-06-23 21:41:14.989 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiOffsetX' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.989 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiOffsetY' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.989 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiResolution' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.990 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiResolution' AND hostname IS NULL;
2008-06-23 21:41:14.990 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiWidth' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.990 MSqlQuery: SELECT data FROM settings WHERE
value = 'GuiHeight' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.997 MSqlQuery: SELECT data FROM settings WHERE
value = 'MenuTheme' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.997 MSqlQuery: SELECT data FROM settings WHERE
value = 'QtFontBig' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.998 MSqlQuery: SELECT data FROM settings WHERE
value = 'QtFontMedium' AND hostname = 'killtivo' ;
2008-06-23 21:41:14.998 MSqlQuery: SELECT data FROM settings WHERE
value = 'QtFontSmall' AND hostname = 'killtivo' ;
Segmentation fault

-- 
Brad Fuller
www.bradfuller.com