1 Topic by enderr

  • enderr
  • Member
  • Offline
  • Registered: 2014-06-02
  • Posts: 42

Topic: WARN save info final

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.5-1
- Linux/BSD distribution name and version: FreeBSD 10.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? no
- Related log if you're reporting an issue:
====

after installing a fresh system I get in maillog:

Oct 22 14:01:35 mx amavis[1545]: (01545-12) (!)WARN save_info_final: sql exec: err=1366, HY000, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x99\\x89 C...' for column 'subject' at row 1 at (eval 107) line 172.
Oct 22 14:01:35 mx postfix/pipe[2076]: 960D651483: to=<mmatei@ambianta.md>, relay=dovecot, delay=0.09, delays=0.01/0/0/0.08, dsn=2.0.0, status=sent (delivered via dovecot service)
Oct 22 14:01:35 mx postfix/qmgr[1757]: 960D651483: removed
Oct 22 14:01:38 mx amavis[1545]: (01545-12) (!)WARN save_info_final: sql exec: err=1366, HY000, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x99\\x89 C...' for column 'subject' at row 1 at (eval 107) line 172.
Oct 22 14:01:41 mx amavis[1545]: (01545-12) (!)WARN save_info_final: sql exec: err=1366, HY000, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x99\\x89 C...' for column 'subject' at row 1 at (eval 107) line 172.
Oct 22 14:01:43 mx amavis[1545]: (01545-12) (!)WARN save_info_final: sql exec: err=1366, HY000, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x99\\x89 C...' for column 'subject' at row 1 at (eval 107) line 172.
Oct 22 14:01:46 mx amavis[1545]: (01545-12) (!)WARN save_info_final: sql exec: err=1366, HY000, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x99\\x89 C...' for column 'subject' at row 1 at (eval 107) line 172.
Oct 22 14:01:46 mx amavis[1545]: (01545-12) (!!)ERROR sql_storage: too many retries on storing final, info not saved

What is it?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,090

Re: WARN save info final

Seems this email subject contains some special characters and Amavisd cannot convert them and store in SQL db.

3 Reply by enderr

  • enderr
  • Member
  • Offline
  • Registered: 2014-06-02
  • Posts: 42

Re: WARN save info final

ZhangHuangbin wrote:

Seems this email subject contains some special characters and Amavisd cannot convert them and store in SQL db.

is there a way how to deal with that?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,090

Re: WARN save info final

I'm afraid that it's better to ask for support in Amavisd mailing list since it's a programming issue instead of a config issue:
https://www.amavis.org/#support

5 Reply by dts

  • dts
  • Member
  • Offline
  • Registered: 2013-08-09
  • Posts: 17

Re: WARN save info final

In doing some reading, the cause is emoji in the subject lines. One possible fix I've seen written up is to change varchar to varbinary for the subject field in the msgs table.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,090

Re: WARN save info final

Fix it with SQL commands below:

- For MySQL:

ALTER TABLE msgs MODIFY COLUMN subject VARBINARY(255);

- For PostgreSQL:

ALTER TABLE msgs ALTER COLUMN subject DROP DEFAULT;
ALTER TABLE msgs ALTER COLUMN subject TYPE bytea USING subject::bytea;
ALTER TABLE msgs ALTER COLUMN subject SET DEFAULT '';

This fix will be available in next iRedMail release.