Optimize database tables spinning forever

Resolved rchasin
(@rchasin)

9 years, 1 month ago

I’m running this plugin on a site after a backup and it’s taking forever to optimize the database tables. Been spinning for an hour now. What can I do?

Viewing 11 replies - 1 through 11 (of 11 total)

Plugin Contributor DNutbourne
(@dnutbourne)

9 years ago

Hi,

Apologies for the delay.

Are you still experiencing this issue?

sjhawar
(@sjhawar)

9 years ago

I am also experiencing the same issue, “Optimize database tables” spinning forever

davikk
(@davikk)

8 years, 10 months ago

I’m experiencing this issue too. How do I know its finish?

davikk
(@davikk)

8 years, 10 months ago

How to force it to stop?

Plugin Contributor DNutbourne
(@dnutbourne)

8 years, 10 months ago

Hi,

Please could you open your browser’s developer console (instructions here), and then start the optimisation.
Do you see any errors or warnings appear in the console?

jmarash
(@jmarash)

8 years, 10 months ago

I am having the same issue.

This is the console errors I am showing:

JQMIGRATE: Migrate is installed, version 1.4.1
/wp-json/jetpack/v4/jitm?message_path=wp%3Atoplevel_page_WP-Optimize%3Aadmin_notices&query=page%253DWP-Optimize&_wpnonce=263cfb8f1a Failed to load resource: the server responded with a status of 500 (Internal Server Error)
updraft-admin.js:1078 Error caught by UpdraftPlus ajaxError handler (follows) for http://entdocsnj.com/wp-json/jetpack/v4/jitm?message_path=wp%3Atoplevel_pag…WP-Optimize%3Aadmin_notices&query=page%253DWP-Optimize&_wpnonce=263cfb8f1a
updraft-admin.js:1079 Internal Server Error
load-scripts.php:2 Uncaught Error: Syntax error, unrecognized expression: []
at Function.fa.error (load-scripts.php:2)
at fa.tokenize (load-scripts.php:2)
at fa.select (load-scripts.php:2)
at Function.fa (load-scripts.php:2)
at Function.a.find (load-scripts.php:9)
at n.fn.init.find (load-scripts.php:2)
at n.fn.init.a.fn.find (load-scripts.php:9)
at a.fn.init.n.fn.init (load-scripts.php:2)
at a.fn.init (load-scripts.php:9)
at n (load-scripts.php:2)
/wp-admin/admin-ajax.php?action=updraft_ajax&subaction=activejobs_list&nonce=542f0f7989&downloaders= Failed to load resource: the server responded with a status of 404 (Not Found)
updraft-admin.js:74 updraft_send_command: error: error (Not Found)
updraft-admin.js:75 Object
updraft-admin.js:1078 Error caught by UpdraftPlus ajaxError handler (follows) for /wp-admin/admin-ajax.php?action=updraft_ajax&subaction=activejobs_list&nonce=542f0f7989&downloaders=
updraft-admin.js:1079 Not Found
load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-widget,quicktags,underscore,…:4 GET http://entdocsnj.com/wp-admin/admin-ajax.php?action=updraft_ajax&subaction=activejobs_list&nonce=542f0f7989&downloaders= 500 (Internal Server Error)
send @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-widget,quicktags,underscore,…:4
ajax @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-widget,quicktags,underscore,…:4
updraft_send_command @ updraft-admin.js?ver=1.13.4:84
updraft_activejobs_update @ updraft-admin.js?ver=1.13.4:519
(anonymous) @ updraft-admin.js?ver=1.13.4:1567
updraft-admin.js?ver=1.13.4:74 updraft_send_command: error: error (Internal Server Error)
updraft-admin.js?ver=1.13.4:75 Object {readyState: 4, getResponseHeader: function, getAllResponseHeaders: function, setRequestHeader: function, overrideMimeType: function…}
updraft-admin.js?ver=1.13.4:1078 Error caught by UpdraftPlus ajaxError handler (follows) for /wp-admin/admin-ajax.php?action=updraft_ajax&subaction=activejobs_list&nonce=542f0f7989&downloaders=
updraft-admin.js?ver=1.13.4:1079 Internal Server Error
load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-widget,quicktags,underscore,…:4 POST http://entdocsnj.com/wp-admin/admin-ajax.php 500 (Internal Server Error)
send @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-widget,quicktags,underscore,…:4
ajax @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-widget,quicktags,underscore,…:4
n.(anonymous function) @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-widget,quicktags,underscore,…:4
wp_optimize_send_command_admin_ajax @ wpadmin.min.js?ver=2.1.1:1
a @ wpadmin.min.js?ver=2.1.1:1
(anonymous) @ wpadmin.min.js?ver=2.1.1:1
updraft-admin.js?ver=1.13.4:1078 Error caught by UpdraftPlus ajaxError handler (follows) for /wp-admin/admin-ajax.php
updraft-admin.js?ver=1.13.4:1079 Internal Server Error

Plugin Contributor DNutbourne
(@dnutbourne)

8 years, 10 months ago

Hi,

It appears that a fatal error is occurring.
Please could you try temporarily disabling the other plugins on the site, and starting an optimization? Does this complete?

jmarash
(@jmarash)

8 years, 10 months ago

I deactivated everything and ran it again. It sill will not complete.

Error message:
JQMIGRATE: Migrate is installed, version 1.4.1
/wp-admin/admin-ajax.php Failed to load resource: the server responded with a status of 404 (Not Found)
updraft-admin.js:1078 Error caught by UpdraftPlus ajaxError handler (follows) for /wp-admin/admin-ajax.php
updraft-admin.js:1079 Not Found

Plugin Author David Anderson / Team Updraft
(@davidanderson)

8 years, 10 months ago

A 404 not found for a file that’s always there (part of WordPress) (wp-admin/admin-ajax.php) is almost always caused by mod_security on the webserver being configured with a policy to block the traffic.

jmarash
(@jmarash)

8 years, 10 months ago

Okay, so what does that mean that I should do?

Plugin Contributor DNutbourne
(@dnutbourne)

8 years, 10 months ago

Hi,

You will need to contact your hosts/server admin and ask them to investigate the mod_security policy which is blocking the traffic, and to adjust this policy to allow it.

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Optimize database tables spinning forever’ is closed to new replies.