[OPEN-ILS-DEV] 1.6.0.0RC1 database update errors

[Alan Rykhus]

Hello,

I had just recently installed Evergreen 1.4.0.4, had it up and running,
but had not loaded any data into it yet. I ran the upgrade and I'm on
the upgrade database step. I see 1 ERROR that doesn't bother me too much
and 2 that do.

Error 1:

psql:Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql:3979: ERROR:
duplicate key violates unique constraint "perm_list_code_key"

Which corresponds to:

INSERT INTO permission.perm_list (code, description) VALUES
('DELETE_RECORD', 'Allow a staff member to directly remove a
bibliographic record');

Since this entry already exists, the error doesn't seem too bad.

Errors 2 and 3:

psql:Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql:4044: ERROR:
relation "auditor.action_hold_request_history" does not exist
psql:Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql:4045: ERROR:
relation "auditor.action_hold_request_history" does not exist

These correspond to:

ALTER TABLE auditor.action_hold_request_history ADD COLUMN cancel_cause
INT;
ALTER TABLE auditor.action_hold_request_history ADD COLUMN cancel_note
TEXT;

These tables do not exist in the database, so this seems like an area of
concern.

al
-- 
Alan Rykhus
PALS, A Program of the Minnesota State Colleges and Universities 
(507)389-1975
alan.rykhus at mnsu.edu