Question

gorgoned: ERROR - MySQL server has gone away

  • 23 February 2024
  • 1 reply
  • 56 views

Badge +2

Hi community !

 

We hit the following error message in the gorgoned log, looking forward to investigate and fix this issue … any hints out there ?

 

==> /var/log/centreon-gorgone/gorgoned.log <==
2024-02-23 14:44:44 - ERROR - [nodes] -class- cannot find debug configuration
2024-02-23 14:45:00 - ERROR - MySQL server has gone away
2024-02-23 14:45:06 - ERROR - MySQL server has gone away


1 reply

Badge +2

This error message seems related,

 

févr. 23 10:02:45 xxxx mariadbd[xxx]: 2024-02-23 10:02:45 0 [Warning] Could not increase number of max_open_files to more than 32000 (request: 64000)

 

Here is an extract of our configuration:

 

SHOW VARIABLES LIKE '%files_limit%';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| open_files_limit | 64000 |
+------------------+-------+
1 row in set (0,001 sec)

 

systemctl show mariadb | grep LimitNOFILE
LimitNOFILE=65536
LimitNOFILESoft=65536

 

centreon@xxxx~$cat /proc/sys/fs/file-max
65000

 

centreon@xxxx~$ echo "show variables"| mysql -p | grep table_open_cache
table_open_cache    2000


centreon@xxxx~$echo "show variables"| mysql -p | grep max_conne
max_connections    151

Reply