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

[NOVAK TOMAŽ]

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, <CLIENT> 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, <CLIENT> 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, <CLIENT> 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, <CLIENT> 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, <CLIENT> 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, <CLIENT> 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, <CLIENT> 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, <CLIENT> 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, <CLIENT> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20160704/6df9f4df/attachment.html>