Opened 19 years ago

Closed 19 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@… 19 years ago.
schema upgrade error log
recordedseek_ignore_fix.patch​ (652 bytes ) - added by stuart@… 19 years ago.
Fix for second schema upgrade issue
schema_upgrade.txt​ (8.0 KB ) - added by stuart@… 19 years ago.
Uncompressed version of the posted log

Download all attachments as: .zip

Change History (6)

by wmunson@…, 19 years ago

Attachment: schema_upgrade.rar​ added

schema upgrade error log

by stuart@…, 19 years ago

Attachment: recordedseek_ignore_fix.patch​ added

Fix for second schema upgrade issue

comment:1 by stuart@…, 19 years ago

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.

by stuart@…, 19 years ago

Attachment: schema_upgrade.txt​ added

Uncompressed version of the posted log

comment:2 by anonymous, 19 years ago

Version: → head

comment:3 by danielk, 19 years ago

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

Note: See TracTickets for help on using tickets.