Opened 14 years ago

Closed 14 years ago

#2180 closed defect (fixed)

Schema upgrade to today's svn fails with 0.19-fixes database

Reported by: wmunson@… 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)

schema_upgrade.rar (1.5 KB) - added by wmunson@… 14 years ago.
schema upgrade error log
recordedseek_ignore_fix.patch (652 bytes) - added by stuart@… 14 years ago.
Fix for second schema upgrade issue
schema_upgrade.txt (8.0 KB) - added by stuart@… 14 years ago.
Uncompressed version of the posted log

Download all attachments as: .zip

Change History (6)

Changed 14 years ago by wmunson@…

Attachment: schema_upgrade.rar added

schema upgrade error log

Changed 14 years ago by stuart@…

Fix for second schema upgrade issue

comment:1 Changed 14 years ago by stuart@…

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 14 years ago by stuart@…

Attachment: schema_upgrade.txt added

Uncompressed version of the posted log

comment:2 Changed 14 years ago by anonymous

Version: head

comment:3 Changed 14 years ago by danielk

Resolution: fixed
Status: newclosed

(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".

Note: See TracTickets for help on using tickets.