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

Matthias Wessendorf matzew at apache.org
Tue Dec 29 11:08:35 EST 2015


Hi Marius,

can you comment on https://issues.jboss.org/browse/KEYCLOAK-2235

and reopen the ticket?

Thanks

On Tuesday, 29 December 2015, Marius Schellenberger <
marius.schellenberger at petafuel.de> wrote:

> 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
> <javascript:_e(%7B%7D,'cvml','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
> <javascript:_e(%7B%7D,'cvml','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
>


-- 
Sent from Gmail Mobile
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-users/attachments/20151229/b7bad234/attachment-0001.html 


More information about the Aerogear-users mailing list