Odd SQL issues

[Shawn Iverson]

Danita,

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.

On Wed, Jan 11, 2017 at 11:05 AM, Danita Zanre <danita at caledonia.net> wrote:

> 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.
>
> Jan 11 07:03:38 xeams MailScanner[31417]: Logging message 92CB8EDE48.AF3D2
> to SQL
>
>
> Here is where we rebooted
>
>
> Jan 11 07:09:16 xeams MailScanner[4361]: Started SQL Logging child
>
> Jan 11 07:09:22 xeams MailScanner[4878]: Started SQL Logging child
>
> Jan 11 07:09:27 xeams MailScanner[5348]: Started SQL Logging child
>
> Jan 11 07:09:33 xeams MailScanner[5621]: Started SQL Logging child
>
> Jan 11 07:09:38 xeams MailScanner[5788]: Started SQL Logging child
>
> Jan 11 07:12:27 xeams MailScanner[4878]: Logging message 209C7EDE37.AA97A
> to SQL
>
> Jan 11 07:12:27 xeams MailScanner[5348]: Logging message 04FF9EDE3F.AA21D
> to SQL
>
> Jan 11 07:12:27 xeams MailScanner[5348]: Logging message DF6B9EDE3C.ABB06
> to SQL
>
> Jan 11 07:12:32 xeams MailScanner[5788]: Logging message 049DAEDE40.A9BBD
> to SQL
>
> Jan 11 07:13:13 xeams MailScanner[5621]: Logging message 7383EEDE41.AADEE
> to SQL
>
> 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!
>
> Thanks for any insights here.
>
> *Danita Zanrè*, *Move Out of the Office*
> I love my job, and you can too!
> Tel: (720) 319-7530 - Caledonia Network Consulting
> Tel: (720) 319-8240 - Move Out of the Office
>
>
>
>
> --
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
>
>
>


-- 
Shawn Iverson
Director of Technology
Rush County Schools
765-932-3901 x271
iversons at rushville.k12.in.us
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20170111/66c95946/attachment.html>