Database disconnect with TranslatePress

  • Resolved denking

    (@denking)


    3 years, 7 months ago

    When the load increases, up to 10-15 people who simultaneously start using the site, translatepress blocks the connection with the database, after which the entire site stops working and shows a 404 error.

    With 2-5 users, everything works stably.

    Here are the logs:

    [04-May-2021 10:01:28 UTC] PHP Fatal error:  Maximum execution time of 120 seconds exceeded in /home/u687817667/domains/gella.co.il/public_html/wp-content/plugins/translatepress-multilingual/assets/lib/simplehtmldom/simple_html_dom.php on line 2230
[04-May-2021 10:01:28 UTC] PHP Fatal error:  Unknown: Cannot use output buffering in output buffering display handlers in Unknown on line 0
[04-May-2021 10:04:49 UTC] PHP Fatal error:  Maximum execution time of 120 seconds exceeded in /home/u687817667/domains/gella.co.il/public_html/wp-content/plugins/translatepress-multilingual/assets/lib/simplehtmldom/simple_html_dom.php on line 2230
[04-May-2021 10:04:49 UTC] PHP Fatal error:  Unknown: Cannot use output buffering in output buffering display handlers in Unknown on line 0
    [10-Jun-2021 11:11:26 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name = '_site_transient_available_translations' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, TRP_Translate_Press->init_machine_translation, TRP_Machine_Translation_Tab->get_active_engine, TRP_Machine_Translator->__construct, TRP_Languages->get_iso_codes, TRP_Languages->get_wp_languages, wp_get_available_translations, get_site_transient, delete_site_option, delete_network_option, delete_option
[10-Jun-2021 11:11:26 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name = '_site_transient_available_translations' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, TRP_Translate_Press->init_machine_translation, TRP_Machine_Translation_Tab->get_active_engine, TRP_Machine_Translator->__construct, TRP_Languages->get_iso_codes, TRP_Languages->get_wp_languages, wp_get_available_translations, get_site_transient, delete_site_option, delete_network_option, delete_option

    How to solve this problem? A very urgent question.

    • This topic was modified 3 years, 7 months ago by denking. Reason: misspelling word

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hello,

    The issue seems to be the fact that you have a low time limit and your database get called more often when you have more users to your website.
    Try increase your time limit:
    php_value max_execution_time 300

    You can read more about how you can do this here:
    https://docs.presscustomizr.com/article/171-fixing-maximum-upload-and-php-memory-limit-issues

    As for the database deadlock:

    It means there’s an application that has locked the table because it didn’t finish updating a record in the DB. Because of the lock, TranslatePress cannot access that table.
    If that happens very often, you would need to try to debug this and to find out which plugin or theme is locking the table.

    Please let us know what you find so that we can continue the debugging process.

    Cheers,

    Dragos

    (@dragosvrejiu)

    Hello,

    As more than a week has passed since the last response, we will close this ticket. If the issue in cause still occurs or further help is needed, please open another ticket and we will answer as soon as we can.

    Kind regards,

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database disconnect with TranslatePress’ is closed to new replies.

Tags