<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">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.)<br>
<br>
Thanks,<br>
Marek<br>
<br>
On 07/09/16 01:28, Sarp Kaya wrote:<br>
</div>
<blockquote
cite="mid:B6B020FF-FCE4-477C-84BB-8FA05539F10D@expedia.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Title" content="">
<meta name="Keywords" content="">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:Calibri;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:#0563C1;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:#954F72;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:Calibri;
        color:windowtext;}
span.msoIns
        {mso-style-type:export-only;
        mso-style-name:"";
        text-decoration:underline;
        color:teal;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:Calibri;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">Hello, after
upgrading to Keycloak 2.1.0 I have started to see that
Keycloak is logging warnings like this:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">WARN
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default
task-224) SQL Error: 0, SQLState: null<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I am using
MySQL Database.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Another
thing I noticed with this is that I listen to this JMX for
metrics:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">jboss.as.expr:subsystem=datasources,data-source=MySQLDS,statistics=pool<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">for the
ActiveCount metric<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">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…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Kind
Regards,<br>
Sarp Kaya<o:p></o:p></span></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
keycloak-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/keycloak-user">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></pre>
</blockquote>
<p><br>
</p>
</body>
</html>