3762374 - In HADR setup a 'dump tran' hangs with ra_ci_sync_sleep in stack and causing Rep Agent error 9416 - SAP ASE

• In HADR setup
• A 'dump transaction' spid hangs with code function ra_ci_sync_sleep in its stack
• With the ASE errorlog showing (many) Replication Agent error 9416
• Below outputs that point to this issue:

1. Query results from sysprocesses or sp_who and syslogshold show
   
   
   1. a sleeping DUMP TRANSACTION spid
   2. that is blocking several system spids (and likely also user spids), which can include:
      REP AGENT CI SCANNER
      CHECKPOINT
      HK CHORE
      
      sp_who
      go
      

      spid  status    ... blk_spid  dbname    cmd
      ----  ----------    --------  --------  ------------------- 
       10   lock sleep        480   DB_NAME   CHECKPOINT SLEEP
       13   lock sleep        480   DB_NAME   HK CHORES
      211   background        480   DB_NAME   REP AGENT CI SCANNER
      480   sleeping            0   DB_NAME   DUMP TRANSACTION

2. A dbcc stacktrace on the DUMP TRAN spid includes ra_ci_sync_sleep
   
   dbcc stacktrace (480)
   go
   
   upsleepgeneric
   uppause
   ra_ci_sync_sleep
   syslogs_flushlog
   finishlog
    ...
   
   
3. Query results from syslocks / sp_lock show the DUMP TRAN spid holding lock on table_id 20, which is sysanchors:
   
   sp_lock
   go
   

   spid   loid   locktype   table_id  partitionid page row dbname  class
   ------ ------ ---------- --------  ----------- ---- --- ------- --------
    480    960   Ex_intent       20             0    0  0  DB_NAME Non Cursor Lock
    

4. ASE errorlog shows (many) message related to 'commit wait' and with error 9416:
   
   Current transaction ID (146637801,31) in database 'DB_NAME' (dbid = 123): commit wait  interrupted.
   Current transaction ID (146637902,47) in database 'DB_NAME' (dbid = 123): commit wait  expired.
   Error: 9416, Severity: 17, State: 4
   Rep Agent on database 'DB_NAME' switched from mode 'sync' to mode 'async' because timer on commit expired.

• SAP Adaptive Server Enterprise (ASE)
  • 16.0 SP04 PL07, PL07 HF1 & PL08 only
  • 16.1 SP00 PL00, PL01 & PL02 only    
• HADR configuration

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Known Error