<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
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","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m trying to investigate an issue we saw the other day when our Shibboleth session database suddenly had a large amount of database connections . Usually we see about 10-30 connections in a 5 minute period but this increased to over 700
connections in a five minute period (for about an hour we had an average of 100 connections per minute.) Any ideas what this was? We think the problem was solved by deleting all the session data from the tables. The logs don’t really show anything strange
before the amount of connections took us over the threshold of allowed connections except:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">ERROR Shibboleth.LogoutInitiator.Local [72]: error accessing current session: ODBC StorageService failed to set transaction isolation level.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">And then a few seconds later:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">WARN Shibboleth.SessionCache [71]: unsuccessful read of session (ID: _SessionId), caches out of sync?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">(We had five servers in the non-sticky load balancer and we know the above problem wasn’t due to high load – requests per second wasn’t any higher than normal (checked against our code and IIS logs).)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I realise this isn’t much information to go from but I was hoping that someone who knows the code a lot better might be able to shed some light on the issue we saw?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Many thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Chris<o:p></o:p></p>
</div>
<table border="0" cellspacing="0" cellpadding="0" width="550">
<tbody>
<tr>
<td width="126" valign="top"><img src="http://www.rm.com/_RMVirtual/media/images/rm-logo-2013.gif" alt="RM Education" width="108" height="78"></td>
<td width="424" valign="top">
<p style="margin: 0 0 0 0;"><font style="font-size: 11px; line-height: 140%;" face="Arial, Helvetica, Trebuchet MS, Tahoma, Verdana, sans-serif" color="#999999" size="2">This message is confidential. You should not copy it or disclose its contents to anyone.
You may use and apply the information only for the intended purpose. Internet communications are not secure and therefore RM Education does not accept legal responsibility for the contents of this message. Any views or opinions presented are only those of
the author and not those of RM Education. If this email has come to you in error please delete it and any attachments. Please note that RM Education may intercept incoming and outgoing email communications.</font></p>
<p style="margin: 1em 0 0 0;"><font style="font-size: 11px; line-height: 140%;" face="Arial, Helvetica, Trebuchet MS, Tahoma, Verdana, sans-serif" color="#999999" size="2">RM Education Ltd is a company registered in England and Wales, Company Reg. No: 01148594;
Registered Office: 140 Eastern Avenue, Milton Park, Milton, Abingdon, Oxon OX14 4SB; VAT No: 630 8236 56.</font></p>
</td>
</tr>
</tbody>
</table>
</body>
</html>