Errro establishing database connection issues

  • maruthasalam

    (@maruthasalam)


    1 year, 2 months ago

    My wordpress site is down and when i restart it again it’s up and running. Found the server logs following warning shows this
    1.The log warning [MY-012985] [InnoDB] A long semaphore wait suggests a potential database lock or resource contention issue.
    2.validate password plugin is deprecated and will be removed in a future release please use vaildate password component instead in wordpress
    3. Error establishing database connection
    WordPress version – 6.3
    mysqli – Server version8.0.40-0ubuntu0.20.04.1
    Server architecture – Linux 5.15.0-1075-aws x86_64
    Web server – Apache/2.4.57 (Ubuntu)
    PHP version – 7.4.33-SergeyD/6.1 (Supports 64bit values)

    Error message from server logs


    • This topic was modified 1 year, 2 months ago by maruthasalam.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator threadi

    (@threadi)

    1 year, 2 months ago

    If you have tried to post pictures, please follow the procedure described here: https://wordpress.org/support/forum-user-guide/block-editor/#adding-screenshots

    Olvy Cloud

    (@olvycloud)

    1 year, 2 months ago

    Hello,

    Please try to run the following MySQL command to Identify long-running transactions:

    SHOW ENGINE INNODB STATUS;

    Also please check what size is for innodb_log_file_size

    Because if innodb_log_file_size is too small, transactions cannot commit efficiently.

    As an alternative option, you may want to consider moving from MySQL 8.0 to MariaDB 11.4. Because MariaDB offers enhanced query optimization and resource efficiency, making it ideal for high-traffic websites. More details about MySQL vs MariaDB

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

The topic ‘Errro establishing database connection issues’ is closed to new replies.