[OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish

[Jason Stephenson]

On 03/28/2018 06:52 PM, Jesse McCarty wrote:
> 
> Not sure how to proceed to test getting the upgrade more manageable
> prior to upgrading production. Obviously cannot have production down or
> having issues for several business days.

If you add the code to disable triggers, etc., from the 2.12.6 to 3.0
upgrade script, then it runs it much less time. It ran in about half an
hour on my test system.

BTW, are you upgrading from 2.10 to 3.0? If so, it sometimes helps to
make a single upgrade script because some steps are occasionally
repeated. In this particular case, the 2.12.6 to 3.0.0 upgrade script
does this calculation. It would be wise to bundle everything up and put
that update at the end so you only have to do it once, rather than twice.

There's an authority ingest in that 2.12.6 to 3.0 upgrade that takes a
lot longer on my test system.

Jason