Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Transaction timeout exception ?!
Date: Thu, 1 Jun 2006 20:21:00 +0530
Message-ID: 
 <4690875E336998438DF43A78B8E38CF2E4F5F2@BLRKECMSG01.ad.infosys.com>
Thread-Topic: Transaction timeout exception ?!
Thread-Index: AcaFiC8bmnOzA0m4Qx60Rr1dc3X+FQAAoOUw
From: "Santosh Koti" <Santosh_Koti@infosys.com>
To: <user@geronimo.apache.org>


In that case do we not get a sql exception saying : the no of process =
exceeded more than the <configured limit> ??


Thanks,
Santosh.
"Don't talk about yourself; it will be done when you leave. "
=20

-----Original Message-----
From: Mario R=FCbsam [mailto:mr@coderesearch.com]=20
Sent: Thursday, June 01, 2006 8:03 PM
To: user@geronimo.apache.org
Subject: Re: Transaction timeout exception ?!

Santosh,

first of all my question is now: which database?
I had this under load conditions when not enough database
connections/sessions available on the db server. Or when
the max connections on Geronimo set higher than max connections
on the server.

-Mario

Santosh Koti wrote:
> =20
>=20
> =20
>=20
> Hi all,
>=20
> =20
>=20
> I am getting transaction timeout exception , may I know the=20
> reasons/workaround for it?
>=20
> =20
>=20
> I guess this the container is try ing to commit, but is waiting for =
the=20
> DB to accept the request ?
>=20
> =20
>=20
> Here is the following code snippet from Geronimo=20
> TransactionImpl.java(commit ()) :
>=20
> =20
>=20
> -------------Begin-----------------
>=20
>                                     |   //Transaction method, does =
2pc|
> |221 ||*public*|| *void* commit() *throws* HeuristicMixedException=20
> <http://www.kickjava.com/3071.htm>, HeuristicRollbackException=20
> <http://www.kickjava.com/3072.htm>, RollbackException=20
> <http://www.kickjava.com/3072.htm>, SecurityException=20
> <http://www.kickjava.com/1840.htm>, SystemException=20
> <http://www.kickjava.com/2975.htm> {|
> |222         beforePrepare();|
> |223 |
> |224         *try* {|
> |225                       *boolean* timedout =3D *false*;|
> |226                       *if* (TransactionTimer.getCurrentTime() >=20
> timeout)|
> |227                       {|
> |228                           status =3D =
Status.STATUS_MARKED_ROLLBACK;|
> |229                           timedout =3D *true*;|
> |230                       }|
> |231 |
> |232             *if* (status =3D=3D Status.STATUS_MARKED_ROLLBACK) {|
> |233                 rollbackResources(resourceManagers);|
> |234                               *if*(timedout)|
> |235                               {|
> |236                                   *throw* *new* RollbackException =

> <http://www.kickjava.com/3072.htm>("Transaction timout");|
> |237                               }|
> |238                               *else*|
> |239                               {|
> |240                                   *throw* *new* RollbackException =

> <http://www.kickjava.com/3072.htm>("Unable to commit");|
> |241                               }|
> |242             }|
> |243             *synchronized* (*this*) {|
> |244                 *if* (status =3D=3D Status.STATUS_ACTIVE) {|
> |245                     *if* (*this*.resourceManagers.size() =3D=3D =
0) {|
> |246                         // nothing to commit|
> |247 status =3D Status.STATUS_COMMITTED;|
> |248                     } *else* *if* (*this*.resourceManagers.size() =

> =3D=3D 1) {|
> |249                         // one-phase commit decision|
> |250 status =3D Status.STATUS_COMMITTING;|
> |251                     } *else* {|
> |252                         // start prepare part of two-phase|
>=20
> =20
>=20
> =20
>=20
> -------------End--------------------
>=20
> Thanks,
>=20
> Santosh.
>=20
> "Don't talk about yourself; it will be done when you leave. "
>=20
> =20
>=20
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended=20
> solely for the use of the addressee(s). If you are not the intended=20
> recipient, please notify the sender by e-mail and delete the original=20
> message. Further, you are not to copy, disclose, or distribute this=20
> e-mail or its contents to any other person and any such actions are=20
> unlawful. This e-mail may contain viruses. Infosys has taken every=20
> reasonable precaution to minimize this risk, but is not liable for any =

> damage you may sustain as a result of any virus in this e-mail. You=20
> should carry out your own virus checks before opening the e-mail or=20
> attachment. Infosys reserves the right to monitor and review the =
content=20
> of all messages sent to or from this e-mail address. Messages sent to =
or=20
> from this e-mail address may be stored on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>=20