[Assigned] 503 error (ATE)

Hm, it is having the same issue as before, so there is something happening, there's something modifying the database entries.

If you delete that page and re-translate it, it will work again.

The problem you have is in the database. there must be an index or something missing and I haven't been able to figure out where it is.

I have a question for you. before moving to this hosting, did you have the site somewhere else? many of the things i've seen seem to date to 2023, but they all seem to be modified recently, and I'm talking about information that WPML doesn't touch.

--------------

Also, would you give me permission to try to get a backup of your site that I can send to our devs? I suspect there are many things that need to be fixed here.

Ok, I still don't know what's the trigger of the problem here, it's something in the database that corrupts the entries that have a lot of special characters. that's why you se something like a shortcode from elementor, because the database entry transformed a special character into an encoded version of it, breaking everything.

The encoding is not done by WPML, it's usually done by WordPress but something seems to be wrong there which is what we're trying to determine.

However it seems the problems started in 2023 because all the pages with issues, even when they seem to be created recently have a date of I think it was may or april 2023, was that site live back then?

Ok, so then delete the arabic page that is getting errors and translate it again selecting "translate automatically" from WPML > Translation Management. you will not get charged for it because it was previously translated.

That should fix the problem, hopefully for good this time :).

Regards,

You need to:

- Delete them, first: go to "pages" > All Pages and switch to the Arabic language.
- Delete all the pages in Arabic.
-Delete them from the trash bin as well (delete permanently option).
- Lastly go to WPML > Translation Management and select all the pages
- Translate them automatically into Arabic.

You'll see them translated right away, no charge added to them.

Regards.

The issue connecting is because your site is experiencing deadlocks in the database:

[06-Aug-2025 02:43:39 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE wp_actionscheduler_actions SET attempts = attempts+1, status='in-progress', last_attempt_gmt = '2025-08-06 02:43:39', last_attempt_local = '2025-08-06 04:43:39' WHERE action_id = 8500147 made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_DBStore->log_execution

[06-Aug-2025 02:43:39 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE wp_actionscheduler_actions SET attempts = attempts+1, status='in-progress', last_attempt_gmt = '2025-08-06 02:43:39', last_attempt_local = '2025-08-06 04:43:39' WHERE action_id = 8500423 made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_DBStore->log_execution

[06-Aug-2025 02:43:39 UTC] PHP Fatal error:  Uncaught InvalidArgumentException: Unidentified action 8500423: we were unable to mark this action as having failed. It may may have been deleted by another process. in /home/1308505.cloudwaysapps.com/dwdfyhvxnv/public_html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:1232

However, It seems these things are happening because there are a LOT of cronjobs that suddenly stopped working. they all seem related to rankmath but I'm not sure if rankmath is the one that originated the problem or it's just the one that was running then when it happens so it's just a "victim" of the process failing.

I'm Investigating this with our devs.

Hey there,

I wonder if you made any sort of change to the site? because I'm starting to see a lot of improvements since I left yesterday:

- The translation jobs page is now loading correctly
- Thanks to the above, I could cancel the jobs normally
- I can see 0 database errors now which means that we're good with the database (and in fact with that all the problems we had with WPML went away!)

Right now the only thing I'm seeing are cronjobs not running which tells me you have a setup where you're disabling the cronjobs maybe with a plugin. It has nothing to do with WPML either but cronjobs are important so it's better if they are not disabled.

Can you give it a try, translate a few pages and let me know how it goes? I translated a few things (no cost on you whatsoever) and it worked without issues.

Awesome,

Let's monitor then to see if things go ok. Please know though that when there are too many things sent to translate at once (in your case it's more about the amount of languages than just the content), jobs could get stuck.

We are working to improve that on big sites and WPML 4.8 already ships some of those improvements. however if you see jobs that are stuck, you will be able to unstuck them from WPML > Support > Troubleshooting.

Let me know how it goes and keep an eye on the debug.log because if there are errors then that will get the jobs stuck.

Regards,