Evergreen

0905.schema.use_current_normalize_heading.sql fails with SQl Error

Bug #1418164 reported by Jason Stephenson
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Undecided
Unassigned
Evergreen 2.8-beta
2.6
Fix Released
Undecided
Unassigned
Evergreen 2.6.6
2.7
Fix Released
Undecided
Unassigned
Evergreen 2.7.3

Bug Description

While running the 0905.schema.use_current_normalize_heading.sql upgrade script on my development system against production data, it dies with the following error:

psql:/home/opensrf/Evergreen/Open-ILS/src/sql/Pg/upgrade/0905.schema.use_current
_normalize_heading.sql:111: ERROR: cannot ALTER TABLE "record_entry" because it
 has pending trigger events

Looks like the script is trying to alter a table after altering data that affects this table.

I'll look into it and post a branch shortly.

Revision history for this message
Jason Stephenson (jstephenson) wrote :

Branch in on working repo: user/dyrcona/lp1418164

tags: added: pullrequest
Revision history for this message
Ben Shum (bshum) wrote :

Result from changes made in bug 1415572.

Pushed to master, rel_2_7 and rel_2_6.

Changed in evergreen:
status: New → Fix Committed
milestone: none → 2.8-beta
Evergreen Bug Maintenance (bugmaster)
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.
Subscribing...

Other bug subscribers

Remote bug watches

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