This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 3 replies, has 2 voices.

Last updated by Bigul 3 months ago.

Assigned support staff: Bigul.

Author Posts
July 11, 2019 at 11:26 am #4189287

Tom Shaw

Hi,

The client is experiencing two issues that may or may not be related. Firstly, we have delivered the translations and they cleared our API (see screenshot 1). But WPML shows that 561 translation jobs are still left outstanding (screenshot 2). Some of them look like they are in progress, but others look like they are delivered, but need update (screenshot 3).

The projects in question are the Chinese Simplified translations Sent on 04-16 with a deadline of 26-06.

The second issue is that WPML seems to be making calls to the database which resulted in the client's website going down yesterday. This is what they said to us:

Further investigation shows that the issues with the deadlocks for WPML were going on all day yesterday, we think that the overload started about 16:58 and the site would have been forced to the one server at this point and the site would have only intermittently available.

I have included the snippet from the log below

[Tue Jul 09 16:54:10.738970 2019] [php7:notice] [pid 4615] [client 172.31.1.111:53576] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM `wp_options` WHERE `option_name`
= '_transient_wpml_st_upgrade_in_progress' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('/var/www/html/web/wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->d
o_action, WP_Hook->apply_filters, SitePress->init, do_action('wpml_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wpml_tm_load, WPML_Translation_Management->load, do_action('wpml_tm_loaded'), WP_Hook->do_action, WP_Hook->apply
_filters, WPML_String_Translation->load, WPML_ST_Upgrade->run, WPML_ST_Upgrade->set_upgrade_completed, delete_transient, delete_option
[Tue Jul 09 16:58:00.865273 2019] [php7:notice] [pid 4634] [client 172.31.2.21:39054] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM `wp_options` WHERE `option_name`
= '_transient_timeout_wpml_st_upgrade_in_progress' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('/var/www/html/web/wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_
Hook->do_action, WP_Hook->apply_filters, SitePress->init, do_action('wpml_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wpml_tm_load, WPML_Translation_Management->load, do_action('wpml_tm_loaded'), WP_Hook->do_action, WP_Hook
->apply_filters, WPML_String_Translation->load, WPML_ST_Upgrade->run, WPML_ST_Upgrade->set_upgrade_completed, delete_transient, delete_option
[Wed Jul 10 03:07:42.412484 2019] [php7:warn] [pid 4961] [client 172.31.0.180:45222] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924, referer: <em><u>hidden link</u></em>
/
[Wed Jul 10 03:15:54.124917 2019] [php7:warn] [pid 4961] [client 172.31.0.180:45222] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924, referer: <em><u>hidden link</u></em>
gle.com/
[Wed Jul 10 04:22:44.924695 2019] [php7:warn] [pid 4574] [client 172.31.1.111:54490] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:22:44.924667 2019] [php7:warn] [pid 4576] [client 172.31.2.21:39880] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:22:44.924686 2019] [php7:warn] [pid 4555] [client 172.31.2.21:39868] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:22:44.924677 2019] [php7:warn] [pid 4557] [client 172.31.0.180:44484] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:22:45.334366 2019] [php7:warn] [pid 4565] [client 172.31.1.111:54504] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:22:44.924631 2019] [php7:warn] [pid 4560] [client 172.31.2.21:39778] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694044 2019] [php7:warn] [pid 4965] [client 172.31.1.111:54104] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694001 2019] [php7:warn] [pid 4970] [client 172.31.2.21:39426] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694122 2019] [php7:warn] [pid 4565] [client 172.31.1.111:54504] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694023 2019] [php7:warn] [pid 4972] [client 172.31.1.111:54090] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694150 2019] [php7:warn] [pid 4560] [client 172.31.2.21:39778] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694083 2019] [php7:warn] [pid 4973] [client 172.31.0.180:43912] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694188 2019] [php7:warn] [pid 4557] [client 172.31.0.180:44484] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694176 2019] [php7:warn] [pid 4555] [client 172.31.2.21:39868] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694163 2019] [php7:warn] [pid 4574] [client 172.31.1.111:54490] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694063 2019] [php7:warn] [pid 4967] [client 172.31.2.21:39490] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.693927 2019] [php7:warn] [pid 4966] [client 172.31.2.21:39416] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924, referer: <em><u>hidden link</u></em>
s.com/student-accommodation/cardiff/?utm_source=UCAS&utm_medium=email&utm_campaign=CardiffUCASjuly19&utm_content=cta1
[Wed Jul 10 04:23:45.694102 2019] [php7:warn] [pid 4971] [client 172.31.0.180:44052] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:23:45.694136 2019] [php7:warn] [pid 4576] [client 172.31.2.21:39880] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:27:09.041691 2019] [php7:warn] [pid 4971] [client 172.31.0.180:44052] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:27:09.041774 2019] [php7:warn] [pid 4967] [client 172.31.2.21:39490] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:27:09.041760 2019] [php7:warn] [pid 4972] [client 172.31.1.111:54090] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:27:09.041753 2019] [php7:warn] [pid 4970] [client 172.31.2.21:39426] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:27:09.041767 2019] [php7:warn] [pid 4973] [client 172.31.0.180:43912] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:27:09.041746 2019] [php7:warn] [pid 4965] [client 172.31.1.111:54104] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:27:09.041739 2019] [php7:warn] [pid 4966] [client 172.31.2.21:39416] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924, referer: <em><u>hidden link</u></em>
students.com/student-accommodation/cardiff/?utm_source=UCAS&utm_medium=email&utm_campaign=CardiffUCASjuly19&utm_content=cta1
[Wed Jul 10 04:34:20.316761 2019] [php7:warn] [pid 4543] [client 172.31.1.111:54462] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:37:41.964354 2019] [php7:warn] [pid 4543] [client 172.31.1.111:54462] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:38:29.856292 2019] [php7:warn] [pid 4575] [client 172.31.2.21:39784] PHP Warning:  mysqli_query(): MySQL server has gone away in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 04:38:38.289098 2019] [php7:warn] [pid 4575] [client 172.31.2.21:39784] PHP Warning:  mysqli_query(): Error reading result set's header in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924
[Wed Jul 10 06:48:59.044231 2019] [php7:warn] [pid 4682] [client 172.31.1.111:53722] PHP Warning:  Error while sending QUERY packet. PID=4682 in /var/www/html/web/wp/wp-includes/wp-db.php on line 1924, referer: <em><u>hidden link</u></em>
ts.com/wp/wp-admin/admin.php?page=tcas-log
[Wed Jul 10 08:22:47.432137 2019] [mpm_prefork:notice] [pid 1391] AH00163: Apache/2.4.18 (Ubuntu) configured -- resuming normal operations
[Wed Jul 10 08:22:47.457011 2019] [core:notice] [pid 1391] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jul 10 08:22:53.639301 2019] [php7:notice] [pid 1413] [client 172.31.0.180:26568] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM `wp_options` WHERE `option_name`
= '_transient_timeout_wpml_st_upgrade_in_progress' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('/var/www/html/web/wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP
_Hook->do_action, WP_Hook->apply_filters, SitePress->init, do_action('wpml_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wpml_tm_load, WPML_Translation_Management->load, do_action('wpml_tm_loaded'), WP_Hook->do_action, WP_Hoo
k->apply_filters, WPML_String_Translation->load, WPML_ST_Upgrade->run, WPML_ST_Upgrade->set_upgrade_completed, delete_transient, delete_option
July 11, 2019 at 6:36 pm #4192657

Bigul
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello,

Welcome to the WPML support forum. I will do my best to help you to resolve these issues.

This may be happening because of the older version of WPML. Therefore I have a request. Please try the following steps and make sure the issue is existing or not. The last three steps will help you to refresh the translation settings.

1) Backup your site
2) Upgrade to the latest version of WPML(4.2.7.1)
3) Visit WPML>>Settings
4) Visit WPML>>Tranlation Management Dashbord
5) Visit WPML>>Translations

--
Thanks!

Bigul

July 15, 2019 at 1:29 pm #4211467

Tom Shaw

Hi, I'm just waiting for the client to get in touch with me.

Best regards,
Kamil

July 15, 2019 at 6:17 pm #4214097

Bigul
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hi Kamil,

Thank you for the updates. Take your time. We will wait for your feedback.

--
Thanks!

Bigul

The topic ‘[Closed] Problems fetching translations and WPML making repeated calls to the database’ is closed to new replies.