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

replication fails with aborted connection to db

sandergrsandergr EntrantCurrent User Role Beginner
Hi everyone, i have a question regarding a 2 nod master slave replication setup. The nodes are on different machines in the network in docker containers. The replication using xtrabackup-v2 keeps failing (immediately) with the error aborted connection to db... got an error reading communications packets (also see attached screenshot). I have scoured the internet for solutions for this problem but to no avail. Does anybody have an idea?

So far already tried:
-https://www.dbavalley.com/mysql-galera-wsrep-sst-error-xtrabackup-checkpoints-missing/
-https://dba.stackexchange.com/questions/19135/mysql-error-reading-communication-packets (set to 1G)
-https://www.percona.com/blog/2016/05/16/mysql-got-an-error-reading-communication-packet-errors/
-disabled selinux
-checked firewalld ports open and used nmap to verify
-The user for sst is present in every database, have all the permissions needed (and i can connect using the mysql command line).

I literally dont know what else to try anymore. The weird thing is that using replication with another server in the network is working..

Comments

  • sandergrsandergr Entrant Current User Role Beginner
    anybody have any idea?
  • krunalbauskarkrunalbauskar Advisor Inactive User Role Novice
    You are getting error with sstuser. Wondering if you can try using different user or may just root user.
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.