You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by ChupaMe <ch...@chupame.ch> on 2009/04/23 14:43:28 UTC
Re: SEVERE: Can't lookup new HighLowSequence for field id using
sequence name SEQ_t_xx_xxx
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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: SEVERE: Can't lookup new HighLowSequence for field id using
sequence name SEQ_t_xx_xxx
Posted by Alessandro Colantoni <al...@gmail.com>.
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 <ch...@chupame.ch> 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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>