Site having connection issues almost once a week

  • acox0809

    (@acox0809)


    2 years ago

    This issue is a little difficult for me to reproduce, because I’ve personally never seen it.

    The scenario – We host our clients website. This client experiences connection issues almost every Friday for about 5 minutes. This last Friday, they got the screen saying “Error Establishing a Database Connection”. It was back up and running before I could get in and see what was going on. This is an issue though even if for just a few minutes. The Friday before, the same thing happened. Then the Friday before that they got a different error message saying “Sight is down for scheduled maintenance” (although I think this one might be okay). We are just at a loss of where to start trying to figure out the problem. Our server stays up and running while this happens.

    A few months ago we did a migration to a new domain and we switched them over from BlueHost to us hosting them. This is when the problems really started.
    We’ve tripled checked database variables and everything is connected correctly.

    I tried turning on error reporting, but even with these two lines added after

    define( ‘WP_DEBUG_DISPLAY’, false );
    @ini_set( ‘display_errors’, 0 );

    The errors were displaying all over the UI so I had to turn it off.
    I did notice quite a few deprecated variable errors for two plugins we have installed. But It seems like the developers of the plugin are fixing the errors before they become a problem, so I didn’t that had anything to do with it.

    Any ideas are much appreciated.

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    If the database is coming and going, the first thing to check are the mysql server logs. Is the server locking up or crashing and restarting?

    Thread Starter acox0809

    (@acox0809)

    No it isn’t that I can see.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Anything in those logs? Or the system log (/var/log/messages)? If the DB is unavailable for a while then it is available again, it speaks to a system problem rather than a WP one?

    Thread Starter acox0809

    (@acox0809)

    Sorry I wasnt looking at the correct thing the first time, this is actually what im seeing now.

    2022-10-24T02:17:57.995476Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 4826
    2022-10-24T02:17:58.483575Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
    2022-10-24T02:17:59.388413Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
    2022-10-24T02:18:14.329512Z 0 [System] [MY-010229] [Server] Starting XA crash recovery…
    2022-10-24T02:18:14.398808Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
    2022-10-24T02:18:15.572120Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
    2022-10-24T02:18:15.572213Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
    2022-10-24T02:18:15.629904Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: ‘::’ port: 33060, socket: /var/run/mysqld/mysqlx.sock
    2022-10-24T02:18:15.629970Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: ‘8.0.31’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Server – GPL.

    This chunk is repeated over and over, I was looking into how others have solved the issue but I would love your expertise on the situation.

    • This reply was modified 2 years ago by acox0809.
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    This is not a WordPress problem; it’s a system problem best addressed via support for your OS or MySQL

    Thread Starter acox0809

    (@acox0809)

    Okay, thanks for the direction! Appreciate your time.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Site having connection issues almost once a week’ is closed to new replies.