<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_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="bloop_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="bloop_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><div id="bloop_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="bloop_sign_1484158082226035968" class="bloop_sign"><b>Danita Zanrè</b>, <i>Move Out of the Office</i><div>I love my job, and you can too!</div><div>Tel: (720) 319-7530 - Caledonia Network Consulting</div><div>Tel: (720) 319-8240 - Move Out of the Office</div><div><div><br></div></div></div> <br><p class="airmail_on">On January 11, 2017 at 12:11:18 PM, Shawn Iverson (<a href="mailto:iversons@rushville.k12.in.us">iversons@rushville.k12.in.us</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>
<title></title>
<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_-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_-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_-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_-6733201040091000415bloop_sign_1484150177894881024" class="m_-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">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="gmail_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>765-932-3901 x271</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>
--<br>
This message has been scanned for viruses and<br>
dangerous content by <a href="http://iris.caledonia.net/"><b>Iris
MailScanner</b></a>, and is<br>
believed to be clean.
<br>
<br>--
<br>MailScanner mailing list
<br>mailscanner@lists.mailscanner.info
<br>http://lists.mailscanner.info/mailman/listinfo/mailscanner
<br>
<br></div></div></span></blockquote></body></html>