SEVERE: Can't lookup new HighLowSequence for field id using sequence name SEQ_t_xx_xxx

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

SEVERE: Can't lookup new HighLowSequence for field id using sequence name SEQ_t_xx_xxx

ChupaMe
Hi,

we have a Problem with Tomcat/MySQL which causes our webapplication to stop working.
After a restart of Tomcat and MySQL it works again. But we have to do this a few times a day.

First some Info about the Server and versions:
- SUSE LINUX Enterprise Server 9 (i586) Patchlevel 4
- jakarta-tomcat-5.0.19-29.18
- mysql-shared-4.0.18-32.37
- java2-jre-1.4.2-129.48
- java2-1.4.2-129.48


Often the follow error occurs the application is blocked:

Mar 12, 2009 9:25:19 AM org.apache.ojb.broker.util.logging.CommonsLoggerImpl error
SEVERE: Can't lookup new HighLowSequence for field id using sequence name SEQ_t_xx_xxx
org.apache.ojb.broker.TransactionInProgressException: Connection is already in transaction
        at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(Unknown Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.beginTransaction(Unknown Source)
        …

This error is always in relation with the following warnings:

12 Mar 09:20:31  22794068 [http8080-Processor16] WARN  ch.XXX.XXX.dh.PersistenceSession  - org.apache.ojb.broker.PersistenceBrokerException: org.apache.ojb.broker.accesslayer.RsIterator$ResourceClosedException: Resources no longer reachable, RsIterator will be automatic cleaned up on PB.close/.commitTransaction/.abortTransaction
12 Mar 09:25:19  23081606 [http8080-Processor16] INFO  ch.XXX.XXX.dh.PersistenceSession  - Transaktion abgebrochen
12 Mar 09:25:19  23081606 [http8080-Processor16] WARN  ch.XXX.XXX.dh.PersistenceSession  - org.apache.ojb.broker.PersistenceBrokerException: Error while try to assign identity value
12 Mar 09:25:19  23081606 [http8080-Processor16] WARN  ch.XXX.XXX.servlets.BestellungSaveServlet  - Error while try to assign identity value

Does anybody have a hint?

Thank you
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SEVERE: Can't lookup new HighLowSequence for field id using sequence name SEQ_t_xx_xxx

ChupaMe
Hello,

does anybody have a clue? Please help.

Thank You!


ChupaMe wrote
Hi,

we have a Problem with Tomcat/MySQL which causes our webapplication to stop working.
After a restart of Tomcat and MySQL it works again. But we have to do this a few times a day.

First some Info about the Server and versions:
- SUSE LINUX Enterprise Server 9 (i586) Patchlevel 4
- jakarta-tomcat-5.0.19-29.18
- mysql-shared-4.0.18-32.37
- java2-jre-1.4.2-129.48
- java2-1.4.2-129.48


Often the follow error occurs the application is blocked:

Mar 12, 2009 9:25:19 AM org.apache.ojb.broker.util.logging.CommonsLoggerImpl error
SEVERE: Can't lookup new HighLowSequence for field id using sequence name SEQ_t_xx_xxx
org.apache.ojb.broker.TransactionInProgressException: Connection is already in transaction
        at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(Unknown Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.beginTransaction(Unknown Source)
        …

This error is always in relation with the following warnings:

12 Mar 09:20:31  22794068 [http8080-Processor16] WARN  ch.XXX.XXX.dh.PersistenceSession  - org.apache.ojb.broker.PersistenceBrokerException: org.apache.ojb.broker.accesslayer.RsIterator$ResourceClosedException: Resources no longer reachable, RsIterator will be automatic cleaned up on PB.close/.commitTransaction/.abortTransaction
12 Mar 09:25:19  23081606 [http8080-Processor16] INFO  ch.XXX.XXX.dh.PersistenceSession  - Transaktion abgebrochen
12 Mar 09:25:19  23081606 [http8080-Processor16] WARN  ch.XXX.XXX.dh.PersistenceSession  - org.apache.ojb.broker.PersistenceBrokerException: Error while try to assign identity value
12 Mar 09:25:19  23081606 [http8080-Processor16] WARN  ch.XXX.XXX.servlets.BestellungSaveServlet  - Error while try to assign identity value

Does anybody have a hint?

Thank you
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SEVERE: Can't lookup new HighLowSequence for field id using sequence name SEQ_t_xx_xxx

Alessandro Colantoni
Hi,

The first think I'd try, could be to switch to java 1.5 or higher.

Anyway you should say if the error you get is always when executing the same
piece of code or it is "aleatory",

Try to isolate the problem and provide more information.

regards

Alessandro

On Thu, Apr 23, 2009 at 2:43 PM, ChupaMe <[hidden email]> wrote:

>
> Hello,
>
> does anybody have a clue? Please help.
>
> Thank You!
>
>
>
> ChupaMe wrote:
> >
> > Hi,
> >
> > we have a Problem with Tomcat/MySQL which causes our webapplication to
> > stop working.
> > After a restart of Tomcat and MySQL it works again. But we have to do
> this
> > a few times a day.
> >
> > First some Info about the Server and versions:
> > - SUSE LINUX Enterprise Server 9 (i586) Patchlevel 4
> > - jakarta-tomcat-5.0.19-29.18
> > - mysql-shared-4.0.18-32.37
> > - java2-jre-1.4.2-129.48
> > - java2-1.4.2-129.48
> >
> >
> > Often the follow error occurs the application is blocked:
> >
> > Mar 12, 2009 9:25:19 AM
> > org.apache.ojb.broker.util.logging.CommonsLoggerImpl error
> > SEVERE: Can't lookup new HighLowSequence for field id using sequence name
> > SEQ_t_xx_xxx
> > org.apache.ojb.broker.TransactionInProgressException: Connection is
> > already in transaction
> >         at
> >
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(Unknown
> > Source)
> >         at
> > org.apache.ojb.broker.core.PersistenceBrokerImpl.beginTransaction(Unknown
> > Source)
> >         …
> >
> > This error is always in relation with the following warnings:
> >
> > 12 Mar 09:20:31  22794068 [http8080-Processor16] WARN
> > ch.XXX.XXX.dh.PersistenceSession  -
> > org.apache.ojb.broker.PersistenceBrokerException:
> > org.apache.ojb.broker.accesslayer.RsIterator$ResourceClosedException:
> > Resources no longer reachable, RsIterator will be automatic cleaned up on
> > PB.close/.commitTransaction/.abortTransaction
> > 12 Mar 09:25:19  23081606 [http8080-Processor16] INFO
> > ch.XXX.XXX.dh.PersistenceSession  - Transaktion abgebrochen
> > 12 Mar 09:25:19  23081606 [http8080-Processor16] WARN
> > ch.XXX.XXX.dh.PersistenceSession  -
> > org.apache.ojb.broker.PersistenceBrokerException: Error while try to
> > assign identity value
> > 12 Mar 09:25:19  23081606 [http8080-Processor16] WARN
> > ch.XXX.XXX.servlets.BestellungSaveServlet  - Error while try to assign
> > identity value
> >
> > Does anybody have a hint?
> >
> > Thank you
> >
>
> --
> View this message in context:
> http://www.nabble.com/SEVERE%3A-Can%27t-lookup-new-HighLowSequence-for-field-id-using-sequence-name-SEQ_t_xx_xxx-tp22558473p23196144.html
> Sent from the Apache DB - ObjectRelationalBridge Users mailing list archive
> at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
Loading...