1 Topic by ired_mania

  • ired_mania
  • Member
  • Offline
  • Registered: 2019-06-20
  • Posts: 173

Topic: MYSQL Error:DBD::mysql::st execute failed: MySQL server has gone away

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hi,I installed 1.3.2 and restore old database backup.  I find this error in maillog file. what does it mean actually?
(migrated from 0.9.9 to 1.3.2MariaDB Edition- MYSQL )

TempDir::prepare_file: /var/spool/amavisd/tmp/amavis-20210124T033020-02620-WWGAh3zN/email.txt no longer exists, can't re-use it
Jan 24 03:30:21 mail amavis[2620]: (02620-08) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 96) line 173.

----

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

Re: MYSQL Error:DBD::mysql::st execute failed: MySQL server has gone away

If Amavisd doesn't receive email frequently, the established SQL connection timed out. but don't worry, Amavisd will re-connect and finish the rest work.