Opened 16 years ago
Closed 16 years ago
#4927 closed patch (fixed)
Handle duplicate RecordFilePrefix values for a host in storagegroup DB upgrade
Reported by: | Owned by: | Isaac Richards | |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | mythtv | Version: | 0.21-fixes |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description
The DB upgrade for storagegroup (1171) has failed on multiple users' machines when their DB contained multiple values for RecordFilePrefix? for a given host. The attached patch modifies the 1171 SQL to select only distinct values for hostname, data (so we don't violate the grouphostdir index on storagegroup) by using a GROUP BY clause.
Attachments (1)
Change History (2)
Changed 16 years ago by
Attachment: | mythtv-storagegroups_db_upgrade-duplicate_RecordFilePrefix.patch added |
---|
comment:1 Changed 16 years ago by
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note: See
TracTickets for help on using
tickets.
I guess I should read my email before doing my own patch next time. :) I went a step further to handle bad data and checked for empty or null hostname values in [16518] and [16519]. Closing this ticket.