[Dspace-general] DatabaseManager.create breaks

[Rui Gamito]

Hi all.

Imagine the following scenario:
Two machines running DSpace smoothly, same DSpace version, same OS, BUT
_different_ postgres.
One is 7.4.17 (let's call it the X server) and the other is 8.1.3 (the Y
server).

After making some changes on X's dspace, and after all is working well, I
transfered the changes
to Y, but things just broke.

I've isolated the error, and it happens when I
DatabaseManager.create(Context c, String table) something.

Any ideas?

BTW, the error was:

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:1525)
       at org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:1309)
       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:340)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
AbstractJdbc2Statement.java:239)
       at org.apache.commons.dbcp.DelegatingStatement.executeQuery(
DelegatingStatement.java:205)
       at org.dspace.storage.rdbms.DatabaseManager.query(
DatabaseManager.java:135)
       at org.dspace.content.Author.findAll_2(Author.java:117)
       at org.dspace.app.webui.servlet.admin.AuthorManageServlet.doDSPost(
AuthorManageServlet.java:92)
       at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(
DSpaceServlet.java:147)
       at org.dspace.app.webui.servlet.DSpaceServlet.doPost(
DSpaceServlet.java:105)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
       at org.dspace.app.webui.filter.AdminOnlyFilter.doFilter(
AdminOnlyFilter.java:103)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
       at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
       at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
       at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:126)
       at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
       at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
       at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
       at org.apache.coyote.http11.Http11Processor.process(
Http11Processor.java:869)
       at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:667)
       at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
       at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:80)
       at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:684)
       at java.lang.Thread.run(Thread.java:595)



-- 
Rui Gamito

Laboratório Nacional de Engenharia Civil
LNEC.CTI.NTIEC
Avenida do Brasil 101
1700-066 Lisboa, Portugal
Tel : ++351 21 844 3819
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/dspace-general/attachments/20070924/572a2239/attachment.htm