You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by tschuler <th...@opentext.com> on 2017/02/03 11:50:07 UTC
TomEE 7.0.2 - increasing quartz tx database connections
Hi!
Our application is using scheduled beans.
The according timers are persisted within quartz tables.
This works as expected using TomEE 7.0.1 (webprofile).
But within TomEE 7.0.2 (also webprofile) we get in trouble because tx
database connections to quartz tables are not released any more.
It does not depend on database: We tried using MSSQL, Oracle & Postgres
database.
It also does not depend on type of timer: We tried calendar, interval and
single action timer.
The amount of database connections seems to be increased in case of adding a
timer only: Timer cancel or timer fire has no impact.
Always three additional connections can be observered while one timer is
added.
Does anyone have an idea what might be cause for the issue?
We are actually not able to provide a simple example but we are working on
it.
Best regards,
Thomas
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
2017-02-23 12:11 GMT+01:00 tschuler <th...@opentext.com>:
> Thanks Romain for clarification.
> Did the quartz handling switched to outside the transaction with
> introduction of the "shaded" quartz access?
>
>
No, never has been in the tx I think - if we run it in the tx then quartz
meta can be rolled back with the business code which is wrong.
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681139.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Thanks Romain for clarification.
Did the quartz handling switched to outside the transaction with
introduction of the "shaded" quartz access?
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681139.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Yes, summarized it could be said this way I think: "quartz doc is valid but
tomee usage of quartz is 'internal' and outside the EJB".
If you use yourself quartz from the EJB then you could use the CMT config
but not the case using @Schedule IIRC.
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-23 11:58 GMT+01:00 tschuler <th...@opentext.com>:
> Hi Romain!
>
> We configured quartz for using JDBC-JobStoreCMT (see
> http://www.quartz-scheduler.org/documentation/quartz-2.2.x/configuration/
> ConfigJobStoreCMT.html).
> It is suggested to be used if "applications are using JTA transactions
> (such
> as via EJB Session Beans) to perform their work."
> To my way of thinking that's exactly what we do if we use scheduled beans.
> The configuration needs two datasources (CMT and non-CMT).
> If we change the configuration to use the non-CMT datasource also as CMT
> datasource - no more open connections are left behind.
>
> That means that even if scheduled beans are used the quartz handling
> happens
> outside the transaction - did I get it right?
>
> So JDBC-JobStoreTX (see
> http://www.quartz-scheduler.org/documentation/quartz-2.2.x/configuration/
> ConfigJobStoreTX.html)
> should be used instead?
>
> Best regards,
> Thomas
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681137.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Hi Romain!
We configured quartz for using JDBC-JobStoreCMT (see
http://www.quartz-scheduler.org/documentation/quartz-2.2.x/configuration/ConfigJobStoreCMT.html).
It is suggested to be used if "applications are using JTA transactions (such
as via EJB Session Beans) to perform their work."
To my way of thinking that's exactly what we do if we use scheduled beans.
The configuration needs two datasources (CMT and non-CMT).
If we change the configuration to use the non-CMT datasource also as CMT
datasource - no more open connections are left behind.
That means that even if scheduled beans are used the quartz handling happens
outside the transaction - did I get it right?
So JDBC-JobStoreTX (see
http://www.quartz-scheduler.org/documentation/quartz-2.2.x/configuration/ConfigJobStoreTX.html)
should be used instead?
Best regards,
Thomas
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681137.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Did you try passing a JtaManaged=false database to quartz? Quartz should be
the one responsible to close this connection.
I wonder if the changes related to isClosed() and close() are related to
that but shouldnt.
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-22 12:29 GMT+01:00 tschuler <th...@opentext.com>:
> Hi Romain!
>
> We want to share what we found out so far.
>
> We added some log messages in both versions (7.0.1 & 7.0.2) of
> org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.java
> recording connection create & close.
> What we see is that while transaction completion the established
> connections used in transaction are closed.
> Afterwards the quartz handling happens requesting a connection to quartz
> database three times.
> As transaction got status 3 the connections are created at a "fallback"
> section commented with // we shouldn't come here, tempted to just throw an
> exception (see ManagedConnection.java).
>
> That happens for both versions 7.0.1 and 7.0.2. To my way of thinking the
> connections are closed to early in case of quartz handling.
> But nonetheless.
>
> TomEE 7.0.1 is able to resue and close the connection that was created in
> the "fallback" section. (see attachment extract701.txt)
> TomEE 7.0.2 is not able to resue and close these connections any more
> causing the error. (see attachment extract702.txt)
>
> So my questions so far:
> Do you have an idea where the "fallback" connection is closed within TomEE
> 7.0.1?
> Can you give me a hint what to look at to get a deeper insight?
>
> We are still not able to reproduce it within a small example.
> Maybe because 'in real' the timer is added using a web service call or
> because of an additional datasource is used within the transaction.
> But we will enhance the example step by step ...
>
> Best regards,
> Thomas
>
>
> extract702.txt (22K) <http://tomee-openejb.979440.
> n4.nabble.com/attachment/4681131/0/extract702.txt>
> extract701.txt (22K) <http://tomee-openejb.979440.
> n4.nabble.com/attachment/4681131/1/extract701.txt>
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681131.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
RE: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Hi Romain!
We want to share what we found out so far.
We added some log messages in both versions (7.0.1 & 7.0.2) of org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.java recording connection create & close.
What we see is that while transaction completion the established connections used in transaction are closed.
Afterwards the quartz handling happens requesting a connection to quartz database three times.
As transaction got status 3 the connections are created at a "fallback" section commented with // we shouldn't come here, tempted to just throw an exception (see ManagedConnection.java).
That happens for both versions 7.0.1 and 7.0.2. To my way of thinking the connections are closed to early in case of quartz handling.
But nonetheless.
TomEE 7.0.1 is able to resue and close the connection that was created in the "fallback" section. (see attachment extract701.txt)
TomEE 7.0.2 is not able to resue and close these connections any more causing the error. (see attachment extract702.txt)
So my questions so far:
Do you have an idea where the "fallback" connection is closed within TomEE 7.0.1?
Can you give me a hint what to look at to get a deeper insight?
We are still not able to reproduce it within a small example.
Maybe because 'in real' the timer is added using a web service call or because of an additional datasource is used within the transaction.
But we will enhance the example step by step ...
Best regards,
Thomas
extract702.txt (22K) <http://tomee-openejb.979440.n4.nabble.com/attachment/4681131/0/extract702.txt>
extract701.txt (22K) <http://tomee-openejb.979440.n4.nabble.com/attachment/4681131/1/extract701.txt>
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681131.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
2017-02-13 12:30 GMT+01:00 tschuler <th...@opentext.com>:
> Hi Romain!
>
> Sure.
> We try to reproduce issue without our complete application.
> As soon as we identified the root cause we can write an according
> datasource
> test.
> Is there a planned release date for upcoming TomEE 7.0.3?
>
>
nothing planned, but nothing blocking too :)
> Best regards,
> Thomas
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681074.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Hi Romain!
Sure.
We try to reproduce issue without our complete application.
As soon as we identified the root cause we can write an according datasource
test.
Is there a planned release date for upcoming TomEE 7.0.3?
Best regards,
Thomas
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681074.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Any hope you work on a test to reproduce it? We have a few quartz and
datasource tests on master and i can help you to write it if needed but the
related commit fixed some leaks so would be great to identify finely your
case.
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-13 12:03 GMT+01:00 tschuler <th...@opentext.com>:
> We tried latest TomEE 7.0.3 snapshot - same issue (increasing quartz tx
> database connections).
> What might be worth to know for the log files provided before: We use
> several connection pools.
> Connections 49 & 50 are related to a non-quartz connection pool.
> Connections 28, 29 & 30 (the ones that are not closed) are related to
> quartz
> connection pool.
>
> Best regards,
> Thomas
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681069.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
We tried latest TomEE 7.0.3 snapshot - same issue (increasing quartz tx
database connections).
What might be worth to know for the log files provided before: We use
several connection pools.
Connections 49 & 50 are related to a non-quartz connection pool.
Connections 28, 29 & 30 (the ones that are not closed) are related to quartz
connection pool.
Best regards,
Thomas
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681069.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Would also be interesting to update
https://github.com/apache/tomee/blob/6d7565af8f6c216644d32dd724bb5a6cd44dc6c5/tomee/tomee-jdbc/src/test/java/org/apache/tomee/jdbc/TomcatXADataSourceTest.java
to reproduce this behavior if you manage to identify the cause.
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-13 10:58 GMT+01:00 Romain Manni-Bucau <rm...@gmail.com>:
> https://repository.apache.org/content/groups/snapshots/org/
> apache/tomee/apache-tomee/ (openejb moved to tomee for 7.x in groupId)
>
>
> Romain Manni-Bucau
> @rmannibucau <https://twitter.com/rmannibucau> | Blog
> <https://blog-rmannibucau.rhcloud.com> | Old Blog
> <http://rmannibucau.wordpress.com> | Github
> <https://github.com/rmannibucau> | LinkedIn
> <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
> <https://javaeefactory-rmannibucau.rhcloud.com>
>
> 2017-02-13 10:54 GMT+01:00 tschuler <th...@opentext.com>:
>
>> Hi Romain!
>>
>> Lines cannot match master version of ManagedConnection.java because we
>> changed it a bit (see attached ManagedConnection.java) on base of TomEE
>> 7.0.2 release.
>> On the other hand we actually have no idea where to find TomEE snapshot -
>> https://repository.apache.org/content/groups/snapshots/org/a
>> pache/openejb/apache-tomee/ does not seem to be snapshot folder any more.
>>
>> Best regards,
>> Thomas
>>
>> From: Romain Manni-Bucau [via TomEE & OpenEJB] [mailto:
>> ml-node+s979440n4681062h32@n4.nabble.com]
>> Sent: Montag, 13. Februar 2017 10:40
>> To: Thomas Schuler <Th...@opentext.com>
>> Subject: Re: TomEE 7.0.2 - increasing quartz tx database connections
>>
>> seems lines don't match master, can you try the snapshot?
>>
>>
>> Romain Manni-Bucau
>> @rmannibucau <https://twitter.com/rmannibucau<https://urldefense.
>> proofpoint.com/v2/url?u=https-3A__twitter.com_rmannibucau&d=
>> DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
>> P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
>> QGRzW_-aXgTo66TRN_vhZDPQp14HHqKNXJBppBbrZfA&e=>> | Blog
>> <https://blog-rmannibucau.rhcloud.com<https://urldefense.
>> proofpoint.com/v2/url?u=https-3A__blog-2Drmannibucau.
>> rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
>> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo
>> 4CNs&s=f0bEeHbgfwmZ9VwkbJKuztxWIesi3_Q6aX_t2L4WgmQ&e=>> | Old Blog
>> <http://rmannibucau.wordpress.com<https://urldefense.proofpo
>> int.com/v2/url?u=http-3A__rmannibucau.wordpress.com&d=
>> DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
>> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo
>> 4CNs&s=mphWJQ99rGdcA7SXIyAwA7cpHr3DvK1QNkl63fFSfg0&e=>> | Github <
>> https://github.com/rmannibucau<https://urldefense.
>> proofpoint.com/v2/url?u=https-3A__github.com_rmannibucau&d=
>> DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
>> P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=p4
>> lVtShsbWWgilgR1n1umjOMJk0YarG4TvV1GYCMSc0&e=>> |
>> LinkedIn <https://www.linkedin.com/in/rmannibucau<https://urldefense.
>> proofpoint.com/v2/url?u=https-3A__www.linkedin.com_in_
>> rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2Y
>> U3LgQbr2QUrGN8RO1mdlo4CNs&s=KJncjGo9tFJEKAPzYIwIMWFSN1VsXe_
>> xahY_DzcZlBc&e=>> | JavaEE Factory
>> <https://javaeefactory-rmannibucau.rhcloud.com<https://
>> urldefense.proofpoint.com/v2/url?u=https-3A__javaeefactory-
>> 2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2Y
>> U3LgQbr2QUrGN8RO1mdlo4CNs&s=nmP7DqgVP__ao1cpigRcoNgw2MZaFa
>> xDcrm1u4OK2FM&e=>>
>>
>> 2017-02-13 10:17 GMT+01:00 tschuler <[hidden
>> email]</user/SendEmail.jtp?type=node&node=4681062&i=0>>:
>>
>> > Hi Romain!
>> >
>> > Attached text file (startAgent_IncludingStackTraces.log) includes the
>> log
>> > messages (including stack traces) showing three connections opened
>> (Thread
>> > "http-nio-28080-exec-1" - ConnectionID 30, 29 & 28) but not closed any
>> more.
>> > Maybe that's more helpful.
>> >
>> > Best regards,
>> > Thomas
>> >
>> >
>> > From: Romain Manni-Bucau [via TomEE & OpenEJB] [mailto:ml-node+
>> > [hidden email]</user/SendEmail.jtp?type=node&node=4681062&i=1>]
>> > Sent: Freitag, 10. Februar 2017 16:59
>> > To: Thomas Schuler <[hidden email]</user/SendEmail.jtp?typ
>> e=node&node=4681062&i=2>>
>> > Subject: Re: TomEE 7.0.2 - increasing quartz tx database connections
>> >
>> > can you add the stack as well (new Exception().printStackTrace())?
>> would
>> > help to see where it leaks from
>> >
>> >
>> > Romain Manni-Bucau
>> > @rmannibucau <https://twitter.com/rmannibucau<https://urldefense.
>> proofpoint.com/v2/url?u=https-3A__twitter.com_rmannibucau&d=
>> DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
>> P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
>> QGRzW_-aXgTo66TRN_vhZDPQp14HHqKNXJBppBbrZfA&e=><https://
>> > urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_
>> > rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_
>> > TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=
>> > MgNLC1GEfYqS9Nkkh-9fK6QUonLKiFRcJpgAVpK-gKA&e=>> | Blog
>> > <https://blog-rmannibucau.rhcloud.com<https://urldefense.
>> proofpoint.com/v2/url?u=https-3A__blog-2Drmannibucau.
>> rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
>> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo
>> 4CNs&s=f0bEeHbgfwmZ9VwkbJKuztxWIesi3_Q6aX_t2L4WgmQ&e=><https://
>> > urldefense.proofpoint.com/v2/url?u=https-3A__blog-
>> > 2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&
>> r=tcnVZpsm--
>> > xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
>> > aWlwIXOID5aHgTDLY2c&s=czTl_KlUFJYLumqyKOTPlqjOiW0Xm5xSwCxw2RuUgvY&e=>>
>> |
>> > Old Blog
>> > <http://rmannibucau.wordpress.com<https://urldefense.proofpo
>> int.com/v2/url?u=http-3A__rmannibucau.wordpress.com&d=
>> DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
>> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo
>> 4CNs&s=mphWJQ99rGdcA7SXIyAwA7cpHr3DvK1QNkl63fFSfg0&e=><https://urldefense
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__urldefense&d=
>> DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
>> P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=nbAuuDc-vYv2Ij-
>> LqNTVVYue256rOwQ6J-TRfymHwBo&e=>.
>> > proofpoint.com/v2/url?u=http-3A__rmannibucau.wordpress.com&
>> > d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
>> > P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=_
>> > 9UwlWBsLmBCnBD2u1gM-INAOCHv0ArrgKtOiyR0O3g&e=>> | Github <
>> > https://github.com/rmannibucau<https://urldefense.proofpoint
>> .com/v2/url?u=https-3A__github.com_rmannibucau&d=DwMCA
>> g&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
>> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo
>> 4CNs&s=p4lVtShsbWWgilgR1n1umjOMJk0YarG4TvV1GYCMSc0&e=><https
>> ://urldefense.proofpoint.com/v2/
>> > url?u=https-3A__github.com_rmannibucau&d=DwMCAg&c=
>> > ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
>> > j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=oqkryix_
>> > txHO7YCLiaABH4cEPqkAV6YMmPReJoV5JZQ&e=>> |
>> > LinkedIn <https://www.linkedin.com/in/rmannibucau<https://urldefense.
>> proofpoint.com/v2/url?u=https-3A__www.linkedin.com_in_
>> rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2Y
>> U3LgQbr2QUrGN8RO1mdlo4CNs&s=KJncjGo9tFJEKAPzYIwIMWFSN1VsXe_
>> xahY_DzcZlBc&e=><https://
>> > urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.
>> > com_in_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
>> > tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
>> > aWlwIXOID5aHgTDLY2c&s=uiTJP4mPtAVQ4Fcihqb7ggraf7n8DheowMIKhUB7tXI&e=>>
>> |
>> > JavaEE Factory
>> > <https://javaeefactory-rmannibucau.rhcloud.com<https://
>> urldefense.proofpoint.com/v2/url?u=https-3A__javaeefactory-
>> 2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2Y
>> U3LgQbr2QUrGN8RO1mdlo4CNs&s=nmP7DqgVP__ao1cpigRcoNgw2MZaFa
>> xDcrm1u4OK2FM&e=><https:
>> > //urldefense.proofpoint.com/v2/url?u=https-3A__
>> > javaeefactory-2Drmannibucau.rhcloud.com&d=DwMCAg&c=
>> > ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
>> > j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=2MgU1N170sWgWkYfKyl-
>> > y7U4UMLxBgQLLNYy9JpKVRU&e=>>
>> >
>> > 2017-02-10 15:43 GMT+01:00 tschuler <[hidden email]</user/SendEmail.jtp?
>> > type=node&node=4681053&i=0>>:
>> >
>> > > Hi Romain!
>> > >
>> > > We actually cannot reproduce the issue within a small example.
>> > >
>> > > But what we did was "enhancing" ManagedConnection.java with log
>> messages
>> > > in case of connection is created or closed.
>> > > Attached text file (startAgent2.log) includes the additional log
>> messages
>> > > showing that three connections are opened (Thread
>> > "http-nio-28080-exec-5" -
>> > > ConnectionID 30, 29 & 28) but not closed any more.
>> > >
>> > > Maybe that helps identifying the root cause.
>> > > If you have a "log message enhancement" suggestion - we'll add it.
>> > >
>> > > Best regards,
>> > > Thomas
>> > >
>> > >
>> > > startAgent2.txt (14K) <http://tomee-openejb.979440<h
>> ttps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Do
>> penejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2Y
>> U3LgQbr2QUrGN8RO1mdlo4CNs&s=YEkBfc2USevamHl4W5CJNFujg4eW3pCg
>> aPgsS32hRJw&e=><h
>> > ttps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
>> > 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
>> > tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
>> > aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
>> > > n4.nabble.com/attachment/4681052/0/startAgent2.txt>
>> > >
>> > >
>> > >
>> > >
>> > > --
>> > > View this message in context: http://tomee-openejb.979440<ht
>> tps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dop
>> enejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2Y
>> U3LgQbr2QUrGN8RO1mdlo4CNs&s=YEkBfc2USevamHl4W5CJNFujg4eW3pCg
>> aPgsS32hRJw&e=><ht
>> > tps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
>> > 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
>> > tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
>> > aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
>> > > n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
>> > > connections-tp4681007p4681052.html
>> > > Sent from the TomEE Users mailing list archive at Nabble.com.
>> > >
>> >
>> > ________________________________
>> > If you reply to this email, your message will be added to the discussion
>> > below:
>> > http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-<https
>> ://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopen
>> ejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-2D&d=DwMCAg&
>> c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
>> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo
>> 4CNs&s=pdDOs4sVAu0kvV9qPbjAU1z19zibAokcdiLThC0ixFc&e=>
>> > increasing-quartz-tx-database-connections-tp4681007p4681053.html<
>> > https://urldefense.proofpoint.com/v2/url?u=http-
>> > 3A__tomee-2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-
>> > 2Dincreasing-2Dquartz-2Dtx-2Ddatabase-2Dconnections-
>> > 2Dtp4681007p4681053.html&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> > xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
>> > aWlwIXOID5aHgTDLY2c&s=9T16nD_KwsWbAHBgR5NgiDM1Yi4iZMF1pGFK7AG6TdA&e=>
>> > To unsubscribe from TomEE 7.0.2 - increasing quartz tx database
>> > connections, click here<https://urldefense.proofp
>> oint.com/v2/url?u=http-
>> > 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServle
>> t.jtp-3Fmacro-
>> > 3Dunsubscribe-5Fby-5Fcode-26node-3D4681007-26code-
>> > 3DdGhvbWFzLnNjaHVsZXJAb3BlbnRleHQuY29tfDQ2ODEwMDd8LTE4NTIyNT
>> > Q0OTI-3D&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
>> > TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=
>> > 0QsMQ2bRmXiAKc4k6q5mMgNrjCXzuC7tZN56yhgmxN8&e=>.
>> > NAML<https://urldefense.proofpoint.com/v2/url?u=http-
>> > 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServle
>> t.jtp-3Fmacro-
>> > 3Dmacro-5Fviewer-26id-3Dinstant-5Fhtml-2521nabble-253Aemail.
>> naml-26base-
>> > 3Dnabble.naml.namespaces.BasicNamespace-2Dnabble.view.
>> > web.template.NabbleNamespace-2Dnabble.view.web.template.
>> > NodeNamespace-26breadcrumbs-3Dnotify-5Fsubscribers-
>> > 2521nabble-253Aemail.naml-2Dinstant-5Femails-2521nabble-
>> > 253Aemail.naml-2Dsend-5Finstant-5Femail-2521nabble-
>> > 253Aemail.naml&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
>> > tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
>> > aWlwIXOID5aHgTDLY2c&s=BEpNzfKI-x6d45mFXlfG-aid1yvQnQssiOVvnX1Mv2E&e=>
>> >
>> >
>> > startAgent_IncludingStackTraces.txt (142K) <http://tomee-openejb.979440
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Do
>> penejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2Y
>> U3LgQbr2QUrGN8RO1mdlo4CNs&s=YEkBfc2USevamHl4W5CJNFujg4eW3pCg
>> aPgsS32hRJw&e=>.
>> > n4.nabble.com/attachment/4681061/0/startAgent_IncludingStackTraces.txt>
>> >
>> >
>> >
>> >
>> > --
>> > View this message in context: http://tomee-openejb.979440<ht
>> tps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dop
>> enejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2Y
>> U3LgQbr2QUrGN8RO1mdlo4CNs&s=YEkBfc2USevamHl4W5CJNFujg4eW3pCg
>> aPgsS32hRJw&e=>.
>> > n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
>> > connections-tp4681007p4681061.html
>> > Sent from the TomEE Users mailing list archive at Nabble.com.
>> >
>>
>> ________________________________
>> If you reply to this email, your message will be added to the discussion
>> below:
>> http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increa
>> sing-quartz-tx-database-connections-tp4681007p4681062.html<h
>> ttps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
>> 2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-2Dincrea
>> sing-2Dquartz-2Dtx-2Ddatabase-2Dconnections-2Dtp4681007p4681
>> 062.html&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
>> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo
>> 4CNs&s=nJ6wv98JhKkAZXufOKnWqpduvLmvJgqKQzBRIJmx52Q&e=>
>> To unsubscribe from TomEE 7.0.2 - increasing quartz tx database
>> connections, click here<https://urldefense.proofp
>> oint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440.n4.nabb
>> le.com_template_NamlServlet.jtp-3Fmacro-3Dunsubscribe-
>> 5Fby-5Fcode-26node-3D4681007-26code-3DdGhvbWFzLnNjaHVsZXJAb
>> 3BlbnRleHQuY29tfDQ2ODEwMDd8LTE4NTIyNTQ0OTI-3D&d=DwMCAg&c=ZgV
>> Rmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
>> P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=Eo
>> MT1Qng2FlncOFhrviAa_1Z6suhoKXrc949Lq5Z4z8&e=>.
>> NAML<https://urldefense.proofpoint.com/v2/url?u=http-3A__
>> tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.
>> jtp-3Fmacro-3Dmacro-5Fviewer-26id-3Dinstant-5Fhtml-
>> 2521nabble-253Aemail.naml-26base-3Dnabble.naml.namespaces.BasicNamespace-
>> 2Dnabble.view.web.template.NabbleNamespace-2Dnabble.view.
>> web.template.NodeNamespace-26breadcrumbs-3Dnotify-
>> 5Fsubscribers-2521nabble-253Aemail.naml-2Dinstant-
>> 5Femails-2521nabble-253Aemail.naml-2Dsend-5Finstant-5Femail-
>> 2521nabble-253Aemail.naml&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
>> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2Y
>> U3LgQbr2QUrGN8RO1mdlo4CNs&s=FC0WgnZajzsyFUL3guvs91s3GABdK8Er
>> iafHpvWBpIc&e=>
>>
>>
>> ManagedConnection.java (17K) <http://tomee-openejb.979440.n
>> 4.nabble.com/attachment/4681063/0/ManagedConnection.java>
>>
>>
>>
>>
>> --
>> View this message in context: http://tomee-openejb.979440.n4
>> .nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connec
>> tions-tp4681007p4681063.html
>> Sent from the TomEE Users mailing list archive at Nabble.com.
>>
>
>
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
https://repository.apache.org/content/groups/snapshots/org/apache/tomee/apache-tomee/
(openejb moved to tomee for 7.x in groupId)
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-13 10:54 GMT+01:00 tschuler <th...@opentext.com>:
> Hi Romain!
>
> Lines cannot match master version of ManagedConnection.java because we
> changed it a bit (see attached ManagedConnection.java) on base of TomEE
> 7.0.2 release.
> On the other hand we actually have no idea where to find TomEE snapshot -
> https://repository.apache.org/content/groups/snapshots/org/
> apache/openejb/apache-tomee/ does not seem to be snapshot folder any more.
>
> Best regards,
> Thomas
>
> From: Romain Manni-Bucau [via TomEE & OpenEJB] [mailto:ml-node+
> s979440n4681062h32@n4.nabble.com]
> Sent: Montag, 13. Februar 2017 10:40
> To: Thomas Schuler <Th...@opentext.com>
> Subject: Re: TomEE 7.0.2 - increasing quartz tx database connections
>
> seems lines don't match master, can you try the snapshot?
>
>
> Romain Manni-Bucau
> @rmannibucau <https://twitter.com/rmannibucau<https://
> urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_
> rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=QGRzW_-
> aXgTo66TRN_vhZDPQp14HHqKNXJBppBbrZfA&e=>> | Blog
> <https://blog-rmannibucau.rhcloud.com<https://
> urldefense.proofpoint.com/v2/url?u=https-3A__blog-
> 2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrG
> N8RO1mdlo4CNs&s=f0bEeHbgfwmZ9VwkbJKuztxWIesi3_Q6aX_t2L4WgmQ&e=>> | Old
> Blog
> <http://rmannibucau.wordpress.com<https://urldefense.
> proofpoint.com/v2/url?u=http-3A__rmannibucau.wordpress.com&
> d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
> P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> mphWJQ99rGdcA7SXIyAwA7cpHr3DvK1QNkl63fFSfg0&e=>> | Github <
> https://github.com/rmannibucau<https://urldefense.proofpoint.com/v2/
> url?u=https-3A__github.com_rmannibucau&d=DwMCAg&c=
> ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> p4lVtShsbWWgilgR1n1umjOMJk0YarG4TvV1GYCMSc0&e=>> |
> LinkedIn <https://www.linkedin.com/in/rmannibucau<https://
> urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.
> com_in_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> KJncjGo9tFJEKAPzYIwIMWFSN1VsXe_xahY_DzcZlBc&e=>> | JavaEE Factory
> <https://javaeefactory-rmannibucau.rhcloud.com<https:
> //urldefense.proofpoint.com/v2/url?u=https-3A__
> javaeefactory-2Drmannibucau.rhcloud.com&d=DwMCAg&c=
> ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=nmP7DqgVP__
> ao1cpigRcoNgw2MZaFaxDcrm1u4OK2FM&e=>>
>
> 2017-02-13 10:17 GMT+01:00 tschuler <[hidden email]</user/SendEmail.jtp?
> type=node&node=4681062&i=0>>:
>
> > Hi Romain!
> >
> > Attached text file (startAgent_IncludingStackTraces.log) includes the
> log
> > messages (including stack traces) showing three connections opened
> (Thread
> > "http-nio-28080-exec-1" - ConnectionID 30, 29 & 28) but not closed any
> more.
> > Maybe that's more helpful.
> >
> > Best regards,
> > Thomas
> >
> >
> > From: Romain Manni-Bucau [via TomEE & OpenEJB] [mailto:ml-node+
> > [hidden email]</user/SendEmail.jtp?type=node&node=4681062&i=1>]
> > Sent: Freitag, 10. Februar 2017 16:59
> > To: Thomas Schuler <[hidden email]</user/SendEmail.jtp?
> type=node&node=4681062&i=2>>
> > Subject: Re: TomEE 7.0.2 - increasing quartz tx database connections
> >
> > can you add the stack as well (new Exception().printStackTrace())? would
> > help to see where it leaks from
> >
> >
> > Romain Manni-Bucau
> > @rmannibucau <https://twitter.com/rmannibucau<https://
> urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_
> rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=QGRzW_-
> aXgTo66TRN_vhZDPQp14HHqKNXJBppBbrZfA&e=><https://
> > urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_
> > rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_
> > TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=
> > MgNLC1GEfYqS9Nkkh-9fK6QUonLKiFRcJpgAVpK-gKA&e=>> | Blog
> > <https://blog-rmannibucau.rhcloud.com<https://
> urldefense.proofpoint.com/v2/url?u=https-3A__blog-
> 2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrG
> N8RO1mdlo4CNs&s=f0bEeHbgfwmZ9VwkbJKuztxWIesi3_Q6aX_t2L4WgmQ&e=><https://
> > urldefense.proofpoint.com/v2/url?u=https-3A__blog-
> > 2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
> > xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> > aWlwIXOID5aHgTDLY2c&s=czTl_KlUFJYLumqyKOTPlqjOiW0Xm5xSwCxw2RuUgvY&e=>> |
> > Old Blog
> > <http://rmannibucau.wordpress.com<https://urldefense.
> proofpoint.com/v2/url?u=http-3A__rmannibucau.wordpress.com&
> d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
> P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> mphWJQ99rGdcA7SXIyAwA7cpHr3DvK1QNkl63fFSfg0&e=><https://urldefense<
> https://urldefense.proofpoint.com/v2/url?u=https-
> 3A__urldefense&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=nbAuuDc-
> vYv2Ij-LqNTVVYue256rOwQ6J-TRfymHwBo&e=>.
> > proofpoint.com/v2/url?u=http-3A__rmannibucau.wordpress.com&
> > d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
> > P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=_
> > 9UwlWBsLmBCnBD2u1gM-INAOCHv0ArrgKtOiyR0O3g&e=>> | Github <
> > https://github.com/rmannibucau<https://urldefense.
> proofpoint.com/v2/url?u=https-3A__github.com_rmannibucau&d=
> DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
> P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> p4lVtShsbWWgilgR1n1umjOMJk0YarG4TvV1GYCMSc0&e=><https://
> urldefense.proofpoint.com/v2/
> > url?u=https-3A__github.com_rmannibucau&d=DwMCAg&c=
> > ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> > j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=oqkryix_
> > txHO7YCLiaABH4cEPqkAV6YMmPReJoV5JZQ&e=>> |
> > LinkedIn <https://www.linkedin.com/in/rmannibucau<https://
> urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.
> com_in_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> KJncjGo9tFJEKAPzYIwIMWFSN1VsXe_xahY_DzcZlBc&e=><https://
> > urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.
> > com_in_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> > tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> > aWlwIXOID5aHgTDLY2c&s=uiTJP4mPtAVQ4Fcihqb7ggraf7n8DheowMIKhUB7tXI&e=>> |
> > JavaEE Factory
> > <https://javaeefactory-rmannibucau.rhcloud.com<https:
> //urldefense.proofpoint.com/v2/url?u=https-3A__
> javaeefactory-2Drmannibucau.rhcloud.com&d=DwMCAg&c=
> ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=nmP7DqgVP__
> ao1cpigRcoNgw2MZaFaxDcrm1u4OK2FM&e=><https:
> > //urldefense.proofpoint.com/v2/url?u=https-3A__
> > javaeefactory-2Drmannibucau.rhcloud.com&d=DwMCAg&c=
> > ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> > j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=2MgU1N170sWgWkYfKyl-
> > y7U4UMLxBgQLLNYy9JpKVRU&e=>>
> >
> > 2017-02-10 15:43 GMT+01:00 tschuler <[hidden email]</user/SendEmail.jtp?
> > type=node&node=4681053&i=0>>:
> >
> > > Hi Romain!
> > >
> > > We actually cannot reproduce the issue within a small example.
> > >
> > > But what we did was "enhancing" ManagedConnection.java with log
> messages
> > > in case of connection is created or closed.
> > > Attached text file (startAgent2.log) includes the additional log
> messages
> > > showing that three connections are opened (Thread
> > "http-nio-28080-exec-5" -
> > > ConnectionID 30, 29 & 28) but not closed any more.
> > >
> > > Maybe that helps identifying the root cause.
> > > If you have a "log message enhancement" suggestion - we'll add it.
> > >
> > > Best regards,
> > > Thomas
> > >
> > >
> > > startAgent2.txt (14K) <http://tomee-openejb.979440<h
> ttps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> YEkBfc2USevamHl4W5CJNFujg4eW3pCgaPgsS32hRJw&e=><h
> > ttps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> > 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> > tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> > aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
> > > n4.nabble.com/attachment/4681052/0/startAgent2.txt>
> > >
> > >
> > >
> > >
> > > --
> > > View this message in context: http://tomee-openejb.979440<ht
> tps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> YEkBfc2USevamHl4W5CJNFujg4eW3pCgaPgsS32hRJw&e=><ht
> > tps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> > 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> > tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> > aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
> > > n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> > > connections-tp4681007p4681052.html
> > > Sent from the TomEE Users mailing list archive at Nabble.com.
> > >
> >
> > ________________________________
> > If you reply to this email, your message will be added to the discussion
> > below:
> > http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-<htt
> ps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> 2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-2D&d=
> DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
> P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> pdDOs4sVAu0kvV9qPbjAU1z19zibAokcdiLThC0ixFc&e=>
> > increasing-quartz-tx-database-connections-tp4681007p4681053.html<
> > https://urldefense.proofpoint.com/v2/url?u=http-
> > 3A__tomee-2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-
> > 2Dincreasing-2Dquartz-2Dtx-2Ddatabase-2Dconnections-
> > 2Dtp4681007p4681053.html&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
> > xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> > aWlwIXOID5aHgTDLY2c&s=9T16nD_KwsWbAHBgR5NgiDM1Yi4iZMF1pGFK7AG6TdA&e=>
> > To unsubscribe from TomEE 7.0.2 - increasing quartz tx database
> > connections, click here<https://urldefense.proofpoint.com/v2/url?u=http-
> > 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_
> NamlServlet.jtp-3Fmacro-
> > 3Dunsubscribe-5Fby-5Fcode-26node-3D4681007-26code-
> > 3DdGhvbWFzLnNjaHVsZXJAb3BlbnRleHQuY29tfDQ2ODEwMDd8LTE4NTIyNT
> > Q0OTI-3D&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
> > TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=
> > 0QsMQ2bRmXiAKc4k6q5mMgNrjCXzuC7tZN56yhgmxN8&e=>.
> > NAML<https://urldefense.proofpoint.com/v2/url?u=http-
> > 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_
> NamlServlet.jtp-3Fmacro-
> > 3Dmacro-5Fviewer-26id-3Dinstant-5Fhtml-2521nabble-253Aemail.naml-26base-
> > 3Dnabble.naml.namespaces.BasicNamespace-2Dnabble.view.
> > web.template.NabbleNamespace-2Dnabble.view.web.template.
> > NodeNamespace-26breadcrumbs-3Dnotify-5Fsubscribers-
> > 2521nabble-253Aemail.naml-2Dinstant-5Femails-2521nabble-
> > 253Aemail.naml-2Dsend-5Finstant-5Femail-2521nabble-
> > 253Aemail.naml&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> > tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> > aWlwIXOID5aHgTDLY2c&s=BEpNzfKI-x6d45mFXlfG-aid1yvQnQssiOVvnX1Mv2E&e=>
> >
> >
> > startAgent_IncludingStackTraces.txt (142K) <http://tomee-openejb.979440<
> https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> YEkBfc2USevamHl4W5CJNFujg4eW3pCgaPgsS32hRJw&e=>.
> > n4.nabble.com/attachment/4681061/0/startAgent_IncludingStackTraces.txt>
> >
> >
> >
> >
> > --
> > View this message in context: http://tomee-openejb.979440<ht
> tps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> YEkBfc2USevamHl4W5CJNFujg4eW3pCgaPgsS32hRJw&e=>.
> > n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> > connections-tp4681007p4681061.html
> > Sent from the TomEE Users mailing list archive at Nabble.com.
> >
>
> ________________________________
> If you reply to this email, your message will be added to the discussion
> below:
> http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-
> increasing-quartz-tx-database-connections-tp4681007p4681062.html<
> https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__tomee-2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-
> 2Dincreasing-2Dquartz-2Dtx-2Ddatabase-2Dconnections-
> 2Dtp4681007p4681062.html&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrG
> N8RO1mdlo4CNs&s=nJ6wv98JhKkAZXufOKnWqpduvLmvJgqKQzBRIJmx52Q&e=>
> To unsubscribe from TomEE 7.0.2 - increasing quartz tx database
> connections, click here<https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-
> 3Dunsubscribe-5Fby-5Fcode-26node-3D4681007-26code-
> 3DdGhvbWFzLnNjaHVsZXJAb3BlbnRleHQuY29tfDQ2ODEwMDd8LTE4NTIyNT
> Q0OTI-3D&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
> TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> EoMT1Qng2FlncOFhrviAa_1Z6suhoKXrc949Lq5Z4z8&e=>.
> NAML<https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-
> 3Dmacro-5Fviewer-26id-3Dinstant-5Fhtml-2521nabble-253Aemail.naml-26base-
> 3Dnabble.naml.namespaces.BasicNamespace-2Dnabble.view.
> web.template.NabbleNamespace-2Dnabble.view.web.template.
> NodeNamespace-26breadcrumbs-3Dnotify-5Fsubscribers-
> 2521nabble-253Aemail.naml-2Dinstant-5Femails-2521nabble-
> 253Aemail.naml-2Dsend-5Finstant-5Femail-2521nabble-
> 253Aemail.naml&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=
> FC0WgnZajzsyFUL3guvs91s3GABdK8EriafHpvWBpIc&e=>
>
>
> ManagedConnection.java (17K) <http://tomee-openejb.979440.
> n4.nabble.com/attachment/4681063/0/ManagedConnection.java>
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681063.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
RE: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Hi Romain!
Lines cannot match master version of ManagedConnection.java because we changed it a bit (see attached ManagedConnection.java) on base of TomEE 7.0.2 release.
On the other hand we actually have no idea where to find TomEE snapshot - https://repository.apache.org/content/groups/snapshots/org/apache/openejb/apache-tomee/ does not seem to be snapshot folder any more.
Best regards,
Thomas
From: Romain Manni-Bucau [via TomEE & OpenEJB] [mailto:ml-node+s979440n4681062h32@n4.nabble.com]
Sent: Montag, 13. Februar 2017 10:40
To: Thomas Schuler <Th...@opentext.com>
Subject: Re: TomEE 7.0.2 - increasing quartz tx database connections
seems lines don't match master, can you try the snapshot?
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau<https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=QGRzW_-aXgTo66TRN_vhZDPQp14HHqKNXJBppBbrZfA&e=>> | Blog
<https://blog-rmannibucau.rhcloud.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__blog-2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=f0bEeHbgfwmZ9VwkbJKuztxWIesi3_Q6aX_t2L4WgmQ&e=>> | Old Blog
<http://rmannibucau.wordpress.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__rmannibucau.wordpress.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=mphWJQ99rGdcA7SXIyAwA7cpHr3DvK1QNkl63fFSfg0&e=>> | Github <https://github.com/rmannibucau<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=p4lVtShsbWWgilgR1n1umjOMJk0YarG4TvV1GYCMSc0&e=>> |
LinkedIn <https://www.linkedin.com/in/rmannibucau<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_in_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=KJncjGo9tFJEKAPzYIwIMWFSN1VsXe_xahY_DzcZlBc&e=>> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__javaeefactory-2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=nmP7DqgVP__ao1cpigRcoNgw2MZaFaxDcrm1u4OK2FM&e=>>
2017-02-13 10:17 GMT+01:00 tschuler <[hidden email]</user/SendEmail.jtp?type=node&node=4681062&i=0>>:
> Hi Romain!
>
> Attached text file (startAgent_IncludingStackTraces.log) includes the log
> messages (including stack traces) showing three connections opened (Thread
> "http-nio-28080-exec-1" - ConnectionID 30, 29 & 28) but not closed any more.
> Maybe that's more helpful.
>
> Best regards,
> Thomas
>
>
> From: Romain Manni-Bucau [via TomEE & OpenEJB] [mailto:ml-node+
> [hidden email]</user/SendEmail.jtp?type=node&node=4681062&i=1>]
> Sent: Freitag, 10. Februar 2017 16:59
> To: Thomas Schuler <[hidden email]</user/SendEmail.jtp?type=node&node=4681062&i=2>>
> Subject: Re: TomEE 7.0.2 - increasing quartz tx database connections
>
> can you add the stack as well (new Exception().printStackTrace())? would
> help to see where it leaks from
>
>
> Romain Manni-Bucau
> @rmannibucau <https://twitter.com/rmannibucau<https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=QGRzW_-aXgTo66TRN_vhZDPQp14HHqKNXJBppBbrZfA&e=><https://
> urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_
> rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
> TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=
> MgNLC1GEfYqS9Nkkh-9fK6QUonLKiFRcJpgAVpK-gKA&e=>> | Blog
> <https://blog-rmannibucau.rhcloud.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__blog-2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=f0bEeHbgfwmZ9VwkbJKuztxWIesi3_Q6aX_t2L4WgmQ&e=><https://
> urldefense.proofpoint.com/v2/url?u=https-3A__blog-
> 2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=czTl_KlUFJYLumqyKOTPlqjOiW0Xm5xSwCxw2RuUgvY&e=>> |
> Old Blog
> <http://rmannibucau.wordpress.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__rmannibucau.wordpress.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=mphWJQ99rGdcA7SXIyAwA7cpHr3DvK1QNkl63fFSfg0&e=><https://urldefense<https://urldefense.proofpoint.com/v2/url?u=https-3A__urldefense&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=nbAuuDc-vYv2Ij-LqNTVVYue256rOwQ6J-TRfymHwBo&e=>.
> proofpoint.com/v2/url?u=http-3A__rmannibucau.wordpress.com&
> d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
> P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=_
> 9UwlWBsLmBCnBD2u1gM-INAOCHv0ArrgKtOiyR0O3g&e=>> | Github <
> https://github.com/rmannibucau<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=p4lVtShsbWWgilgR1n1umjOMJk0YarG4TvV1GYCMSc0&e=><https://urldefense.proofpoint.com/v2/
> url?u=https-3A__github.com_rmannibucau&d=DwMCAg&c=
> ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=oqkryix_
> txHO7YCLiaABH4cEPqkAV6YMmPReJoV5JZQ&e=>> |
> LinkedIn <https://www.linkedin.com/in/rmannibucau<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_in_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=KJncjGo9tFJEKAPzYIwIMWFSN1VsXe_xahY_DzcZlBc&e=><https://
> urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.
> com_in_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=uiTJP4mPtAVQ4Fcihqb7ggraf7n8DheowMIKhUB7tXI&e=>> |
> JavaEE Factory
> <https://javaeefactory-rmannibucau.rhcloud.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__javaeefactory-2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=nmP7DqgVP__ao1cpigRcoNgw2MZaFaxDcrm1u4OK2FM&e=><https:
> //urldefense.proofpoint.com/v2/url?u=https-3A__
> javaeefactory-2Drmannibucau.rhcloud.com&d=DwMCAg&c=
> ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=2MgU1N170sWgWkYfKyl-
> y7U4UMLxBgQLLNYy9JpKVRU&e=>>
>
> 2017-02-10 15:43 GMT+01:00 tschuler <[hidden email]</user/SendEmail.jtp?
> type=node&node=4681053&i=0>>:
>
> > Hi Romain!
> >
> > We actually cannot reproduce the issue within a small example.
> >
> > But what we did was "enhancing" ManagedConnection.java with log messages
> > in case of connection is created or closed.
> > Attached text file (startAgent2.log) includes the additional log messages
> > showing that three connections are opened (Thread
> "http-nio-28080-exec-5" -
> > ConnectionID 30, 29 & 28) but not closed any more.
> >
> > Maybe that helps identifying the root cause.
> > If you have a "log message enhancement" suggestion - we'll add it.
> >
> > Best regards,
> > Thomas
> >
> >
> > startAgent2.txt (14K) <http://tomee-openejb.979440<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=YEkBfc2USevamHl4W5CJNFujg4eW3pCgaPgsS32hRJw&e=><h
> ttps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
> > n4.nabble.com/attachment/4681052/0/startAgent2.txt>
> >
> >
> >
> >
> > --
> > View this message in context: http://tomee-openejb.979440<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=YEkBfc2USevamHl4W5CJNFujg4eW3pCgaPgsS32hRJw&e=><ht
> tps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
> > n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> > connections-tp4681007p4681052.html
> > Sent from the TomEE Users mailing list archive at Nabble.com.
> >
>
> ________________________________
> If you reply to this email, your message will be added to the discussion
> below:
> http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-2D&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=pdDOs4sVAu0kvV9qPbjAU1z19zibAokcdiLThC0ixFc&e=>
> increasing-quartz-tx-database-connections-tp4681007p4681053.html<
> https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__tomee-2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-
> 2Dincreasing-2Dquartz-2Dtx-2Ddatabase-2Dconnections-
> 2Dtp4681007p4681053.html&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=9T16nD_KwsWbAHBgR5NgiDM1Yi4iZMF1pGFK7AG6TdA&e=>
> To unsubscribe from TomEE 7.0.2 - increasing quartz tx database
> connections, click here<https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-
> 3Dunsubscribe-5Fby-5Fcode-26node-3D4681007-26code-
> 3DdGhvbWFzLnNjaHVsZXJAb3BlbnRleHQuY29tfDQ2ODEwMDd8LTE4NTIyNT
> Q0OTI-3D&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
> TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=
> 0QsMQ2bRmXiAKc4k6q5mMgNrjCXzuC7tZN56yhgmxN8&e=>.
> NAML<https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-
> 3Dmacro-5Fviewer-26id-3Dinstant-5Fhtml-2521nabble-253Aemail.naml-26base-
> 3Dnabble.naml.namespaces.BasicNamespace-2Dnabble.view.
> web.template.NabbleNamespace-2Dnabble.view.web.template.
> NodeNamespace-26breadcrumbs-3Dnotify-5Fsubscribers-
> 2521nabble-253Aemail.naml-2Dinstant-5Femails-2521nabble-
> 253Aemail.naml-2Dsend-5Finstant-5Femail-2521nabble-
> 253Aemail.naml&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=BEpNzfKI-x6d45mFXlfG-aid1yvQnQssiOVvnX1Mv2E&e=>
>
>
> startAgent_IncludingStackTraces.txt (142K) <http://tomee-openejb.979440<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=YEkBfc2USevamHl4W5CJNFujg4eW3pCgaPgsS32hRJw&e=>.
> n4.nabble.com/attachment/4681061/0/startAgent_IncludingStackTraces.txt>
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=YEkBfc2USevamHl4W5CJNFujg4eW3pCgaPgsS32hRJw&e=>.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681061.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
________________________________
If you reply to this email, your message will be added to the discussion below:
http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681062.html<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-2Dincreasing-2Dquartz-2Dtx-2Ddatabase-2Dconnections-2Dtp4681007p4681062.html&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=nJ6wv98JhKkAZXufOKnWqpduvLmvJgqKQzBRIJmx52Q&e=>
To unsubscribe from TomEE 7.0.2 - increasing quartz tx database connections, click here<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-3Dunsubscribe-5Fby-5Fcode-26node-3D4681007-26code-3DdGhvbWFzLnNjaHVsZXJAb3BlbnRleHQuY29tfDQ2ODEwMDd8LTE4NTIyNTQ0OTI-3D&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=EoMT1Qng2FlncOFhrviAa_1Z6suhoKXrc949Lq5Z4z8&e=>.
NAML<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-3Dmacro-5Fviewer-26id-3Dinstant-5Fhtml-2521nabble-253Aemail.naml-26base-3Dnabble.naml.namespaces.BasicNamespace-2Dnabble.view.web.template.NabbleNamespace-2Dnabble.view.web.template.NodeNamespace-26breadcrumbs-3Dnotify-5Fsubscribers-2521nabble-253Aemail.naml-2Dinstant-5Femails-2521nabble-253Aemail.naml-2Dsend-5Finstant-5Femail-2521nabble-253Aemail.naml&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=t0LrDDhqtCTu9Wby2YU3LgQbr2QUrGN8RO1mdlo4CNs&s=FC0WgnZajzsyFUL3guvs91s3GABdK8EriafHpvWBpIc&e=>
ManagedConnection.java (17K) <http://tomee-openejb.979440.n4.nabble.com/attachment/4681063/0/ManagedConnection.java>
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681063.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
seems lines don't match master, can you try the snapshot?
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-13 10:17 GMT+01:00 tschuler <th...@opentext.com>:
> Hi Romain!
>
> Attached text file (startAgent_IncludingStackTraces.log) includes the log
> messages (including stack traces) showing three connections opened (Thread
> "http-nio-28080-exec-1" - ConnectionID 30, 29 & 28) but not closed any more.
> Maybe that's more helpful.
>
> Best regards,
> Thomas
>
>
> From: Romain Manni-Bucau [via TomEE & OpenEJB] [mailto:ml-node+
> s979440n4681053h53@n4.nabble.com]
> Sent: Freitag, 10. Februar 2017 16:59
> To: Thomas Schuler <Th...@opentext.com>
> Subject: Re: TomEE 7.0.2 - increasing quartz tx database connections
>
> can you add the stack as well (new Exception().printStackTrace())? would
> help to see where it leaks from
>
>
> Romain Manni-Bucau
> @rmannibucau <https://twitter.com/rmannibucau<https://
> urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_
> rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
> TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=
> MgNLC1GEfYqS9Nkkh-9fK6QUonLKiFRcJpgAVpK-gKA&e=>> | Blog
> <https://blog-rmannibucau.rhcloud.com<https://
> urldefense.proofpoint.com/v2/url?u=https-3A__blog-
> 2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=czTl_KlUFJYLumqyKOTPlqjOiW0Xm5xSwCxw2RuUgvY&e=>> |
> Old Blog
> <http://rmannibucau.wordpress.com<https://urldefense.
> proofpoint.com/v2/url?u=http-3A__rmannibucau.wordpress.com&
> d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-
> P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=_
> 9UwlWBsLmBCnBD2u1gM-INAOCHv0ArrgKtOiyR0O3g&e=>> | Github <
> https://github.com/rmannibucau<https://urldefense.proofpoint.com/v2/
> url?u=https-3A__github.com_rmannibucau&d=DwMCAg&c=
> ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=oqkryix_
> txHO7YCLiaABH4cEPqkAV6YMmPReJoV5JZQ&e=>> |
> LinkedIn <https://www.linkedin.com/in/rmannibucau<https://
> urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.
> com_in_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=uiTJP4mPtAVQ4Fcihqb7ggraf7n8DheowMIKhUB7tXI&e=>> |
> JavaEE Factory
> <https://javaeefactory-rmannibucau.rhcloud.com<https:
> //urldefense.proofpoint.com/v2/url?u=https-3A__
> javaeefactory-2Drmannibucau.rhcloud.com&d=DwMCAg&c=
> ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=
> j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=2MgU1N170sWgWkYfKyl-
> y7U4UMLxBgQLLNYy9JpKVRU&e=>>
>
> 2017-02-10 15:43 GMT+01:00 tschuler <[hidden email]</user/SendEmail.jtp?
> type=node&node=4681053&i=0>>:
>
> > Hi Romain!
> >
> > We actually cannot reproduce the issue within a small example.
> >
> > But what we did was "enhancing" ManagedConnection.java with log messages
> > in case of connection is created or closed.
> > Attached text file (startAgent2.log) includes the additional log messages
> > showing that three connections are opened (Thread
> "http-nio-28080-exec-5" -
> > ConnectionID 30, 29 & 28) but not closed any more.
> >
> > Maybe that helps identifying the root cause.
> > If you have a "log message enhancement" suggestion - we'll add it.
> >
> > Best regards,
> > Thomas
> >
> >
> > startAgent2.txt (14K) <http://tomee-openejb.979440<h
> ttps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
> > n4.nabble.com/attachment/4681052/0/startAgent2.txt>
> >
> >
> >
> >
> > --
> > View this message in context: http://tomee-openejb.979440<ht
> tps://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-
> 2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
> > n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> > connections-tp4681007p4681052.html
> > Sent from the TomEE Users mailing list archive at Nabble.com.
> >
>
> ________________________________
> If you reply to this email, your message will be added to the discussion
> below:
> http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-
> increasing-quartz-tx-database-connections-tp4681007p4681053.html<
> https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__tomee-2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-
> 2Dincreasing-2Dquartz-2Dtx-2Ddatabase-2Dconnections-
> 2Dtp4681007p4681053.html&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--
> xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=9T16nD_KwsWbAHBgR5NgiDM1Yi4iZMF1pGFK7AG6TdA&e=>
> To unsubscribe from TomEE 7.0.2 - increasing quartz tx database
> connections, click here<https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-
> 3Dunsubscribe-5Fby-5Fcode-26node-3D4681007-26code-
> 3DdGhvbWFzLnNjaHVsZXJAb3BlbnRleHQuY29tfDQ2ODEwMDd8LTE4NTIyNT
> Q0OTI-3D&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_
> TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=
> 0QsMQ2bRmXiAKc4k6q5mMgNrjCXzuC7tZN56yhgmxN8&e=>.
> NAML<https://urldefense.proofpoint.com/v2/url?u=http-
> 3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-
> 3Dmacro-5Fviewer-26id-3Dinstant-5Fhtml-2521nabble-253Aemail.naml-26base-
> 3Dnabble.naml.namespaces.BasicNamespace-2Dnabble.view.
> web.template.NabbleNamespace-2Dnabble.view.web.template.
> NodeNamespace-26breadcrumbs-3Dnotify-5Fsubscribers-
> 2521nabble-253Aemail.naml-2Dinstant-5Femails-2521nabble-
> 253Aemail.naml-2Dsend-5Finstant-5Femail-2521nabble-
> 253Aemail.naml&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=
> tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_
> aWlwIXOID5aHgTDLY2c&s=BEpNzfKI-x6d45mFXlfG-aid1yvQnQssiOVvnX1Mv2E&e=>
>
>
> startAgent_IncludingStackTraces.txt (142K) <http://tomee-openejb.979440.
> n4.nabble.com/attachment/4681061/0/startAgent_IncludingStackTraces.txt>
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681061.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
RE: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Hi Romain!
Attached text file (startAgent_IncludingStackTraces.log) includes the log messages (including stack traces) showing three connections opened (Thread "http-nio-28080-exec-1" - ConnectionID 30, 29 & 28) but not closed any more.
Maybe that's more helpful.
Best regards,
Thomas
From: Romain Manni-Bucau [via TomEE & OpenEJB] [mailto:ml-node+s979440n4681053h53@n4.nabble.com]
Sent: Freitag, 10. Februar 2017 16:59
To: Thomas Schuler <Th...@opentext.com>
Subject: Re: TomEE 7.0.2 - increasing quartz tx database connections
can you add the stack as well (new Exception().printStackTrace())? would
help to see where it leaks from
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau<https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=MgNLC1GEfYqS9Nkkh-9fK6QUonLKiFRcJpgAVpK-gKA&e=>> | Blog
<https://blog-rmannibucau.rhcloud.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__blog-2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=czTl_KlUFJYLumqyKOTPlqjOiW0Xm5xSwCxw2RuUgvY&e=>> | Old Blog
<http://rmannibucau.wordpress.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__rmannibucau.wordpress.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=_9UwlWBsLmBCnBD2u1gM-INAOCHv0ArrgKtOiyR0O3g&e=>> | Github <https://github.com/rmannibucau<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=oqkryix_txHO7YCLiaABH4cEPqkAV6YMmPReJoV5JZQ&e=>> |
LinkedIn <https://www.linkedin.com/in/rmannibucau<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_in_rmannibucau&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=uiTJP4mPtAVQ4Fcihqb7ggraf7n8DheowMIKhUB7tXI&e=>> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__javaeefactory-2Drmannibucau.rhcloud.com&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=2MgU1N170sWgWkYfKyl-y7U4UMLxBgQLLNYy9JpKVRU&e=>>
2017-02-10 15:43 GMT+01:00 tschuler <[hidden email]</user/SendEmail.jtp?type=node&node=4681053&i=0>>:
> Hi Romain!
>
> We actually cannot reproduce the issue within a small example.
>
> But what we did was "enhancing" ManagedConnection.java with log messages
> in case of connection is created or closed.
> Attached text file (startAgent2.log) includes the additional log messages
> showing that three connections are opened (Thread "http-nio-28080-exec-5" -
> ConnectionID 30, 29 & 28) but not closed any more.
>
> Maybe that helps identifying the root cause.
> If you have a "log message enhancement" suggestion - we'll add it.
>
> Best regards,
> Thomas
>
>
> startAgent2.txt (14K) <http://tomee-openejb.979440<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
> n4.nabble.com/attachment/4681052/0/startAgent2.txt>
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=iKAw7pLvMknhZoh3jnTXDqbazZYy6Z1CoJxw995fHO4&e=>.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681052.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
________________________________
If you reply to this email, your message will be added to the discussion below:
http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681053.html<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440.n4.nabble.com_TomEE-2D7-2D0-2D2-2Dincreasing-2Dquartz-2Dtx-2Ddatabase-2Dconnections-2Dtp4681007p4681053.html&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=9T16nD_KwsWbAHBgR5NgiDM1Yi4iZMF1pGFK7AG6TdA&e=>
To unsubscribe from TomEE 7.0.2 - increasing quartz tx database connections, click here<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-3Dunsubscribe-5Fby-5Fcode-26node-3D4681007-26code-3DdGhvbWFzLnNjaHVsZXJAb3BlbnRleHQuY29tfDQ2ODEwMDd8LTE4NTIyNTQ0OTI-3D&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=0QsMQ2bRmXiAKc4k6q5mMgNrjCXzuC7tZN56yhgmxN8&e=>.
NAML<https://urldefense.proofpoint.com/v2/url?u=http-3A__tomee-2Dopenejb.979440.n4.nabble.com_template_NamlServlet.jtp-3Fmacro-3Dmacro-5Fviewer-26id-3Dinstant-5Fhtml-2521nabble-253Aemail.naml-26base-3Dnabble.naml.namespaces.BasicNamespace-2Dnabble.view.web.template.NabbleNamespace-2Dnabble.view.web.template.NodeNamespace-26breadcrumbs-3Dnotify-5Fsubscribers-2521nabble-253Aemail.naml-2Dinstant-5Femails-2521nabble-253Aemail.naml-2Dsend-5Finstant-5Femail-2521nabble-253Aemail.naml&d=DwMCAg&c=ZgVRmm3mf2P1-XDAyDsu4A&r=tcnVZpsm--xbG4A9tLhh_CVv_TOmzYWmS-P4lauv47I&m=j5PcFhN5wNkiZXRRBmt6aj2_aWlwIXOID5aHgTDLY2c&s=BEpNzfKI-x6d45mFXlfG-aid1yvQnQssiOVvnX1Mv2E&e=>
startAgent_IncludingStackTraces.txt (142K) <http://tomee-openejb.979440.n4.nabble.com/attachment/4681061/0/startAgent_IncludingStackTraces.txt>
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681061.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
can you add the stack as well (new Exception().printStackTrace())? would
help to see where it leaks from
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-10 15:43 GMT+01:00 tschuler <th...@opentext.com>:
> Hi Romain!
>
> We actually cannot reproduce the issue within a small example.
>
> But what we did was "enhancing" ManagedConnection.java with log messages
> in case of connection is created or closed.
> Attached text file (startAgent2.log) includes the additional log messages
> showing that three connections are opened (Thread "http-nio-28080-exec-5" -
> ConnectionID 30, 29 & 28) but not closed any more.
>
> Maybe that helps identifying the root cause.
> If you have a "log message enhancement" suggestion - we'll add it.
>
> Best regards,
> Thomas
>
>
> startAgent2.txt (14K) <http://tomee-openejb.979440.
> n4.nabble.com/attachment/4681052/0/startAgent2.txt>
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681052.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
RE: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Hi Romain!
We actually cannot reproduce the issue within a small example.
But what we did was "enhancing" ManagedConnection.java with log messages in case of connection is created or closed.
Attached text file (startAgent2.log) includes the additional log messages showing that three connections are opened (Thread "http-nio-28080-exec-5" - ConnectionID 30, 29 & 28) but not closed any more.
Maybe that helps identifying the root cause.
If you have a "log message enhancement" suggestion - we'll add it.
Best regards,
Thomas
startAgent2.txt (14K) <http://tomee-openejb.979440.n4.nabble.com/attachment/4681052/0/startAgent2.txt>
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681052.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
if you manage to share a test (arquillian or application composer) then we
can help you more accurately and fix it for 7.0.3
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-08 12:33 GMT+01:00 tschuler <th...@opentext.com>:
> We did some investigations:
> The problem (increasing amount of database connections to quartz database)
> still occurs if tomcat-jdbc.jar is replaced with same file included in
> TomEE
> 7.0.1.
> On the other hand we replaced the ManagedConnection*.class files in
> openejb-core-7.0.2.jar with the ones included in openejb-core-7.0.1.jar.
> This solves the problem!
>
> Therefore it seems to be related to changes done for ManagedConnection.java
> (package org.apache.openejb.resource.jdbc.managed.local).
>
> We'll take a deeper look into the changes.
> But maybe someone else has an idea what particular change might be cause
> for
> increasing amout of database connections.
> We can reproduce the issue easily and therefore can verify the idea.
>
> Best regards,
> Thomas
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681030.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
We did some investigations:
The problem (increasing amount of database connections to quartz database)
still occurs if tomcat-jdbc.jar is replaced with same file included in TomEE
7.0.1.
On the other hand we replaced the ManagedConnection*.class files in
openejb-core-7.0.2.jar with the ones included in openejb-core-7.0.1.jar.
This solves the problem!
Therefore it seems to be related to changes done for ManagedConnection.java
(package org.apache.openejb.resource.jdbc.managed.local).
We'll take a deeper look into the changes.
But maybe someone else has an idea what particular change might be cause for
increasing amout of database connections.
We can reproduce the issue easily and therefore can verify the idea.
Best regards,
Thomas
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681030.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
tomcat-jdbc or our JTA proxy (probably)
here are the related commits:
-
https://github.com/apache/tomee/commit/6d7565af8f6c216644d32dd724bb5a6cd44dc6c5
-
https://github.com/apache/tomee/commit/56ec4be8bc3db9754f5d4ddc5f57206861363537
-
https://github.com/apache/tomee/commit/57a235d672cd7692f0a2a50bf345e966f9d2bd16
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-03 14:49 GMT+01:00 tschuler <th...@opentext.com>:
> Hi Romain!
>
> I switched the quartz related datasource to dbcp (DataSourceCreator =
> dbcp).
> Now the database connections do not increase any more.
>
> Does this mean for sure that cause is a change in tomcat jdbc
> implementation?
>
> Thanks,
> Thomas
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681013.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Hi Romain!
I switched the quartz related datasource to dbcp (DataSourceCreator = dbcp).
Now the database connections do not increase any more.
Does this mean for sure that cause is a change in tomcat jdbc
implementation?
Thanks,
Thomas
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681013.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
2017-02-03 13:34 GMT+01:00 tschuler <th...@opentext.com>:
> Hi Romain!
>
> I'm not sure if I get you right: Changes were done but should not have in
> impact, right?
>
In term of tomee code yes, if you check the release note on
https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12312320&version=12336943,
only [TOMEE-1964 <https://issues.apache.org/jira/browse/TOMEE-1964>] can
be impacting and related to xa databases.
However I have to admit I didn't check all the changes in tomcat-jdbc so if
you use this one and not dbcp then it can have some impacting changes you
don't see in tomee changelog itself.
> Can I somehow revert these changes to get sure if or if not they are cause
> for the issue?
>
>
one option, a bit time consuming but "secured" in the sense you'll find the
cause for sure is to take git version just before 7.0.1 release and then
doing a dichotomy test all revisions until it breaks.
It will likely need a small sample easy to run but will ensure you find it
in a finite period of time and avoid this effect "almost there, almost
there"[1 month later]"not sure it fixes it :s".
> Best regards,
> Thomas
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681011.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Hi Romain!
I'm not sure if I get you right: Changes were done but should not have in
impact, right?
Can I somehow revert these changes to get sure if or if not they are cause
for the issue?
Best regards,
Thomas
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681011.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
we upgraded some database pooling dependencies so can be hidden, otherwise
our changes are not that impacting on the datasource by themself
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-03 13:15 GMT+01:00 tschuler <th...@opentext.com>:
> Hi Romain!
>
> Database configuration is unchanged (same as for TomEE 7.0.1) - is there a
> configuration parameter that changed its default value since TomEE 7.0.1?
> Thread count is stable, no deadlocks, thread states are same as for TomEE
> 7.0.1.
>
> Best regards,
> Thomas
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007p4681009.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by tschuler <th...@opentext.com>.
Hi Romain!
Database configuration is unchanged (same as for TomEE 7.0.1) - is there a
configuration parameter that changed its default value since TomEE 7.0.1?
Thread count is stable, no deadlocks, thread states are same as for TomEE
7.0.1.
Best regards,
Thomas
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-connections-tp4681007p4681009.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: TomEE 7.0.2 - increasing quartz tx database connections
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Hi Thomas,
did you investigate
1. the database configuration
2. thread dumps to see if something is locked
?
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-02-03 12:50 GMT+01:00 tschuler <th...@opentext.com>:
> Hi!
>
> Our application is using scheduled beans.
> The according timers are persisted within quartz tables.
>
> This works as expected using TomEE 7.0.1 (webprofile).
>
> But within TomEE 7.0.2 (also webprofile) we get in trouble because tx
> database connections to quartz tables are not released any more.
> It does not depend on database: We tried using MSSQL, Oracle & Postgres
> database.
> It also does not depend on type of timer: We tried calendar, interval and
> single action timer.
> The amount of database connections seems to be increased in case of adding
> a
> timer only: Timer cancel or timer fire has no impact.
> Always three additional connections can be observered while one timer is
> added.
>
> Does anyone have an idea what might be cause for the issue?
>
> We are actually not able to provide a simple example but we are working on
> it.
>
> Best regards,
> Thomas
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/TomEE-7-0-2-increasing-quartz-tx-database-
> connections-tp4681007.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>