Informix

 View Only
Expand all | Collapse all

Replication disconnect and reconnect to server

  • 1.  Replication disconnect and reconnect to server

    Posted Tue February 14, 2023 09:44 AM

    Good day

    I'm new to the community. 

    i have this issue on Enterprise Replication between 2 servers.it just started no change to the system. if you do cdr list serv all servers is connected but if you check in the online log it keeps on saying server 1 disconnect and then reconnects again. no replication is happening to the 2 servers. all the other servers is working fine no problem. if you say issue a cdr stop repl *** from server 1 to server 2 it takes about 5 min to stop the repl. from all the other servers its instant stop.

    11:36:45  CDR connection to server lost, id 23, name <grp_23_north>
    Reason: connection lost
    11:37:39  CDR: Re-connected to server, id 23, name <grp_23_north>



    ------------------------------
    Jaco Loots
    ------------------------------


  • 2.  RE: Replication disconnect and reconnect to server

    Posted Tue February 14, 2023 10:01 AM
    As a complete guess has someone put a new machine on the network
    with a duplicate ip of the server that keeps 'disconnecting'?


    Clive Eisen












  • 3.  RE: Replication disconnect and reconnect to server

    Posted Tue February 14, 2023 10:14 AM

    no we have checked for IP conflict nothing. we even reserved and excluded the IP from the scope 



    ------------------------------
    Jaco Loots
    ------------------------------



  • 4.  RE: Replication disconnect and reconnect to server

    Posted Tue February 14, 2023 10:27 AM
    The only way to be 100% sure is to turn off the problem server (or give it a new ip)
    and then wait for the arp table to catch up and try pinging the old ip.

    Other than that I have no idea.



    Clive Eisen
    GPG: 3818B5F1











  • 5.  RE: Replication disconnect and reconnect to server

    Posted Tue February 14, 2023 10:38 AM

    Thanks Clive

    At this stage we will try anything to get to the bottom of this issue. just srtange all the other servers has no issue to the 2 said servers and visa versa only the 2 to each other



    ------------------------------
    Jaco Loots
    ------------------------------



  • 6.  RE: Replication disconnect and reconnect to server

    Posted Tue February 14, 2023 10:44 AM
    One other thought.

    Are these VMs?

    If so it could be duplicate MAC not duplicate ip.

    Good luck,


    Clive Eisen
    GPG: 3818B5F1











  • 7.  RE: Replication disconnect and reconnect to server

    IBM Champion
    Posted Tue February 14, 2023 10:36 AM

    First of all, welcome to the group!


    Immediately next: what version(s) are we talking about?

    Then: any time pattern possibly, with those disconnects and/or reconnects?  Any coincidence possibly with e.g. load on one of the two disconnecting servers?

    Finally: "cdr stop repl" should not depend on servers' connection status (it works locally only and creates request messages for work to be done on other servers, but wouldn't wait on their feedback.)  So something else might be going on ...
    What exactly do you mean by "cdr stop repl *** from server 1 to server 2"  vs. "... from all the other servers"?
    Is it:  you're running the cdr utility on server 1 using "--connect server2"?  With servers 1 + 2 being the ones disconnecting (so server 2 being grp_23_north)?

    BR,
     Andreas



    ------------------------------
    Andreas Legner
    ------------------------------



  • 8.  RE: Replication disconnect and reconnect to server

    Posted Tue February 14, 2023 12:50 PM

    Thank you

    Informix is at version 11.70 FC8.

    it happens every 4 to 5 min it a constant disconnect and reconnect and at any time of the day.

    yes when running the CDR utility on server1 (grp_08_headq) to server 2 (grp_23_north) and visa versa. 

    if you run same utility on server 3 to 1 everything 100% even to server 2. 

    there is a total of 12 server but only those 2 started with this issue



    ------------------------------
    Jaco Loots
    ------------------------------



  • 9.  RE: Replication disconnect and reconnect to server

    IBM Champion
    Posted Wed February 15, 2023 09:45 AM

    So what's the other side saying, in its message log?

    Replication working properly between the two servers and between the disconnects?



    ------------------------------
    Andreas Legner
    ------------------------------



  • 10.  RE: Replication disconnect and reconnect to server

    Posted Wed February 15, 2023 09:53 AM

    on both the impacted servers it says disconnect and reconnect.

    No replication not working on the 2 servers



    ------------------------------
    Jaco Loots
    ------------------------------



  • 11.  RE: Replication disconnect and reconnect to server

    IBM Champion
    Posted Wed February 15, 2023 10:41 AM

    Then I'm afraid it's time for a support case (and for upgrading to a supported version anyway).
    This situation might require closer inspection than what's possible on this forum.



    ------------------------------
    Andreas Legner
    ------------------------------