[mythtv-users] Database upgrade 0.21 -> 0.22: issue to avoid

Michael T. Dean mtdean at thirdcontact.com
Tue Nov 17 09:00:36 UTC 2009

On 11/17/2009 03:22 AM, James Warden wrote:
> before I restore a DB from a backup, I drop mythconverg. There's no chance anything is left from a previous mythconverg. To be honest, I don't know why I experienced this issue in the 1st place. My server was running on a backend version that dates back from july 2008. Upgrading to 0.22 should be painless, but it was not. So I can only assume the upgrade path is not bug-free.

I know for a fact--as I spent a great deal of time tracking down all 
possible paths for the upgrade or initial DB install--that it's 
/impossible/ for a default_authority column to exist in the 
dtv_multiplex or channelscan_dtv_multiplex tables before the 1230->1231 
DB upgrade--except with a modified (by something other than Myth) 
database schema or when improperly restoring a backup.  This part (at 
the very least) of the DB upgrade /is/ bug free.

If you didn't do an improper restore, then you probably applied a patch 
to 0.21-fixes that broke your database schema and you didn't clean up 
after the patch.

I'm saying this--and repeating it (trying to "get the last word") only 
to prevent any other users from needlessly worrying or--worse--from 
hacking their databases because the failure that indicates they didn't 
properly restore their database backup was "written off as a bug in 
Myth" on the lists.

If anyone gets the mentioned failure--duplicate column when doing the 
1230->1231 DB upgrade, they /need to/ go back to their 0.21-fixes 
database backup, restore it properly, and let MythTV upgrade it 
properly.  Otherwise, those users will have corrupt data, and any 
problems they experience with MythTV using corrupt data are theirs to 
keep--along with the broken data.


More information about the mythtv-users mailing list