Optimizer hangs indefinately

This is the error I get in the apache log:

WordPress database error Out of sort memory, consider increasing server sort buffer size for query \r\n\t\t\t SELECTIDAS id, 'post' AS post_type,post_titleAS title,post_modifiedAS modified\r\n\t\t\t\t FROM kv5zet1n_3_posts\r\n\t\t\t\tWHEREpost_status= 'trash'\r\n\t\t\tUNION ALL\r\n\t\t\t SELECTcomment_IDAS id, 'comment' AS post_type,comment_author_IPAS title,comment_dateAS modified\r\n\t\t\t\t FROM kv5zet1n_3_comments\r\n\t\t\t\tWHEREcomment_approved= 'trash'\r\n\t\t\t ORDER BY post_type, UCASE(title)\t\t\r\n\t\t\t made by require_once('C:\\UniServerZ\\www\\kcwww\\wordpress\\wp-admin\\admin.php'), do_action('tools_page_rvg-optimize-db'), call_user_func_array, rvg_optimize_db, rvg_get_trash, referer: https://www.mysite.com/wp-admin/tools.php?page=rvg-optimize-db.php

I’ve upped the sort buffer size to 256K but it still falls over.

In phpMyAdmin, the above query returns instantly with zero rows and no errors.

Hey iltdevunit,

That’s a strange problem…
Hasn’t been reported before.

It must be some MySQL issue.
Maybe a stupid question but did you restart MySQL after making the memory changes?

peace,
Rolf

I just updated to the latest version, today, and I’m having the exact same problem. However, there are no errors in the webserver logs. FYI I’m running multisite. The plugin has worked flawlessly for me prior to this.

Please advise for any specific information I can provide which may help troubleshoot.

Thanks,
Trevor

Hi Rolf,

Yes I restarted both MySQL and Apache. I too am running on a multisite.

Cheers.

Hey guys,

The major change in the latest version is the way expired transients are being deleted.

So, what happens when you uncheck the ‘Delete expired transients’ checkbox (on the settings page)?

Does that fix the problem?

peace,
Rolf

+1

on a local install

So, what happens when you uncheck the ‘Delete expired transients’ checkbox (on the settings page)?

Does that fix the problem?

the operations now complete their work.

but now white screen (have backup)

Runs fine for me without ‘Delete expired transients’ checked too ??

Hey guys,

I’m able to reproduce the problem now.

It’s a very strange problem but I’m working on a fix.

peace,
Rolf

Hey guys,

Found the bug and killed it ??

Update to v3.4.8 and you should be fine.

peace,
Rolf

Fantastic!

I’ve tested the updated version and everything works perfectly.

Thanks Rolf.

Ditto

Really excellent
Many Thanks