LinHES Forums http://forums.linhes.org/ |
|
[Solved]Cannot Upgrade DB Schema after Upgrading http://forums.linhes.org/viewtopic.php?f=22&t=24349 |
Page 1 of 1 |
Author: | sparks [ Thu May 19, 2016 5:27 pm ] |
Post subject: | [Solved]Cannot Upgrade DB Schema after Upgrading |
I tried upgrading my LinHES from 8.3 to 8.4. What could go wrong? The pacman upgrade went smoothly enough but when I rebooted and tried to update the DB schema get a message about a backup file to use if needed and this line: Quote: There are also other clients using this database. They should be shutdown first. What do I need to shutdown? Also, how do I stop the annoying error message 'Waiting for connection to mythbackend'. I don't want to start the backend before the DB upgrade. s |
Author: | tscholl [ Thu May 19, 2016 9:08 pm ] |
Post subject: | Re: Cannot Upgrade DB Schema after Upgrading |
I ran into this same problem upgrading one of my test machines. Anyone have any ideas? No backends or frontends are running. |
Author: | sparks [ Fri May 20, 2016 7:50 am ] |
Post subject: | Re: Cannot Upgrade DB Schema after Upgrading |
I was using Alt+S to update the DB. When I used mythtv-set from the CLI I got some info. Quote: Database Backup complete. 2016-05-20 09:15:02.658057 C Backed up database to file: '/data/storage/ST31000524AS_6VPFKXFP/backup/mythtv_backups/mythconverg-1318-20160520131453.sql.gz' 2016-05-20 09:15:15.378785 C Upgrading to MythTV schema version 1319 2016-05-20 09:15:15.379199 E DB Error (Performing database upgrade): Query was: ALTER TABLE program ADD COLUMN season INT(4) NOT NULL DEFAULT '0', ADD COLUMN episode INT(4) NOT NULL DEFAULT '0'; Error was: Driver error was [2/1060]: QMYSQL: Unable to execute query Database error was: Duplicate column name 'season' 2016-05-20 09:15:15.379216 E Database schema upgrade failed. 2016-05-20 09:15:15.379760 E Couldn't upgrade database to new schema. 2016-05-20 09:15:15.699039 I OpenGL2: Deleting OpenGL Resources 2016-05-20 09:15:15.699117 I OpenGL: Deleting OpenGL Resources Where do I go from here? S |
Author: | sparks [ Fri May 20, 2016 9:09 am ] |
Post subject: | Cannot Upgrade DB Schema after Upgrading |
I finally fixed this. I did a restore of the DB, not the lastest one but one from before the pacman upgrade. Evidently my machine ran the daily backup job when I started my machine for the day. I did this from the web interface on another box. By the time I looked up from the laptop (took me a few minutes; I get hung-up), mythtv was running with no other input from me, IOW I never ran mythtv-setup after the restore. When I started the frontend I got a screen saying myth wanted to update the schema from 1318 to 1320. When I started mythtv-setup, one of the lines stated that the DB schema was 1344 so I just exited out and used my myth box. Looks real nice too. Like the new default theme. S |
Page 1 of 1 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |