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

[Matthias Wessendorf]

Hello Marius,

regarding your transaction code, I filed this ticket:
https://issues.jboss.org/browse/KEYCLOAK-2235

Didn't get to do some docker/postgres 9.3 tests

But for my shell history, I was using 9.3 - but not sure if w/ EAP (6.3.x /
6.4.1)  or WildFly

More on Doccker tomorrow

On Thu, Dec 17, 2015 at 11:10 AM, Matthias Wessendorf <matzew at apache.org>
wrote:

> Hello Marius,
>
> sorry for the late reply - your mail was stuck in the moderators queue.
> Did you subscribe before sending?  Anyways.
>
> I am not sure about this issue, looks like there is a bug in the "old"
> Keycloak we use, on 1.1.0 of UPS.
> We are in the process of updating it to a more recent version of Keycloak
> (1.7.0):
> https://github.com/aerogear/aerogear-unifiedpush-server/pull/659
>
> Can you file a JIRA against Keycloak ->
> http://JIRA.jboss.org/browse/KEYCLOAK
>
> We have done a bit of testing w/ UPS 1.1.0 and Postgres9 - but I am, tbh,
> not sure if we did test w/ 9.3 :/
>
> I will create docker-compose files, that will use this DB for our own
> testing of UPS. I will share my evaluations of this later (today/tomorow)
>
> Sorry for the inconvenience!
>
> HTH,
> Matthias
>
> On Mon, Dec 14, 2015 at 4:48 PM, Marius Schellenberger <
> marius.schellenberger at petafuel.de> wrote:
>
>> Hello AeroGear dev‘s,
>>
>>
>>
>> I’m currently evaluating the AeroGear Unified Push Server in a
>> pre-production environment (RedHat JBoss EAP 6.4.4) and I’m facing an issue
>> with an idle database transaction, which is executed every time the app is
>> deployed (or the JBoss Server is started).
>>
>>
>>
>> I’m using Postgresql 9.3 as the database backend.
>>
>>
>>
>> The idle process listed in ps aux:
>>
>> postgres: keycloak keycloak 10.0.6.106(55387) idle in transaction
>>
>>
>>
>> The transaction seems to hang at this SQL statement:
>>
>> select authentica0_.REALM_ID as REALM_ID4_28_1_, authentica0_.ID as
>> ID1_3_1_, authentica0_.ID as ID1_3_0_, authentica0_.ALIAS as ALIAS2_3_0_,
>> authentica0_.PROVIDER_ID as PROVIDER3_3_0_, authentica0_.REALM_ID as
>> REALM_ID4_3_0_ from AUTHENTICATOR authentica0_ where
>> authentica0_.REALM_ID=$1
>>
>>
>>
>> The query results nothing, as you can see below:
>>
>> select * from AUTHENTICATOR;
>>
>> id | alias | realm_id | provider_id
>>
>> ----+-------+----------+-------------
>>
>> (0 rows)
>>
>>
>>
>> Can you guys please help me identifying this issue?
>>
>>
>>
>> Kind regards,
>>
>>
>>
>> Marius Schellenberger
>>
>>
>>
>> _______________________________________________
>> Aerogear-users mailing list
>> 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
>



-- 
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/20151217/3bb7b112/attachment.html