Hi Christophe.<br><br>I've increased the transaction delay but with no results.<br><br>The weird thing is that only an insert seems to break (updates and removes work ok).<br><br>For what I've read across a few forums, the error I'm getting results from a problem with the previous query (which was a simple select ... order by ...). Anyway, if this was the case, wouldn't updates and removes complaint also?
<br><br>Thanks for your help,<br>Rui Gamito<br><br><div><span class="gmail_quote">On 9/24/07, <b class="gmail_sendername">Dupriez Christophe</b> <<a href="mailto:christophe_dupriez@yahoo.fr">christophe_dupriez@yahoo.fr
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>May be the server performances are not equal. You may try to increase the SQL transaction delay in
dspace.cfg (default of 5 seconds seems low to me).</div> <div> </div> <div>Have a nice day!</div> <div> </div> <div>Christophe Dupriez</div> <div><a href="mailto:dupriez@destin.be" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
dupriez@destin.be</a><br><br><b><i>Rui Gamito <<a href="mailto:rgamito@lnec.pt" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">rgamito@lnec.pt</a>></i></b> a écrit :</div> <blockquote style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: 5px;">
<div><span class="e" id="q_1153850f8e1f2e8e_1">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></span></div>Tel : ++351 21 844 3819 _______________________________________________<br>Dspace-general mailing list<br><a href="mailto:Dspace-general@mit.edu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
Dspace-general@mit.edu</a><br><a href="http://mailman.mit.edu/mailman/listinfo/dspace-general" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://mailman.mit.edu/mailman/listinfo/dspace-general</a>
<br></blockquote><span class="ad"><br><p>
</p><hr size="1">
Ne gardez plus qu'une seule adresse mail ! <a href="http://www.trueswitch.com/yahoo-fr/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Copiez vos mails</a> vers Yahoo! Mail <p></p></span></blockquote>
</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