[mythtv-users] db upgrade ? please help :)
fordy ydrof
fordy at ydrof.com
Sat Sep 21 18:37:18 UTC 2013
i think my last email can be safely ignored (sorry). I re-deleted
mythconverg and copied it over again from the backup and this time set the
permissions to mysql:mysql -- the output of mythtvsetup is below. and
again, I'd apprecate any help:) thanks
[myth at totally ~]$ mythtvsetup
2013-09-21 11:31:25.979816 I Setup Interrupt handler
2013-09-21 11:31:25.979835 I Setup Terminated handler
2013-09-21 11:31:25.979848 I Setup Segmentation fault handler
2013-09-21 11:31:25.979860 I Setup Aborted handler
2013-09-21 11:31:25.979871 I Setup Bus error handler
2013-09-21 11:31:25.979883 I Setup Floating point exception handler
2013-09-21 11:31:25.979895 I Setup Illegal instruction handler
2013-09-21 11:31:25.979920 I Setup Real-time signal 0 handler
2013-09-21 11:31:25.980019 C mythtv-setup version: fixes/0.26
[0.26.0-9.fc19 (v0.26.0-153-gb02d25a)] www.mythtv.org
2013-09-21 11:31:25.980027 C Qt version: compile: 4.8.4, runtime: 4.8.5
2013-09-21 11:31:25.980032 N Enabled verbose msgs: general
2013-09-21 11:31:25.980040 N Setting Log Level to LOG_INFO
2013-09-21 11:31:25.980359 N Using runtime prefix = /usr
2013-09-21 11:31:25.980377 N Using configuration directory =
/home/myth/.mythtv
2013-09-21 11:31:25.980491 I Assumed character encoding: en_GB.utf8
2013-09-21 11:31:25.980502 I Added logging to the console
2013-09-21 11:31:25.980505 W This application expects to be running a
locale that specifies a UTF-8 codeset, and many features may behave
improperly with your current language settings. Please set the LC_ALL or
LC_CTYPE, and LANG variable(s) in the environment in which this program is
executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
2013-09-21 11:31:25.980974 N Empty LocalHostName.
2013-09-21 11:31:25.980981 I Using localhost value of totally
2013-09-21 11:31:25.999983 N Setting QT default locale to EN_US
2013-09-21 11:31:26.000070 I Current locale EN_US
2013-09-21 11:31:26.000114 N Reading locale defaults from
/usr/share/mythtv//locales/en_us.xml
2013-09-21 11:31:26.008137 I Starting process manager
2013-09-21 11:31:26.008156 I Starting process signal handler
2013-09-21 11:31:26.012650 I Starting IO manager (read)
2013-09-21 11:31:26.012792 I Starting IO manager (write)
2013-09-21 11:31:26.109240 I ScreenSaverX11Private: DPMS is active.
2013-09-21 11:31:26.123847 N Desktop video mode: 3840x1200 60.000 Hz
2013-09-21 11:31:26.209334 I Added logging to mythlogserver at TCP:35327
2013-09-21 11:31:26.574544 W MythUIHelper: No theme dir:
'/usr/share/mythtv/themes/metallurgy'
2013-09-21 11:31:26.574556 E MythUIHelper: Could not find theme:
metallurgy - Switching to Terra
2013-09-21 11:31:26.578248 I Loading en_us translation for module
mythfrontend
2013-09-21 11:31:26.578680 E LIRC: Failed to connect to Unix socket
'/var/run/lirc/lircd'
eno: No such file or directory (2)
2013-09-21 11:31:26.578707 E JoystickMenuThread: Joystick disabled -
Failed to read /home/myth/.mythtv/joystickmenurc
2013-09-21 11:31:26.578714 I UDPListener: Enabling
2013-09-21 11:31:26.581518 I Binding to UDP 127.0.0.1:6948
2013-09-21 11:31:26.581624 I Binding to UDP 192.168.1.200:6948
2013-09-21 11:31:26.581841 I Binding to UDP [::1]:6948
2013-09-21 11:31:26.582073 I Binding to UDP [2001:470:67:368::49]:6948
2013-09-21 11:31:26.582298 I Binding to UDP
[fe80::21b:fcff:fed2:a6be%em1]:6948
2013-09-21 11:31:26.582407 I Binding to UDP 192.168.1.255:6948
2013-09-21 11:31:26.596251 W Key Esc is bound to multiple actions in
context Main Menu.
2013-09-21 11:31:26.606954 I Using Frameless Window
2013-09-21 11:31:26.606976 I Using Full Screen Window
2013-09-21 11:31:26.609850 I Using the Qt painter
2013-09-21 11:31:27.021781 I Current MythTV Schema Version (DBSchemaVer):
1271
2013-09-21 11:31:27.038973 E Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2013-09-21 11:32:35.396340 E DBUtil: Error backing up database:
/usr/share/mythtv/mythconverg_backup.pl /tmp/mythtv_db_backup_conf_jDIipl
(2)
2013-09-21 11:32:35.396370 C Script-based database backup failed. Retrying
with internal backup.
2013-09-21 11:32:35.399872 C Backing up database to file:
'/mnt/store5/mythtv_db_backups/mythconverg-1271-20130921183235.sql'
2013-09-21 11:32:35.496529 E DBUtil: Error backing up database: 'mysqldump
--defaults-extra-file='/tmp/mythtv_db_backup_conf_gSZyAm'
--host='localhost' --port='3306' --user='mythtv' --add-drop-table
--add-locks --allow-keywords --complete-insert --extended-insert
--lock-tables --no-create-db --quick 'mythconverg' >
'/mnt/store5/mythtv_db_backups/mythconverg-1271-20130921183235.sql'
2>/dev/null' (2)
2013-09-21 11:33:58.961380 C Upgrading to MythTV schema version 1272
2013-09-21 11:33:58.961943 E DB Error (Performing database upgrade):
Query was: ALTER TABLE recordmatch MODIFY recordid INT UNSIGNED NOT NULL;
Error was: Driver error was [2/144]:
QMYSQL: Unable to execute query
Database error was:
Table './mythconverg/recordmatch' is marked as crashed and last
(automatic?) repair failed
new version: 1272
2013-09-21 11:33:58.961961 E Database schema upgrade failed.
2013-09-21 11:33:58.962206 E Couldn't upgrade database to new schema.
[myth at totally ~]$
On Sat, Sep 21, 2013 at 11:15 AM, fordy ydrof <fordy at ydrof.com> wrote:
> Hello Stephen, et al;
> I restored my 0.24 DB again, and then I ran mythtvsetup. I'd welcome
> any suggestions or insights on how to proceed.
>
> thanks again
>
> The output is as follows:
>
>
> [myth at totally ~]$ mythtvsetup
> 2013-09-21 11:03:55.279488 I Setup Interrupt handler
> 2013-09-21 11:03:55.279507 I Setup Terminated handler
> 2013-09-21 11:03:55.279520 I Setup Segmentation fault handler
> 2013-09-21 11:03:55.279531 I Setup Aborted handler
> 2013-09-21 11:03:55.279542 I Setup Bus error handler
> 2013-09-21 11:03:55.279554 I Setup Floating point exception handler
> 2013-09-21 11:03:55.279566 I Setup Illegal instruction handler
> 2013-09-21 11:03:55.279579 I Setup Real-time signal 0 handler
> 2013-09-21 11:03:55.279669 C mythtv-setup version: fixes/0.26
> [0.26.0-9.fc19 (v0.26.0-153-gb02d25a)] www.mythtv.org
> 2013-09-21 11:03:55.279676 C Qt version: compile: 4.8.4, runtime: 4.8.5
> 2013-09-21 11:03:55.279681 N Enabled verbose msgs: general
> 2013-09-21 11:03:55.279689 N Setting Log Level to LOG_INFO
> 2013-09-21 11:03:55.279962 N Using runtime prefix = /usr
> 2013-09-21 11:03:55.279980 N Using configuration directory =
> /home/myth/.mythtv
> 2013-09-21 11:03:55.280050 I Added logging to the console
> 2013-09-21 11:03:55.280160 I Assumed character encoding: en_GB.utf8
> 2013-09-21 11:03:55.280171 W This application expects to be running a
> locale that specifies a UTF-8 codeset, and many features may behave
> improperly with your current language settings. Please set the LC_ALL or
> LC_CTYPE, and LANG variable(s) in the environment in which this program is
> executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
> 2013-09-21 11:03:55.281049 N Empty LocalHostName.
> 2013-09-21 11:03:55.281055 I Using localhost value of totally
> 2013-09-21 11:03:55.301912 N Desktop video mode: 3840x1200 60.000 Hz
> 2013-09-21 11:03:55.505551 I Added logging to mythlogserver at TCP:35327
> 2013-09-21 11:03:55.764156 E LIRC: Failed to connect to Unix socket
> '/var/run/lirc/lircd'
> eno: No such file or directory (2)
> 2013-09-21 11:03:55.764198 E JoystickMenuThread: Joystick disabled -
> Failed to read /home/myth/.mythtv/joystickmenurc
> 2013-09-21 11:03:55.764210 I UDPListener: Enabling
> 2013-09-21 11:03:55.768302 I Binding to UDP 127.0.0.1:0
> 2013-09-21 11:03:55.768464 I Binding to UDP 192.168.1.200:0
> 2013-09-21 11:03:55.768791 I Binding to UDP [::1]:0
> 2013-09-21 11:03:55.769138 I Binding to UDP [2001:470:67:368::49]:0
> 2013-09-21 11:03:55.769472 I Binding to UDP
> [fe80::21b:fcff:fed2:a6be%em1]:0
> 2013-09-21 11:03:55.769635 I Binding to UDP 192.168.1.255:0
> 2013-09-21 11:03:55.781229 I Using Frameless Window
> 2013-09-21 11:03:55.781260 I Using Full Screen Window
> 2013-09-21 11:03:55.783493 I Using the Qt painter
> 2013-09-21 11:03:56.061220 N Setting QT default locale to en_GB
> 2013-09-21 11:03:56.266352 I System Locale (en_GB), Country (GB),
> Language (en)
> 2013-09-21 11:04:01.183625 I Loading en_gb translation for module
> mythfrontend
> 2013-09-21 11:04:01.188942 N Setting QT default locale to en_GB
> 2013-09-21 11:04:01.189078 I Current locale en_GB
> 2013-09-21 11:04:01.189165 N Reading locale defaults from
> /usr/share/mythtv//locales/en_gb.xml
> 2013-09-21 11:04:01.189816 E SaveSettingOnHost('FreqTable') - No database
> yet
> 2013-09-21 11:04:01.189828 E SaveSettingOnHost('ISO639Language0') - No
> database yet
> 2013-09-21 11:04:01.189836 E SaveSettingOnHost('ISO639Language1') - No
> database yet
> 2013-09-21 11:04:01.189843 E SaveSettingOnHost('TVFormat') - No database
> yet
> 2013-09-21 11:04:01.189850 E SaveSettingOnHost('VbiFormat') - No database
> yet
> 2013-09-21 11:04:01.189857 E SaveSettingOnHost('prefDupMethod') - No
> database yet
> 2013-09-21 11:04:01.189870 E SaveSettingOnHost('DateFormat') - No
> database yet
> 2013-09-21 11:04:01.189880 E SaveSettingOnHost('EnableMHEG') - No
> database yet
> 2013-09-21 11:04:01.189892 E SaveSettingOnHost('MythArchiveVideoFormat')
> - No database yet
> 2013-09-21 11:04:01.189902 E SaveSettingOnHost('ShortDateFormat') - No
> database yet
> 2013-09-21 11:04:01.189925 E SaveSettingOnHost('TimeFormat') - No
> database yet
> 2013-09-21 11:04:01.190403 I Starting process manager
> 2013-09-21 11:04:01.193951 I Starting process signal handler
> 2013-09-21 11:04:01.194208 I Starting IO manager (read)
> 2013-09-21 11:04:01.194274 I Starting IO manager (write)
> 2013-09-21 11:04:01.295096 I ScreenSaverX11Private: DPMS is active.
> 2013-09-21 11:04:01.308242 N Inserting MythTV initial database
> information.
> 2013-09-21 11:04:01.308265 C Upgrading to MythTV schema version 1307
> 2013-09-21 11:04:01.308500 E DB Error (Performing database upgrade):
> Query was: CREATE TABLE callsignnetworkmap ( id int(11) NOT NULL
> AUTO_INCREMENT, callsign varchar(20) NOT NULL DEFAULT '', network
> varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (id), UNIQUE KEY callsign
> (callsign)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
> Error was: Driver error was [2/1050]:
> QMYSQL: Unable to execute query
> Database error was:
> Table 'callsignnetworkmap' already exists
>
>
> then running mythtvsetup again re-asks for my country/language and
> results in this:
>
> [myth at totally ~]$ mythtvsetup
> 2013-09-21 11:09:10.852216 I Setup Interrupt handler
> 2013-09-21 11:09:10.852235 I Setup Terminated handler
> 2013-09-21 11:09:10.852247 I Setup Segmentation fault handler
> 2013-09-21 11:09:10.852259 I Setup Aborted handler
> 2013-09-21 11:09:10.852270 I Setup Bus error handler
> 2013-09-21 11:09:10.852281 I Setup Floating point exception handler
> 2013-09-21 11:09:10.852293 I Setup Illegal instruction handler
> 2013-09-21 11:09:10.852306 I Setup Real-time signal 0 handler
> 2013-09-21 11:09:10.852395 C mythtv-setup version: fixes/0.26
> [0.26.0-9.fc19 (v0.26.0-153-gb02d25a)] www.mythtv.org
> 2013-09-21 11:09:10.852403 C Qt version: compile: 4.8.4, runtime: 4.8.5
> 2013-09-21 11:09:10.852408 N Enabled verbose msgs: general
> 2013-09-21 11:09:10.852416 N Setting Log Level to LOG_INFO
> 2013-09-21 11:09:10.852680 N Using runtime prefix = /usr
> 2013-09-21 11:09:10.852698 N Using configuration directory =
> /home/myth/.mythtv
> 2013-09-21 11:09:10.852798 I Assumed character encoding: en_GB.utf8
> 2013-09-21 11:09:10.852809 W This application expects to be running a
> locale that specifies a UTF-8 codeset, and many features may behave
> improperly with your current language settings. Please set the LC_ALL or
> LC_CTYPE, and LANG variable(s) in the environment in which this program is
> executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
> 2013-09-21 11:09:10.852884 I Added logging to the console
> 2013-09-21 11:09:10.853736 N Empty LocalHostName.
> 2013-09-21 11:09:10.853754 I Using localhost value of totally
> 2013-09-21 11:09:10.874822 N Desktop video mode: 3840x1200 60.000 Hz
> 2013-09-21 11:09:11.080870 I Starting mythlogserver
> 2013-09-21 11:09:11.081150 I Starting process manager
> 2013-09-21 11:09:11.081201 I Starting process signal handler
> 2013-09-21 11:09:11.081271 I Starting IO manager (read)
> 2013-09-21 11:09:11.083241 I Starting IO manager (write)
> 2013-09-21 11:09:11.349701 E LIRC: Failed to connect to Unix socket
> '/var/run/lirc/lircd'
> eno: No such file or directory (2)
> 2013-09-21 11:09:11.349740 E JoystickMenuThread: Joystick disabled -
> Failed to read /home/myth/.mythtv/joystickmenurc
> 2013-09-21 11:09:11.349750 I UDPListener: Enabling
> 2013-09-21 11:09:11.351872 I Binding to UDP 127.0.0.1:0
> 2013-09-21 11:09:11.352042 I Binding to UDP 192.168.1.200:0
> 2013-09-21 11:09:11.352365 I Binding to UDP [::1]:0
> 2013-09-21 11:09:11.352701 I Binding to UDP [2001:470:67:368::49]:0
> 2013-09-21 11:09:11.353051 I Binding to UDP
> [fe80::21b:fcff:fed2:a6be%em1]:0
> 2013-09-21 11:09:11.353219 I Binding to UDP 192.168.1.255:0
> 2013-09-21 11:09:11.365173 I Using Frameless Window
> 2013-09-21 11:09:11.365211 I Using Full Screen Window
> 2013-09-21 11:09:11.367539 I Using the Qt painter
> 2013-09-21 11:09:11.382262 I Added logging to mythlogserver at TCP:35327
> 2013-09-21 11:09:11.716466 N Setting QT default locale to en_GB
> 2013-09-21 11:09:11.905581 I System Locale (en_GB), Country (GB),
> Language (en)
> 2013-09-21 11:09:15.716059 I Loading en_gb translation for module
> mythfrontend
> 2013-09-21 11:09:15.721335 N Setting QT default locale to en_GB
> 2013-09-21 11:09:15.721436 I Current locale en_GB
> 2013-09-21 11:09:15.721480 N Reading locale defaults from
> /usr/share/mythtv//locales/en_gb.xml
> 2013-09-21 11:09:15.721746 E SaveSettingOnHost('FreqTable') - No database
> yet
> 2013-09-21 11:09:15.721753 E SaveSettingOnHost('ISO639Language0') - No
> database yet
> 2013-09-21 11:09:15.721758 E SaveSettingOnHost('ISO639Language1') - No
> database yet
> 2013-09-21 11:09:15.721763 E SaveSettingOnHost('TVFormat') - No database
> yet
> 2013-09-21 11:09:15.721768 E SaveSettingOnHost('VbiFormat') - No database
> yet
> 2013-09-21 11:09:15.721772 E SaveSettingOnHost('prefDupMethod') - No
> database yet
> 2013-09-21 11:09:15.721782 E SaveSettingOnHost('DateFormat') - No
> database yet
> 2013-09-21 11:09:15.721789 E SaveSettingOnHost('EnableMHEG') - No
> database yet
> 2013-09-21 11:09:15.721796 E SaveSettingOnHost('MythArchiveVideoFormat')
> - No database yet
> 2013-09-21 11:09:15.721803 E SaveSettingOnHost('ShortDateFormat') - No
> database yet
> 2013-09-21 11:09:15.721810 E SaveSettingOnHost('TimeFormat') - No
> database yet
> 2013-09-21 11:09:15.789986 I ScreenSaverX11Private: DPMS is active.
> 2013-09-21 11:09:15.804429 N Inserting MythTV initial database
> information.
> 2013-09-21 11:09:15.804452 C Upgrading to MythTV schema version 1307
> 2013-09-21 11:09:15.804679 E DB Error (Performing database upgrade):
> Query was: CREATE TABLE callsignnetworkmap ( id int(11) NOT NULL
> AUTO_INCREMENT, callsign varchar(20) NOT NULL DEFAULT '', network
> varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (id), UNIQUE KEY callsign
> (callsign)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
> Error was: Driver error was [2/1050]:
> QMYSQL: Unable to execute query
> Database error was:
> Table 'callsignnetworkmap' already exists
>
> new version: 1307
>
>
>
>
> On Fri, Sep 20, 2013 at 11:13 PM, Stephen Worthington <
> stephen_agent at jsw.gen.nz> wrote:
>
>> On Fri, 20 Sep 2013 16:28:27 -0700, you wrote:
>>
>> >Hello All,
>> >
>> > Background: I was happily running fedora 14 and mythtv .24 -- until
>> my
>> >boot/OS drive failed.
>> >
>> > I bought a new drive and loaded it up with current Fedora (19) and
>> >installed mythtv (.26)
>> >
>> > I've been able to recover the mysql db mythconverg (though, i dont
>> have
>> >good exported backups i'm afraid), and when I attempted to upgrade (.24
>> ->
>> >.26) on a copy of mythconverg (i still have the state of the DB at the
>> time
>> >of the hard drive crash, but i no longer have a place to run fedora 14 or
>> >myth .24)
>> >
>> >mythtv has partially updated DB schemas, but now seem to be stuck here
>> now
>> >unable to upgrade further:
>> >Warning: MythTV wants to upgrade your database,
>> >for the TV schema, from 1271 to 1307.
>> >
>> >
>> >any suggestions? what are my options at this point? I'd like of course to
>> >retain my data about episodes recorded etc.. not looking forward to a
>> clean
>> >slate and re-recording shows i've already watched..
>> >
>> >
>> >thanks in advance
>>
>> The best way to update DB schemas is to use mythtv-setup. So if you
>> restore your 0.24 database again, then make sure that you do not run
>> mythbackend, and instead run mythtv-setup, you should get prompts to
>> update the schema. Remember that it will first make a backup of the
>> database before it upgrades it. If your database is huge like mine (>
>> 5000 recordings), that can take quite a while and there is no visible
>> activity on screen for minutes while it happens. Then the upgrade
>> prompts will finally appear.
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130921/af91130f/attachment-0001.html>
More information about the mythtv-users
mailing list