JBAS-944 2.7 sql upgrade dupe holds cleanup
authorBill Erickson <berickxx@gmail.com>
Thu, 11 Feb 2016 15:52:49 +0000 (07:52 -0800)
committerBill Erickson <berickxx@gmail.com>
Thu, 21 Mar 2019 19:46:23 +0000 (15:46 -0400)
commitac2becec97871997bb5e4b94127b4222ca9f2e61
treee66ad815893179f88dbaea9331d705ba271fb96f
parent089d6faaa1d088892bb728c739709685b83c8346
JBAS-944 2.7 sql upgrade dupe holds cleanup

2.7 adds an index that prevents 2 captured, unfulfilled, uncanceled
holds from targeting the same copy.  Before the index is created,
cancel any such dupe-copy holds that have expired on the shelf and reset
any such holds that are otherwise unfulfilled (i.e. in transit or on the
holds shelf).

Signed-off-by: Bill Erickson <berickxx@gmail.com>
KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql