2.0-2.1-upgrade.sql script: insert or update on table "org_unit_setting_type" violates foreign key constraint "org_unit_setting_type_grp_fkey"

[Chris Sharp]

Receiving this error when running the 2.0-2.1 upgrade script:

psql:2.0-2.1-upgrade-db.sql:8853: ERROR: insert or update on table "org_unit_setting_type" violates foreign key constraint "org_unit_setting_type_grp_fkey"
DETAIL: Key (grp)=(circ) is not present in table "settings_group".

Upon investigation, no entries exist in config.settings_group. The table is created by the 1.6.1-2.0 upgrade script, but is never populated.

At the suggestion of tsbere in #evergreen, my workaround is to modify the upgrade script so to not try and add the "grp" field to config.org_unit_setting_type.

  * Evergreen version - 2.1.0
  * OpenSRF version - 2.0.1
  * PostgreSQL version - 9.0 and 9.1
  * Linux distribution (type and version) on which Evergreen is running - Debian "squeeze"
  * Sample records which we can use to reproduce the problem - not applicable

[Michael Peters (mrpeters)]

Evidence of more than one distinct organization reporting this issue in the past, therefore I'm marking confirmed.

Case #1 http://open-ils.org/irc_logs/evergreen/2011-10/%23evergreen.28-Fri-2011.log?raw
Case #2 - http://open-ils.org/irc_logs/evergreen/2011-11/%23evergreen.29-Tue-2011.log?raw

[Alex Lazar (alex-lazar)]

What would be a way to resolve this bug? Would it be to use some type of conditional check before attempting to run this code?

[Ben Shum (bshum)]

Marking this as "won't fix". I'm going to suggest that a bug this old from the 2.0-2.1 era is way past expiration and that most sites should be on more supported (aka more recent) versions by now.