Restarting replication
David Grove's RSS stayed Disconnected after both servers were upgraded to 12.10.FC14. Mark Jalkiewicz suggested restarting the secondary. Paul Watson spotted in the log that GSKit was not installed and ICC library load failed. David manually ran the GSKit installer from the Informix gskit directory and RSS worked. Paul suspected an existing older library blocked the installer.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 KbytesLocal 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
------------------------------
#Informix
restarting Informix on the RSS secondary should do it providing that the logs on the primary didn't wrap.
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 44004b008/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
------------------------------
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
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 ------------------------------
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 ------------------------------
I don't think the installer will automagically overwrite an old GSK so it is a manual task Cheers Paul
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 ------------------------------
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.
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 ------------------------------
And the gsk was not on the system anywhere ?
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 ------------------------------
I meant it wasn't already installed in /usr/lib/whatever?
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 ------------------------------
I think the existing library is what prevents the newer version being installed
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g