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.