[PDOException] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

[rishabh07074]

Hi Team, #

I am getting error of mysql has gone away on my MISP setup. Please refer below logs and let me know what is possible workaround to resolve this issue-

2021-06-12 22:26:00 Notice: Could not save progress for job 1580
[PDOException] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Stack Trace:
MISPerrorlogs.txt
#0 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(502): PDOStatement->execute()
#1 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(468): DboSource->_execute()
#2 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(715): DboSource->execute()
#3 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(1226): DboSource->fetchAll()
#4 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(3053): DboSource->read()
#5 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(3025): Model->_readDataSource()
#6 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(2931): Model->find()
#7 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(1827): Model->exists()
#8 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(1754): Model->_doSave()
#9 /var/www/MISP/app/Model/Job.php(95): Model->save()
#10 /var/www/MISP/app/Model/Feed.php(1888): Job->saveProgress()
#11 /var/www/MISP/app/Model/Feed.php(585): Feed->jobProgress()
#12 /var/www/MISP/app/Model/Feed.php(971): Feed->downloadFromFeed()
#13 /var/www/MISP/app/Console/Command/ServerShell.php(297): Feed->downloadFromFeedInitiator()
#14 /var/www/MISP/app/Console/Command/AppShell.php(35): ServerShell->fetchFeed()
#15 /var/www/MISP/app/Vendor/kamisama/php-resque-ex/lib/Resque/Job.php(199): AppShell->perform()
#16 /var/www/MISP/app/Vendor/kamisama/php-resque-ex/lib/Resque/Worker.php(278): Resque_Job->perform()
#17 /var/www/MISP/app/Vendor/kamisama/php-resque-ex/lib/Resque/Worker.php(241): Resque_Worker->perform()
#18 /var/www/MISP/app/Vendor/kamisama/php-resque-ex/bin/resque(109): Resque_Worker->work()
#19 /var/www/MISP/app/Vendor/kamisama/php-resque-ex/bin/resque(100): startWorker()
#20 {main}

My MISP instance is currently live. I can login using CLI. I tried to increase wait_timeout and max_allowed_packet as listed in owncloud/core#26254 for the issue. I couldn't find much on Google except for increasing those parameters still those didn't worked out properly. I have been posting multiple queries on gitter channel regarding this but no response. Looking for the solution t resolve this issue.

Attached are errorl ogs for reference. Any suggestions would be appreciated. Thanks!

[rishabh07074]

Hello can anyone please look into this and update if any solution is available for this issue?

[mokaddem]

Hello,
Does it only happen if you try to fetch a feed?

[rishabh07074]

Hi,
This issue occurred when I enabled feed sync from two source. Resource utilization was around 25-30% only. Not sure what can be the real cause. With error logs I tried available solution on internet as well but no luck.

[mokaddem]

Hey,
I'm curious about the specification of the server used to run your MISP instance.
Could you share details about disk, ram and cpu?
Thanks!