[OPEN-ILS-DEV] A few errors when upgrading evergreen database from 2.0 - 2.1

[Whalen, Liam]

In the process of upgrading from 2.0.10a to 2.1.0a, I got the following errors when I ran the 'psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql evergreen' command.

i.	psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8850: ERROR:  insert or update on table "org_unit_setting_type" violates foreign key constraint "org_unit_setting_type_grp_fkey"
ii.	DETAIL:  Key (grp)=(circ) is not present in table "settings_group".
iii.	INSERT 0 1
iv.	psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8866: ERROR:  duplicate key value violates unique constraint "org_unit_setting_type_label_key"
v.	DETAIL:  Key (label)=(Circ:  Patron Merge Address Delete) already exists.
vi.	psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8874: ERROR:  duplicate key value violates unique constraint "org_unit_setting_type_label_key"
vii.	DETAIL:  Key (label)=(Circ: Patron Merge Barcode Delete) already exists.
viii.	psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8882: ERROR:  duplicate key value violates unique constraint "org_unit_setting_type_label_key"
ix.	DETAIL:  Key (label)=(Circ:  Patron Merge Deactivate Card) already exists.

The OPAC and Staff Client seem to be working with the upgrade to 2.1.0a completed.  Can we ignore these errors?  If not, what should be done to correct them?

Liam

Natural Resources Canada Library / Bibliothèque de Ressources naturelles Canada
615 rue Booth Street, 121, Ottawa, ON
Canada K1A 0E9
Telephone / Téléphone : 613-995-4180
lwhalen at nrcan-rncan.gc.ca
Web: http://www.nrcan.gc.ca/library/