[OPEN-ILS-GENERAL] Upgrade error

[Jim Raney]

Hello all,

I'm test-upgrading a snapshot of a live evergreen system running 2.6.4 
to 2.8.1.  I've successfully run 2.6.3-2.7.0-upgrade-db.sql. I then get 
the following:

root at evergreen:/home/opensrf/Evergreen-ILS-2.8.1/Open-ILS/src/sql/Pg# 
psql -U postgres -f version-upgrade/2.7.0-2.7.1-upgrade-db.sql evergreen
BEGIN
INSERT 0 1
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:6: ERROR:  duplicate key 
value violates unique constraint "upgrade_log_pkey"
DETAIL:  Key (version)=(0892) already exists.
CONTEXT:  SQL statement "INSERT INTO config.upgrade_log (version, 
applied_to) VALUES (my_db_patch, my_applied_to)"
PL/pgSQL function "upgrade_deps_block_check" line 22 at SQL statement
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:19: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:108: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:112: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:149: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:152: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:154: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:157: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:159: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:160: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:161: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:162: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:163: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:164: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:166: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:167: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.7.0-2.7.1-upgrade-db.sql:168: ERROR:  current 
transaction is aborted, commands ignored until end of transaction block
ROLLBACK

Did I make a mistake running 2.6.3-2.7.0-upgrade-db.sql?  Or do I have 
something else going on?

--
Jim Raney