[Aerogear-users] Idle in transaction using AeroGear Unified Push 1.1.0 and postgresql 9.3

[Marius Schellenberger]

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 at petafuel.de<mailto:marius.schellenberger at 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 at lists.jboss.org<mailto:Aerogear-users at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-users/attachments/20151229/3778b262/attachment.html