Builder evergreen-master-ubuntu-12.04-x86 Build #1230

Results:

Build successful

SourceStamp:

BuildSlave:

Reason:

scheduler

Steps and Logfiles:

1. git update ( 0 secs )
   1. stdio
2. Bootstrap via autogen './autogen.sh' skipped ( 0 secs )
   1. - no logs -
3. Bootstrap via autoreconf 'autoreconf -f ...' ( 9 secs )
   1. stdio
4. configure configure ( 7 secs )
   1. stdio
5. compile compile ( 1 secs )
   1. stdio
6. test test 848 tests 848 passed ( 13 secs )
   1. stdio
7. pylint pylint convention=203 error=1 fatal=14 refactor=6 warning=21 failed ( 1 secs )
   1. stdio
   2. convention
   3. error
   4. fatal
   5. refactor
   6. warning

Build Properties:

Forced Build Properties:

Responsible Users:

1. Galen Charlton

   gmcohnoyoudont@esilibrary.com
2. Kathy Lussier

   klussierohnoyoudont@masslnc.org

Timing:

All Changes:

:

1. Change #3359

   Category	None
   Changed by	Galen Charlton <gmcohnoyoudont@esilibrary.com>
   Changed at	Fri 10 Jun 2016 11:45:51
   Repository	git://git.evergreen-ils.org/Evergreen.git
   Project	Evergreen
   Branch	master
   Revision	d947d7ca90bfdae26f261efc5e79aba85ea066cd

   Comments

   LP#1526858: speed up queries for shelf-expired holds during checkin
   This patch adds indexes on action.hold_request and tweaks
   the definition of the alhr IDL view to more efficiently
   identify holds that can be canceled if the "Clear Holds Shelf"
   checkin modifier is in use.  This can prevent a problem
   where such checkins can time out in very large databases.
   
   The tweaks were created by Jason Etheridge and have been in
   production at a large consortium for some time.
   
   To test
   -------
   [1] With a suitably large database, set up an item that
       is on the holds shelf but has passed its shelf-expiration
       time, then check it in using the "Clear Holds Shelf" modifier.
   [2] The checkin may fail with a "network failure" message due
       the query on the alhr timing out.
   [3] Apply the patch and repeat step 1. This time, the checkin
       should succeed.
   
   Signed-off-by: Galen Charlton <gmc@esilibrary.com>
   Signed-off-by: Jeanette Lundgren <jlundgren@cwmars.org>
   Signed-off-by: Kathy Lussier <klussier@masslnc.org>

   Changed files

   • Open-ILS/examples/fm_IDL.xml
   • Open-ILS/src/sql/Pg/090.schema.action.sql
   • Open-ILS/src/sql/Pg/upgrade/XXXX.schema.indexes_for_alhr_queries.sql

2. Change #3360

   Category	None
   Changed by	Kathy Lussier <klussierohnoyoudont@masslnc.org>
   Changed at	Fri 10 Jun 2016 11:51:41
   Repository	git://git.evergreen-ils.org/Evergreen.git
   Project	Evergreen
   Branch	master
   Revision	a6d3bdea207394fafc8caf92dcd18843410fcb2e

   Comments

   LP#1526858: Stamping upgrade script for faster alhr query
   Signed-off-by: Kathy Lussier <klussier@masslnc.org>

   Changed files

   • Open-ILS/src/sql/Pg/002.schema.config.sql
   • Open-ILS/src/sql/Pg/upgrade/0981.schema.indexes_for_alhr_queries.sql
   • Open-ILS/src/sql/Pg/upgrade/XXXX.schema.indexes_for_alhr_queries.sql