ElasticSearch Essentials [Paid] 3.17.16

[cosmo]

After upgrading to ElasticSearch Essentials 3.17.16, I'm getting these server errors.

[LIST]
[*]XF\Db\DeadlockException: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction
[*]src/XF/Db/AbstractStatement.php:225
[*]Generated by: r_o_b_e_r_t
[*]Mar 7, 2026 at 2:45 PM
[/LIST]
[HEADING=2]Stack trace[/HEADING]
            -- XFDB=noForceAllWrite
            INSERT INTO xf_thread_view
                (thread_id, total)
            VALUES
                (? , 1)
            ON DUPLICATE KEY UPDATE
                total = total + 1
        
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1213, '40001')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Repository/ThreadRepository.php(185): XF\Db\AbstractAdapter->query('
            -- XFDB=noF...', 966755)
#4 src/XF/Pub/Controller/ThreadController.php(185): XF\Repository\ThreadRepository->logThreadView(Object(SV\SearchImprovements\XF\Entity\ThreadCollab))
#5 src/addons/XFMG/XF/Pub/Controller/Thread.php(12): XF\Pub\Controller\ThreadController->actionIndex(Object(XF\Mvc\ParameterBag))
#6 src/XF/Mvc/Dispatcher.php(362): XFMG\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Thread), NULL)
#8 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Thread), NULL)
#9 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2824): XF\Mvc\Dispatcher->run()
#11 src/XF.php(814): XF\App->run()
#12 index.php(23): XF::runApp('XF\\Pub\\App')
#13 {main}
[HEADING=2]Request state[/HEADING]
array(4) {
  ["url"] => string(35) "/threads/macbook-neo.966755/page-13"
  ["referrer"] => string(57) "https://www.xxxxxx/threads/macbook-neo.966755/page-12"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[philmckrackon]

What ES version are you running? I'm on Essentials v3.17.16 and ES v8.19.12 (haven't been able to go to ES v9 yet) and have no issues.

 

[philmckrackon]

Just to help you troubleshoot, I upgraded to the latest ES - which is ES v9.3.1 - Essentials v3.17.16 and do not receive any errors.

[root@server ~]# curl -XGET 'http://localhost:9200'
{
  "name" : "***********",
  "cluster_name" : "elasticsearch",
  "cluster_uuid" : "INzKa********VZ61uJdSbA",
  "version" : {
    "number" : "9.3.1",
    "build_flavor" : "default",
    "build_type" : "rpm",
    "build_hash" : "0dd66e52ba3a********e46339dbb71f0269",
    "build_date" : "2026-02-23T23:37:38.684779921Z",
    "build_snapshot" : false,
    "lucene_version" : "10.3.2",
    "minimum_wire_compatibility_version" : "8.19.0",
    "minimum_index_compatibility_version" : "8.0.0"
  },
  "tagline" : "You Know, for Search"
}
[root@server ~]#

 

[Xon]

After upgrading to ElasticSearch Essentials 3.17.16, I'm getting these server errors.

The xf_thread_view table isn't anything todo with this add-on.

But you can remove contention on the xf_thread_view table by using my "redis backed view counters" which offloads the view counts running totals from an in-memory table to redis and changes the view totals updating to be less deadlock prone.

X

Redis backed view counters

Aug 9, 2017

Use redis for view counters rather than MySQL

• Xon
• performance redis threads
• Add-ons [2.x]

Why it is only happening now I'm unsure, but likely just a coincidence