Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#10750 closed Bug Report - General (fixed)

mythtv-setup fails during initial configuration of a completely new system.

Reported by: Robert Kulagowski Owned by: sphery
Priority: minor Milestone: 0.26
Component: MythTV - Mythtv-setup Version: Master Head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

rkulagow@opti:~$ mythtv-setup 
2012-05-23 13:37:49.237514 C  mythtv-setup version: master [v0.26-pre-365-gfc07bfd-dirty] www.mythtv.org
2012-05-23 13:37:49.237537 C  Qt version: compile: 4.8.1, runtime: 4.8.1
2012-05-23 13:37:49.237542 N  Enabled verbose msgs:  general
2012-05-23 13:37:49.237566 N  Setting Log Level to LOG_INFO
2012-05-23 13:37:49.237623 I  Added logging to the console
2012-05-23 13:37:49.237632 I  Added database logging to table logging
2012-05-23 13:37:49.237721 N  Setting up SIGHUP handler
2012-05-23 13:37:49.237877 N  Using runtime prefix = /usr/local
2012-05-23 13:37:49.237906 N  Using configuration directory = /home/rkulagow/.mythtv
2012-05-23 13:37:49.238324 I  Assumed character encoding: en_US.UTF-8
2012-05-23 13:37:49.238564 E  DBHostName is not set in config.xml
2012-05-23 13:37:49.238584 E  DBHostName is not set in config.xml
2012-05-23 13:37:49.238598 N  Empty LocalHostName.
2012-05-23 13:37:49.238604 I  Using localhost value of opti
2012-05-23 13:37:49.262168 N  Desktop video mode: 1280x1024 60.020 Hz
2012-05-23 13:37:49.494004 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
			eno: No such file or directory (2)
2012-05-23 13:37:49.494049 E  JoystickMenuThread: Joystick disabled - Failed to read /home/rkulagow/.mythtv/joystickmenurc
2012-05-23 13:37:49.494629 I  Binding to UDP 127.0.0.1:0
2012-05-23 13:37:49.494690 I  Binding to UDP 10.244.23.50:0
2012-05-23 13:37:49.494766 I  Binding to UDP [::1]:0
2012-05-23 13:37:49.494846 I  Binding to UDP [fe80::7a2b:cbff:fea9:dcfb%eth0]:0
2012-05-23 13:37:49.494938 I  Binding to UDP 10.244.23.255:0
2012-05-23 13:37:49.506936 I  Using Frameless Window
2012-05-23 13:37:49.506975 I  Using Full Screen Window
2012-05-23 13:37:49.510150 I  Using the Qt painter
2012-05-23 13:37:49.541713 N  Setting QT default locale to en_US
2012-05-23 13:37:49.687943 I  System Locale (en_US), Country (US), Language (en)
2012-05-23 13:37:56.650770 I  Loading en_us translation for module mythfrontend
2012-05-23 13:37:56.656705 N  Setting QT default locale to en_US
2012-05-23 13:37:56.656854 I  Current locale en_US
2012-05-23 13:37:56.656914 N  Reading locale defaults from /usr/local/share/mythtv//locales/en_us.xml
2012-05-23 13:37:56.657246 E  SaveSettingOnHost('FreqTable') - No database yet
2012-05-23 13:37:56.657256 E  SaveSettingOnHost('ISO639Language0') - No database yet
2012-05-23 13:37:56.657262 E  SaveSettingOnHost('ISO639Language1') - No database yet
2012-05-23 13:37:56.657267 E  SaveSettingOnHost('TVFormat') - No database yet
2012-05-23 13:37:56.657272 E  SaveSettingOnHost('VbiFormat') - No database yet
2012-05-23 13:37:56.657282 E  SaveSettingOnHost('Country') - No database yet
2012-05-23 13:37:56.657290 E  SaveSettingOnHost('DateFormat') - No database yet
2012-05-23 13:37:56.657296 E  SaveSettingOnHost('Language') - No database yet
2012-05-23 13:37:56.657303 E  SaveSettingOnHost('MythArchiveDateFormat') - No database yet
2012-05-23 13:37:56.657310 E  SaveSettingOnHost('MythArchiveTimeFormat') - No database yet
2012-05-23 13:37:56.657317 E  SaveSettingOnHost('MythArchiveVideoFormat') - No database yet
2012-05-23 13:37:56.657324 E  SaveSettingOnHost('ShortDateFormat') - No database yet
2012-05-23 13:37:56.657330 E  SaveSettingOnHost('TimeFormat') - No database yet
2012-05-23 13:37:56.657558 I  Starting process manager
2012-05-23 13:37:56.657891 I  Starting process signal handler
2012-05-23 13:37:56.658005 I  Starting IO manager (read)
2012-05-23 13:37:56.660211 I  Starting IO manager (write)
2012-05-23 13:37:56.758227 I  ScreenSaverX11Private: XScreenSaver support enabled
2012-05-23 13:37:56.759037 I  ScreenSaverX11Private: DPMS is disabled.
2012-05-23 13:37:56.769237 E  Error preparing query: SELECT DISTINCT dirname FROM storagegroup WHERE groupname = :GROUP AND hostname = :HOSTNAME
2012-05-23 13:37:56.769256 E  Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2012-05-23 13:37:56.769485 E  DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = :GROUP AND hostname = :HOSTNAME
Bindings were:
:GROUP="Themes", :HOSTNAME="opti"
Driver error was [2/1064]:
QMYSQL: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':GROUP AND hostname = :HOSTNAME' at line 1

2012-05-23 13:37:56.769981 N  Inserting MythTV initial database information.
2012-05-23 13:37:56.770012 C  Upgrading to MythTV schema version 1299
2012-05-23 13:37:56.868577 I  Loading en_us translation for module mythfrontend
2012-05-23 13:37:56.868714 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
			eno: No such file or directory (2)
2012-05-23 13:37:56.868740 E  JoystickMenuThread: Joystick disabled - Failed to read /home/rkulagow/.mythtv/joystickmenurc
2012-05-23 13:37:56.868865 I  Binding to UDP 127.0.0.1:0
2012-05-23 13:37:56.868918 I  Binding to UDP 10.244.23.50:0
2012-05-23 13:37:56.868990 I  Binding to UDP [::1]:0
2012-05-23 13:37:56.869067 I  Binding to UDP [fe80::7a2b:cbff:fea9:dcfb%eth0]:0
2012-05-23 13:37:56.869131 I  Binding to UDP 10.244.23.255:0
2012-05-23 13:37:56.912814 I  Using Frameless Window
2012-05-23 13:37:56.912843 I  Using Full Screen Window
2012-05-23 13:37:56.914966 I  Using the Qt painter
2012-05-23 13:37:56.986255 I  No current database version?
2012-05-23 13:37:56.993775 E  SG(DB Backups): Unable to find any Storage Group Directories.  Using hardcoded default value of '/mnt/store'
2012-05-23 13:37:56.993817 E  SG(DB Backups): FindNextDirMostFree: '/mnt/store' does not exist!
2012-05-23 13:37:56.993970 E  Backing up database with script: '/usr/local/share/mythtv/mythconverg_backup.pl'
2012-05-23 13:37:57.359067 C  Database Backup complete.
2012-05-23 13:37:57.359576 C  Backed up database to file: '/tmp/mythconverg--20120523133756.sql.gz'
2012-05-23 13:38:04.612205 E  Unrecognized database schema version. Unable to upgrade database.
2012-05-23 13:38:04.612221 E  Database schema upgrade failed.
2012-05-23 13:38:04.612596 E  Couldn't upgrade database to new schema.

Change History (3)

comment:1 Changed 12 years ago by sphery

Owner: changed from danielk to sphery
Status: newaccepted

This is due to the changes in 8cbf33b0e6 . Without the Schema Wizard managing the initialization/upgrade of the database, we can currently only "successfully" create a new DB schema if the current DB schema is the one created by InitializeMythSchema?() (formerly InitializeDatabase?()). This will be fixed, but I haven't decided how, yet (meaning whether I'll get time to do the proper fix in the near future or have to settle for a workaround).

That said, in spite of the "failure" and mythtv-setup's shutting down, everything worked properly during the upgrade and by restarting mythtv-setup, you'll then be able to configure your system and all will work.

comment:2 Changed 12 years ago by Michael T. Dean <mdean@…>

Resolution: fixed
Status: acceptedclosed

In 0fc12e4a206a2c4a0877f79673488daac1c9dc30/mythtv:

Allow DB schema use after InitializeMythSchema?()

This seems to have been overlooked in 75cf4e4b439 . Fixes #10750.

comment:3 Changed 12 years ago by Raymond Wagner

Milestone: unknown0.26
Note: See TracTickets for help on using tickets.