imscp-dsk-quota MySQL server has gone away

**kess** · Oct 12th 2019

Hello guys,

since some weeks I receive every night the following mail message:

Code

Dear administrator,
This is an automatic email sent by i-MSCP:
Server name: xxx.yyy.zzz
Server IP: a.b.c.d
Version: 1.5.3
Build: 2018120800
Message severity: error
==========================================================================
An error has been raised while executing function main in
/var/www/imscp/engine/quota/imscp-dsk-quota:
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at
/var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
(eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed
at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
(eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone
away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
==========================================================================
Please do not reply to this email.
___________________________
i-MSCP Mailer

Display More

Contents of /var/log/imscp/imscp-dsk-quota.log:

Code

[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[WARN] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[ERROR] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[ERROR] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.
[Sat Oct 12 00:00:50 2019] [warn] (eval): rollback ineffective with AutoCommit enabled at /var/www/imscp/engine/quota/imscp-dsk-quota line 152.
[Sat Oct 12 00:00:50 2019] [error] (eval): DBD::mysql::db begin_work failed: Turning off AutoCommit failed at /var/www/imscp/engine/quota/imscp-dsk-quota line 136.
[Sat Oct 12 00:00:50 2019] [error] (eval): DBD::mysql::db selectall_hashref failed: MySQL server has gone away at /var/www/imscp/engine/quota/imscp-dsk-quota line 82.

Display More

I've checked everything I could check, I also found a possible related issue here: https://github.com/perl5-dbi/DBD-mysql/issues/202 but unfortunately without a solution.

Am I the one facing this problem ?

Everything is working perfectly as expected on my system, the only issue I have is with that thing.

The system:

- Debian 9 x64, i-MSCP 1.5.3-2018120800, Dovecot, php-fpm (7.0 as default), proftpd, MariaDB 10.1

- Plugins: ClamAV, LetsENcrypt, Mailgraph, Monitorix, OpenDKIM, PhpSwitcher, PostScreen, RoundcubePlugins, ServerDefaultPage, SpamAssassin, WHMCS (all latest versions)

If you need any further informations, please feel free to ask.

Thank you,

bye Kess.

**Nuxwin** · Oct 12th 2019

Good morning,

This is a known issue which should be solved in next i-MSCP maintenance version.

**kess** · Oct 12th 2019

Thank you very much… so I'll keep waiting.

That's not a blocking problem, just annoying.

Thx a lot,

bye Kess.

imscp-dsk-quota MySQL server has gone away

Share

Daily visitors