<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 06/18/2013 12:35 AM, Mahadevan,
      Venkat wrote:<br>
    </div>
    <blockquote
cite="mid:57ABCAA446A34248A21072281010E3305B2CD020@S-ITSV-MBX01P.ead.ubc.ca"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta name="Generator" content="Microsoft Word 14 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 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";
        color:black;
        mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";
        color:black;}
tt
        {mso-style-priority:99;
        font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {mso-style-priority:99;
        mso-style-link:"Balloon Text Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif";
        color:black;
        mso-fareast-language:EN-US;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:Consolas;
        color:black;
        mso-fareast-language:EN-US;}
span.BalloonTextChar
        {mso-style-name:"Balloon Text Char";
        mso-style-priority:99;
        mso-style-link:"Balloon Text";
        font-family:"Tahoma","sans-serif";
        color:black;
        mso-fareast-language:EN-US;}
span.EmailStyle22
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.EmailStyle23
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle24
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle25
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@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]-->
      <div class="WordSection1">
        <p class="MsoNormal" style="margin-bottom:12.0pt"><br>
          I do not know why your environment is prone to trigger
          db_deadlock (lot of replica agreements, VM, slow disks...).<br>
          I think the best way to progress is that you fill a ticket/bug
          so that we may track the issue. Note this bug is possibly
          affecting all operations (ADD/MOD/MODRDN/DEL)<o:p></o:p></p>
        <p class="MsoNormal"><span style="color:#1F497D">-------<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:&quot;Times New
            Roman&quot;,&quot;serif&quot;;color:#1F497D;mso-fareast-language:EN-CA"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:&quot;Times New
            Roman&quot;,&quot;serif&quot;;color:#1F497D;mso-fareast-language:EN-CA">Hi
            Thierry,<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:&quot;Times New
            Roman&quot;,&quot;serif&quot;;color:#1F497D;mso-fareast-language:EN-CA"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:&quot;Times New
            Roman&quot;,&quot;serif&quot;;color:#1F497D;mso-fareast-language:EN-CA">We
            are running in a VMWare environment, is this known to cause
            issues and are there any tuning steps you can recommend or
            things<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:&quot;Times New
            Roman&quot;,&quot;serif&quot;;color:#1F497D;mso-fareast-language:EN-CA">to
            watch out for? Thanks and sorry for so many questions.<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:&quot;Times New
            Roman&quot;,&quot;serif&quot;;color:#1F497D;mso-fareast-language:EN-CA"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:&quot;Times New
            Roman&quot;,&quot;serif&quot;;color:#1F497D;mso-fareast-language:EN-CA">cheers,<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:&quot;Times New
            Roman&quot;,&quot;serif&quot;;color:#1F497D;mso-fareast-language:EN-CA"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:&quot;Times New
            Roman&quot;,&quot;serif&quot;;color:#1F497D;mso-fareast-language:EN-CA">VM<o:p></o:p></span></p>
      </div>
    </blockquote>
    <font face="Times New Roman, Times, serif">Hi Mahadevan,<br>
      <br>
    </font>
    <blockquote><font face="Times New Roman, Times, serif">Running in a
        VM should not be an issue if it follows the usual tuning
        recommendation. But of course it adds a layer when investigating
        a RC.<br>
        What is weird is to hit so frequent (50) deadlock in a single DB
        call. In addition it looks like it always happen when updating
        the CL so I can think to only RA threads, CL trimming and Write
        thread (the one holding the backend lock) being in competition.
        You may try to disable the RA for a test to check if they are
        responsible of that. You may also remove the CL maxage to
        prevent the CL trimming thread to be in the loop. Also you may
        check if you have pb with disk IO. Or tune the dbcache to be in
        memory.<br>
        Sorry I have no easy answer to your question because it requires
        deeper investigations.<br>
        <br>
      </font></blockquote>
    <font face="Times New Roman, Times, serif">best regards<br>
      thierry<br>
    </font>
  </body>
</html>