HDR is not working
Posted in 2018
Topics: High Availability & Replication, Storage & Space Management, Logging & Checkpoints, Networking & sqlhosts Configuration, Clustering, Grid & MACH11, Versions, Editions & End-of-Life
Dear All,
In our environment we have configured HDR. it is successfully configured.
Today unexpectedly primary server got physically restarted with unknown
reason. But as per HDR setup application should redirect to secondary server,
which has not happened, still the secondary server is in Read-only mode.
Why is this happen?
Priamry DB details:
Online log:
08:00:08 Maximum server connections 172
08:00:08 Checkpoint Statistics - Avg. Txn Block Time 0.017, # Txns blocked 0,
Plog used 0, Llog used 2
09:54:53 SCHAPI: thread dbWorker1 task mon_chunk(6-3524) shutting down
09:54:53 SCHAPI: thread dbWorker2 task Low Memory Reconfig(47-3523) shutting
down
09:54:54 SCHAPI: thread dbScheduler(112) shutting down
Secondary DB details:
Online log:
08:00:08 Maximum server connections 110
08:00:08 Checkpoint Statistics - Avg. Txn Block Time 0.019, # Txns blocked 0,
Plog used 9, Llog used 0
09:55:09 DR: Receive error
09:55:09 dr_secrcv thread : asfcode = -25582: oserr = 0: errstr = : Network
connection is broken.
09:55:09 DR_ERR set to -1
09:55:10 DR: Turned off on secondary server
09:55:13 SMX thread is exiting
09:55:13 SMX thread is exiting
We are suing connection manager:
NAME cm_hdr1
LOG 1
LOGFILE C:\\\\Connection_Manager\\\\tmp\\\\cm.log
CLUSTER hdr_cluster
{
INFORMIXSERVER dbserv_g
SLA oltp DBSERVERS=PRI
SLA report DBSERVERS=HDR,PRI
FOC ORDER=ENABLED PRIORITY=1
CMALARMPROGRAM C:\\\\Connection_Manager\\\\etc\\\\cmalarmprogram.bat
}
Now immediately we have started the primary server. it is started in PRIM mode
only.
In primary if i execute the onstat -g cmsm it is showing nothing
Primary: onstat -g cmsm
IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 00:44:43
-- 4400896 Kbytes
Secondary: onstat -g cmsm
IBM Informix Dynamic Server Version 12.10.FC8 -- Read-Only (Sec) -- Up 2 days
14:15:47 -- 4925184 KbytesUnified Connection Manager: cm_hdr1 Hostname: WINHDRCM.iacirc.com
CLUSTER hdr_cluster LOCAL
Informix Servers: dbserv_g
SLA Connections Service/Protocol Rule
oltp 0 50008/onsoctcp DBSERVERS=PRI
report 0 50010/onsoctcp DBSERVERS=HDR,PRI
Failover Arbitrator: Failover is enabled
ORDER=ENABLED PRIORITY=1
Help me on this?
Connection manager couldn't connect to primary server. Primary server assigns
active arbitrator role to connection manager. Pls. check connect manager log
file to check on why CM cannot connect to primary server.
Thanks & Regards,
Nagaraju
On 2/9/18, 11:21 PM, "ids-bounces@iiug.org on behalf of MUKESH TANUKU"
<ids-bounces@iiug.org on behalf of mukeshbt1328@gmail.com> wrote:
Dear All,
In our environment we have configured HDR. it is successfully configured.
Today unexpectedly primary server got physically restarted with unknown
reason. But as per HDR setup application should redirect to secondary server,
which has not happened, still the secondary server is in Read-only mode.
Why is this happen?
Priamry DB details:
Online log:
08:00:08 Maximum server connections 172
08:00:08 Checkpoint Statistics - Avg. Txn Block Time 0.017, # Txns blocked 0,
Plog used 0, Llog used 2
09:54:53 SCHAPI: thread dbWorker1 task mon_chunk(6-3524) shutting down
09:54:53 SCHAPI: thread dbWorker2 task Low Memory Reconfig(47-3523) shutting
down
09:54:54 SCHAPI: thread dbScheduler(112) shutting down
Secondary DB details:
Online log:
08:00:08 Maximum server connections 110
08:00:08 Checkpoint Statistics - Avg. Txn Block Time 0.019, # Txns blocked 0,
Plog used 9, Llog used 0
09:55:09 DR: Receive error
09:55:09 dr_secrcv thread : asfcode = -25582: oserr = 0: errstr = : Network
connection is broken.
09:55:09 DR_ERR set to -1
09:55:10 DR: Turned off on secondary server
09:55:13 SMX thread is exiting
09:55:13 SMX thread is exiting
We are suing connection manager:
NAME cm_hdr1
LOG 1
LOGFILE C:\\\\Connection_Manager\\\\tmp\\\\cm.log
CLUSTER hdr_cluster
{
INFORMIXSERVER dbserv_g
SLA oltp DBSERVERS=PRI
SLA report DBSERVERS=HDR,PRI
FOC ORDER=ENABLED PRIORITY=1
CMALARMPROGRAM C:\\\\Connection_Manager\\\\etc\\\\cmalarmprogram.bat
}
Now immediately we have started the primary server. it is started in PRIM mode
only.
In primary if i execute the onstat -g cmsm it is showing nothing
Primary: onstat -g cmsm
IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 00:44:43
-- 4400896 Kbytes
Secondary: onstat -g cmsm
IBM Informix Dynamic Server Version 12.10.FC8 -- Read-Only (Sec) -- Up 2 days
14:15:47 -- 4925184 Kbytes
Unified Connection Manager: cm_hdr1 Hostname: WINHDRCM.iacirc.com
CLUSTER hdr_cluster LOCAL
Informix Servers: dbserv_g
SLA Connections Service/Protocol Rule
oltp 0 50008/onsoctcp DBSERVERS=PRI
report 0 50010/onsoctcp DBSERVERS=HDR,PRI
Failover Arbitrator: Failover is enabled
ORDER=ENABLED PRIORITY=1
Help me on this?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
::DISCLAIMER::
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------
The contents of this e-mail and any attachment(s) are confidential and
intended for the named recipient(s) only. E-mail transmission is not
guaranteed to be secure or error-free as information could be intercepted,
corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses
in transmission. The e mail and its contents (with or without referred errors)
shall therefore not attach any liability on the originator or HCL or its
affiliates. Views or opinions, if any, presented in this email are solely
those of the author and may not necessarily reflect the views or opinions of
HCL or its affiliates. Any form of reproduction, dissemination, copying,
disclosure, modification, distribution and / or publication of this message
without the prior written consent of authorized representative of HCL is
strictly prohibited. If you have received this email in error please delete it
and notify the sender immediately. Before opening any email and/or
attachments, please check them for viruses and other defects.
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------
Post your last 30 lines from C:\\\\Connection_Manager\\\\tmp\\\\cm.log and your Connection manager sqlhosts
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