<div dir="ltr">Shawn,<div> Did you see my DBITrace information? </div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jan 11, 2017 at 1:12 PM, Danita Zanre <span dir="ltr"><<a href="mailto:danita@caledonia.net" target="_blank">danita@caledonia.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div id="m_-6786745639966431899bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">Shawn,</div><div id="m_-6786745639966431899bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div id="m_-6786745639966431899bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">Not that I can see. I’ve had Mailscanner stop logging to the database before, and reboot has fixed it, which could point to a stuck lock, but this time I rebooted and it was still not logging. Next time it stops updating the database I’ll see if I can find a stuck lock.</div><span class=""><div id="m_-6786745639966431899bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div> <br> <div id="m_-6786745639966431899bloop_sign_1484158082226035968" class="m_-6786745639966431899bloop_sign"><b>Danita Zanrè</b>, <i>Move Out of the Office</i><div>I love my job, and you can too!</div><div>Tel: <a href="tel:(720)%20319-7530" value="+17203197530" target="_blank">(720) 319-7530</a> - Caledonia Network Consulting</div><div>Tel: <a href="tel:(720)%20319-8240" value="+17203198240" target="_blank">(720) 319-8240</a> - Move Out of the Office</div><div><div><br></div></div></div> <br></span><div><div class="h5"><p class="m_-6786745639966431899airmail_on">On January 11, 2017 at 12:11:18 PM, Shawn Iverson (<a href="mailto:iversons@rushville.k12.in.us" target="_blank">iversons@rushville.k12.in.us</a>) wrote:</p> </div></div><blockquote type="cite" class="m_-6786745639966431899clean_bq"><span><div><div></div><div><div><div class="h5">
<div dir="ltr">Danita,
<div><br></div>
<div>Is there a stuck lock on the mysql table(s)? I am
currently trying to figure out an issue with Mailscanner/mysql
which is why I ask.</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Jan 11, 2017 at 11:05 AM, Danita
Zanre <span dir="ltr"><<a href="mailto:danita@caledonia.net" target="_blank">danita@caledonia.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<div id="m_-6786745639966431899m_-6733201040091000415bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
This morning we added more memory to our VM running
MailScanner/MailWatch. After reboot, MailScanner logged that
it was sending messages to SQL, but no new entries were in the
database.</div>
<div id="m_-6786745639966431899m_-6733201040091000415bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<br></div>
<div id="m_-6786745639966431899m_-6733201040091000415bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:03:38 xeams MailScanner[31417]: Logging message 92CB8EDE48.AF3D2
to SQL</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"><br></span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Here is
where we rebooted</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"><br></span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:09:16 xeams MailScanner[4361]: Started SQL Logging
child</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:09:22 xeams MailScanner[4878]: Started SQL Logging
child</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:09:27 xeams MailScanner[5348]: Started SQL Logging
child</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:09:33 xeams MailScanner[5621]: Started SQL Logging
child</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:09:38 xeams MailScanner[5788]: Started SQL Logging
child</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:12:27 xeams MailScanner[4878]: Logging message 209C7EDE37.AA97A
to SQL</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:12:27 xeams MailScanner[5348]: Logging message 04FF9EDE3F.AA21D
to SQL</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:12:27 xeams MailScanner[5348]: Logging message DF6B9EDE3C.ABB06
to SQL</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:12:32 xeams MailScanner[5788]: Logging message 049DAEDE40.A9BBD
to SQL</span></p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">Jan 11
07:13:13 xeams MailScanner[5621]: Logging message 7383EEDE41.AADEE
to SQL</span></p>
<div><span style="font-variant-ligatures:no-common-ligatures"><br></span></div>
<div><span style="font-variant-ligatures:no-common-ligatures">I
tried all kinds of things, and then ultimately turned Debug SQL =
yes just to see if I could SEE anything. It started updating
the database. I turned it back to Debug SQL = no and it
stopped updating the database! I’m leaving it at “yes” for
now - but why would this even matter? Is there any other
downside to leaving this on? I can’t even see where it is
logging any kind of “debug” info, but it’s keeping the database
updates happening, so I’m not touching it!</span></div>
<div><span style="font-variant-ligatures:no-common-ligatures"><br></span></div>
<div><span style="font-variant-ligatures:no-common-ligatures">Thanks for any
insights here.</span></div>
</div>
<br>
<div id="m_-6786745639966431899m_-6733201040091000415bloop_sign_1484150177894881024" class="m_-6786745639966431899m_-6733201040091000415bloop_sign"><b>Danita Zanrè</b>,
<i>Move Out of the Office</i>
<div>I love my job, and you can too!</div>
<div>Tel: <a href="tel:(720)%20319-7530" value="+17203197530" target="_blank">(720) 319-7530</a> - Caledonia Network
Consulting</div>
<div>Tel: <a href="tel:(720)%20319-8240" value="+17203198240" target="_blank">(720) 319-8240</a> - Move Out of the Office</div>
<div>
<div><br></div>
</div>
</div>
</div>
<br>
<br>
<br>
--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.<wbr>info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" rel="noreferrer" target="_blank">http://lists.mailscanner.info/<wbr>mailman/listinfo/mailscanner</a><br>
<br>
<br></blockquote>
</div>
<br>
<br clear="all">
<div><br></div>
--<br>
<div class="m_-6786745639966431899gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Shawn Iverson
<div>Director of Technology</div>
<div>Rush County Schools</div>
<div><a href="tel:(765)%20932-3901" value="+17659323901" target="_blank">765-932-3901 x271</a></div>
<div><a href="mailto:iversons@rushville.k12.in.us" target="_blank">iversons@rushville.k12.in.us</a></div>
<div><br></div>
<div><img src="https://docs.google.com/uc?export=download&id=0Bw5iD0ToYvs_cy1OZFNIZ0drYVU&revid=0Bw5iD0ToYvs_UitIcHVIWkJVVTl2VGpxVUE0d0FQcHBIRXk4PQ" width="96" height="96" style="font-size:12.8px"><br></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br></div></div><span class="HOEnZb"><font color="#888888">
--<br>
This message has been scanned for viruses and<br>
dangerous content by <a href="http://iris.caledonia.net/" target="_blank"><b>Iris
MailScanner</b></a>, and is<br>
believed to be clean.
<br></font></span><span class="">
<br>--
<br>MailScanner mailing list
<br><a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.<wbr>info</a>
<br><a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/<wbr>mailman/listinfo/mailscanner</a>
<br>
<br></span></div></div></span></blockquote></div><br><br>
<br>
--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.<wbr>info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" rel="noreferrer" target="_blank">http://lists.mailscanner.info/<wbr>mailman/listinfo/mailscanner</a><br>
<br>
<br></blockquote></div><br></div>