MailScanner/MailWatch error after a while writing into MYSQL, please help

[Jerry Benton]

Tomaz,

You really should ask the MailWatch support list.


-
Jerry Benton
www.mailborder.com
+1 - 844-436-6245


-----Original Message-----
From: NOVAK TOMAŽ <novak.tomaz at adria-mobil.si>
Reply: MailScanner Discussion <mailscanner at lists.mailscanner.info>
Date: July 4, 2016 at 5:17:55 AM
To: mailscanner at lists.mailscanner.info <mailscanner at lists.mailscanner.info>
Subject:  MailScanner/MailWatch error after a while writing into
MYSQL, please help

> Hi!
>
> I have the following problem:
>
> MailWatch Version = 1.2.0 - RC1 DEV
> MailScanner Version = 4.85.2
> PHP Version = 5.6.1
> MySQL Version = 5.6.17
>
> After a day or so, one email comes which brakes my system.
>
> Error`s:
>
> Jun 29 17:38:19 ADRIA40 MailScanner[13859]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging,
> it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st
> execute failed: Incorrect string value: '\xF0\x9F\x94\x9C A...' for column 'subject'
> at row 1 at /usr/share/MailScanner/MailScanner/CustomFunctions/MailWatch.pm
> line 135, line 13166.
> Jun 30 05:49:56 ADRIA40 MailScanner[16295]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging,
> it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st
> execute failed: Incorrect string value: '\xF0\x9F\x94\xA5' for column 'subject'
> at row 1 at /usr/share/MailScanner/MailScanner/CustomFunctions/MailWatch.pm
> line 135, line 2001.
> Jun 30 12:11:04 ADRIA40 MailScanner[16766]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging,
> it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st
> execute failed: Incorrect string value: '\xF0\x9F\x99\x8C' for column 'subject'
> at row 1 at /usr/share/MailScanner/MailScanner/CustomFunctions/MailWatch.pm
> line 135, line 11952.
> Jul 01 08:15:14 ADRIA40 MailScanner[24525]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging,
> it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st
> execute failed: Incorrect string value: '\xF0\x9F\x8D\xA8 S...' for column 'subject'
> at row 1 at /usr/share/MailScanner/MailScanner/CustomFunctions/MailWatch.pm
> line 135, line 409.
> Jul 01 13:24:52 ADRIA40 MailScanner[5449]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging,
> it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st
> execute failed: Incorrect string value: '\xF0\x9F\x8E\xAC' for column 'subject'
> at row 1 at /usr/share/MailScanner/MailScanner/CustomFunctions/MailWatch.pm
> line 135, line 16878.
> Jul 02 05:00:33 ADRIA40 MailScanner[5466]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging,
> it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st
> execute failed: Incorrect string value: '\xF0\x9F\x93\xA9 I...' for column 'subject'
> at row 1 at /usr/share/MailScanner/MailScanner/CustomFunctions/MailWatch.pm
> line 135, line 133.
> Jul 02 11:31:05 ADRIA40 MailScanner[12677]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging,
> it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st
> execute failed: Incorrect string value: '\xF0\x9F\x8E\xAF P...' for column 'subject'
> at row 1 at /usr/share/MailScanner/MailScanner/CustomFunctions/MailWatch.pm
> line 135, line 4442.
> Jul 03 12:40:54 ADRIA40 MailScanner[16371]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging,
> it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st
> execute failed: Incorrect string value: '\xF0\x9F\x92\x96 N...' for column 'subject'
> at row 1 at /usr/share/MailScanner/MailScanner/CustomFunctions/MailWatch.pm
> line 135, line 7529.
> Jul 04 08:01:05 ADRIA40 MailScanner[8328]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging,
> it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st
> execute failed: Incorrect string value: '\xF0\x9F\x91\x89\xC2\xA0...' for column
> 'subject' at row 1 at /usr/share/MailScanner/MailScanner/CustomFunctions/MailWatch.pm
> line 135, line 5803.
>
> * Frequency after this error appears is about 1-2 times per day.
> After this error i get on MailScanner child which is stuck, and i get no new rows into my
> maillog MYSQL table.
> I have to kill that >stuck< MailScanner child and restart MailScanner, after which my
> system is working again with no problems.
>
> My mailscanner DB into which i am writing has Character set: utf8mb4 and Collation: utf8mb4_general_ci
>
> Excluding this my mail system is working for years without any problems.
>
> Can you please help me with this !
>
> Thank you all!
>
> With regards,
>
> Tomaž Novak
>
>
> --
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/listinfo/mailscanner
>
>