Hi all.<br><br>Imagine the following scenario:<br>Two machines running DSpace smoothly, same DSpace version, same OS, BUT _different_ postgres.<br>One is 7.4.17 (let's call it the X server) and the other is 8.1.3 (the Y server).
<br><br>After making some changes on X's dspace, and after all is working well, I transfered the changes<br>to Y, but things just broke. <br><br>I've isolated the error, and it happens when I DatabaseManager.create
(Context c, String table) something.<br><br>Any ideas?<br><br>BTW, the error was:<br><br>org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block<br><div style="direction: ltr;">
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)<br> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)<br> at org.postgresql.core.v3.QueryExecutorImpl.execute
(QueryExecutorImpl.java:188)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java
:340)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)<br> at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)<br> at
org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:135)<br> at org.dspace.content.Author.findAll_2(Author.java:117)<br> at org.dspace.app.webui.servlet.admin.AuthorManageServlet.doDSPost(AuthorManageServlet.java
:92)<br> at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147)<br> at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105)<br> at javax.servlet.http.HttpServlet.service
(HttpServlet.java:709)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br> at org.dspace.app.webui.filter.AdminOnlyFilter.doFilter(AdminOnlyFilter.java:103)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:202)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java
:213)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<br> at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:105)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<br> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)<br> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)<br> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
(PoolTcpEndpoint.java:527)<br> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)<br> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java
:684)<br> at java.lang.Thread.run(Thread.java:595)</div><br><br clear="all"><br>-- <br>Rui Gamito<br><br>Laboratório Nacional de Engenharia Civil<br>LNEC.CTI.NTIEC<br>Avenida do Brasil 101<br>1700-066 Lisboa, Portugal
<br>Tel : ++351 21 844 3819