Tagged: , ,

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Customer Inquiry
    Participant
    Post count: 201

    My cluster is running fine, but once a day I get an error in the event log, category DATABASE, saying that the MySQL server has gone away.

    Why does this happen, and what does it mean? The databases seem to be updating properly

    Telium Support Group
    Moderator
    Post count: 263

    This error means that the connection to the database server has closed unexpectedly. HAast will immediately try to reopen the connection to recover, which is why you see data still being written to the database. However, the database operation that triggered the error has failed and it’s data will not be recorded (if it operation was trying to add data).

    The root cause is that your MySQL/MariaDB server is configured to automatically close the connection after a period of inactivity, and that period is too short. To solve the problem, edit the MySQL configuration file (usually /etc/mysql/my.conf and add the following:

    [mysqld]
    wait_timeout = 31536000
    interactive_timeout = 31536000

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.