Not the answer you need?
Register and ask your own question!

[Warning] Aborted connection

fonsecacassiofonsecacassio EntrantCurrent User Role Beginner
Hello,

Follow our my.cnf and error that occurs in 3 clusters of replication that have created with Percona.

Is only generated the error, we have no packet losses, because we made a ping and even called me back normally.

Have increased the max_allowed_packet and not resolved.


ERRO:

140211 9:06:24 [Warning] Aborted connection 4229297 to db: 'DB' user: 'USER' host: '10.1.1.1' (Got an error reading communication packets)
140211 9:06:46 [Warning] Aborted connection 4229572 to db: 'DB' user: 'USER' host: '10.1.1.1' (Got an error reading communication packets)
140211 9:07:43 [Warning] Aborted connection 4230285 to db: 'DB' user: 'USER' host: '10.1.1.1' (Got an error reading communication packets)

MY.CNF

[mysqld]

server_id=1

binlog_format=ROW

log_bin=mysql-bin

wsrep_cluster_address=gcomm://NODE1,NODE2,NODE3

wsrep_provider=/usr/lib64/libgalera_smm.so

datadir=/var/lib/mysql

wsrep_cluster_name=NAMECLUSTER

wsrep_sst_method=xtrabackup-v2

wsrep_node_name=NODE1

log_slave_updates

innodb_locks_unsafe_for_binlog=1

innodb_autoinc_lock_mode=2

wsrep_sst_auth="sstuser:sst12345"

#Variaveis

wsrep_provider_options="gcache.size=2G;"
wsrep_slave_threads=16
wsrep_causal_reads=ON
#wsrep_replicate_myisam=1

# The MySQL server
[mysqld]
port = 31890
#socket = /var/lib/mysql/mysql.sock
key_buffer = 5M
max_allowed_packet = 512M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8M
read_buffer_size = 256K
read_rnd_buffer_size = 512K
max_tmp_tables = 100
join_buffer_size = 1M
max_join_size = 1M
max_connections = 500
max_connect_errors = 500
max_join_size = 10M
log_warnings = 2
long_query_time = 20
open_files_limit = 65000
myisam_sort_buffer_size = 3M
wait_timeout = 6000
#read_timeout = 600
connect_timeout = 6000
query_cache_type = 0
query_cache_size = 0

interactive_timeout = 6000

net_read_timeout = 6000
net_write_timeout = 6000

expire_logs_days = 7

# Regras customizadas no my.cnf
#tmp_table_size = 16M
#max_heap_table_size = 16M
#thread_cache_size = 8
#table_cache = 64
#max_connections = 600

join_buffer_size = 1M
tmp_table_size = 16M
max_heap_table_size = 16M
key_buffer_size = 16M
#innodb_force_recovery = 1

#plugin-load=thread_pool.so
thread_pool_size = 24

#skip-networking
bind-address=IP-NODE
skip-name-resolve

[InnoDB]
innodb_flush_method = O_DIRECT
innodb_read_io_threads = 16
innodb_write_io_threads = 16
innodb_additional_mem_pool_size = 64M
innodb_log_buffer_size = 512M
#innodb_data_file_path=ibdata1:1GB:autoextend

[safe_mysqld]
#err-log=/var/lib/mysql/mysqld.log
wsrep_url=gcomm://NODE1,gcmm://NODE2,gcomm://NODE3,gcomm://

[mysqldump]
quick
max_allowed_packet = 64M

[mysql]
no-auto-rehash

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

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

[mysqlhotcopy]
#interactive-timeout

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.