Dspace 5.4 Batch import PGSQL error

20 views
Skip to first unread message

Tushar Sangamnerkar

unread,
Dec 6, 2016, 4:46:53 AM12/6/16
to DSpace Technical Support
Hello,
I have installed Dspace 5.4 on rhel 6.8.  Postgresql 9.4 installed from the .run file.  I am using the batch import command (dspace import) . I have added 26000 records the older version (1.4.2) after running dspace_migrate on those records. I am facing  a new error while batch importing.

org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
        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:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:441)
        at org.dspace.content.WorkspaceItem.deleteEpersonGroup2WorkspaceItem(WorkspaceItem.java:601)
        at org.dspace.content.WorkspaceItem.deleteAll(WorkspaceItem.java:587)
        at org.dspace.app.itemimport.ItemImport.addItem(ItemImport.java:918)
        at org.dspace.app.itemimport.ItemImport.addItems(ItemImport.java:736)
        at org.dspace.app.itemimport.ItemImport.main(ItemImport.java:498)
        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)
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block


If -R switch used in batch import command it resumes but stops with same error but imports some records. Otherwise dspace is running Okay.

Please help/guide 


Tushar Sangamnerkar
ARDE ,
Pune
Reply all
Reply to author
Forward
0 new messages