ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Boisvert <boisv...@intalio.com>
Subject Re: Hibernate / Oracle + Load testing - maximum number of sessions
Date Thu, 19 Mar 2009 03:01:43 GMT
Looks like you're running out of JDBC connections...  You should consider
capping the number of threads (in Ode and in the appserver) and/or
increasing the max. number of JDBC connections.

alex


On Wed, Mar 18, 2009 at 7:26 PM, Rafal Rusin <rafal.rusin@gmail.com> wrote:

> Hello,
> I'm also interested in load testing with Oracle.
> It would be great if you could provide some scripts for your load test
> with sample process.
> Then I could check out some ODE switches and give you some results.
>
> By the way, creating an ODE load tests project would be a very good idea.
> I think providing soapui load test with sample process for jbi and
> axis2 versions would be the best thing to do now.
>
> 2009/3/19 Andi Abes <aabes@progress.com>:
> > Any thoughts?
> >
> >
> >
> > The funny thing about this test is that I've successfully run 100
> > clients with 1 message each. Then tried 100 clients with 5 messages
> > each. This second scenario caused a slew of these...
> >
> >
> >
> > ERROR - GeronimoLog.error(108) | Error while processing transaction,
> > retrying.
> >
> > org.apache.ode.bpel.iapi.Scheduler$JobProcessorException:
> > java.lang.RuntimeException: org.hibernate.exception.GenericJDBCExcept
> >
> > ion: could not get next sequence value
> >
> >
> >
> > with ultimate cause of:
> >
> >
> >
> > Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive
> > SQL level 1
> >
> > ORA-00018: maximum number of sessions exceeded
> >
> >
> >
> >        at
> > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> > 2)
> >
> >        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> >
> >        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> >
> >        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
> >
> >        at
> > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> > a:216)
> >
> >        at
> > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> > ent.java:966)
> >
> >        at
> > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.
> > java:1062)
> >
> >        at
> > oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepared
> > Statement.java:850)
> >
> >        at
> > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> > java:1134)
> >
> >        at
> > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> > dStatement.java:3339)
> >
> >        at
> > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt
> > atement.java:3384)
> >
> >        at
> > org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(Del
> > egatingPreparedStatement.java:93)
> >
> >        at
> > org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:75)
> >
> >        ... 38 more
> >
> >
> >
> >
> >
> >
> >
> > Any thoughts?
> >
> >
>
>
>
> --
> RafaƂ Rusin
> http://www.touk.pl
> http://www.mimuw.edu.pl/~rrusin <http://www.mimuw.edu.pl/%7Errusin>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message