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
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.
SAP Knowledge Base Article - Preview