Re: [OPEN-ILS-DEV] Olly olly oxen free - upgrade updates
Hi, On Tue, Sep 26, 2017 at 11:08 AM, Kathy Lussier wrote: > Also, do we need to include an authority reingest in the upgrade script for > the MADS work? Yes, although it's (fortunately) something that can be deferred and run outside of the main portion of the upgrade. Regarding the general question: thanks for the feedback, folks! I've created a branch with additional improvements to the monolithic schema update script; it's available for review here: https://bugs.launchpad.net/evergreen/+bug/1719726 Regards, Galen -- Galen Charlton Infrastructure and Added Services Manager Equinox Open Library Initiative phone: 1-877-OPEN-ILS (673-6457) email: g...@equinoxinitiative.org web: https://equinoxInitiative.org direct: +1 770-709-5581 cell: +1 404-984-4366
Re: [OPEN-ILS-DEV] Olly olly oxen free - upgrade updates
Here's the branch Galen mentioned: http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/miker/batch-user-edit-missing-column Upgraded systems work fine, it's "just" fresh installs that need this. A stop-gap for testing looks like: ALTER TABLE action.fieldset_group ADD COLUMN can_rollback BOOL DEFAULT TRUE; Thanks, -- Mike Rylander | President | Equinox Open Library Initiative | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@equinoxinitiative.org | web: http://equinoxinitiative.org On Tue, Sep 26, 2017 at 10:55 AM, Galen Charlton wrote: > Hi, > > In preparation for the release candidate tomorrow, I am sending out a > call for changes needed for the installation and upgrade process, > particularly the schema update. > > I'm aware of the following so far: > > - a change in the works by Mike to sync up the base schema and schema > updates for action.fieldset_group > - chatter about adjustments for record reingest > > Regards, > > Galen > -- > Galen Charlton > Infrastructure and Added Services Manager > Equinox Open Library Initiative > phone: 1-877-OPEN-ILS (673-6457) > email: g...@equinoxinitiative.org > web: https://equinoxInitiative.org > direct: +1 770-709-5581 > cell: +1 404-984-4366
Re: [OPEN-ILS-DEV] Olly olly oxen free - upgrade updates
The following line of 2.12.5-3.0-beta1-upgrade-db.sql was brutal. It took at least 28 hours on our test system and it tripped over some bad data so needed to be restarted a couple times. UPDATE biblio.record_entry SET vis_attr_vector = biblio.calculate_bib_visibility_attribute_set(id); Related to this was bug 1714026. The patch for that bug made it much easier to find the bad data in the above query. Other than that our upgrade from 2.10 to 3.0 was very smooth. Bob Wicksall Computer and Network Services Manager Pioneer Library System 2557 State Rt. 21 Canandaigua, New York 14424 Voice: (585) 394-8260 ext. 110 Fax: (585) 394-1935 - Original Message - > From: "Galen Charlton" > To: "Evergreen Development Discussion List" > > Sent: Tuesday, September 26, 2017 10:55:02 AM > Subject: [OPEN-ILS-DEV] Olly olly oxen free - upgrade updates > Hi, > > In preparation for the release candidate tomorrow, I am sending out a > call for changes needed for the installation and upgrade process, > particularly the schema update. > > I'm aware of the following so far: > > - a change in the works by Mike to sync up the base schema and schema > updates for action.fieldset_group > - chatter about adjustments for record reingest > > Regards, > > Galen > -- > Galen Charlton > Infrastructure and Added Services Manager > Equinox Open Library Initiative > phone: 1-877-OPEN-ILS (673-6457) > email: g...@equinoxinitiative.org > web: https://equinoxInitiative.org > direct: +1 770-709-5581 > cell: +1 404-984-4366
Re: [OPEN-ILS-DEV] Olly olly oxen free - upgrade updates
Hi, - chatter about adjustments for record reingest I don't know if this is what you're referring to, but there's been some chatter about dropping triggers for the 1057 upgrade script. I know csharp has a branch he's been sharing when people have been testing the upgrade. I don't think anyone has submitted anything to LP on it. Also, do we need to include an authority reingest in the upgrade script for the MADS work? Kathy On 09/26/2017 10:55 AM, Galen Charlton wrote: Hi, In preparation for the release candidate tomorrow, I am sending out a call for changes needed for the installation and upgrade process, particularly the schema update. I'm aware of the following so far: - a change in the works by Mike to sync up the base schema and schema updates for action.fieldset_group - chatter about adjustments for record reingest Regards, Galen -- Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative (508) 343-0128 kluss...@masslnc.org Twitter: http://www.twitter.com/kmlussier
[OPEN-ILS-DEV] Olly olly oxen free - upgrade updates
Hi, In preparation for the release candidate tomorrow, I am sending out a call for changes needed for the installation and upgrade process, particularly the schema update. I'm aware of the following so far: - a change in the works by Mike to sync up the base schema and schema updates for action.fieldset_group - chatter about adjustments for record reingest Regards, Galen -- Galen Charlton Infrastructure and Added Services Manager Equinox Open Library Initiative phone: 1-877-OPEN-ILS (673-6457) email: g...@equinoxinitiative.org web: https://equinoxInitiative.org direct: +1 770-709-5581 cell: +1 404-984-4366