You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by hwaastad <he...@waastad.org> on 2016/09/19 18:06:32 UTC
7.0.1 app composer container properties issue
Hi,
I've made a ebean test project where I use two different props
implementations (defining datasource):
1. using @ContainerProperties on class
2. using @Configuration
I do al loop calling a repository 10 times and in 2. its ok.
In 1. everything freezes after 8 requests.
I started out thinking it must be an ebean issue, but I do think it's an
tomee issue.
Any comments?
repo:
https://github.com/hwaastad/TomeeJaxrsValidation.git
and branch is develop.
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/7-0-1-app-composer-container-properties-issue-tp4680158.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: 7.0.1 app composer container properties issue
Posted by hwaastad <he...@waastad.org>.
I was too quick to say it works in 1.7.4.
DataSource spec has changed.
Default in 1.7.4 maxactive/maxIdle = 20 while in 7.0 its
maxTotal/maxActive=8
so in my test running loop of 10....yeah, testing is not always the answer.
spec usually is :-)
I'll start testing my own transactionmanager to see where it's not
releasing.
/hw
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/7-0-1-app-composer-container-properties-issue-tp4680158p4680173.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: 7.0.1 app composer container properties issue
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Same binary iirc
Le 20 sept. 2016 15:07, "hwaastad" <he...@waastad.org> a écrit :
> Well,
> I've started to debug tx manager now.
>
> I see no issue using 1.7.4/4.7.4 so I need to see what changed in 7.0.
>
> I'm open for suggestions regarding the tomee part :-)
>
> /hw
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/7-0-1-app-composer-container-properties-
> issue-tp4680158p4680169.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: 7.0.1 app composer container properties issue
Posted by hwaastad <he...@waastad.org>.
Well,
I've started to debug tx manager now.
I see no issue using 1.7.4/4.7.4 so I need to see what changed in 7.0.
I'm open for suggestions regarding the tomee part :-)
/hw
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/7-0-1-app-composer-container-properties-issue-tp4680158p4680169.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: 7.0.1 app composer container properties issue
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Le 20 sept. 2016 11:45, "hwaastad" <he...@waastad.org> a écrit :
>
> Well,
> I might see if ebeans does something special.
>
> I've tried setting atuocommit false in ebean but the result is the same:
>
> 11:20:55.857 [main] DEBUG org.avaje.ebean.SQL - txn[1474363255855] select
> t0.id c0, t0.name c1 from t_user t0 where t0.name = ? ; --bind(aSDAWD)
> 11:20:55.857 [main] DEBUG org.avaje.ebean.SUM - txn[1474363255855]
FindMany
> type[User] origin[BdZsUV.BqJLxS.BnEUyX] exeMicros[822] rows[0]
> predicates[t0.name = ? ] bind[aSDAWD]
> 11:20:55.858 [main] DEBUG c.a.e.s.t.JtaTransactionManager - Jta Txn
> [1474363255855] committed
> 11:20:55.858 [main] DEBUG org.avaje.ebean.TXN - txn[1474363255855] Commit
>
> It reached the maxTotal but apparently no release
>
> What puzzels me now is that without logsql, an injected datasource is a
> proxy to a loggingsqldatasource while without it's just a
> basicmanageddatasource.
> I'll see if there is a diff on those two that might affect ebean.
>
That is what does LogSql properties yes. Is tx mg integration with ebean
well done?
> /hw
>
>
>
> --
> View this message in context:
http://tomee-openejb.979440.n4.nabble.com/7-0-1-app-composer-container-properties-issue-tp4680158p4680165.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
Re: 7.0.1 app composer container properties issue
Posted by hwaastad <he...@waastad.org>.
Well,
I might see if ebeans does something special.
I've tried setting atuocommit false in ebean but the result is the same:
11:20:55.857 [main] DEBUG org.avaje.ebean.SQL - txn[1474363255855] select
t0.id c0, t0.name c1 from t_user t0 where t0.name = ? ; --bind(aSDAWD)
11:20:55.857 [main] DEBUG org.avaje.ebean.SUM - txn[1474363255855] FindMany
type[User] origin[BdZsUV.BqJLxS.BnEUyX] exeMicros[822] rows[0]
predicates[t0.name = ? ] bind[aSDAWD]
11:20:55.858 [main] DEBUG c.a.e.s.t.JtaTransactionManager - Jta Txn
[1474363255855] committed
11:20:55.858 [main] DEBUG org.avaje.ebean.TXN - txn[1474363255855] Commit
It reached the maxTotal but apparently no release
What puzzels me now is that without logsql, an injected datasource is a
proxy to a loggingsqldatasource while without it's just a
basicmanageddatasource.
I'll see if there is a diff on those two that might affect ebean.
/hw
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/7-0-1-app-composer-container-properties-issue-tp4680158p4680165.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: 7.0.1 app composer container properties issue
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Side note: autocommit + jta doesnt lake sense since jta handles the tx or
you autocommit. Maybe a wrong setup there.
Le 20 sept. 2016 09:40, "hwaastad" <he...@waastad.org> a écrit :
> Yep,
> I will.
>
> I seems that it has something to do with releasing datasource connections
> since after a while I see:
> EjbTransactionUtil.handleSystemException: java.sql.SQLException: Unable to
> acquire a new connection from the pool
> javax.persistence.PersistenceException: java.sql.SQLException: Unable to
> acquire a new connection from the pool
>
> I will do some more testing and get back to you.
>
> /hw
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.
> n4.nabble.com/7-0-1-app-composer-container-properties-
> issue-tp4680158p4680163.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
Re: 7.0.1 app composer container properties issue
Posted by hwaastad <he...@waastad.org>.
Yep,
I will.
I seems that it has something to do with releasing datasource connections
since after a while I see:
EjbTransactionUtil.handleSystemException: java.sql.SQLException: Unable to
acquire a new connection from the pool
javax.persistence.PersistenceException: java.sql.SQLException: Unable to
acquire a new connection from the pool
I will do some more testing and get back to you.
/hw
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/7-0-1-app-composer-container-properties-issue-tp4680158p4680163.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: 7.0.1 app composer container properties issue
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Le 19 sept. 2016 21:04, "hwaastad" <he...@waastad.org> a écrit :
>
> Hi,
> aligne both (needed to change inmemory db to separate since paralell runs)
>
> Strange, but with my current config both fails with LogSql=false.
> LogSQL=true it OK...
>
> If this does'nt make sense I can always check the thread stack.
>
Yes please
> /hw
>
>
>
> --
> View this message in context:
http://tomee-openejb.979440.n4.nabble.com/7-0-1-app-composer-container-properties-issue-tp4680158p4680161.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
Re: 7.0.1 app composer container properties issue
Posted by hwaastad <he...@waastad.org>.
Hi,
aligne both (needed to change inmemory db to separate since paralell runs)
Strange, but with my current config both fails with LogSql=false.
LogSQL=true it OK...
If this does'nt make sense I can always check the thread stack.
/hw
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/7-0-1-app-composer-container-properties-issue-tp4680158p4680161.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: 7.0.1 app composer container properties issue
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Le 19 sept. 2016 20:11, "hwaastad" <he...@waastad.org> a écrit :
>
> Hi,
> I've made a ebean test project where I use two different props
> implementations (defining datasource):
>
> 1. using @ContainerProperties on class
>
> 2. using @Configuration
>
You pushed different config, did you try aligning both?
> I do al loop calling a repository 10 times and in 2. its ok.
> In 1. everything freezes after 8 requests.
>
What is the thread stack when locked? Also note hsqldb can need mvcc option
depending (ebean?) tx setup
> I started out thinking it must be an ebean issue, but I do think it's an
> tomee issue.
>
> Any comments?
>
> repo:
> https://github.com/hwaastad/TomeeJaxrsValidation.git
> and branch is develop.
>
>
>
>
>
> --
> View this message in context:
http://tomee-openejb.979440.n4.nabble.com/7-0-1-app-composer-container-properties-issue-tp4680158.html
> Sent from the TomEE Users mailing list archive at Nabble.com.