MySQL Forums
Forum List  »  Replication

Aborted connection 19319491 to db: 'unconnected' user: 'repl-db2' host: '192.168.69.3' (Got an error writing communication packets)
Posted by: claudiu vasadi
Date: February 20, 2012 06:30AM

Hi guys,

We have the following setup:

db1 - mysql-5.1.49 running as primary and master (replication) database
db2, db3, testdb running (mariadb-5.2.8) as slaves and replicating from db1.

Each db machine has it's own username for the replication and each username is restricted to the sole IP of the slave machine (ex: 'repl-db2'@'<IP>').

We have InnoDB as default engine everywhere.

Without any known deletes or changes to the system, this morning, db1 started spitting out the below errors:

120220 12:53:41 [Warning] Aborted connection 19319491 to db: 'unconnected' user: 'repl-db2' host: '192.168.69.3' (Got an error writing communication packets)


There is no 'unconnected' database, we have no FEDERATED engine anywhere and there were no deletes to our knowledge. We also tried disabling the cache on the salve servers but to no avail.

Out of ideas. I'm hopping someone more experienced can shed some light.

So far, the replication was working flawlessly. The initial replication setup was created using percona's xtrabackup utility.

Ow, we are running FreeBSD amd64 machine for all db's.

Options: ReplyQuote


Subject
Views
Written By
Posted
Aborted connection 19319491 to db: 'unconnected' user: 'repl-db2' host: '192.168.69.3' (Got an error writing communication packets)
16085
February 20, 2012 06:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.