[mythtv-users] Failed database update 1327->1328

[Ken Mandelberg]

Russell Gower wrote, On 06/22/2014 03:51 AM:
>
> On 21 Jun 2014, at 16:45, Ken Mandelberg <km at mathcs.emory.edu> wrote:
>
>> I run the trunk and the most recent update failed trying to update 1327 to 1328.  The first attempt complained about a duplicate entry, the second about a missing column.
>>
>> How do I recover from this?
>
> The update consist of two actions, the first one drops the existing index which there is no problem with, the second tries to recreate it as a unique key, this fails if you have any entries in the record table that would be considered a duplicate under the new index.
>
> To recover I restored the database backup taken at the start of the upgrade, then identified and removed all the records with the duplicate key (chanid, starttime, startdate, title, type) then re-ran the upgrade.
>
> But once I’d got the upgrade completed the backend was unable to find any of my previous recordings, I’ve not yet had a chance to look into that issue yet as we wanted to watch one of them when we noticed the issue, so I just regressed.
>
> Regards
>    Russell

I had some new recordings coming up, so before seeing your note I also 
did the restore. I always keep the last version of the trunk around so 
I'm back up and running.

My first thought was that there was some unique duplicate record problem 
in my database, and thought I would try a repair and then another 
upgrade. It seems that this might actually be a bug, and worthy of 
submitting a bug report.

Ken