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

[Vaclav Jansa]

Hi Bill,
thanks for confirmation. Our testing environment is currently fully updated
from 2.8.2 to 2.10.2. Overall DB update process is without error.

Best regards

Vaclav Jansa

On Sun, May 1, 2016 at 5:17 PM, Bill Erickson  wrote:

> Hi Linda,
>
> On Sat, Apr 30, 2016 at 2:41 PM, Linda Jansova  wrote:
> 
>
>> 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
>
>

[OPEN-ILS-GENERAL] IRC practice time this Wednesday, May 4 @ 2PM ES

[Yamil Suarez]

Hello,

At the 2016 Evergreen conference I gave a lightning talk
presentation on how easy is to get started with using the Evergreen
IRC channel. Which is used by the community to collaborate, hold
meetings, and answer each other's questions.

Here is a longer version of the presentation with more information…

http://goo.gl/w3zml2

In this presentation I postulate that if you…

1) have ever sent a text message

2) have a web browser

… you can pull off giving IRC a try for yourself.


This will be an hour long session for newcomers to practice using IRC
to be held on Wednesday, May 4 @ 2PM EST. This will be a designated
practice time, so no one feels like they are interrupting others.


Thanks in advance,
Yamil

P.S. I can schedule another practice session later in May if there is
enough interest, if you cannot attend the first one. Just email me directly to
suggest a date/time for the 2nd IRC practice time.





Yamil Suarez, MCS
Library Systems Administrator/Developer

Stan Getz Library
Berklee College of Music
1140 Boylston St
Boston, MA 02215

ysua...@berklee.edu
617-747-2617

Re: [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  wrote:


> 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