Opened 18 years ago
Closed 18 years ago
#2180 closed defect (fixed)
Schema upgrade to today's svn fails with 0.19-fixes database
Reported by: | Owned by: | Isaac Richards | |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | mythtv | Version: | head |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description
When upgrading 0.19-fixes to latest svn (compiled today) the schema upgrade fails in a couple of spots. I have attached the output from mythbackend while attempting to upgrade my database. Please let me know if I can/should provide any additional info.
Attachments (3)
Change History (6)
Changed 18 years ago by
Attachment: | schema_upgrade.rar added |
---|
Changed 18 years ago by
Attachment: | recordedseek_ignore_fix.patch added |
---|
Fix for second schema upgrade issue
comment:1 Changed 18 years ago by
Attached a patch which addresses the second of the two schema upgrade issues by silently dropping duplicate entries when porting over seek info into the new table.
Changed 18 years ago by
Attachment: | schema_upgrade.txt added |
---|
Uncompressed version of the posted log
comment:2 Changed 18 years ago by
Version: | → head |
---|
comment:3 Changed 18 years ago by
Resolution: | → fixed |
---|---|
Status: | new → closed |
(In [10790]) Fixes #2180. Makes some of the DB schema updates more robust.
It appears the issues were not due to a pure upgrade from 0.19-fixes, but this just adds the "IF NOT EXISTS" we normally use for table creation a table creation and uses "INSERT IGNORE" in the recordedseek update instead of a straight "INSERT".
schema upgrade error log