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" <g...@equinoxinitiative.org> > To: "Evergreen Development Discussion List" > <open-ils-dev@list.georgialibraries.org> > 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
