Inconsistent Email Fetching in Postmaster

[miktritel]

Hi,

The problem is some of the emails are not fetched correctly and is logged in /opt/otrs/var/spool. The Scenario is we've moved the OTRS 6.0.3 to a new VM.

Old Setup: RHEL 7 + OTRS 6.0.3 + MariaDB 5.5.65 + ArticleStorageDB
New Setup: RHEL 7 + OTRS 6.0.3 + MySQL 5.7.27 + converted to (ArticleStorageFS)

One of our troubleshooting is we copied a problem-email## to the old Setup and manually run the problem-email## via command line Console.pl, the email was processed without errors. I don't know if we need to edit some config after we converted to ArticleStorageFS.

One of the suggestion I've read would be using utf8mb4 in the database column, specifically article_data_mime. But others are also discouraging it.

Note: The DB schema and tables have the same collation and charset.
Attached is the sample error when inserting in DB.

[miktritel]

UPDATE:
If anyone comes across the same problem.

MariaDB table CHARSET utf8 collation latin1
MySQL table CHARSET utf8 collation latin1

I still don't know why MariaDB is accepting it and MySQL doesn't.

The solution is to convert the tables into CHARSET and COLLATION to utf8mb4.
So far no issues we're encountered.

[zzz]

Hey,

OTRS 6 is not supporting utf8mb4 (see [link=https://bugs.otrs.org/show_bug.cgi?id=12361]bug 12361[/link].

Please use utf8;utf8_unicode_ci instead.

— Emin