Crash forum + MySQL fetch error [2014]

[Ristretto]

Hello,

We are facing a forum crash every 4 or 5 days "502 bad gateway". A reboot of the server solve it, but not for a long time...

So, let start with server configuration. It's a VPS running NGINX and MARIADB.



Forum is up-to-date, only add-on is "XenForo Resource Manager 2.1.6"



Database is an import from Simple Machine Forum with "XenForo Importers 1.3.2"
We already repair and optimize tables.

And now the errors :

Last crash was Friday



The last one :

Server error log
XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now src/XF/Db/AbstractStatement.php:228
Généré par: Compte inconnu 22 Mai 2020, à 06:39
Stack trace
            SELECT `xf_user`., `xf_user_profile_Profile_1`., `xf_user_option_Option_2`.*
            FROM `xf_user`
            INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
            WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND (`xf_user_profile_Profile_1`.`dob_day` = 22) AND (`xf_user_profile_Profile_1`.`dob_month` = 5) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1558586363) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
            ORDER BY `xf_user`.`username` ASC
       
LIMIT 60
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL fetch err...', 2014, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(134): XF\Db\Mysqli\Statement->getException('MySQL fetch err...', 2014, 'HY000')
#2 src/XF/Db/AbstractStatement.php(93): XF\Db\Mysqli\Statement->fetchRowValues()
#3 src/XF/Mvc/Entity/Finder.php(1296): XF\Db\AbstractStatement->fetchAliasGrouped()
#4 src/XF/MemberStat/Birthdays.php(14): XF\Mvc\Entity\Finder->fetch(60)
#5 [internal function]: XF\MemberStat\Birthdays::getBirthdayUsers(Object(XF\Entity\MemberStat), Object(XF\Finder\User))
#6 src/XF/Service/MemberStat/Preparer.php(138): call_user_func_array(Array, Array)
#7 src/XF/Service/MemberStat/Preparer.php(199): XF\Service\MemberStat\Preparer->applyCallback('XF\\MemberStat\\B...', 'getBirthdayUser...', Object(XF\Finder\User))
#8 src/XF/Service/MemberStat/Preparer.php(63): XF\Service\MemberStat\Preparer->getResultsData()
#9 src/XF/Cron/MemberStats.php(19): XF\Service\MemberStat\Preparer->cache()
#10 [internal function]: XF\Cron\MemberStats::rebuildMemberStatsCache(Object(XF\Entity\CronEntry))
#11 src/XF/Job/Cron.php(34): call_user_func(Array, Object(XF\Entity\CronEntry))
#12 src/XF/Job/Manager.php(253): XF\Job\Cron->run(G)
#13 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#14 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#15 job.php(42): XF\Job\Manager->runQueue(false, 8)
#16 {main}

Request state
array(4) {
  ["url"] => string(8) "/job.php"
  ["referrer"] => string(40) "https://ducati-mostro-forum.fr/index.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

So, could you help me ? I don't know where is the trouble which is the cause of the crash.

Thanks for your help.

 

[iCafe]

what your real RAM and check php config.

 

[Ristretto]

The server has 4go of ram and php.ini allocated memory was 128mo...

We increased to 2Go to check. Let see...

Thanks @iCafe

 

[Ristretto]

What is the memory limit advisable for XF 2.1 ?