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? :roll:
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/