High CPU Load After Update to v4.3

UPDATE: WordPress 4.3.1 has been released and it contains an automated fix for this issue. Please update to 4.3.1 instead of following these instructions.

—

After reading through that ticket, I can see this being the cause of extreme load in some cases. Here’s how to fix the problem. You will need shell or file access to the server.

Step 1. Fix the actual issue by applying part of the patch in that ticket. It’s a one liner. Open the wp-includes/taxonomy.php file, and go to line 4448. This is that line:

wp_schedule_single_event( 'wp_batch_split_terms', time() + MINUTE_IN_SECONDS );

The problem is that the arguments are reversed. Switch them, like so:

wp_schedule_single_event( time() + MINUTE_IN_SECONDS, 'wp_batch_split_terms' );

That will fix the underlying issue, but it won’t stop the load. To do that, we’re going to make a temporary mu-plugin.

Step 2. Navigate to your /wp-content directory. Create a subdirectory called “mu-plugins”, at /wp-content/mu-plugins. The name of the directory is important. If you already have that directory, just go in there.

MU Plugins are “must use”. All PHP files in this directory get auto-included by WordPress. It’s a handy way to run some code in your WordPress instance without having access to the Plugin page to activate plugins.

Create a new file called “fix.php”. Or anything, the name doesn’t matter. This will be the contents of that file:

EDIT: This is the new code which will not cause additional load on your site. The old code has been removed as it was problematic for some cases.

<?php
function clear_bad_cron_entries() {
	// Fix incorrect cron entries for term splitting
	$cron_array = _get_cron_array();
	if ( isset( $cron_array['wp_batch_split_terms'] ) ) {
		unset( $cron_array['wp_batch_split_terms'] );
	        _set_cron_array( $cron_array );
	}
}
clear_bad_cron_entries();

This is the same code in 4.3.1 to clean up the problem. You need it to run now instead. So paste that code into the fix.php file, and save.

Now, navigate to your site. The problem should clear up shortly. Once it does, you can delete the fix.php file. It only needs to run once, not every time your site loads.

If you are using multi-site, then you need to load every site at least once to allow this code to run on all of them. Cron jobs are stored per-site, not per-instance.

Gonna try to follow your instructions now. Still, I hope an update that will address this issue will be released soon.

I can validate that the fix above solves the problem – Please be aware that the “FIX.PHP” in mu-plugins gave me a astronomic load for aprox. 4 minutes. I have 4 cores, and I was at 17 – It fell to below 1 after 4 minutes. and now the CPU load is back to prior 4.3 levels.

Implemented the fix, although things seem to be running better I get a white screen after hitting ‘Publish’ for posts. The posts do indeed publish so no content is lost but having the white screen to navigate from is concerning. Server my install is on is running Nginx if that makes any difference as most other sites run Apache.

I’m running Nginx + CloudFlare + Varnish

I get no white screen after implementing the script

@hummelmose

I had the same experience with astronomical load for a while after running the fix ??

Thanks for reporting this and posting a sollution, I found it when Updraftplus Backup plugin reported (in various websites of mine) that I had scheduled tasks with a date in the past. When looking into it, I eventually stumbled on this bug-report.

I’ve corrected line 4448 in wp-includes/taxonomy.php and deleted the events used a cron manager plugin to delete the ‘wp_batch_split_terms’ entries, but that only corrects part of my problem, since there are also (and still) about 590 entries that don’t show in any of the cron plugins because they don’t have a hook (or any data) in it. I don’t know how to change the code mentioned above to delete those entries.

When I echo the output of _get_cron_array() it starts out with a lot of entries like this, before showing entries with hooks and args. It might be because some other (previous?) bug, but I don’t like having this in my db.

Can anybody please advice on how to delete these entries?

Array
(
    [1430901747] => Array
        (
        )

    [1430901752] => Array
        (
        )

    [1430901757] => Array
        (
        )

Thanks, Hans

While my blog’s performance really wasn’t impacted, I installed WP Control ( https://www.ads-software.com/plugins/wp-crontrol/ ) just to see what was there and I had about 10 of these. Anyway, I made the change to taxonomy.php and created the fix.php mentioned previously and it cleared them out.

Same Problem. Here. Seems the solution is working, but how long does it take to clean it all. My server is spawning endless httpd processes until all resources are full and then colapses

So I’m not an expert on code Samuel, but in this statement…

Now, navigate to your site. The problem should clear up shortly. Once it does, you can delete the fix.php file. It only needs to run once, not every time your site loads.

Are you saying your Fix.php will be executed every time ANYONE comes to the site? I’m going to go ahead and guess that is one reason your script is causing a horrible load on our servers. As those of us who have this issue, are already in this mess because wp-cron is executed EVERYTIME someone visits our site. So if we get 1000 hits per hour, we’re getting thousands of new created jobs. But now we’re also getting tons of instances of Fix.php running? Correct me if I’m wrong, but your fix seems to just be making the issue worse for those of us with heavily used wordpress installs.

So happened to me with 400 users i got a massive number of jobs created and the server fell appart.

Is there an easy way to delete all the jobs this fix created ?

Are you saying your Fix.php will be executed every time ANYONE comes to the site?

Yes, which is why you only let it run long enough to clear out the excessive entries, and then delete the file. You don’t *leave it there*, you run it only once and then remove it.

The purpose of the fix.php is to clear out all those excess cron entries. That’s what that code does.

Fixing the taxonomy.php file will prevent new jobs from being created. Running this code will clear out the invalid existing jobs. Then, problem solved. It only takes one run. Maybe a minute or two to clean things up, tops.

Yes, which is why you only let it run long enough to clear out the excessive entries, and then delete the file. You don’t *leave it there*, you run it only once and then remove it.

Well. Why put it in the mu-plugins then. Wouldn’t it have been smarter to just call the fix.php from another folder once ?

Well. Why put it in the mu-plugins then. Wouldn’t it have been smarter to just call the fix.php from another folder once ?

Well, I could make a much more complicated script and give you instructions on how to run it, or you could just do this simple fix one time and get on with things. It’s not a big deal to let it stay there, as such. It’s just not necessary. If you don’t have a bunch of excess cron jobs, then the script doesn’t do anything.

Simplicity works better than complicated solutions.

The fix does not create load. It solves the load by removing all the excess cron entries. Now, that does take some time and processing power, especially if you have a lot of entries. Still, once they’re gone, then the load drops.