EasyBlog Deadlock issue
By John Coonen on Wednesday, 28 October 2015
Posted in General Issues
Replies 4
Likes 0
Views 641
Votes 0
When I try to change the status of more than 5 or 6 posts, I often run into a "deadlock" error:

1213 Deadlock found when trying to get lock; try restarting transaction SQL=UPDATE `XXXX_finder_terms` AS t INNER JOIN `XXXX_finder_tokens_aggregate` AS ta ON ta.term_id = t.term_id SET t.`links` = t.links + 1

What's causing this? I'd like to "publish" or "delete" multiple articles, not just 2-3 at a time.
Hey John,

I am sorry for the delay of this reply,

It seems like this issue is not related with Easyblog, this issue was caused by the default finder component.

Can you try temporary disable the Smart search extension from backend and see how it goes?
Arlex Wong
·
Wednesday, 28 October 2015 11:53
·
0 Likes
·
0 Votes
·
0 Comments
·
I disabled Smart Search as you suggested. Now, when I choose to publish or delete more than 2-3 articles, I get either a 500 error, or this:

Catchable fatal error: Argument 1 passed to plgFinderEasyBlog::index() must be an instance of FinderIndexerResult, instance of stdClass given, called in /administrator/components/com_finder/helpers/indexer/adapter.php on line 330 and defined in /public_html/plugins/finder/easyblog/easyblog.php on line 157
John Coonen
·
Thursday, 29 October 2015 11:07
·
0 Likes
·
0 Votes
·
0 Comments
·
OK, I switched OFF ALL "Smart Search" plugins for Joomla, and now, I'm able to use EasyBlog more effectively. So now, I don't have Smart Search capabilities? Is that the trade-off?
John Coonen
·
Thursday, 29 October 2015 11:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey John,

I have turn on the `Smart search - Easyblog post` plugin from your backend then I tried to publish 6~7 post, it seems work fine. May i know which specify post when you try to publish/unpublish/delete hitting that error?

You can take a look of my video link : http://screencast.com/t/rrxgSEoR
Arlex Wong
·
Thursday, 29 October 2015 14:04
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post