3400555 - After continuous ' s_bufpartition::GetCleanPage' messages logging, server run into aborted with stack symbols "TDSPres::RcvLoginMsg" & "TDSPres::RequestLogin" - SAP IQ

• 'Alter Table MOVE partition' execution encountered lot of deadlock avoiding messages, After that server ran into crash with stack symbols "TDSPres::RcvLoginMsg" & "TDSPres::RequestLogin".
  • From zrlog :
      ...
      10/14 08:31:06.482,<,570,EXEC_ANY_IMM,alter table "USER"."USER_TEST_Table" move partition "NOV_22" to "Partition_01"
     
  • IQMSG :
      ...
      I. 10/14 08:31:06. 0000001081 Connect:  SA connHandle: 570  SA connID: 55  IQ connID: 0000001081  User: DBA
      I. 10/14 08:31:09. 0000001081 ALTER MOVE TABLE PARTITION
      I. 10/14 09:49:43. 0000001081 [bmp-trace-tout][rpbid] tid:139878642972416 bmp:0x7f42803d0d18 lbn:4832088 next-lbn:0 pbn:251089927 nb: compr?1 updateNext?1
      I. 10/14 09:49:43. 0000001081 INFO s_bufpartition::GetCleanPage is working diligently to prevent a deadlock. Please be patient. retry=1, tid=139878642972416 s_buf=0x7f2c74de4970 btype=13
• The deadlock messages were displayed until IQ crash with stack trace at 2023-10-14 15:39:17.
      **  Error from IQ connection:  NONE
      **  Time of error:  2023-10-14 15:39:17
      **  IQ Version:  SAP IQ/16.1.050/13176/P/SP05.09
      **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327,  ...
      **  Command status when error occurred:  NO COMMAND OR CURSOR ACTIVE
      **  Dump all thread stacks at stcxtlib/st_server.cxx:2488 for PID: 1536923
    ===== Thread Number ... =====
    ..       
    .. DumpAllThreads( ..             
    .. hos_ABORT( ..                 
    .. SigHndlr+11c
    .. <unknown>
    .. TDSPres::RcvLoginMsg( ..       
    .. TDSPres::RequestLogin( ..     
    .. TDSPres::PresReceiveRequest( ..
    .. RequestProcedure::call( ..     
    .. Worker::spawn( ..             
    .. EngStream::handle_ind( ..     
    .. EngStream::execute( ..         
    .. RQConnItem::do_request( ..     
    .. RQBaseItem::do_work( ..       
    .. RequestQueue::worker_body( .. 
    .. 

SAP IQ 16.1 SP05 PL09

RcvLoginMsg, deadlock, GetCleanPage, table partition,  , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Known Error