[keycloak-user] Keycloak 2.1.0 Random SQL Errors (Possible connection leaks)

[Marek Posolda]

Can you please create JIRA for it? Ideally also if you can add some 
details (eg. configuration of your KeycloakDS datasource, what Keycloak 
functionality you used. if number of connection is 18 from the beginning 
and then it's same for longer time or if it's 0 from the beginning and 
then it slowly increases etc.)

Thanks,
Marek

On 07/09/16 01:28, Sarp Kaya wrote:
>
> Hello, after upgrading to Keycloak 2.1.0 I have started to see that 
> Keycloak is logging warnings like this:
>
> WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default 
> task-224) SQL Error: 0, SQLState: null
>
> I am using MySQL Database.
>
> Another thing I noticed with this is that I listen to this JMX for 
> metrics:
>
> jboss.as.expr:subsystem=datasources,data-source=MySQLDS,statistics=pool
>
> for the ActiveCount metric
>
> and I constantly see this being 18 despite having nearly no Keycloak 
> usage. So it’s making me to think that there is a connection leak in 
> Keycloak, because I should not see 18 active connections, when there 
> is no load on Keycloak.
>
> Could you please have a look at this? I don’t really remember seeing 
> this issue in Keycloak 2.0.0, so I’m just guessing it could be just 
> 2.1.0 issue as well…
>
> Kind Regards,
> Sarp Kaya
>
>
>
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20160907/5055883e/attachment.html