experiencing intermittent database crashes on our AWS architecture

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.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 12:00	9:00 – 12:00	9:00 – 12:00	9:00 – 12:00	9:00 – 12:00	-
-	13:00 – 18:00	13:00 – 18:00	13:00 – 18:00	13:00 – 18:00	13:00 – 18:00	-

Supporter timezone: Asia/Singapore (GMT+08:00)

Tagged: Performance

This topic contains 0 replies, has 0 voices.

Last updated by Kor 1 month, 1 week ago.

Assisted by: Kor.

Author	Posts
November 15, 2024 at 7:10 pm #16409514
Daniel Dorado	Background of the issue: I am trying to serve my traffic without hassle using WPML on our AWS architecture. We manage several multisite installations with WPML handling 2 to 6 languages per site. Recently, we've been experiencing intermittent database crashes on our AWS architecture, specifically with our t4g.large Aurora database instance. Here's a snippet from the logs illustrating the problem: 2024-11-15T16:13:11.069Z 1731687191069847, rdsgoldengem-instance-1, rdsgoldengem, 172.30.0.45, 2502072, 314963150, WRITE, boxp_ghola, ghml_6_options, 1731687191069847, rdsgoldengem-instance-1, rdsgoldengem, 172.30.0.45, 2502072, 314963150, WRITE, boxp_ghola, ghml_6_options, 2024-11-15T16:13:11.070Z 1731687191070047, rdsgoldengem-instance-1, rdsgoldengem, 172.30.0.45, 2502072, 314963150, QUERY, boxp_ghola, 'DELETE FROM `ghml_6_options` WHERE `option_name` = 'wpml.WPMLTMSettingsProcessNewTranslatableFields.lock'', 0. Link to a page where the issue can be seen: hidden link Symptoms: Experiencing intermittent database crashes due to a very high number of connections. Logs indicate multiple INSERT, UPDATE, and DELETE operations on options like wpml.WPMLTMSettingsProcessNewTranslatableFields.lock, causing contention issues. Received a 504 gateway timeout error. Questions: Is this a known issue with the WPML plugin, particularly concerning the ProcessNewTranslatableFields.lock option? Are there any configurations, updates, or patches that can mitigate this issue? What are the best practices for handling database contention caused by these operations within WPML? I Can provide a high level of audit logs with hundreds and thousands of queries performed in a row by wpml many of them are looking very similar...
November 15, 2024 at 7:22 pm #16409574
Kor Supporter Languages: English (English ) Timezone: Asia/Singapore (GMT+08:00)	Thanks for your patience. here is the ticket and please share as much information you can so that I could escalate this to our 2nd Tier Support.
November 15, 2024 at 7:28 pm #16409575
Daniel Dorado	2024-11-15T16:53:10.291Z 1731689590291743,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270413,QUERY,box_ibzs,'SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type FROM sibz_6_icl_translations wpml_translations JOIN sibz_6_term_taxonomy tax ON wpml_translations.element_id = tax.term_taxonomy_id AND wpml_translations.element_type = CONCAT(\'tax_\', tax.taxonomy) JOIN sibz_6_icl_translations tridt ON tridt.element_type = wpml_translations.element_type AND tridt.trid = wpml_translations.trid WHERE tridt.element_id IN(737)',0 1731689590291743,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270413,QUERY,box_ibzs,'SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type FROM sibz_6_icl_translations wpml_translations JOIN sibz_6_term_taxonomy tax ON wpml_translations.element_id = tax.term_taxonomy_id AND wpml_translations.element_type = CONCAT(\'tax_\', tax.taxonomy) JOIN sibz_6_icl_translations tridt ON tridt.element_type = wpml_translations.element_type AND tridt.trid = wpml_translations.trid WHERE tridt.element_id IN(737)',0 2024-11-15T16:53:10.292Z 1731689590292209,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270414,READ,box_ibzs,sibz_6_icl_translations, 1731689590292209,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270414,READ,box_ibzs,sibz_6_icl_translations, 2024-11-15T16:53:10.292Z 1731689590292212,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270414,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590292212,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270414,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.292Z 1731689590292213,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270414,READ,box_ibzs,sibz_6_icl_translations, 1731689590292213,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270414,READ,box_ibzs,sibz_6_icl_translations, 2024-11-15T16:53:10.292Z 1731689590292405,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270414,QUERY,box_ibzs,'SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type FROM sibz_6_icl_translations wpml_translations JOIN sibz_6_term_taxonomy tax ON wpml_translations.element_id = tax.term_taxonomy_id AND wpml_translations.element_type = CONCAT(\'tax_\', tax.taxonomy) JOIN sibz_6_icl_translations tridt ON tridt.element_type = wpml_translations.element_type AND tridt.trid = wpml_translations.trid WHERE tridt.element_id IN(2004)',0 1731689590292405,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270414,QUERY,box_ibzs,'SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type FROM sibz_6_icl_translations wpml_translations JOIN sibz_6_term_taxonomy tax ON wpml_translations.element_id = tax.term_taxonomy_id AND wpml_translations.element_type = CONCAT(\'tax_\', tax.taxonomy) JOIN sibz_6_icl_translations tridt ON tridt.element_type = wpml_translations.element_type AND tridt.trid = wpml_translations.trid WHERE tridt.element_id IN(2004)',0 2024-11-15T16:53:10.292Z 1731689590292828,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270415,READ,box_ibzs,sibz_6_icl_translations, 1731689590292828,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270415,READ,box_ibzs,sibz_6_icl_translations, 2024-11-15T16:53:10.292Z 1731689590292831,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270415,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590292831,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270415,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.292Z 1731689590292832,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270415,READ,box_ibzs,sibz_6_icl_translations, 1731689590292832,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270415,READ,box_ibzs,sibz_6_icl_translations, 2024-11-15T16:53:10.339Z 1731689590339140,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270465,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590339140,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270465,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.339Z 1731689590339234,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270465,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (1657)',0 1731689590339234,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270465,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (1657)',0 2024-11-15T16:53:10.339Z 1731689590339736,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270466,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590339736,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270466,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.339Z 1731689590339842,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270466,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (749)',0 1731689590339842,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270466,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (749)',0 2024-11-15T16:53:10.340Z 1731689590340307,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270467,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590340307,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270467,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.340Z 1731689590340405,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270467,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (2004)',0 1731689590340405,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270467,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (2004)',0 2024-11-15T16:53:10.340Z 1731689590340891,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270468,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590340891,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270468,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.340Z 1731689590340993,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270468,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (1998)',0 1731689590340993,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270468,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (1998)',0 2024-11-15T16:53:10.341Z 1731689590341503,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270469,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590341503,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270469,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.341Z 1731689590341595,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270469,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (863)',0 1731689590341595,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270469,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (863)',0 2024-11-15T16:53:10.342Z 1731689590342977,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_terms, 1731689590342977,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_terms, 2024-11-15T16:53:10.342Z 1731689590342982,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590342982,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.342Z 1731689590342984,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_icl_translations, 1731689590342984,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_icl_translations, 2024-11-15T16:53:10.342Z 1731689590342986,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590342986,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.342Z 1731689590342987,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_icl_translations, 1731689590342987,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_icl_translations, 2024-11-15T16:53:10.342Z 1731689590342989,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_icl_translations, 1731689590342989,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270470,READ,box_ibzs,sibz_6_icl_translations, 2024-11-15T16:53:10.389Z 1731689590389335,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270516,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590389335,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270516,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.389Z 1731689590389436,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270516,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (941)',0 1731689590389436,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270516,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (941)',0 2024-11-15T16:53:10.389Z 1731689590389890,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270517,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590389890,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270517,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.389Z 1731689590389991,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270517,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (1674)',0 1731689590389991,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270517,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (1674)',0 2024-11-15T16:53:10.390Z 1731689590390472,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270518,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590390472,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270518,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.390Z 1731689590390590,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270518,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (845)',0 1731689590390590,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270518,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (845)',0 2024-11-15T16:53:10.391Z 1731689590391141,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270519,READ,box_ibzs,sibz_6_term_taxonomy, 1731689590391141,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270519,READ,box_ibzs,sibz_6_term_taxonomy, 2024-11-15T16:53:10.391Z 1731689590391264,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270519,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (1013)',0 1731689590391264,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270519,QUERY,box_ibzs,'SELECT taxonomy, term_id FROM sibz_6_term_taxonomy WHERE term_id IN (1013)',0 2024-11-15T16:53:10.391Z 1731689590391962,rdsgoldengem-instance-1,rdsgoldengem,172.30.0.45,2503888,315270520,READ,box_ibzs,sibz_6_term_taxonomy,
November 18, 2024 at 1:51 am #16412398
Kor Supporter Languages: English (English ) Timezone: Asia/Singapore (GMT+08:00)	Thanks for your reply. I will need to closely examine your website. Therefore, I will require temporary access (WP-Admin and FTP) to a test site where the problem has been replicated, if possible. This will enable me to provide better assistance and determine if any configurations need to be modified. Please note that it is important to have a backup for security purposes and to prevent any potential data loss. You can use the UpdraftPlus plugin (https://wordpress.org/plugins/updraftplus/) to fulfill your backup requirements. Your upcoming reply will be treated with confidentiality and will only be visible to you and me. ✙ To resolve the issue, I may need your consent to deactivate and reactivate plugins and the theme, as well as make configuration changes on the site if necessary. This emphasizes the significance of having a backup.

The topic ‘[Closed] experiencing intermittent database crashes on our AWS architecture’ is closed to new replies.