Informix

 View Only
Expand all | Collapse all

DR: Cannot connect to secondary server - After secondary server restart

  • 1.  DR: Cannot connect to secondary server - After secondary server restart

    Posted Mon November 09, 2020 07:32 AM
    Hello,

    Everything was working well, but after restart my secundary Informix 14 Server, the replication stopped working. I don't know why, because i don't have network problems.

    I'm getting the following log on the secondary server:

    11:23:25 Started 1 B-tree scanners.
    11:23:25 B-tree scanner threshold set at 5000.
    11:23:25 B-tree scanner range scan size set to -1.
    11:23:25 B-tree scanner ALICE mode set to 6.
    11:23:25 B-tree scanner index compression level set to med.
    11:23:25 Physical Recovery Started at Page (2:136869).
    11:23:25 Physical Recovery Complete: 7 Pages Examined, 2 Pages Restored.
    11:23:25 DR: Trying to connect to primary server = ol_unifato
    11:23:27 DR: Cannot connect to primary server
    11:23:27 DR: Turned off on secondary server
    11:23:27 Dataskip is now OFF for all dbspaces
    11:23:27 Restartable Restore has been ENABLED
    11:23:27 Recovery Mode
    11:24:25 Booting Language <spl> from module <>
    11:24:25 Loading Module <SPLNULL>

    On primary:
    10:48:38 System Error: Wait on network event fai led
    10:48:38 Socket: 2756, Mask: 16, Error: 10060
    10:49:50 System Error: Wait on network event fai led
    10:49:50 Socket: 2660, Mask: 16, Error: 10060
    10:51:49 DR: Cannot connect to secondary server
    10:53:09 Checkpoint Completed: duration was 0 seconds.
    10:53:09 Mon Nov 9 - loguniq 129, logpos 0x671018, timestamp: 0x3185c343 Interval: 5469
    10:53:09 Maximum server connections 65
    10:53:09 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 648, Llog used 56
    10:57:42 DR: Cannot connect to secondary server
    10:58:13 Checkpoint Completed: duration was 0 seconds.

    I already restart the secondary server again, but the replication din't start.
    What i can do to solve de problem,  preferably without start the primary. 

    Thank you all,

    Tiago Santos

    ------------------------------
    Tiago Santos
    ------------------------------

    #Informix


  • 2.  RE: DR: Cannot connect to secondary server - After secondary server restart

    Posted Mon November 09, 2020 08:17 AM

    Tiago

     

     

    It seems that you connection between secondary and primary has problems, and this is a major reason for the secondary not be working fine

     

    Did you test accessing the primary from the secondary using dbaccess (on the same port as the HDR connection) ?

     




    Original Message


  • 3.  RE: DR: Cannot connect to secondary server - After secondary server restart

    Posted Mon November 09, 2020 11:04 AM

    Hi Eric,

    Effectively, I am also not getting access using dbaccess either. Your right.
    I'm getting 908: Attempt to connect to database server failed.
    Firewall is off on both server. I can correctly ping both machines.
    sqlhosts file is ok...

    I don't know what is happening.

    Thanks,



    ------------------------------
    Tiago Santos
    ------------------------------

    Original Message


  • 4.  RE: DR: Cannot connect to secondary server - After secondary server restart

    IBM Champion
    Posted Mon November 09, 2020 11:11 AM
    Tiago:

    It looks like the two systems are not trusting each other. Check your /etc/hosts.equiv or the $INFORMIXDIR/hosts.equiv or whatever file you have listed in the REMOTE_SERVER_CFG parameter if anything. The servers must be trusted to each other.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.






    Original Message


  • 5.  RE: DR: Cannot connect to secondary server - After secondary server restart

    IBM Champion
    Posted Mon November 09, 2020 11:20 AM

    If it is a trust thing you should see an error in the target onstat –m  

     

    Cheers

    Paul

     




    Original Message


  • 6.  RE: DR: Cannot connect to secondary server - After secondary server restart

    Posted Mon November 09, 2020 11:19 AM

    Tiago :

     

    Second step : check if you can reach the port number (if it is open) with telnet or any other tools

    Third step: if yes, try connection to this alias and check the primary's Informix log file: check that the server/user are authenticated. If not, you would see errors -951 or -952

     

     




    Original Message


  • 7.  RE: DR: Cannot connect to secondary server - After secondary server restart

    Posted Mon November 09, 2020 08:20 AM
    Hello, Tiago.
    Make sure you are starting your secondary server using TCP alias, not SHM.
    It should work.

    HTH
    Alexandre Marini




    Original Message


  • 8.  RE: DR: Cannot connect to secondary server - After secondary server restart

    Posted Mon November 09, 2020 11:06 AM
    Hello Alexandre,

    Sorry about this, but what do you mean with SHM?

    Thanks,

    ------------------------------
    Tiago Santos
    ------------------------------

    Original Message


  • 9.  RE: DR: Cannot connect to secondary server - After secondary server restart

    IBM Champion
    Posted Mon November 09, 2020 08:54 AM
    From error number I guessed this must be Windows.

    Errno 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

    So something IS going wrong apparently on network level. Firewall maybe?

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

    Original Message


  • 10.  RE: DR: Cannot connect to secondary server - After secondary server restart

    Posted Mon November 09, 2020 04:52 PM

    Thank you all,

    With your help i think i've discovered de problem
    After change de protocol from onsoctcp to olsoctcp on sqlhosts file, finally i could establish a connection with dbaccess from the secondary do the primary. 
    After i change the protocol on the other lines (ol, dr, and lo services on sqlhosts), about secondary service and restart de secundary server, the replication began to work again.

    I take a lock on onconfig files, and i saw that the company that configured my server, set the NETTYPE parameter whith olsoctcp,1,150,NET (on a Windows OS), and they configured sqlhosts file with onsoctcp.

    But now that every thing seems to be working again (with olsoctcp), on a Windows OS, would be better olsoctcp or onsoctcp.

    Note: my Windows ODBC clients are configured with: onsoctcp.

    Thanks again for you comments,



    ------------------------------
    Tiago Santos
    ------------------------------

    Original Message