Gin Rummy Mania,LuckyLand Casino app.Recharge Every day and Get Bonus up-to 50%!

Resolved gotman
(@gotman)

4 years, 5 months ago
I’m getting this message as soon as I hit the button “Start data SEO optimization“:

Oops, something has gone wrong and we couldn’t complete the optimization of your SEO data. Please click the button again to re-start the process.

My site is barely unusable from 5 months to this part. I think the problem must be related with the indexables…? There are times that I cannot access to wp-admin to manage my site and the hosting companny has to restart services so the bellow process may by stoped.

I’m on a VPS (MYSQL 5.6 and nginx 1.17.2), and I have frequently my site offline because, apparently the plugin tries to run run this process without success:

912381 | mysite | localhost | mysite | Query | 788 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912398 | mysite | localhost | mysite | Query | 772 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912402 | mysite | localhost | mysite | Query | 766 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912484 | mysite | localhost | mysite | Query | 706 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912491 | mysite | localhost | mysite | Query | 702 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912554 | mysite | localhost | mysite | Query | 649 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912564 | mysite | localhost | mysite | Query | 643 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912625 | mysite | localhost | mysite | Query | 586 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912655 | mysite | localhost | mysite | Query | 566 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912721 | mysite | localhost | mysite | Query | 461 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912868 | mysite | localhost | mysite | Query | 245 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 912938 | mysite | localhost | mysite | Query | 164 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 913057 | mysite | localhost | mysite | Query | 27 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id FROM w | 0.000 |
| 913060 | mysite | localhost | mysite | Query | 21 | Waiting for table level lock | SELECT * FROM wp_yoast_indexable WHERE object_id = ‘26130’ AND object_type = ‘post’ LIMIT 1 | 0.000 |
| 913061 | mysite | localhost | mysite | Query | 21 | Waiting for table level lock | UPDATE wp_yoast_indexable SET permalink = ‘https://www.mysite.com/tag/dell | 0.000 |
| 913070 | mysite | localhost | mysite | Query | 4 | Waiting for table level lock | SELECT * FROM wp_yoast_indexable WHERE object_id = ‘23339’ AND object_type = ‘post’ LIMIT 1 | 0.000 |
| 913071 | root | localhost | NULL | Query | 0 | NULL | show processlist

What have I done to try to understand the problem cause?

I tried to put this on my dev machine and I found this message on dev tools console:
```
POST https://localhost/mysite/wp-json/yoast/v1/indexation/prepare 404 (Not Found)
(anonymous) @ indexation-1511.js:1

tryCatch @ wp-polyfill.min.js:3
invoke @ wp-polyfill.min.js:3
t.<computed> @ wp-polyfill.min.js:3
r @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
tryCatch @ wp-polyfill.min.js:3
invoke @ wp-polyfill.min.js:3
t.<computed> @ wp-polyfill.min.js:3
tryCatch @ wp-polyfill.min.js:3
maybeInvokeDelegate @ wp-polyfill.min.js:3
invoke @ wp-polyfill.min.js:3
t.<computed> @ wp-polyfill.min.js:3
r @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
Promise.then (async)
r @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
tryCatch @ wp-polyfill.min.js:3
invoke @ wp-polyfill.min.js:3
t.<computed> @ wp-polyfill.min.js:3
r @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
Ag @ react-dom.min.js:116
zg @ react-dom.min.js:116
qi @ react-dom.min.js:130
ui @ react-dom.min.js:133
(anonymous) @ react-dom.min.js:158
unstable_runWithPriority @ react.min.js:27
Vc @ react-dom.min.js:158
Sc @ react-dom.min.js:158
Z @ react-dom.min.js:156
ah @ react-dom.min.js:159
xf @ react-dom.min.js:40
```
And online I get this message:
```
POST https://www.mysite.com/wp-json/yoast/v1/indexation/terms 524

indexation-1511.js:1

(anonymous) @ indexation-1511.js:1
tryCatch @ wp-polyfill.min.js:1
invoke @ wp-polyfill.min.js:1
t.<computed> @ wp-polyfill.min.js:1
r @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
tryCatch @ wp-polyfill.min.js:1
invoke @ wp-polyfill.min.js:1
t.<computed> @ wp-polyfill.min.js:1
tryCatch @ wp-polyfill.min.js:1
maybeInvokeDelegate @ wp-polyfill.min.js:1
invoke @ wp-polyfill.min.js:1
t.<computed> @ wp-polyfill.min.js:1
r @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
Promise.then (async)
r @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
tryCatch @ wp-polyfill.min.js:1
invoke @ wp-polyfill.min.js:1
t.<computed> @ wp-polyfill.min.js:1
r @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
Promise.then (async)
r @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
(anonymous) @ indexation-1511.js:1
yg @ react-dom.min.js:62
xg @ react-dom.min.js:61
Ti @ react-dom.min.js:148
unstable_runWithPriority @ react.min.js:26
Ma @ react-dom.min.js:52
Ia @ react-dom.min.js:140
ze @ react-dom.min.js:118
(anonymous) @ react-dom.min.js:53
unstable_runWithPriority @ react.min.js:26
Ma @ react-dom.min.js:52
mg @ react-dom.min.js:52
V @ react-dom.min.js:52
Be @ react-dom.min.js:119
xi @ react-dom.min.js:39
```
Possible solutions that I’ve found that I also tried:
- Replaced my theme to Twenty Twenty;
- Switch OFF all other plugins.
…and the following:
- Install & activate the Yoast Test Helper plugin
- Go to Tools -> Yoast Test
- Hit the “Reset indexables & migrations” button
- Click the “Click here to speed up your site now” button.
All this didn’t resolve the issue.

Please solve this asap!

Viewing 4 replies - 16 through 19 (of 19 total)

← 1 2

Thread Starter gotman
(@gotman)

4 years, 4 months ago
Why are you closing this? This is not fixed and…

I don’t have a Github account and I don’t plan to open one.

That way, this is the only channel that I have to provide you precious information.

ps- this is NOT resolved! Please un-mark this as a resolved thread.
- This reply was modified 4 years, 4 months ago by gotman.
Kalacta
(@rocafresh)

4 years ago

4 months later appears this problem still persists and is clearly widespread. Any solution for this EXACT problem please?

adskiller
(@adskiller)

3 years, 12 months ago

Seems I have the same issue! Been having the same error for months now! Spent more than 100 hours and paid dev to try to fix it.

My hosting just sent me the following which is exactly the same error the guy who opened this ticket has:

| 99 | denu4945_230321 | localhost | denu4945_230321 | Query | 58 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id
FR | 0.000 |
| 106 | denu4945_230321 | localhost | denu4945_230321 | Query | 57 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id
FR | 0.000 |
| 212 | denu4945_230321 | localhost | denu4945_230321 | Query | 50 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id
FR | 0.000 |
| 313 | denu4945_230321 | localhost | denu4945_230321 | Query | 40 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id
FR | 0.000 |
| 389 | denu4945_230321 | localhost | denu4945_230321 | Query | 32 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id
FR | 0.000 |
| 405 | denu4945_230321 | localhost | denu4945_230321 | Query | 30 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id
FR | 0.000 |
| 451 | denu4945_230321 | localhost | denu4945_230321 | Query | 20 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id
FR | 0.000 |
| 505 | denu4945_230321 | localhost | denu4945_230321 | Query | 19 | Sending data | SELECT COUNT(term_id)
FROM wp_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id
FR | 0.000 |

Al I

Thread Starter gotman
(@gotman)

3 years, 12 months ago

Hi @adskiller

I think it must be better for you to open a new topic because I suspect that when they as “resolved” this one, they stop to see it (statistics … go imagine).

I also still have this problem on my site. In fact, I’m still stuck to Vers?o 13.5…

Regards

Viewing 4 replies - 16 through 19 (of 19 total)

← 1 2

The topic ‘Site constantly Offline & SEO Optimization error message’ is closed to new replies.

Tags