No subject


Fri Jan 30 20:15:43 JST 2015


<i><i>From PGP1  select * from family;
           --&gt; Bob
           --&gt; Sally
           --&gt; Mike
</i>From PGP2  select * from family;
           --&gt; Bob</i>
</pre>
    As the existing system was given to me, I am required to receive
    transactions from two Tomcat servers into 2 independent Pgpools. <br>
    <br>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">     </span><span
          style="mso-spacerun:yes">   </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes">  </span>┌ ─ ─ ─
        ─ ─ ─ ─ ─ ┐<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">    </span><span
          style="mso-spacerun:yes">    </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>│<span
          style="mso-spacerun:yes">             
        </span><span style="mso-spacerun:yes">   </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">     </span><span
          style="mso-spacerun:yes">   </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>│<span
          style="mso-spacerun:yes">      </span>ACE<span
          style="mso-spacerun:yes">     </span><span
          style="mso-spacerun:yes">   </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">     </span><span
          style="mso-spacerun:yes">   </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes">  </span>│<span
          style="mso-spacerun:yes">              </span><span
          style="mso-spacerun:yes">   </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">    </span><span
          style="mso-spacerun:yes">    </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>└ ─ ─ ─ ─ ─ ─ ─ ─ ┘<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">               </span><span
          style="mso-spacerun:yes">  </span>/ <span
          style="mso-spacerun:yes">  </span><span
          style="mso-spacerun:yes">  </span>\ <o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">              </span><span
          style="mso-spacerun:yes">  </span>/<span
          style="mso-spacerun:yes">  </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes">  </span><span
          style="mso-spacerun:yes"> </span>\<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">             </span><span
          style="mso-spacerun:yes">  </span>/<span
          style="mso-spacerun:yes">    </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes">  </span><span
          style="mso-spacerun:yes">  </span>\<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes">          
        </span><span style="mso-spacerun:yes">  </span>˅<span
          style="mso-spacerun:yes">     </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>˅<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">┌ ─ ─ ─ ─ ─ ─ ─ ─ ┐<span style="mso-spacerun:yes">    
        </span>┌ ─ ─ ─ ─ ─ ─ ─ ─ ┐<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│<span style="mso-spacerun:yes">                 </span>│<span
          style="mso-spacerun:yes">     </span>│<span
          style="mso-spacerun:yes">                 </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│ <span style="mso-spacerun:yes"> </span>TOMCAT
        SERVER <span style="mso-spacerun:yes"> </span>│<span
          style="mso-spacerun:yes">     </span>│<span
          style="mso-spacerun:yes">  </span>TOMCAT SERVER <span
          style="mso-spacerun:yes"> </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│<span style="mso-spacerun:yes">                 </span>│<span
          style="mso-spacerun:yes">     </span>│<span
          style="mso-spacerun:yes">                 </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│ <span style="mso-spacerun:yes"> </span>PGPOOL INST
        1 <span style="mso-spacerun:yes"> </span>│<span
          style="mso-spacerun:yes">     </span>│<span
          style="mso-spacerun:yes">  </span>PGPOOL INST 2<span
          style="mso-spacerun:yes"> 
        </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│(ACTIVE/INDEPEN.)│<span style="mso-spacerun:yes">    
        </span>│(ACTIVE/INDEPEN.)│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">└ ─ ─ ─ ─ ─ ─ ─ ─ ┘<span style="mso-spacerun:yes">    
        </span>└ ─ ─ ─ ─ ─ ─ ─ ─ ┘<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">       </span><span
          style="mso-spacerun:yes"> </span>│<span
          style="mso-spacerun:yes">        </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>\ <span
          style="mso-spacerun:yes"> </span>/<span
          style="mso-spacerun:yes">   </span><span
          style="mso-spacerun:yes">      </span>│<span
          style="mso-spacerun:yes">  </span><o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">  </span><span
          style="mso-spacerun:yes"> </span>READ │
        WRITE <span style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>\/<span
          style="mso-spacerun:yes">   </span><span
          style="mso-spacerun:yes">  </span>READ
        │ ONLY<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">        </span>│ <span
          style="mso-spacerun:yes">       </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>/\<span
          style="mso-spacerun:yes">    </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes">    </span><span
          style="mso-spacerun:yes"> </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">        </span>│<span
          style="mso-spacerun:yes">         </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>/ <span
          style="mso-spacerun:yes"> </span>\<span
          style="mso-spacerun:yes">    </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes">    </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;"><span style="mso-spacerun:yes">       </span><span
          style="mso-spacerun:yes"> </span>˅<span
          style="mso-spacerun:yes">   </span><span
          style="mso-spacerun:yes">     </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>˅<span
          style="mso-spacerun:yes">  </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>˅<span
          style="mso-spacerun:yes">    </span><span
          style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes">   </span>˅<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">┌ ─ ─ ─ ─ ─ ─ ─ ─
        ┐<span style="mso-spacerun:yes">     </span>┌ ─ ─ ─ ─ ─ ─ ─ ─ ┐<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│<span style="mso-spacerun:yes">                 </span>│<span
          style="mso-spacerun:yes">     </span>│<span
          style="mso-spacerun:yes">                 </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│ POSTGRES SERVER │<span style="mso-spacerun:yes">    
        </span>│ POSTGRES SERVER │<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│<span style="mso-spacerun:yes">                 </span>│<span
          style="mso-spacerun:yes">     </span>│<span
          style="mso-spacerun:yes">                 </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│ <span style="mso-spacerun:yes"> </span><span
          style="mso-spacerun:yes"> </span>PGPOOL
        PRIM <span style="mso-spacerun:yes">  </span>│<span
          style="mso-spacerun:yes">     </span>│ PG HOT STANDBY<span
          style="mso-spacerun:yes">  </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">│<span style="mso-spacerun:yes">                 </span>│<span
          style="mso-spacerun:yes">     </span>│<span
          style="mso-spacerun:yes">                 </span>│<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-family:&quot;Courier
        New&quot;">└ ─ ─ ─ ─ ─ ─ ─ ─
        ┘<span style="mso-spacerun:yes">     </span>└ ─ ─ ─ ─ ─ ─ ─ ─ ┘<o:p></o:p></span></p>
    <meta name="ProgId" content="Word.Document">
    <meta name="Generator" content="Microsoft Word 15">
    <meta name="Originator" content="Microsoft Word 15">
    <link rel="File-List"
href="file:///C:%5CUsers%5CMike%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml">
    <!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:AllowPNG/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
    <link rel="themeData"
href="file:///C:%5CUsers%5CMike%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx">
    <link rel="colorSchemeMapping"
href="file:///C:%5CUsers%5CMike%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml">
    <!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:Zoom>0</w:Zoom>
  <w:TrackMoves/>
  <w:TrackFormatting/>
  <w:PunctuationKerning/>
  <w:ValidateAgainstSchemas/>
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
  <w:DoNotPromoteQF/>
  <w:LidThemeOther>EN-US</w:LidThemeOther>
  <w:LidThemeAsian>X-NONE</w:LidThemeAsian>
  <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>
   <w:UseAsianBreakRules/>
   <w:DontGrowAutofit/>
   <w:SplitPgBreakAndParaMark/>
   <w:EnableOpenTypeKerning/>
   <w:DontFlipMirrorIndents/>
   <w:OverrideTableStyleHps/>
  </w:Compatibility>
  <m:mathPr>
   <m:mathFont m:val="Cambria Math"/>
   <m:brkBin m:val="before"/>
   <m:brkBinSub m:val="&#45;-"/>
   <m:smallFrac m:val="off"/>
   <m:dispDef/>
   <m:lMargin m:val="0"/>
   <m:rMargin m:val="0"/>
   <m:defJc m:val="centerGroup"/>
   <m:wrapIndent m:val="1440"/>
   <m:intLim m:val="subSup"/>
   <m:naryLim m:val="undOvr"/>
  </m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
  DefSemiHidden="false" DefQFormat="false" DefPriority="99"
  LatentStyleCount="371">
  <w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
  <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 6"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 7"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 8"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 9"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 1"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 2"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 3"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 4"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 5"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 6"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 7"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 8"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 9"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Normal Indent"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="footnote text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="annotation text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="header"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="footer"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index heading"/>
  <w:LsdException Locked="false" Priority="35" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="caption"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="table of figures"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="envelope address"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="envelope return"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="footnote reference"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="annotation reference"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="line number"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="page number"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="endnote reference"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="endnote text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="table of authorities"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="macro"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="toa heading"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number 5"/>
  <w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Closing"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Signature"/>
  <w:LsdException Locked="false" Priority="1" SemiHidden="true"
   UnhideWhenUsed="true" Name="Default Paragraph Font"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text Indent"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Message Header"/>
  <w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Salutation"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Date"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text First Indent"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text First Indent 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Note Heading"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text Indent 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text Indent 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Block Text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Hyperlink"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="FollowedHyperlink"/>
  <w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
  <w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Document Map"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Plain Text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="E-mail Signature"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Top of Form"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Bottom of Form"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Normal (Web)"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Acronym"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Address"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Cite"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Code"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Definition"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Keyboard"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Preformatted"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Sample"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Typewriter"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Variable"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Normal Table"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="annotation subject"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="No List"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Outline List 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Outline List 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Outline List 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Simple 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Simple 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Simple 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Classic 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Classic 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Classic 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Classic 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Colorful 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Colorful 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Colorful 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 6"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 7"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 8"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 6"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 7"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 8"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table 3D effects 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table 3D effects 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table 3D effects 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Contemporary"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Elegant"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Professional"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Subtle 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Subtle 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Web 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Web 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Web 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Balloon Text"/>
  <w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Theme"/>
  <w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
  <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
  <w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
  <w:LsdException Locked="false" Priority="34" QFormat="true"
   Name="List Paragraph"/>
  <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
  <w:LsdException Locked="false" Priority="30" QFormat="true"
   Name="Intense Quote"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
  <w:LsdException Locked="false" Priority="19" QFormat="true"
   Name="Subtle Emphasis"/>
  <w:LsdException Locked="false" Priority="21" QFormat="true"
   Name="Intense Emphasis"/>
  <w:LsdException Locked="false" Priority="31" QFormat="true"
   Name="Subtle Reference"/>
  <w:LsdException Locked="false" Priority="32" QFormat="true"
   Name="Intense Reference"/>
  <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
  <w:LsdException Locked="false" Priority="37" SemiHidden="true"
   UnhideWhenUsed="true" Name="Bibliography"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
  <w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
  <w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
  <w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
  <w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
  <w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
  <w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
  <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
  <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
  <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 1"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 1"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 1"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 2"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 2"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 2"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 3"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 3"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 3"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 4"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 4"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 4"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 5"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 5"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 5"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 6"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 6"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 6"/>
  <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
  <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
  <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 1"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 1"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 1"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 2"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 2"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 2"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 3"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 3"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 3"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 4"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 4"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 4"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 5"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 5"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 5"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 6"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 6"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 6"/>
 </w:LatentStyles>
</xml><![endif]-->
    <style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;
	mso-font-charset:0;
	mso-generic-font-family:roman;
	mso-font-pitch:variable;
	mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:-536870145 1073786111 1 0 415 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-unhide:no;
	mso-style-qformat:yes;
	mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	line-height:107%;
	mso-pagination:widow-orphan;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ascii-font-family:Calibri;
	mso-ascii-theme-font:minor-latin;
	mso-fareast-font-family:Calibri;
	mso-fareast-theme-font:minor-latin;
	mso-hansi-font-family:Calibri;
	mso-hansi-theme-font:minor-latin;
	mso-bidi-font-family:"Times New Roman";
	mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
	{mso-style-type:export-only;
	mso-default-props:yes;
	font-family:"Calibri",sans-serif;
	mso-ascii-font-family:Calibri;
	mso-ascii-theme-font:minor-latin;
	mso-fareast-font-family:Calibri;
	mso-fareast-theme-font:minor-latin;
	mso-hansi-font-family:Calibri;
	mso-hansi-theme-font:minor-latin;
	mso-bidi-font-family:"Times New Roman";
	mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
	{mso-style-type:export-only;
	line-height:107%;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.WordSection1
	{page:WordSection1;}
-->
</style><!--[if gte mso 10]>
<style>
 /* Style Definitions */
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-priority:99;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	line-height:107%;
	mso-pagination:widow-orphan;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ascii-font-family:Calibri;
	mso-ascii-theme-font:minor-latin;
	mso-hansi-font-family:Calibri;
	mso-hansi-theme-font:minor-latin;}
</style>
<![endif]--><br>
    Thanks,<br>
    <br>
    Mike Hill<br>
    <meta name="ProgId" content="Word.Document">
    <meta name="Generator" content="Microsoft Word 15">
    <meta name="Originator" content="Microsoft Word 15">
    <link rel="File-List"
href="file:///C:%5CUsers%5CMike%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml">
    <!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:AllowPNG/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
    <link rel="themeData"
href="file:///C:%5CUsers%5CMike%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx">
    <link rel="colorSchemeMapping"
href="file:///C:%5CUsers%5CMike%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml">
    <!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:Zoom>0</w:Zoom>
  <w:TrackMoves/>
  <w:TrackFormatting/>
  <w:PunctuationKerning/>
  <w:ValidateAgainstSchemas/>
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
  <w:DoNotPromoteQF/>
  <w:LidThemeOther>EN-US</w:LidThemeOther>
  <w:LidThemeAsian>X-NONE</w:LidThemeAsian>
  <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>
   <w:UseAsianBreakRules/>
   <w:DontGrowAutofit/>
   <w:SplitPgBreakAndParaMark/>
   <w:EnableOpenTypeKerning/>
   <w:DontFlipMirrorIndents/>
   <w:OverrideTableStyleHps/>
  </w:Compatibility>
  <m:mathPr>
   <m:mathFont m:val="Cambria Math"/>
   <m:brkBin m:val="before"/>
   <m:brkBinSub m:val="&#45;-"/>
   <m:smallFrac m:val="off"/>
   <m:dispDef/>
   <m:lMargin m:val="0"/>
   <m:rMargin m:val="0"/>
   <m:defJc m:val="centerGroup"/>
   <m:wrapIndent m:val="1440"/>
   <m:intLim m:val="subSup"/>
   <m:naryLim m:val="undOvr"/>
  </m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
  DefSemiHidden="false" DefQFormat="false" DefPriority="99"
  LatentStyleCount="371">
  <w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
  <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 6"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 7"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 8"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index 9"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 1"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 2"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 3"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 4"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 5"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 6"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 7"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 8"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" Name="toc 9"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Normal Indent"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="footnote text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="annotation text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="header"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="footer"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="index heading"/>
  <w:LsdException Locked="false" Priority="35" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="caption"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="table of figures"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="envelope address"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="envelope return"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="footnote reference"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="annotation reference"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="line number"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="page number"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="endnote reference"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="endnote text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="table of authorities"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="macro"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="toa heading"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Bullet 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Number 5"/>
  <w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Closing"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Signature"/>
  <w:LsdException Locked="false" Priority="1" SemiHidden="true"
   UnhideWhenUsed="true" Name="Default Paragraph Font"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text Indent"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="List Continue 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Message Header"/>
  <w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Salutation"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Date"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text First Indent"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text First Indent 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Note Heading"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text Indent 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Body Text Indent 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Block Text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Hyperlink"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="FollowedHyperlink"/>
  <w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
  <w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Document Map"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Plain Text"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="E-mail Signature"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Top of Form"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Bottom of Form"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Normal (Web)"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Acronym"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Address"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Cite"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Code"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Definition"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Keyboard"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Preformatted"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Sample"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Typewriter"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="HTML Variable"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Normal Table"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="annotation subject"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="No List"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Outline List 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Outline List 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Outline List 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Simple 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Simple 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Simple 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Classic 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Classic 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Classic 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Classic 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Colorful 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Colorful 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Colorful 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Columns 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 6"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 7"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Grid 8"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 4"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 5"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 6"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 7"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table List 8"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table 3D effects 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table 3D effects 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table 3D effects 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Contemporary"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Elegant"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Professional"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Subtle 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Subtle 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Web 1"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Web 2"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Web 3"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Balloon Text"/>
  <w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
   Name="Table Theme"/>
  <w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
  <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
  <w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
  <w:LsdException Locked="false" Priority="34" QFormat="true"
   Name="List Paragraph"/>
  <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
  <w:LsdException Locked="false" Priority="30" QFormat="true"
   Name="Intense Quote"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
  <w:LsdException Locked="false" Priority="19" QFormat="true"
   Name="Subtle Emphasis"/>
  <w:LsdException Locked="false" Priority="21" QFormat="true"
   Name="Intense Emphasis"/>
  <w:LsdException Locked="false" Priority="31" QFormat="true"
   Name="Subtle Reference"/>
  <w:LsdException Locked="false" Priority="32" QFormat="true"
   Name="Intense Reference"/>
  <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
  <w:LsdException Locked="false" Priority="37" SemiHidden="true"
   UnhideWhenUsed="true" Name="Bibliography"/>
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
   UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
  <w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
  <w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
  <w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
  <w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
  <w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
  <w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
  <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
  <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
  <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 1"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 1"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 1"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 2"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 2"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 2"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 3"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 3"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 3"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 4"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 4"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 4"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 5"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 5"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 5"/>
  <w:LsdException Locked="false" Priority="46"
   Name="Grid Table 1 Light Accent 6"/>
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
  <w:LsdException Locked="false" Priority="51"
   Name="Grid Table 6 Colorful Accent 6"/>
  <w:LsdException Locked="false" Priority="52"
   Name="Grid Table 7 Colorful Accent 6"/>
  <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
  <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
  <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 1"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 1"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 1"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 2"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 2"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 2"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 3"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 3"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 3"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 4"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 4"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 4"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 5"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 5"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 5"/>
  <w:LsdException Locked="false" Priority="46"
   Name="List Table 1 Light Accent 6"/>
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
  <w:LsdException Locked="false" Priority="51"
   Name="List Table 6 Colorful Accent 6"/>
  <w:LsdException Locked="false" Priority="52"
   Name="List Table 7 Colorful Accent 6"/>
 </w:LatentStyles>
</xml><![endif]-->
    <style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;
	mso-font-charset:0;
	mso-generic-font-family:roman;
	mso-font-pitch:variable;
	mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:-536870145 1073786111 1 0 415 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-unhide:no;
	mso-style-qformat:yes;
	mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	line-height:107%;
	mso-pagination:widow-orphan;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ascii-font-family:Calibri;
	mso-ascii-theme-font:minor-latin;
	mso-fareast-font-family:Calibri;
	mso-fareast-theme-font:minor-latin;
	mso-hansi-font-family:Calibri;
	mso-hansi-theme-font:minor-latin;
	mso-bidi-font-family:"Times New Roman";
	mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
	{mso-style-type:export-only;
	mso-default-props:yes;
	font-family:"Calibri",sans-serif;
	mso-ascii-font-family:Calibri;
	mso-ascii-theme-font:minor-latin;
	mso-fareast-font-family:Calibri;
	mso-fareast-theme-font:minor-latin;
	mso-hansi-font-family:Calibri;
	mso-hansi-theme-font:minor-latin;
	mso-bidi-font-family:"Times New Roman";
	mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
	{mso-style-type:export-only;
	line-height:107%;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.WordSection1
	{page:WordSectio</style>LMCO, Herndon, VA<br>
    <h1>[pgpool-general: 3676] Re: Error in pgpool memory cache
      invalidation.</h1>
    <b>Tatsuo Ishii</b> <a
href="mailto:pgpool-general%40pgpool.net?Subject=Re:%20Re%3A%20%5Bpgpool-general%3A%203676%5D%20Re%3A%20Error%20in%20pgpool%20memory%20cache%0A%20invalidation.&amp;In-Reply-To=%3C20150430.182247.762685084071967340.t-ishii%40sraoss.co.jp%3E"
      title="[pgpool-general: 3676] Re: Error in pgpool memory cache
      invalidation.">ishii at postgresql.org </a><br>
    <i>Thu Apr 30 18:22:47 JST 2015</i>
    <ul>
      <li>Previous message: <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/003722.html">[pgpool-general:
          3670] Re: Error in pgpool memory cache invalidation.
        </a></li>
      <li>Next message: <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/003695.html">[pgpool-general:
          3646] Re: Adding a New Server and Recovery
        </a></li>
      <li> <b>Messages sorted by:</b> <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/date.html#3729">[
          date ]</a> <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/thread.html#3729">[
          thread ]</a> <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/subject.html#3729">[
          subject ]</a> <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/author.html#3729">[
          author ]</a> </li>
    </ul>
    <hr>
    <pre>Hum. You are right. Consider following scenario:

1) pgpool-II A receives "SELECT * FROM t1 ..." and create a cache on memecached

2) pgpool-II B receives "UPDATE t1 ..." and tries to invalidate the query cache created at #1.

#2 will fail because pgpool-II B does not have the table oid file.

We need to have a way to share info among A &amp; B regarding table
oids. In the mean time is it possible for you to send write queries
only one of A or B? This will avoid the problem above.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a>
Japanese:<a href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a>

&gt;<i> Hi,
</i>&gt;<i> 
</i>&gt;&gt;<i>From my intial reading of the source code,
</i>&gt;<i> 
</i>&gt;<i> 1. For every query cached memcached writes the cache-key on
</i>&gt;<i> oidir/&lt;db_oid&gt;/&lt;table_oid&gt;
</i>&gt;<i> 2. If there is an update on a table, read each hash from &lt;Table_oid&gt; file
</i>&gt;<i> and delete in memcache.
</i>&gt;<i> 
</i>&gt;<i> If this is what pgpool uses to invalidate cache - two pgpools, using same
</i>&gt;<i> memcache will not invalidate cache properly. Please correct me if there are
</i>&gt;<i> more to this logic.
</i>&gt;<i> 
</i>&gt;<i> 
</i>&gt;<i> 
</i>&gt;<i> 
</i>&gt;<i> 
</i>&gt;<i> 
</i>&gt;<i> 
</i>&gt;<i> 
</i>&gt;<i> *DHANANJAY *| Infrastructure Engineer
</i>&gt;<i> Plivo, Inc. 340 Pine St, San Francisco - 94104, USA
</i>&gt;<i> Web: www.plivo.com | Twitter: @plivo &lt;<a href="http://twitter.com/plivo">http://twitter.com/plivo</a>&gt;,
</i>&gt;<i> @notmycommit &lt;<a href="https://twitter.com/notmycommit">https://twitter.com/notmycommit</a>&gt;
</i>&gt;<i> 
</i>&gt;<i> Free Incoming SMS for All US Short Codes – Get One Today!
</i>&gt;<i> &lt;<a href="https://www.plivo.com/sms-short-code/?utm=emailsig">https://www.plivo.com/sms-short-code/?utm=emailsig</a>&gt;
</i>&gt;<i> 
</i>&gt;<i> 
</i>&gt;<i> 
</i>&gt;<i> On Wed, Apr 29, 2015 at 4:10 AM, Tatsuo Ishii &lt;<a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general">ishii at postgresql.org</a>&gt; wrote:
</i>&gt;<i> 
</i>&gt;&gt;<i> Probably pgpool log with -d (debugging option) turned on will provide
</i>&gt;&gt;<i> more useful information.
</i>&gt;&gt;<i>
</i>&gt;&gt;<i> Best regards,
</i>&gt;&gt;<i> --
</i>&gt;&gt;<i> Tatsuo Ishii
</i>&gt;&gt;<i> SRA OSS, Inc. Japan
</i>&gt;&gt;<i> English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a>
</i>&gt;&gt;<i> Japanese:<a href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a>
</i>&gt;&gt;<i>
</i>&gt;&gt;<i> &gt; Message got clipped again. Resending
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; Hi,
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; This commit seems to have fixed the issue. However cache invalidation
</i>&gt;&gt;<i> when
</i>&gt;&gt;<i> &gt; multiple pgpools are used (connecting to same memcache server) is (?)
</i>&gt;&gt;<i> &gt; broken even with 3.3.5. Here are the logs from 3.3.5
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; <a href="https://gist.github.com/dbalan/c5a93458d5c091c28c71">https://gist.github.com/dbalan/c5a93458d5c091c28c71</a>
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; My test setup is two instances of 3.3.5 running on 9999 and 9988 of same
</i>&gt;&gt;<i> &gt; machine with memcache running in localhost.
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; Logs:
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt;&gt;From first pgpool,
</i>&gt;&gt;<i> &gt; # First, read and update data - invalidates cache - this works fine.
</i>&gt;&gt;<i> &gt; psql -U ruser -d mydb -h 127.0.0.1 -p 9999
</i>&gt;&gt;<i> &gt; Password for user ruser:
</i>&gt;&gt;<i> &gt; psql (9.4.1)
</i>&gt;&gt;<i> &gt; Type "help" for help.
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;     comments
</i>&gt;&gt;<i> &gt; ----------------
</i>&gt;&gt;<i> &gt;  boot me please
</i>&gt;&gt;<i> &gt; (1 row)
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; mydb=&gt; update users set comments='hello' where id=1;
</i>&gt;&gt;<i> &gt; UPDATE 1
</i>&gt;&gt;<i> &gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;  comments
</i>&gt;&gt;<i> &gt; ----------
</i>&gt;&gt;<i> &gt;  hello
</i>&gt;&gt;<i> &gt; (1 row)
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; mydb=&gt;
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; Second pgpool:
</i>&gt;&gt;<i> &gt; # Connects via second deamon, reads stale data, i/e updates from this
</i>&gt;&gt;<i> &gt; pgpool instance never invalidate cache.
</i>&gt;&gt;<i> &gt; λ ~/ psql -U ruser -d mydb -h 127.0.0.1 -p 9988
</i>&gt;&gt;<i> &gt; Password for user ruser:
</i>&gt;&gt;<i> &gt; psql (9.4.1)
</i>&gt;&gt;<i> &gt; Type "help" for help.
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;  comments
</i>&gt;&gt;<i> &gt; ----------
</i>&gt;&gt;<i> &gt;  hello
</i>&gt;&gt;<i> &gt; (1 row)
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; mydb=&gt; update users set comments='hello world' where id=1;
</i>&gt;&gt;<i> &gt; UPDATE 1
</i>&gt;&gt;<i> &gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;  comments
</i>&gt;&gt;<i> &gt; ----------
</i>&gt;&gt;<i> &gt;  hello
</i>&gt;&gt;<i> &gt; (1 row)
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; mydb=&gt;
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; The configs and full logs are attached in the link, They both are same
</i>&gt;&gt;<i> &gt; except for the directory paths and ports - not sure whats going wrong
</i>&gt;&gt;<i> here.
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; *DHANANJAY *| Infrastructure Engineer
</i>&gt;&gt;<i> &gt; Plivo, Inc. 340 Pine St, San Francisco - 94104, USA
</i>&gt;&gt;<i> &gt; Web: www.plivo.com | Twitter: @plivo &lt;<a href="http://twitter.com/plivo">http://twitter.com/plivo</a>&gt;,
</i>&gt;&gt;<i> &gt; @notmycommit &lt;<a href="https://twitter.com/notmycommit">https://twitter.com/notmycommit</a>&gt;
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; Free Incoming SMS for All US Short Codes – Get One Today!
</i>&gt;&gt;<i> &gt; &lt;<a href="https://www.plivo.com/sms-short-code/?utm=emailsig">https://www.plivo.com/sms-short-code/?utm=emailsig</a>&gt;
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt; On Mon, Apr 27, 2015 at 5:29 PM, Dhananjay Balan &lt;<a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general">dhananjay at plivo.com</a>&gt;
</i>&gt;&gt;<i> &gt; wrote:
</i>&gt;&gt;<i> &gt;
</i>&gt;&gt;<i> &gt;&gt; Hi,
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; This commit seems to have fixed the issue. However cache invalidation
</i>&gt;&gt;<i> when
</i>&gt;&gt;<i> &gt;&gt; multiple pgpools are used (connecting to same memcache server) is (?)
</i>&gt;&gt;<i> &gt;&gt; broken even with 3.3.5. Here are the logs from 3.3.5
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; <a href="https://gist.github.com/dbalan/c5a93458d5c091c28c71">https://gist.github.com/dbalan/c5a93458d5c091c28c71</a>
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; My test setup is two instances of 3.3.5 running on 9999 and 9988 of same
</i>&gt;&gt;<i> &gt;&gt; machine with memcache running in localhost.
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; From first pgpool,
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; # First, read and update data - invalidates cache - this works fine.
</i>&gt;&gt;<i> &gt;&gt; psql -U ruser -d mydb -h 127.0.0.1 -p 9999
</i>&gt;&gt;<i> &gt;&gt; Password for user ruser:
</i>&gt;&gt;<i> &gt;&gt; psql (9.4.1)
</i>&gt;&gt;<i> &gt;&gt; Type "help" for help.
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;     comments
</i>&gt;&gt;<i> &gt;&gt; ----------------
</i>&gt;&gt;<i> &gt;&gt;  boot me please
</i>&gt;&gt;<i> &gt;&gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; mydb=&gt; update users set comments='hello' where id=1;
</i>&gt;&gt;<i> &gt;&gt; UPDATE 1
</i>&gt;&gt;<i> &gt;&gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;  comments
</i>&gt;&gt;<i> &gt;&gt; ----------
</i>&gt;&gt;<i> &gt;&gt;  hello
</i>&gt;&gt;<i> &gt;&gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; mydb=&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; Second pgpool:
</i>&gt;&gt;<i> &gt;&gt; # Connects via second deamon, reads stale data, i/e updates from this
</i>&gt;&gt;<i> &gt;&gt; pgpool instance never invalidate cache.
</i>&gt;&gt;<i> &gt;&gt; λ ~/ psql -U ruser -d mydb -h 127.0.0.1 -p 9988
</i>&gt;&gt;<i> &gt;&gt; Password for user ruser:
</i>&gt;&gt;<i> &gt;&gt; psql (9.4.1)
</i>&gt;&gt;<i> &gt;&gt; Type "help" for help.
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;  comments
</i>&gt;&gt;<i> &gt;&gt; ----------
</i>&gt;&gt;<i> &gt;&gt;  hello
</i>&gt;&gt;<i> &gt;&gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; mydb=&gt; update users set comments='hello world' where id=1;
</i>&gt;&gt;<i> &gt;&gt; UPDATE 1
</i>&gt;&gt;<i> &gt;&gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;  comments
</i>&gt;&gt;<i> &gt;&gt; ----------
</i>&gt;&gt;<i> &gt;&gt;  hello
</i>&gt;&gt;<i> &gt;&gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; mydb=&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; The configs and full logs are attached in the link, They both are same
</i>&gt;&gt;<i> &gt;&gt; except for the directory paths and ports - not sure whats going wrong
</i>&gt;&gt;<i> here.
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; <a href="https://gist.github.com/dbalan/c5a93458d5c091c28c71">https://gist.github.com/dbalan/c5a93458d5c091c28c71</a>
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; *DHANANJAY *| Infrastructure Engineer
</i>&gt;&gt;<i> &gt;&gt; Plivo, Inc. 340 Pine St, San Francisco - 94104, USA
</i>&gt;&gt;<i> &gt;&gt; Web: www.plivo.com | Twitter: @plivo &lt;<a href="http://twitter.com/plivo">http://twitter.com/plivo</a>&gt;,
</i>&gt;&gt;<i> &gt;&gt; @notmycommit &lt;<a href="https://twitter.com/notmycommit">https://twitter.com/notmycommit</a>&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; Free Incoming SMS for All US Short Codes – Get One Today!
</i>&gt;&gt;<i> &gt;&gt; &lt;<a href="https://www.plivo.com/sms-short-code/?utm=emailsig">https://www.plivo.com/sms-short-code/?utm=emailsig</a>&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt; On Thu, Apr 23, 2015 at 5:11 PM, Muhammad Usama &lt;<a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general">m.usama at gmail.com</a>&gt;
</i>&gt;&gt;<i> wrote:
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt; Hi
</i>&gt;&gt;<i> &gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt; I have found the problem, It was because of the buffer for storing
</i>&gt;&gt;<i> table
</i>&gt;&gt;<i> &gt;&gt;&gt; oids was created in wrong memory context.
</i>&gt;&gt;<i> &gt;&gt;&gt; I have pushed the fix for it in master and 3_4 stable branches.
</i>&gt;&gt;<i> &gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt; Thanks
</i>&gt;&gt;<i> &gt;&gt;&gt; Best regards
</i>&gt;&gt;<i> &gt;&gt;&gt; Muhammad Usama
</i>&gt;&gt;<i> &gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt; On Wed, Apr 22, 2015 at 2:09 PM, Tatsuo Ishii &lt;<a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general">ishii at postgresql.org</a>&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt; wrote:
</i>&gt;&gt;<i> &gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; Thanks for the report.
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; I confirm this with pgpool-II 3.4.1. I also found that this does not
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; happen with 3.3.5 (I tested with shmem).
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; Here is the test script.
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; -------------------------------------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; drop table t1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; create table t1(i int, j text);
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; insert into t1 values(1, 'aaa');
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; select * from t1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; select * from t1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; update t1 set j = 'bbb' where i = 1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; select * from t1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; -------------------------------------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; Will look into this...
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; Best regards,
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; --
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; Tatsuo Ishii
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; SRA OSS, Inc. Japan
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a>
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; Japanese:<a href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a>
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Looks like only part of this email ended up in the mailing list ,
</i>&gt;&gt;<i> not
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; sure how. Resending again - hope it works this time.
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; pgpool doesn't seem to be invalidating caches properly. See the
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; example test case below
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; psql -U ruser -d mydb -h 127.0.0.1 -p 9999
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Password for user ruser:
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; psql (9.4.1)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Type "help" for help.
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  boooo
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; # comes from cache
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  boooo
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; # works
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; mydb=&gt; update users set comments='hello' where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; UPDATE 1
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  hello
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; # stale
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; mydb=&gt; update users set comments='hello world' where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; UPDATE 1
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  hello
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; # also stale
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; mydb=&gt; update users set comments='booo' where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; UPDATE 1
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;  hello
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; From the second write onwards, the cache is not invalidated and
</i>&gt;&gt;<i> stale
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; value is being served. Is it a bug or am I doing something wrong?
</i>&gt;&gt;<i> This
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; happens with both cache backends (memcache and shmem but test logs
</i>&gt;&gt;<i> are
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; from memcache backend)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Test setup is postgresql-9.4 and memcached 1.4.21 and pgpool-3.4.2.
</i>&gt;&gt;<i> my
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; configs and logs from test are here
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; <a href="https://gist.github.com/dbalan/d635993a3e532a083751">https://gist.github.com/dbalan/d635993a3e532a083751</a>
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Regards,
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; --------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; DHANANJAY | Infrastructure Engineer
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Plivo, Inc. 340 Pine St, San Francisco - 94104, USA
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Web: www.plivo.com | Twitter: @plivo, @notmycommit
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; DHANANJAY | Infrastructure Engineer
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Plivo, Inc. 340 Pine St, San Francisco - 94104, USA
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Web: www.plivo.com | Twitter: @plivo, @notmycommit
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; Free Incoming SMS for All US Short Codes – Get One Today!
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; On Tue, Apr 21, 2015 at 12:33 PM, Dhananjay Balan &lt;
</i>&gt;&gt;<i> <a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general">dhananjay at plivo.com</a>&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; wrote:
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; pgpool doesn't seem to be invalidating caches properly. See the
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; example test case below
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; psql -U ruser -d mydb -h 127.0.0.1 -p 9999
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; Password for user ruser:
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; psql (9.4.1)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; Type "help" for help.
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  boooo
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; # comes from cache
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  boooo
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; # works
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; mydb=&gt; update users set comments='hello' where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; UPDATE 1
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  hello
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; # stale
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; mydb=&gt; update users set comments='hello world' where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; UPDATE 1
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  hello
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; # also stale
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; mydb=&gt; update users set comments='booo' where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; UPDATE 1
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; mydb=&gt; select comments from users where id=1;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  comments
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; ----------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;  hello
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; (1 row)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; From the second write onwards, the cache is not invalidated and
</i>&gt;&gt;<i> stale
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; value is being served. Is it a bug or am I doing something wrong?
</i>&gt;&gt;<i> This
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; happens with both cache backends (memcache and shmem but test logs
</i>&gt;&gt;<i> are
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; from memcache backend)
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; Test setup is postgresql-9.4 and memcached 1.4.21 and
</i>&gt;&gt;<i> pgpool-3.4.2. my
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; configs and logs from test are here
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; <a href="https://gist.github.com/dbalan/d635993a3e532a083751">https://gist.github.com/dbalan/d635993a3e532a083751</a>
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; Regards,
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; --------
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; DHANANJAY | Infrastructure Engineer
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; Plivo, Inc. 340 Pine St, San Francisco - 94104, USA
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt;&gt; Web: www.plivo.com | Twitter: @plivo, @notmycommit
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; _______________________________________________
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; pgpool-general mailing list
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; <a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general">pgpool-general at pgpool.net</a>
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; &gt; <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; _______________________________________________
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; pgpool-general mailing list
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; <a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general">pgpool-general at pgpool.net</a>
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt; <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</i>&gt;&gt;<i> &gt;&gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;&gt;
</i>&gt;&gt;<i> &gt;&gt;
</i>&gt;&gt;<i>
</i></pre>
    <hr>
    <ul>
      <li>Previous message: <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/003722.html">[pgpool-general:
          3670] Re: Error in pgpool memory cache invalidation.
        </a></li>
      <li>Next message: <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/003695.html">[pgpool-general:
          3646] Re: Adding a New Server and Recovery
        </a></li>
      <li> <b>Messages sorted by:</b> <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/date.html#3729">[
          date ]</a> <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/thread.html#3729">[
          thread ]</a> <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/subject.html#3729">[
          subject ]</a> <a
href="http://www.sraoss.jp/pipermail/pgpool-general/2015-April/author.html#3729">[
          author ]</a> </li>
    </ul>
    <hr>
    <a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general">More
      information about the pgpool-general
      mailing list</a><br>
    <br>
  
<br /><br />
<hr style='border:none; color:#909090; background-color:#B0B0B0; height: 1px; width: 99%;' />
<table style='border-collapse:collapse;border:none;'>
	<tr>
		<td style='border:none;padding:0px 15px 0px 8px'>
			<a href="https://www.avast.com/antivirus">
				<img border=0 src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo" />
			</a>
		</td>
		<td>
			<p style='color:#3d4d5a; font-family:"Calibri","Verdana","Arial","Helvetica"; font-size:12pt;'>
				This email has been checked for viruses by Avast antivirus software.
				<br><a href="https://www.avast.com/antivirus">www.avast.com</a>
			</p>
		</td>
	</tr>
</table>
<br />
</body>
</html>

--Boundary_(ID_E6HQgE/9JLkBojx6vGTrww)--


More information about the pgpool-general mailing list