Database error

Lê Tân

• November 12, 2024 08:34

When site error not connect to my database.

This is log

WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name = '_site_transient_wp_theme_files_patterns-d88f9e325cd27e42d1b106316a1cb1e1' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, _register_theme_block_patterns, WP_Theme->get_block_patterns, WP_Theme->get_pattern_cache, get_site_transient, delete_site_option, delete_network_option

 

Help me check it

• 

  Can Yayo

  • November 12, 2024 19:17

  Clear Transients -->  Use a plugin like WP-Optimize to delete expired transients.
  Optimize Database --> In phpMyAdmin, optimize the wp_options table.
  Check Database Locks --> Run SHOW ENGINE INNODB STATUS; in phpMyAdmin to check for any locking issues.
  Update Themes/Plugins make sure all are updated.
  Increase Connections: Contact your host to increase max_connections if needed.

  0
• 

  cPRex Jurassic Moderator

  • November 12, 2024 22:25

  Can Yayo - it's unlikely any of those steps will help if there is an actual database error happening.

  The most likely issue in this instance is that a plugin or theme may not be properly designed and is locking the database, leading to this error.  If you have root access to the server I would try checking the MySQL error log at /var/log/mysqld.log.  If you only have cPanel access you could try deactivating any plugins you have to see if that keeps the error from happening.

  0

Please sign in to leave a comment.