General error: 2006 MySQL server has gone away

[Samik]

2017/06/28 18:53:31 [error] [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away. The SQL statement executed was: SELECT domain, policy FROM `delivery_server_domain_policy` `t` WHERE server_id = :sid ORDER BY policy ASC, domain_id ASC.
2017/06/28 18:53:31 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away. The SQL statement executed was: UPDATE `campaign` SET `status`=:status, `last_updated`=NOW() WHERE campaign_id = :cid.
2017/06/28 18:53:32 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in /home/admin/web/mydomain/public_html/apps/common/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/admin/web/mydomain/public_html/apps/common/framework/db/CDbCommand.php(1313): CDbCommand->execute(Array)
#1 /home/admin/web/mydomain/public_html/apps/common/models/Campaign.php(1254): CDbCommand->update('{{campaign}}', Array, 'campaign_id = :...', Array)
#2 /home/admin/web/mydomain/public_html/apps/console/commands/SendCampaignsCommand.php(741): Campaign->saveStatus()
#3 /home/admin/web/mydomain/public_html/apps/console/commands/SendCampaignsCommand.php(622): SendCampaignsCommand->sendCampaignStep3(Array)
#4 /home/admin/web/mydomain/public_html/apps/console/commands/SendCampaignsCommand.php(522): SendCampaignsCommand->sendCampaignStep2(Array)
#5 /home/admin/web/mydomain/public_html/apps/console/commands/SendCampaignsCommand.php(422): SendCampaignsCommand->sendCampaignStep1('10', 0)
#6 /home/admin/web/mydomain/public_html/apps/console/commands/SendCampaignsCommand.php(366): SendCampaignsCommand->sendCampaignStep0(Array)
#7 /home/admin/web/mydomain/public_html/apps/console/commands/SendCampaignsCommand.php(131): SendCampaignsCommand->process()
#8 [internal function]: SendCampaignsCommand->actionIndex()
#9 /home/admin/web/mydomain/public_html/apps/common/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs(Object(SendCampaignsCommand), Array)
#10 /home/admin/web/mydomain/public_html/apps/common/framework/console/CConsoleCommandRunner.php(71): CConsoleCommand->run(Array)
#11 /home/admin/web/mydomain/public_html/apps/common/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run(Array)
#12 /home/admin/web/mydomain/public_html/apps/common/framework/base/CApplication.php(185): CConsoleApplication->processRequest()
#13 /home/admin/web/mydomain/public_html/apps/init.php(233): CApplication->run()
#14 /home/admin/web/mydomain/public_html/apps/console/console.php(28): require_once('/home/admin/web...')
#15 {main}
---

------------------------------------------------------------------------------------------------------------------------------------
my.cnf
wait_timeout = 120
interactive_timeout = 120
max_allowed_packet = 128m

 

[twisted1919]

Try to increase the number of allowed connections to the mysql server.

 

[ipolic]

Had same issue, increased these 3 variables in mysql conf file and it is solved:
wait_timeout
max_allowed_packet
max_connections

 

[Shannon G]

I am having the same issue. Can someone please show me the path to the file I need to modify? I am using a Digital Ocean VPS and have the latest update of MailWizz.

 

[amitk4119]

I was getting the same error and I tried this and it works

Solution:

my.cnf
wait_timeout = 120
interactive_timeout = 120
max_allowed_packet = 128m