Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Restarting replication

  • 1.  Restarting replication

    Posted Tue August 11, 2020 11:55 AM
    IDS 12.10.FC14
    Solaris 10 1/13

    I guess I took too long between starting the primary, and starting the secondary.  Got this in the log:



    08/11/20 07:43:42 The SMX connection between high availability servers was closed because the
    peer server was unresponsive for the timeout period (60 seconds times the
    number of retries).



    And, this is the output of onstat -g rss on the primary:



    informix@ifmx-prod-anc>onstat -g rss

    IBM Informix Dynamic Server Version 12.10.FC14 -- On-Line -- Up 00:09:41 -- 19726336 Kbytes

    Local server type: Primary
    Index page logging status: Enabled
    Index page logging was enabled at: 2019/02/27 09:22:35
    Number of RSS servers: 1

    RSS Server information:

    RSS Srv RSS Srv Connection Next LPG to send Supports
    name status status (log id,page) Proxy Writes
    prodjnutli Defined Disconnected 0,0 N

    informix@ifmx-prod-anc>



    Is there any way I can get RSS working again, besides re-initializing it from scratch?  (Taking Level 0, and trucking it across the WAN)


    Thank you.

    DG

    ------------------------------
    David Grove
    ------------------------------


  • 2.  RE: Restarting replication

    Posted Tue August 11, 2020 11:59 AM

    restarting Informix on  the RSS secondary should do it providing that the logs on the primary didn't wrap.

     

     

     

     

     






  • 3.  RE: Restarting replication

    Posted Tue August 11, 2020 12:15 PM
    Thank you for your amazingly quick response.

    I have logs sized to last several days before wrapping, so that shouldn't be a problem.

    I should mention that I had both primary and secondary down to upgrade Informix from 12.10.FC12 to 12.10.FC14.

    I restarted the secondary. Still no go.  The primary continues to have the same response from 'onstat -g rss'.

    The secondary shows this in the log:


    IBM Informix Dynamic Server Version 12.10.FC14 -- Read-Only (RSS) -- Up 00:01:51 -- 19726336 Kbytes

    Message Log File: /opt/informix/tmp/online.log
    08/11/20 08:07:12 SQL_DEF_CTRL value set to 44004b0
    08/11/20 08:07:13 IBM Informix Dynamic Server Version 12.10.FC14 Software Serial Number AAA#B000000
    08/11/20 08:07:13 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

    08/11/20 08:07:13 Started 1 B-tree scanners.
    08/11/20 08:07:13 B-tree scanner threshold set at 5000.
    08/11/20 08:07:13 B-tree scanner range scan size set to -1.
    08/11/20 08:07:13 B-tree scanner ALICE mode set to 6.
    08/11/20 08:07:13 B-tree scanner index compression level set to med.
    08/11/20 08:07:13 Physical Recovery Started at Page (1:5591940).
    08/11/20 08:07:13 Physical Recovery Complete: 2 Pages Examined, 2 Pages Restored.
    08/11/20 08:07:14 IBM Global Security Kit (GSKit) version 8.0.55.12 or higher,
    which provides APIs for Secure Sockets Layer (SSL) communication
    and for encryption, is not installed.
    08/11/20 08:07:14 ICC library load failed
    08/11/20 08:07:14 DR: Trying to connect to server, prodanctli. If the specified server
    is not in Online mode, bring it to Online mode.
    08/11/20 08:07:14 Dataskip is now OFF for all dbspaces
    08/11/20 08:07:14 Restartable Restore has been ENABLED
    08/11/20 08:07:14 Recovery Mode


    I guess I'll open a case with tech support.  It would appear something is missing from the install of 12.10.FC14.  Perhaps I can rerun the installer and just install what's missing.

    Thank you again, for your help.

    Regards,

    DG

    ------------------------------
    David Grove
    ------------------------------



  • 4.  RE: Restarting replication

    Posted Tue August 11, 2020 12:19 PM

    Reinstall the gsk to get past this, you will need to be root

     

    08/11/20 08:07:14 IBM Global Security Kit (GSKit) version 8.0.55.12 or higher,
    which provides APIs for Secure Sockets Layer (SSL) communication
    and for encryption, is not installed.
    08/11/20 08:07:14 ICC library load failed






  • 5.  RE: Restarting replication

    Posted Tue August 11, 2020 12:23 PM
    Thank you, Paul.

    After rereading the log message, I had concluded the same thing.  Will try that instead of bothering tech support.

    DG

    ------------------------------
    David Grove
    ------------------------------



  • 6.  RE: Restarting replication

    Posted Tue August 11, 2020 12:56 PM
    I couldn't find the gskit option in the installer.  So, I looked in the gskit directory in the Informix binaries.  Found the README, and learned that I had to manually run a gskit installer.  I did that, and now RSS is working.

    Strange.  Never before have I had to do any extra step after the Informix Installer completed successfully.  I would have been nice if it would have let me know that the job wasn't finished until I manually installed the GSKit.

    Thank you.

    DG

    ------------------------------
    David Grove
    ------------------------------



  • 7.  RE: Restarting replication

    Posted Tue August 11, 2020 01:05 PM

    I don't think the installer will automagically overwrite an old GSK so it is a manual task

     

    Cheers

    Paul

     






  • 8.  RE: Restarting replication

    Posted Tue August 11, 2020 01:15 PM
    Edited by David Grove Tue August 11, 2020 01:16 PM
    That makes sense, but I did the installation to a brand new (empty) directory.

    That is, when I installed 12.10.FC14, I created a new Informix directory and did a brand new installation.  So, the GSKit was never installed during that process.

    DG

    ------------------------------
    David Grove
    ------------------------------



  • 9.  RE: Restarting replication

    Posted Tue August 11, 2020 01:34 PM

    from the gskit README

     

    The standard Dynamic Server installation applications install GSKit automatically. No further installation steps are required for GSKit

    if you use these installation applications.

     

    When you deploy Dynamic Server by other methods (such as tar and untar), you must install GSKit manually if you want to include it on m

    ultiple machines. This directory contains the redistributable version of GSKit for this purpose. If you have obtained the software lice

    nse to install Informix products in multiple host computers, the GSKit installation procedure below must be repeated for each instance.

     

     

    doesn't make sense cause I also had to manually install  the gskit even though I ran the standard ids_install.

     

    unless I am missing something.

     

     

     

     

     






  • 10.  RE: Restarting replication

    Posted Tue August 11, 2020 02:26 PM
    That was exactly my situation.

    I installed to a brand new, empty /opt/informix/ directory.

    GSKit did not install.  I had to do it manually (as described above).

    DG

    ------------------------------
    David Grove
    ------------------------------



  • 11.  RE: Restarting replication

    Posted Tue August 11, 2020 02:28 PM

    And the gsk was not on the system anywhere ?

     






  • 12.  RE: Restarting replication

    Posted Tue August 11, 2020 02:33 PM
    Oh yeah... it was there.  In the /opt/informix/gskit/ directory.  It just wasn't installed.  (The tar files were there-- just not used.)

    DG

    ------------------------------
    David Grove
    ------------------------------



  • 13.  RE: Restarting replication

    Posted Tue August 11, 2020 02:34 PM

    I meant it wasn't already installed in /usr/lib/whatever?

     






  • 14.  RE: Restarting replication

    Posted Tue August 11, 2020 03:17 PM
    Yes, there was a symbolic link, "libgsk8ssl_64.so", present in /usr/lib/sparcv9/.

    This is the first time I encountered the situation in which the installer didn't do all that was necessary to complete the installation.  Nor did it alert me to the fact that I needed to do something manually, outside of the installer.

    I thank you for pointing out the problem.

    I feel like the Informix installer left me "holding the bag" on this one.

    Not a big deal (when you know the answer)!  :)

    Thank you.

    DG

    ------------------------------
    David Grove
    ------------------------------



  • 15.  RE: Restarting replication

    Posted Tue August 11, 2020 03:22 PM

    I think the existing library is what prevents the newer version being installed