Hi everyone
I've just tried to upgrade DSpace on our test server (CentOS Linux)
from version 1.6.2 to 1.7.0
I have got to the very end of the upgrade procedure only to be faced
by the following error message when I try to run the index script:
[dsp...@standbyvle dspace-1.7.0-build.dir]$ psql -U dspace -f
/home/dspace/dspace-1.7.0-src-release/dspace/etc/postgres/database_schema_16-17.sql
dspace
DROP SEQUENCE
[dsp...@standbyvle dspace-1.7.0-build.dir]$ /home/dspace/bin/dspace index-init
Started: 1293794521880
Ended: 1293794523440
Elapsed time: 1 secs (1560 msecs)
Exception: org.postgresql.util.PSQLException: ERROR: syntax error at
or near "RETURNING"
org.dspace.browse.BrowseException: org.postgresql.util.PSQLException:
ERROR: syntax error at or near "RETURNING"
at
org.dspace.browse.BrowseCreateDAOPostgres.insertIndex(BrowseCreateDAOPostgres.java:700)
at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:354)
at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1124)
at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1073)
at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:715)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at
or near "RETURNING"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
at
org.dspace.browse.BrowseCreateDAOPostgres.insertIndex(BrowseCreateDAOPostgres.java:695)
... 9 more
Any idea what I have done wrong?
Incidentally the name of the database upgrade script on the Wiki at
http://www.dspace.org/1_7_0Documentation/Upgrading%20a%20DSpace%20Installation.html#UpgradingaDSpaceInstallation-Upgradingfrom1.6.xto1.7
is wrong. It is listed as database_schema_16_17.sql instead of what it
should be which is database_schema_16-17.sql
I have blogged the entire failed upgrade procedure at
http://dspacebromley.blogspot.com/
Thanks very much and Happy New Year everyone
Clive
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
