1 Topic by TiTo

  • TiTo
  • Member
  • Offline
  • Registered: 2021-08-29
  • Posts: 23

Topic: Data too long for column 'subject' at row 1

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 2025012401 (Backend: mariadb, Date: 2025-01-27 21:52:55) iRedMail Easy
- Deployed with iRedMail Easy or the downloadable installer?  iRedMail Easy
- Linux/BSD distribution name and version:  Debian 12
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

System Specifications:
CPU: 16 cores, 1699 MHz
Memory: 128 GB (1 GB active)
Storage: 15 TB (Thick Provision Eager Zeroed)
Problem Description:
mail.log is full of errors such as this

2025-01-30T14:01:33.883381+01:00 mail amavis[1082256]: (1082256-01-35) (!)WARN save_info_final: sql exec: err=1406, 22001, DBD::mysql::st execute failed: Data too long for column 'subject' at row 1 at /usr/share/perl5/Amavis/Out/SQL/Connection.pm line 175, <GEN33> line 234150.
2025-01-30T14:01:33.883589+01:00 mail amavis[1082256]: (1082256-01-35) (!!)ERROR sql_storage: too many retries on storing final, info not saved


As for the previous error (last topic by me) please guide me with specific instructions on what to do because the installation was done via iredmail easy.
I don't want to do anything that would later break the iredmail easy upgrade or migration to the EE version

Thank you in advance!

----

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,197

Re: Data too long for column 'subject' at row 1

This issue was fixed in iRedMail-1.7.1, seems we forgot to commit this fix in iRedMail Easy and EE, will fix it in next release.

As a temporary solution, you can fix it with shell command below:

mysql amavisd -e "ALTER TABLE msgs MODIFY COLUMN subject VARBINARY(1024) DEFAULT '';"

3 Reply by TiTo (edited by TiTo 2025-02-01 22:56:54)

  • TiTo
  • Member
  • Offline
  • Registered: 2021-08-29
  • Posts: 23

Re: Data too long for column 'subject' at row 1

ZhangHuangbin wrote:

This issue was fixed in iRedMail-1.7.1, seems we forgot to commit this fix in iRedMail Easy and EE, will fix it in next release.

As a temporary solution, you can fix it with shell command below:

mysql amavisd -e "ALTER TABLE msgs MODIFY COLUMN subject VARBINARY(1024) DEFAULT '';"

Thank you for fast answer
I also post you ticket about migration from iredmail easy to EE where migration stuck on

TASK [antispam] [SQL] Generate file on disk from embedded file: amavisd/extend_msgs.mysql.
changed: /tmp/upload.sql [2.33325ms]

TASK [antispam] [SQL] Import file (MariaDB).