SAP Knowledge Base Article - Preview

3526635 - unplanned failover take long time in XA check - SRS

Symptom

  • When the primary ASE is not timeout accessable for example: NFS hang in primary ASE.
  • The unplanned failover will take long time to complete, we will take 4 mins in XA enable checking:

2023-10-18 08:19:49 [INFO ] [Failover:5758][RMA] - [XAReplication            ] - Check if xa_replication is enabled.
2023-10-18 08:19:49 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:site0
2023-10-18 08:19:49 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Creating connection to pool: jdbc_sybase_Tds_Site0_34025_DR_admin_5254ab1419734b5acdad134de9cfc35 (s/r/a/w/t/o) (131/918/0/0/0/0)
2023-10-18 08:20:19 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Failed to get connection. TimeoutException: Message: 'java.util.concurren
2023-10-18 08:20:19 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Create connection failed with timetout. Will retry 2 m
2023-10-18 08:20:19 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:Site0
2023-10-18 08:20:19 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Creating connection to pool: jdbc_sybase_Tds_Site0_34025_DR_admin_5254ab1419734b5acdad134de9cfc35 (s/r/a/w/t/o) (131/918/0/0/1/0)
2023-10-18 08:20:49 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Failed to get connection. TimeoutException: Message: 'java.util.concurren
2023-10-18 08:20:49 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Create connection failed with timetout. Will retry 1 m
2023-10-18 08:20:49 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:Site0
2023-10-18 08:20:49 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Creating connection to pool: jdbc_sybase_Tds_Site0_34025_DR_admin_5254ab1419734b5acdad134de9cfc35 (s/r/a/w/t/o) (131/919/0/0/1/0)
2023-10-18 08:21:19 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Failed to get connection. TimeoutException: Message: 'java.util.concurren
2023-10-18 08:21:19 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:Site0
2023-10-18 08:22:19 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Creating connection to pool: jdbc_sybase_Tds_Site0_34025_DR_admin_5254ab1419734b5acdad134de9cfc35 (s/r/a/w/t/o) (131/922/0/0/1/0)
2023-10-18 08:22:49 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Failed to get connection. TimeoutException: Message: 'java.util.concurren
2023-10-18 08:22:49 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Create connection failed with timetout. Will retry 2 m
2023-10-18 08:22:49 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:Site0
2023-10-18 08:23:19 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Creating connection to pool: jdbc_sybase_Tds_Site0_34025_DR_admin_5254ab1419734b5acdad134de9cfc35 (s/r/a/w/t/o) (131/924/0/0/1/0)
2023-10-18 08:23:49 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Failed to get connection. TimeoutException: Message: 'java.util.concurren
2023-10-18 08:23:49 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Create connection failed with timetout. Will retry 1 m
2023-10-18 08:23:49 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:Site0
2023-10-18 08:24:49 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Creating connection to pool: jdbc_sybase_Tds_Site0_34025_DR_admin_5254ab1419734b5acdad134de9cfc35 (s/r/a/w/t/o) (131/927/0/0/1/0)
2023-10-18 08:25:19 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Failed to get connection. TimeoutException: Message: 'java.util.concurren
2023-10-18 08:25:19 [INFO ] [Failover:5758][RMA] - [XAReplication            ] - Failed to check the XA configure to the Server 'HOST1' on host 'HOST* user 'DR_admin', the parametter DTM enable valude is ''.
2023-10-18 08:25:19 [ERROR] [Failover:5758][LOGGER] - Diagnostic Data for Exception java.lang.NullPointerException
'34025' as user 'DR_admin', the parametter DTM enable valude is ''.
2023-10-18 08:25:19 [ERROR] [Failover:5758][LOGGER] - Diagnostic Data for Exception java.lang.NullPointerException
    Detected by: Null
    Thread: Failover - [5,758]
    Description: Cannot create SQLExecutor class with a null connection.

    StackTrace
        ( 0) - com.sybase.ua.plugins.dr.operations.SQLExecutor.<init>(SQLExecutor.java:73)
        (-1) - com.sybase.ua.plugins.dr.runtime.models.repobjs.ASEServerInstance.getSpConfig(ASEServerInstance.java:149)
        (-2) - com.sybase.ua.plugins.dr.api.XAReplication.isXAEnable(XAReplication.java:459)
        (-3) - com.sybase.ua.plugins.dr.api.Failover.executeWithHADR(Failover.java:997)
        (-4) - com.sybase.ua.plugins.dr.api.Failover.execute(Failover.java:737)
        (-5) - com.sybase.ua.plugins.dr.tasks.TaskBase.runTask(TaskBase.java:262)
        (-6) - com.sybase.ua.plugins.dr.api.APITaskBase.runTask(APITaskBase.java:444)
        (-7) - com.sybase.ua.plugins.dr.tasks.AsyncTaskThread.run(AsyncTaskThread.java:227)
        (-8) - java.lang.Thread.run(Thread.java:838)
2023-10-18 08:25:19 [INFO ] [Failover:5758][RMA] - [ConnectionManager        ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:Site0
2023-10-18 08:25:19 [TRACE] [Failover:5758][RMA] - [ConnectionManager        ] - Creating connection to pool: jdbc_sybase_Tds_Site0_34025_DR_admin_c4749fd478136d3ae048be61b963e4 (s/r/a/w/t/o) (1091/45/1/0/1/0)


Read more...

Environment

  • SAP Replication Server (SRS) 16.0

Product

SAP Replication Server 16.0

Keywords

CR 828575;  XA check; unplanned failover , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.