Skip to main content
Question

MySQL [Warning] Aborted connection to db: 'centreon' user: 'centreon' host: 'localhost' (Got timeout reading communication packets)

  • November 12, 2025
  • 0 replies
  • 17 views

Forum|alt.badge.img

Hi! The big issue is that at “Reporting->Availability->Hosts” i see al hosts with “ UNDETERMINED” status for any period selected. In mariadb.log i get this error from 10 to 10 min - “[Warning] Aborted connection xxx to db: 'centreon' user: 'centreon' host: 'localhost' (Got timeout reading communication packets)”

I can log in to mysql/mariadb server with my centreon user and password stored in /etc/centreon/centron.conf.php. This is my /etc/my.cnf.d/centreon.cnf

=========================================================

# cat centreon.cnf 
#
# Custom MySQL/MariaDB server configuration for Centreon
#
[server]
innodb_file_per_table=1

open_files_limit = 32000

key_buffer_size = 256M
sort_buffer_size = 32M
join_buffer_size = 4M
thread_cache_size = 64
read_buffer_size = 512K
read_rnd_buffer_size = 256K
#max_allowed_packet = 8M

max_allowed_packet = 64M
wait_timeout = 300
interactive_timeout = 300
net_read_timeout = 60
net_write_timeout = 60

[mysqld]
log_error = /var/log/mariadb/mariadb.log
general_log_file = /var/log/mariadb/general.log
slow_query_log_file = /var/log/mariadb/slow.log
slow_query_log = 1
long_query_time = 2

# For 4 Go Ram
innodb_buffer_pool_size=512M

=========================================================

Please any idea what to test for debug?

 

0 replies

Be the first to reply!