[OPEN-ILS-GENERAL] Error when upgrading from 2.9.3 to 2.10.0

[Bill Erickson]

Hi Linda,

On Sat, Apr 30, 2016 at 2:41 PM, Linda Jansova <skolkova at chello.cz> wrote:
<snip>

> This time we experienced the same error (but involving a different copy of
> the same serial):
>
> psql:version-upgrade/2.9.3-2.10.0-upgrade-db.sql:4578: ERROR: insert or
> update on table "usr_circ_history" violates foreign key constraint
> "usr_circ_history_target_copy_fkey"
> DETAIL:  Key (target_copy)=(57113) is not present in table "copy".
>
> Could it be related to the bug fixed in 2.10.2 as described at
> https://evergreen-ils.org/documentation/release/RELEASE_NOTES_2_10.html#_evergreen_2_10_2
> (Fixes a bug where serials checkouts failed for users that track
> circulation history.)?
>

That's the one.  See more here:
https://bugs.launchpad.net/evergreen/+bug/1564079


> If so, what should we do to get rid of the error in our case when 2.10.2
> has not been reached yet (in the upgrade process)?
>

The 2.10.2 fix includes a patch to the 2.9.3-2.10.0 upgrade script.  You'll
want to get the 2.10.2 code and use it to perform your 2.10.0 upgrade (and
ideally continue on to 2.10.2 to pick up more bug fixes).

Hope this helps,

--bill
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160501/5ee439be/attachment.html>