XF 2.0 MySQL fetch error [2014]: Commands out of sync; you can't run this command now

[Recep Baltaş]

Stack Trace:

SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*
            FROM `xf_thread` FORCE INDEX (`post_date`)
            LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '2')
            WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`node_id` IN (119, 85, 86, 87, 38, 138, 137, 44, 136, 135, 39, 42, 134, 43, 115, 139, 73, 74, 127, 72, 70, 71, 113, 16, 7, 8, 9, 10, 11, 12, 13, 14, 15, 28, 202, 121, 29, 146, 209, 147, 35, 30, 31, 140, 141, 142, 143, 144, 145, 33, 32, 122, 123, 36, 34, 18, 26, 19, 20, 21, 22, 23, 24, 25, 204, 220, 203, 149, 150, 62, 51, 52, 53, 54, 55, 56, 57, 58, 59, 61, 196, 60, 64, 65, 68, 47, 132, 133, 49, 48, 124, 103, 104, 105, 102, 126, 210, 128, 129, 130, 131, 77, 201, 152, 156, 154, 155, 116, 153, 120, 205, 167, 168, 169, 170, 172, 173, 174, 175, 176, 107, 109, 110, 108, 148, 189, 190, 191, 192, 82, 83, 185, 186, 187, 79, 157, 158, 159, 160, 161, 206, 162, 163, 164, 165, 80, 81, 177, 178, 179, 180, 181, 182, 183, 184, 118))
            ORDER BY `xf_thread`.`post_date` DESC
        
LIMIT 40
------------

#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(88): XF\Db\Mysqli\Statement->fetchRowValues()
#3 src/XF/Mvc/Entity/Finder.php(1165): XF\Db\AbstractStatement->fetchAliasGrouped()
#4 src/XF/Widget/NewThreads.php(62): XF\Mvc\Entity\Finder->fetch()
#5 src/XF/Template/Templater.php(1526): XF\Widget\NewThreads->render()
#6 src/XF/Pub/App.php(452): XF\Template\Templater->widgetPosition('pub_sidebar_bot...')
#7 src/XF/App.php(1769): XF\Pub\App->renderPageHtml('

<div class="b...', Array, Object(XF\Mvc\Reply\Error), Object(XF\Mvc\Renderer\Html))
#8 src/XF/Mvc/Dispatcher.php(310): XF\App->renderPage('

<div class="b...', Object(XF\Mvc\Reply\Error), Object(XF\Mvc\Renderer\Html))
#9 src/XF/Mvc/Dispatcher.php(44): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\Error), 'html')
#10 src/XF/App.php(1934): XF\Mvc\Dispatcher->run()
#11 src/XF.php(333): XF\App->run()
#12 index.php(13): XF::runApp('XF\\Pub\\App')
#13 {main}

Request:

array(4) {
  ["url"] => string(47) "/sosyal/bolum/ikinci-el-alim-satim-ilanlari.89/"
  ["referrer"] => bool(false)
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[Recep Baltaş]

Solved by ditching MySQL and upgrading to MariaDB 10.2.