[Plugin: Yet Another Related Posts Plugin] Broken in 2.9?

@mitchoyoshitaka now its working, received a 404 before.

@mitchoyoshitaka tried the new version, updating works fine now, have not made a new post yet but assume that it will work as well.

Great. I’ll push it now.

@mitchoyoshitaka I’m experiencing database problems that are caused by YarPP (latest version). According to my webhoster the cause of the problem are locked processes that are waiting on wp_yarpp_related_cache.

“Your WordPress has quite a large number open, but what is a bit more alarming is that many of them are locked. I see that a number of processes are locked, they are all waiting on one large database table, wp_yarpp_related_cache”

Me too… I updated to 3.1.2 this morning and, since then, mysql takes up a lot of CPU and stays stuck for ages on queries like “insert into wp_yarpp_related_cache (reference_ID,ID,score)……”.

I have not really looked at all of the code, but I wonder why it keeps inserting stuff?
I mean, unless I have actually POSTED something new, or updated something… shouldn’t all similarities be already “known” to the plugin?

btw, disabling “cross-relate posts and pages” seems to partially “fix it”… the high load still happens, but it is less frequent and a bit less high.

Here’s some error messages I’m getting in my error log:

[19-Dec-2009 17:24:27] PHP Warning: array_keys() [function.array-keys]: The first argument should be an array in /home1/alterpol/public_html/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 83

[19-Dec-2009 17:24:27] PHP Warning: Invalid argument supplied for foreach() in /home1/alterpol/public_html/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 83

[19-Dec-2009 17:24:27] PHP Warning: array_keys() [function.array-keys]: The first argument should be an array in /home1/alterpol/public_html/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 87

[19-Dec-2009 17:24:27] PHP Warning: Invalid argument supplied for foreach() in /home1/alterpol/public_html/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 87

[20-Dec-2009 05:34:00] PHP Warning: array_keys() [function.array-keys]: The first argument should be an array in /home1/alterpol/public_html/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 83

[20-Dec-2009 05:34:01] PHP Warning: Invalid argument supplied for foreach() in /home1/alterpol/public_html/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 83

[20-Dec-2009 05:34:01] PHP Warning: array_keys() [function.array-keys]: The first argument should be an array in /home1/alterpol/public_html/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 87

[20-Dec-2009 05:34:01] PHP Warning: Invalid argument supplied for foreach() in /home1/alterpol/public_html/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 87

[20-Dec-2009 17:00:04] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1 for query delete from wp_yarpp_related_cache where reference_ID in () made by require, require_once, include, the_content, apply_filters, call_user_func_array, yarpp_default, yarpp_related, yarpp_cache_enforce, yarpp_cache_clear

Hope this helps.

@ghacks, @dani3l3 – if the load is too much you can follow the general advice (in the FAQ, I believe) to disable “cross-relate posts and pages” and to not consider tags or categories. These should all help. Note, however, that once the cache is organically built up after a while, you should notice a marked decrease in CPU load.

@dani3l3 – things are being inserted because those “relatedness” relations aren’t known until they’re checked the first time. This normally happens when a page is viewed by a visitor. At that time it computes the “relatedness” and then caches it for future use.

@callup – something *very* strange is happening in your installation (it’s not getting the right value for a variable which should have just been set)… perhaps it’s a plugin conflict? Is this a new YARPP install or an upgrade?

things are being inserted because those “relatedness” relations aren’t known until they’re checked the first time. This normally happens when a page is viewed by a visitor. At that time it computes the “relatedness” and then caches it for future use.

I understand, but I *though* that such a cache WAS already built on my db now – I have been running this plugin for several months without this issue, and I am only seeing it after UPGRADING to 3.1.2 ??

unless the new version requires a “new” cache?

@dani3l3 I’m not sure what to say… that part of YARPP hasn’t changed at all since 3.0. If you changed any pool or relatedness settings in YARPP Options, though, that would have reset the cache.

@dani3l3 I also released a beta, 3.1.3b1 which may improve long-term performance (it won’t help with the initial hit of cache-building when the cache is reset). Feel free to give it a try as well.

https://downloads.www.ads-software.com/plugin/yet-another-related-posts-plugin.3.1.3b1.zip

For three days, I was having High Resource Usage & CPU for my site..
I tried many things..downgraded, restored backup, changed theme, deactivated plugins. but no luck..
I have been using your plugin in my three site..your plugin was not having any problem in my other two site..so I never thought your plugin would cause this..then I decided to monitor your plugin when it is active / deactive..

while your plugin active, I monitored the processes through my cpanel..
it sometimes increase over 25 processes which is highest number allowed by my hosting firm..also high cpu generated yarpp active..and suddenly I sometimes come up with error establishing databse..

when I deactivate yarpp, I monitored process for many minutes to make sure..and my blog runs smoothy without any problem..

So seems yarpp is ok with wordpress 2.9 which works pretty well with my two other sites..

but must be conflicting with any other plugins..no idea which one it could be..

I use following plugins

• WP Super Cache
• WP Page Numbers
• WPML Multilingual CMS
• WP Greet Box
• WP-PageNavi
• WP-DBManager
• WordPress Portfolio Plugin
• WordPress.com Stats
• SEO Booster PRO
• Platinum SEO Pack
• PC Robots.txt
• NextGEN Gallery
• Google Friends Connect Widget
• Google Analyticator
• Contact Form 7
• CommentLuv
• Akismet

Let me know If I can provide you any helpful info..as I really want to use your plugin..

Thanks!

Hifa, I’m sorry to hear that. How is this site different than the others? Is it the same WP, same YARPP, same plugins, same hosting?

Same WP, Same YARPP, Same Hosting but plugins differ..

I do not know if this makes sense but when I received Database Connection error, I Check the tables having overhead (which yarpp table/s included), and repair them; both my admin panel and site returns back..but it does not last long..

the plugins I don’t use in my two other site are

• WPML
• WP Greet Box
• WordPress Portfolio Plugin
• NextGEN Gallery
• Google Friends Connect Widget
• CommentLuv

I suspect if the problem is with WPML plugin..I will test by deactivating it and activating urs..

Maybe it is not all plugin conflict but just my assumption..I will give u report later..

Thanks

I’m glad I’m not the only one. I upgraded to 2.9 several days ago and everything was fine until this morning. My hosting company had to deactivate my database because an overload of requests. Looking at the log I traced it back to YARP.

It started with WordPress database error Server shutdown in progress for query select count(*) as count from yarpp_related_cache where reference_ID = 5621 and date > date_sub(now(),interval 600 minute) made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce

The hosting company also said that something weird had happened to my .htaccess file, but I have no idea how that is related.

Hoping that I can reactivate this plugin in the future, it was great.