# \[Warning\] Aborted connection

**URL:** <https://forums.percona.com/t/warning-aborted-connection/3268>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 11, 2014, 5:49am UTC](https://forums.percona.com/t/warning-aborted-connection/3268 "2014-02-11T05:49:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![fonsecacassio](https://avatars.discourse-cdn.com/v4/letter/f/7cd45c/32.png) [@fonsecacassio](https://forums.percona.com/u/fonsecacassio)\
**Post date:** [February 11, 2014, 5:49am UTC](https://forums.percona.com/t/warning-aborted-connection/3268/1 "2014-02-11T05:49:05Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [February 14, 2014, 7:00am UTC](https://forums.percona.com/t/warning-aborted-connection/3268/2 "2014-02-14T07:00:11Z")

</div>

Do you maybe have large number of connections per second? Try this article if it helps:  
[url][http://www.mysqlperformanceblog.com/2012/01/06/mysql-high-number-connections-per-secon/[/url]](http://www.mysqlperformanceblog.com/2012/01/06/mysql-high-number-connections-per-secon/%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![madhusudan](https://avatars.discourse-cdn.com/v4/letter/m/76d3ee/32.png) [@madhusudan](https://forums.percona.com/u/madhusudan)\
**Post date:** [February 17, 2014, 1:30am UTC](https://forums.percona.com/t/warning-aborted-connection/3268/3 "2014-02-17T01:30:38Z")

</div>

Or any firewall/selinux issue…? do a telnet that node for 4567 port and see if u r able to connect.?