[Dspace-general] RE : DatabaseManager.create breaks

[Rui Gamito]

Hi Christophe.

I've increased the transaction delay but with no results.

The weird thing is that only an insert seems to break (updates and removes
work ok).

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?

Thanks for your help,
Rui Gamito

On 9/24/07, Dupriez Christophe <christophe_dupriez at yahoo.fr> wrote:
>
> 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).
>
> Have a nice day!
>
> Christophe Dupriez
> dupriez at destin.be
>
> *Rui Gamito <rgamito at lnec.pt>* a écrit :
>
> 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 _______________________________________________
> Dspace-general mailing list
> Dspace-general at mit.edu
> http://mailman.mit.edu/mailman/listinfo/dspace-general
>
>
> ------------------------------
> Ne gardez plus qu'une seule adresse mail ! Copiez vos mails<http://www.trueswitch.com/yahoo-fr/>vers Yahoo! Mail
>
>


-- 
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/20070925/2a58aef7/attachment.htm