Dear Matthias,

I got the newest commit (880de40) running.

Now there are two idle transactions on the database, instead of one.

The SQL statement has also changed.

select pid,datname,query from pg_stat_activity where pid = 27622 or pid = 27714;

  pid  | datname  |                                                                                                                                                                                                  query                                                                                                                                                                                              

-------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

27622 | keycloak | select defaultgro0_.REALM_ID as REALM_ID1_28_1_, defaultgro0_.GROUP_ID as GROUP_ID2_31_1_, groupentit1_.ID as ID1_21_0_, groupentit1_.NAME as NAME2_21_0_, groupentit1_.PARENT_GROUP as PARENT_G3_21_0_, groupentit1_.REALM_ID as REALM_ID4_21_0_ from REALM_DEFAULT_GROUPS defaultgro0_ inner join KEYCLOAK_GROUP groupentit1_ on defaultgro0_.GROUP_ID=groupentit1_.ID where defaultgro0_.REALM_ID=$1

27714 | keycloak | select defaultgro0_.REALM_ID as REALM_ID1_28_1_, defaultgro0_.GROUP_ID as GROUP_ID2_31_1_, groupentit1_.ID as ID1_21_0_, groupentit1_.NAME as NAME2_21_0_, groupentit1_.PARENT_GROUP as PARENT_G3_21_0_, groupentit1_.REALM_ID as REALM_ID4_21_0_ from REALM_DEFAULT_GROUPS defaultgro0_ inner join KEYCLOAK_GROUP groupentit1_ on defaultgro0_.GROUP_ID=groupentit1_.ID where defaultgro0_.REALM_ID=$1

Also when I kill these transactions manually using

select pg_terminate_backend(27622);

select pg_terminate_backend(27714);

the transactions seem to never show up again.

The idle transactions are back if the JBoss server is restarted or the App is redeployed.

Please tell me if you need any more information.

Best regards

Marius

Perfecto!

have a nice xmas break!

On Wed, Dec 23, 2015 at 5:31 PM, Marius Schellenberger <marius.schellenberger@petafuel.de> wrote:

Hi Matthias,

alright, give me some days to test.
I think next week I will have the results.

Best regards
Marius

_______________________________________________
Aerogear-users mailing list
Aerogear-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-users

--

Matthias Wessendorf

blog: http://matthiaswessendorf.wordpress.com/
sessions: http://www.slideshare.net/mwessendorf
twitter: http://twitter.com/mwessendorf