Upgrade: 2.3-2.4-supplmental.sh can result in Pg deadlocks

Bug #1176206 reported by Galen Charlton
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Undecided
Unassigned

Bug Description

The parallel create index concurrently statements executed by 2.3-2.4-supplemental.sh can occasionally deadlock, due to two different issues. One of them is a PostgreSQL bug fixed by the following commit, but not released as of this writing.

http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c3d09b3

The other was attempts by the script to create multiple indexes on acq.edi_messages and action.hold_request in parallel.

Evergreen 2.4.0

Revision history for this message
Galen Charlton (gmc) wrote :

A fix is available at the tip of the user/gmcharlt/avoid-deadlock-during-supplemental-upgrade branch in the working/Evergreen repository:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/gmcharlt/avoid-deadlock-during-supplemental-upgrade

tags: added: pullrequest upgrade
Changed in evergreen:
milestone: none → 2.4.0
Revision history for this message
Galen Charlton (gmc) wrote :

Note for anybody who was very quick on the draw -- I've force-pushed a corrected patch.

Ben Shum (bshum)
Changed in evergreen:
milestone: 2.4.0 → 2.4.1
Revision history for this message
Dan Scott (denials) wrote :

The fix worked well for us for upgrading a copy of our production database; I've pushed this to master and rel_2_4. Thanks Galen!

Changed in evergreen:
status: New → Fix Committed
Ben Shum (bshum)
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.