Opened 12 years ago

Closed 12 years ago

#4927 closed patch (fixed)

Handle duplicate RecordFilePrefix values for a host in storagegroup DB upgrade

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

mythtv-storagegroups_db_upgrade-duplicate_RecordFilePrefix.patch (679 bytes) - added by sphery <mtdean@…> 12 years ago.

Download all attachments as: .zip

Change History (2)

Changed 12 years ago by sphery <mtdean@…>

comment:1 Changed 12 years ago by cpinkham

Resolution: fixed
Status: newclosed

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.

Note: See TracTickets for help on using tickets.