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

Tue Jun 24 05:25:52 UTC 2008

On Mon, Jun 23, 2008 at 9:53 PM, Brad Fuller <bradallenfuller at gmail.com> wrote:
> 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
===========================

looking thru this, it doesn't look like the dB was converted.

-- 
Brad Fuller
www.bradfuller.com