Last_IO_Errno: 1593

Discussion in 'HOWTO-Related Questions' started by onastvar, Jul 28, 2017.

  1. onastvar

    onastvar Member

    Hello,

    I have existing server1 wanted to add new server2 (used The Perfect Server - Debian 8.4 Jessie (Apache2, BIND, Dovecot, ISPConfig 3.1 guide to setup server1 & server2). So I followed HowTo: "Installing a Web, Email & MySQL Database Cluster on Debian 8.4 Jessie with ISPConfig 3.1" exactly per guide (I tried 2-3 times already), every time on the last step in section

    5.5 MySQL Master-Master-Replication

    and check the slave-status with
    SHOW SLAVE STATUS \G
    Check, that the slave is running:
    Slave_IO_Running: Yes
    Slave_SQL_Running: Yes

    I get error:
    Last_IO_Errno: 1593
    Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).

    Error message is misleading, I double checked, server IDs are 1 and 2.
    I tried to restart mysql master-master replication (per schaal-24.de guide),
    both options skip the error and rebuild still did not work

    I cannot get to the result where original guide shows
    Slave_IO_Running: Yes
    Slave_SQL_Running: Yes

    What am I doing wrong?
    I would appreciate any assistance.

    Thanks!
     
    Azharmrd1 likes this.
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    master and slave have equal MySQL server ids; these ids must be different for replication to work = re-check the mysql-configs on both servers. Or grep for server_id in /etc/mysql
     
    Azharmrd1 likes this.
  3. onastvar

    onastvar Member

    Thanks Florian!

    This is what I'm showing

    server1

    root@sun:/etc/mysql# grep server-id my.cnf
    server-id = 1
    replicate-same-server-id = 0
    #server-id = 1

    server2
    root@aria:/etc/mysql# grep server-id my.cnf
    server-id = 2
    replicate-same-server-id = 0
    #server-id = 1
     
  4. onastvar

    onastvar Member

    I made some progress. I made sure Database client version: libmysql - 5.5.57 is same on server1 & server2. I'm not sure if that got rid of Last_IO_Errno: 1593

    I'm still at the last step in section
    5.5 MySQL Master-Master-Replication

    and check the slave-status with
    SHOW SLAVE STATUS \G

    Check, that the slave is running:
    Slave_IO_Running: Yes
    Slave_SQL_Running: Yes

    I get new error "Last_IO_Errno: 2003"

    Last_IO_Errno: 2003
    Last_IO_Error: error connecting to master 'slaveuser1@11.22.33.44:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '11.22.33.44' (110 "Connection timed out")

    Port 3306 is open on public IP I'm using.

    Any suggestion how to fix error 2003?
     
    Last edited: Jul 30, 2017
  5. onastvar

    onastvar Member

    I can ping the remote host. Port 3306 is open.
    Any ideas how to fix error 2003?
     

Share This Page