Hi Freddy,
Sorry for the delayed response to your issue. It sounds like, in your
situation, the database migration has failed because the database tables are
"owned" by a different database user account? The main error seems to be:
Caused by: org.postgresql.util.PSQLException: ERROR: must be owner of relation
requestitem
So, essentially, the "requestitem" relation does not seem to be owned by the
database user configured in your "db.username" field of the 'dspace.cfg'.
So, you may need to investigate whether the "db.username" is set properly. If
it is set properly, you should investigate the ownership of your database
tables, and ensure they are all owned by the user account specified in
"db.username". It's possible that you are running the migration against a
database without full "owner" access rights.
You should be able to use either the "ALTER DATABASE [database] OWNER TO
[owner]" or "ALTER TABLE [table] OWNER TO [owner]" commands to fix your
ownership:
* ALTER DATABASE:
http://www.postgresql.org/docs/9.1/static/sql-alterdatabase.html
* ALTER TABLE: http://www.postgresql.org/docs/9.1/static/sql-altertable.html
Good luck,
Tim
--
Tim Donohue
Technical Lead for DSpace & DSpaceDirect
DuraSpace.org | DSpace.org | DSpaceDirect.org
On 6/6/2015 8:35:22 AM, Freddy Guerrero <freddygu...@gmail.com> wrote:
Hi Bill,
Forgive thousand bad English, please I need your help I am trying to update
dspace of version 1.8 to version 5.2, but I have a mistake, I ask you please
help me, look what I get:
+----------------+----------------------------+---------------------+---------+
| Version | Description | Installed on | State |
+----------------+----------------------------+---------------------+---------+
| 1.1 | Initial DSpace 1.1 databas | | PreInit |
| 1.2 | Upgrade to DSpace 1.2 sche | | PreInit |
| 1.3 | Upgrade to DSpace 1.3 sche | | PreInit |
| 1.3.9 | Drop constraint for DSpace | | PreInit |
| 1.4 | Upgrade to DSpace 1.4 sche | | PreInit |
| 1.5 | Upgrade to DSpace 1.5 sche | | PreInit |
| 1.5.9 | Drop constraint for DSpace | | PreInit |
| 1.6 | Upgrade to DSpace 1.6 sche | | PreInit |
| 1.7 | Upgrade to DSpace 1.7 sche | | PreInit |
| 1.8 | Upgrade to DSpace 1.8 sche | | PreInit |
| 3.0 | Upgrade to DSpace 3.x sche | | PreInit |
| 4.0 | Initializing from DSpace 4 | 2015-06-05 09:53:47 | Success |
| 5.0.2014.08.08 | DS-1945 Helpdesk Request a | | Pending |
| 5.0.2014.09.25 | DS 1582 Metadata For All O | | Pending |
| 5.0.2014.09.26 | DS-1582 Metadata For All O | | Pending |
+----------------+----------------------------+---------------------+---------+
The error:
2015-06-05 11:02:20,700 ERROR org.dspace.storage.rdbms.DatabaseManager @ Failed
to initialize the database:
java.sql.SQLException: Flyway migration error occurred
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:430)
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:338)
at
org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.java:1373)
at org.dspace.storage.rdbms.DatabaseManager.getDbName(DatabaseManager.java:1491)
at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:191)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:226)
at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:78)
Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Error
executing statement at line 20: ALTER TABLE requestitem ADD COLUMN
request_message TEXT
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:91)
at
org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:73)
at
org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
at
org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
at
org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
at
org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
at
org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
at
org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
at
org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:864)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:811)
at org.flywaydb.core.Flyway.execute(Flyway.java:1171)
at org.flywaydb.core.Flyway.migrate(Flyway.java:811)
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:419)
... 10 more
Caused by: org.postgresql.util.PSQLException: ERROR: must be owner of relation
requestitem
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at
org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:235)
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:89)
... 25 more
Pls helpme
------------------------------------------------------------------------------
_______________________________________________ DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette:
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors
network devices and physical & virtual servers, alerts via email & sms
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
