Quoting Araik Manukyan <ar...@flib.sci.am>:
Dear friends,
We are upgrading from Everegreen 2.2.1 to 2.3.1. The transition was going
smoothly untill the final step. When try to upgrade the Evergreen database
scheme with the command
Yeah, I think that upgrade script has a bug that was fixed later.
You can get around it by adding -v eg_version=2.3.1 on the command
line for psql when you run the upgrade script.
---
psql -U evergreen -h localhost -f version-upgrade/2.3.0-2.3.1-upgrade-db.sql
evergreen
---
an error occurs. Here is the error text.
---
BEGIN
psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:3: ERROR: syntax error at
or near ":"
LINE 1: ...pgrade_log (version, applied_to) VALUES ('2.3.1', :eg_versio...
^
psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:5: ERROR: syntax error at
or near ":"
LINE 1: SELECT evergreen.upgrade_deps_block_check('0740', :eg_versio...
^
psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:134: ERROR: current
transaction is aborted, commands ignored until end of transaction block
psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:137: ERROR: syntax error at
or near ":"
LINE 1: SELECT evergreen.upgrade_deps_block_check('0742', :eg_versio...
^
psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:269: ERROR: current
transaction is aborted, commands ignored until end of transaction block
ROLLBACK
---
Any ideas?
Regards, Arayik.
--
Jason Stephenson
Assistant Director for Technology Services
Merrimack Valley Library Consortium
Chief Bug Wrangler, Evergreen ILS
