Got an error reading communication packets

MySQL & MariaDB MariaDB Server & Utilities
1

Hi folks,

I installed a Galera Cluster with five nodes some months ago. Everything worked fine but since last nigth I have this warning in all my cluster nodes:

[Warning] Aborted connection 11745 to db: 'XXX' user: 'YYY' host: 'ZZZ' (Got an error reading communication packets)

I tried to increase some variables values like “wait_timeout”, “max_allowed_packet” and “table_definition_cache” but that not solved the problem

It’s is my.cnf

===================================
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user                       = mysql
socket                     = /var/run/mysqld/mysqld.sock
bind-address               = ::
port                       = 3306
basedir                    = /usr
datadir                    = /var/lib/mysql
tmpdir                     = /var/lib/mysql/tmp
skip-external-locking
max_heap_table_size        = 64M
tmp_table_size             = 64M
key_buffer                 = 1024M
aria-pagecache-buffer-size = 1024M
table_definition_cache     = 1024
thread_cache_size          = 8
query_cache_size           = 256M
open_files_limit           = 8192
thread_handling            = pool-of-threads
max_allowed_packet         = 512M

slow_query_log             = 1
slow_query_log_file        = /var/log/mysql/slow.log
max_connections            = 8192
max_user_connections       = 0
log_error                  = /var/log/mysql/error.log
max_connect_errors         = 999999999
wait_timeout               = 300

thread_concurrency         = 16

query_cache_limit          = 4M
general_log_file           = /var/log/mysql/mysql.log

server-id                  = 1

init-file                  = /etc/mysql/init.sql

[mysqldump]
quick
max_allowed_packet = 256M

[mysql]
no-auto-rehash

[isamchk]
key_buffer        = 256M
sort_buffer_size  = 256M
read_buffer       = 2M
write_buffer      = 2M

[myisamchk]
key_buffer        = 256M
sort_buffer_size  = 256M
read_buffer       = 2M
write_buffer      = 2M

[mysqlhotcopy]
interactive-timeout

!includedir /etc/mysql/conf.d/

And my /etc/mysql/conf.d/galera.cnf

========================================
[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address= ::

# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so

# Galera Cluster Configuration
wsrep_cluster_name="auth_replication"
wsrep_cluster_address="gcomm://x.x.x.x,y.y.y.y,z.z.z.z,w.w.w.w,f.f.f.f"

# Galera Synchronization Configuration
wsrep_sst_method=rsync

# Galera Node Configuration
wsrep_node_address="x.x.x.x"
wsrep_node_name="NAME"

Could someone help me ?

Thanks

1 Like
2

Hello @Alexander_Varejao ,
“Aborted connection” is just a warning that a connection to MySQL has expired due to lack of activity. Your application might be holding connections open, or you have a load-balancer or connection pooler keeping long connections open. After several hours, MySQL force closes these to save memory and resources.

1 Like