English media library is crashing my whole server (MySQL)

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client's English media library was causing the MySQL server to crash.

Solution:
We recommend disabling Redis or clearing its cache, as it appears to be the source of the issue. This was confirmed when the client reported that stopping Redis resolved the problem. If Redis is necessary for your site, ensure that the

WP_REDIS_CONFIG

constant is properly defined in your

wp-config.php

file. It may help to move the definition closer to the beginning of the file. For more detailed information on configuring Redis, please refer to the following documentation:

Redis Object Cache Configuration

If this solution does not seem relevant to your situation, please do not hesitate to open a new support ticket with us for further assistance. You can do so by visiting the WPML support forum.

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.

Tagged: Exception

This topic contains 10 replies, has 2 voices.

Last updated by cedricP-6 1 year, 5 months ago.

Assisted by: Bruno Kos.

Author	Posts
January 18, 2024 at 12:10 am #15197427
cedricP-6	Hello, Summary: English media library is crashing my whole server (MySQL) Explanations: hidden link Let me know how to fix that please, thanks.
January 18, 2024 at 10:01 am #15199040
Bruno Kos WPML Supporter since 12/2018 Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+02:00)	Hi, Thank you for contacting WPML support! Before we investigate this issue further, could you make sure your server conforms to our minimum requirements? https://wpml.org/home/minimum-requirements/ Based on provided debug information, I can see the following - WP Memory Limit: 40M. Could you set WP Memory limit to at least 128MB? https://wordpress.org/support/article/editing-wp-config-php/#increasing-memory-allocated-to-php So just add this into wp-config.php file: define('WP_MEMORY_LIMIT', '128M'); before this line: /* That's all, stop editing! Happy publishing. */ After you increase this value, you can confirm it by checking on WPML -> Support by finding the “Memory limit” value. Regards, Bruno Kos
January 18, 2024 at 3:47 pm #15201007
cedricP-6	Hello, I have increased it and I confirm that I see it in my WPML -> Support by finding the “Memory limit” value dashboard but the problem is very much present. Let me know if you need access to it in order to fix the issue please, thanks!
January 19, 2024 at 7:33 am #15203105
Bruno Kos WPML Supporter since 12/2018 Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+02:00)	I see, can you try this then? This may give us some required information: 1. Edit wp-config.php and insert the following lines (just before /* That's all, stop editing! Happy publishing. */ part) define( 'WP_DEBUG', true); define( 'WP_DEBUG_LOG', true); define( 'WP_DEBUG_DISPLAY', false); 2. Reproduce the issue 3. Locate the debug log in: /wp-content/debug.log 4. Paste the latest lines here. No need to paste the entire log file, just 10 lines or so will do. Please censor any sensitive information. https://codex.wordpress.org/Debugging_in_WordPress But more importantly we need this: - do the above reproducing (so from step 2) - get the latest server debug logs (you can ask hosting support if unsure how to locate them)
January 19, 2024 at 9:34 pm #15206400
cedricP-6	Hello Bruno, Is it possible to extract it by yourself if I provide you the SFTP access please? If not, which log file out of the 2 dozens I attach to this message do I need to provide you with?... Let me know, thanks.
January 22, 2024 at 7:16 am #15209549
Bruno Kos WPML Supporter since 12/2018 Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+02:00)	Is there a file called error.log or the one with "error.log" within the name, as that would be typical name for Nginx and Apache error logs?
January 22, 2024 at 6:34 pm #15213165
cedricP-6	It will be 1000x faster if you just do it yourself instead of playing arabic phone here and have to wait 1 day between each reply. Is it possible for you to do so please?! Where do I send you the login info?
January 23, 2024 at 7:48 am #15214367
Bruno Kos WPML Supporter since 12/2018 Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+02:00)	Can I ask you the following? In order to debug this issue, I will install Duplicator plugin, will create packages and will try this on my localhost and escalate further to 2nd tier. https://wpml.org/faq/provide-supporters-copy-site/ Let me know if this is OK with you. Also, can you tell me which time zone are you? Because I can find someone closer to your time zone who could reply more frequently.
January 24, 2024 at 10:01 am #15220780
Bruno Kos WPML Supporter since 12/2018 Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+02:00)	I deployed the website on my localhost but am only getting the following: [24-Jan-2024 09:22:08 UTC] objectcache.critical: Failed to initialize object cache: The `WP_REDIS_CONFIG` constant has not been defined. If it was defined, try moving it closer to the beginning of the `wp-config.php` file. For more information see: <em><u>hidden link</u></em> [24-Jan-2024 09:22:08 UTC] objectcache.warning: Failing over to in-memory object cache [24-Jan-2024 09:22:09 UTC] PHP Deprecated: Creation of dynamic property Whip_RequirementsChecker::$configuration is deprecated in C:\Apache24\htdocs\new1\wp-content\plugins\sitepress-multilingual-cms\vendor\yoast\whip\src\Whip_RequirementsChecker.php on line 37 [24-Jan-2024 09:22:09 UTC] PHP Deprecated: Creation of dynamic property Whip_RequirementsChecker::$messageManager is deprecated in C:\Apache24\htdocs\new1\wp-content\plugins\sitepress-multilingual-cms\vendor\yoast\whip\src\Whip_RequirementsChecker.php on line 38 [24-Jan-2024 09:22:10 UTC] PHP Deprecated: Creation of dynamic property Whip_RequirementsChecker::$configuration is deprecated in C:\Apache24\htdocs\new1\wp-content\plugins\sitepress-multilingual-cms\vendor\yoast\whip\src\Whip_RequirementsChecker.php on line 37 [24-Jan-2024 09:22:10 UTC] PHP Deprecated: Creation of dynamic property Whip_RequirementsChecker::$messageManager is deprecated in C:\Apache24\htdocs\new1\wp-content\plugins\sitepress-multilingual-cms\vendor\yoast\whip\src\Whip_RequirementsChecker.php on line 38 [24-Jan-2024 09:22:10 UTC] PHP Deprecated: Creation of dynamic property Whip_RequirementsChecker::$configuration is deprecated in C:\Apache24\htdocs\new1\wp-content\plugins\sitepress-multilingual-cms\vendor\yoast\whip\src\Whip_RequirementsChecker.php on line 37 [24-Jan-2024 09:22:10 UTC] PHP Deprecated: Creation of dynamic property Whip_RequirementsChecker::$messageManager is deprecated in C:\Apache24\htdocs\new1\wp-content\plugins\sitepress-multilingual-cms\vendor\yoast\whip\src\Whip_RequirementsChecker.php on line 38 [24-Jan-2024 09:22:10 UTC] objectcache.critical: Failed to initialize object cache: The `WP_REDIS_CONFIG` constant has not been defined. If it was defined, try moving it closer to the beginning of the `wp-config.php` file. For more information see: <em><u>hidden link</u></em> [24-Jan-2024 09:22:10 UTC] objectcache.warning: Failing over to in-memory object cache [24-Jan-2024 09:22:11 UTC] .../builder/core.php:5352 et_builder_get_google_fonts(): An unkown error has occured while trying to retrieve the fonts from the Google Fonts API. Please ensure your Google API Key is valid and active. I am currently in contact with our 2nd tier to see what could be behind this, also the server seems to be crashing because this logging never ends.
January 24, 2024 at 2:09 pm #15222244
Bruno Kos WPML Supporter since 12/2018 Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+02:00)	I was able to get his working on my localhost after completely disabling Redis as I got: [24-Jan-2024 09:22:10 UTC] objectcache.critical: Failed to initialize object cache: The `WP_REDIS_CONFIG` constant has not been defined. If it was defined, try moving it closer to the beginning of the `wp-config.php` file. For more information see: <em><u>hidden link</u></em> [24-Jan-2024 09:22:10 UTC] objectcache.warning: Failing over to in-memory object cache Can you disable Redis (or clear it) on your site and try then?
January 25, 2024 at 7:24 pm #15227952
cedricP-6	Hello, I've completely stopped Redis and it's now working (it doesn't work when I relaunch it but I'll keep it off). Thanks for your help, it was much appreciated 🙂
January 25, 2024 at 7:25 pm #15227955
cedricP-6	Hello, I've completely stopped Redis and it's now working (it doesn't work when I relaunch it but I'll keep it off). Thanks for your help, it was much appreciated 🙂