3801563 - MPX full or Incremental Backup got hang with stacktrace in module s_iqstore::LockFL() - IQ 16.1 SP05

IQ MPX full or Incremental Backup crashed with stacktrace.

When this issue happened,  IQ got hang and see the  following error message in iqmsg file:

I. 11/02 06:29:19. 0000013918 Warning: s_iqstore::LockFL has been waiting for more than 60 seconds. tid:140718640977664
I. 11/02 06:29:19. 0000013918 Warning: s_iqstore::LockFL has been waiting for more than 60 seconds. tid:140718659081984
I. 11/02 06:29:19. 0000013918 Warning: s_iqstore::LockFL has been waiting for more than 60 seconds. tid:140718567495424
I. 11/02 06:29:19. 0000013918 Warning: s_iqstore::LockFL has been waiting for more than 60 seconds. tid:140718676653824
I. 11/02 06:29:19. 0000013918 Warning: s_iqstore::LockFL has been waiting for more than 60 seconds. tid:140718616483584
I. 11/02 06:29:19. 0000013918 140718606366464 Stacktrace requested from oslib/hos_InMemMsgLog.cxx:178 on thread 140718606366464 (TIX 1383) start stacktrace
I. 11/02 06:29:19. 0000013918     **  Error from IQ connection:  SA connHandle: 2568  SA connID: 44  IQ connID: 0000013918  User: delp_prod
I. 11/02 06:29:19. 0000013918     **  Time of error:  2025-11-02 06:29:19
I. 11/02 06:29:19. 0000013918     **  IQ Version:  SAP IQ/16.1.050/15121/P/SP05.14
I. 11/02 06:29:19. 0000013918     **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327,  Executed on: Linux/nydbflm52936.ny.fw.gs.com/3.10.0-1160.136.1.el7.x86_64/#1 SMP Tue Jul 8 07:32:00 EDT 2025/x86_64
I. 11/02 06:29:19. 0000013918     **  Command status when error occurred:  CURSOR ACTIVE
I. 11/02 06:29:19. 0000013918     **  Command text:
I. 11/02 06:29:19. 0000013918 create hg index "IND_NAME_HG" ...
I. 11/02 06:29:19. 0000013918     **  Dump all thread stacks at oslib/hos_InMemMsgLog.cxx:178 for PID: 54611
I. 11/02 06:29:19. 0000013918 ***************** This is the STACKTRACE ***************
I. 11/02 06:29:19. 0000013918 ===== Thread Number 140718606366464 (IQ connID: 0000013918) =====
I. 11/02 06:29:19. 0000013918 pc: 0x400e81 backtrace+21
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbe8fcf44 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+34
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbe8fd66b ucstkgentrace(int, int)+18b
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbe8fdf2d DumpAllThreads(char const*, unsigned int, int)+2bd
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbe8f8000 hos_InMemMsgLog::DumpFullStackTraceIfNotRecentlyDumped()+1b0
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbf0f790d s_iqstore::LockFL()+24d
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbeac48b0 s_bufpartition::GetCleanPage(s_bufman_errorInfo*, s_connectionCacheStats*, hos_bio*, s_blockmap*, unsigned long long, unsigned long long, unsigned int, unsigned long long, short, hos_cmprstype, s_bufman::s_paging, s_bufmanCallerStats*)+1570
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbeac64bc s_bufpartition::Create(s_bufman_errorInfo*, s_connectionCacheStats*, hos_bio*, unsigned long long, unsigned long long, unsigned long long, short, hos_cmprstype, s_blockmap*, s_bufman::s_paging, s_bufman::s_zeroing)+15c
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbe9f58f4 s_blockmap::Create(short, int, hos_cmprstype, unsigned int, unsigned int)+514
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbf2cb560 hc_run::NewBuffer(s_buf*, int)+100
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbf2cb649 hc_frun::Append(void const*)+69
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbeb0b230 hs_csort::SortAndSave(hs_csortInsertPkg*, int)+19a0
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbe8f2109 hos_thread::Main()+209
I. 11/02 06:29:19. 0000013918 pc: 0x7ffbbe862799 hos_lwtask::Start(hos_lwtask*)+69
I. 11/02 06:29:19. 0000013918 pc: 0x7ffff6ad2a5e IQWorkerStarter(void*)+3e
I. 11/02 06:29:19. 0000013918 pc: 0x7ffff71ebc1e run_task_body+1e
I. 11/02 06:29:19. 0000013918 pc: 0x7ffff6da5488 UnixTask::pre_body(void*)+78
I. 11/02 06:29:19. 0000013918 pc: 0x7ffff5f0bea5 <unknown>
I. 11/02 06:29:19. 0000013918 pc: 0x7ffff5426b0d clone+6d
I. 11/02 06:29:19. 0000000000 ===== Thread Number 140737353926528 =====
I. 11/02 06:29:19. 0000000000 pc: 0x400e81 backtrace+21
I. 11/02 06:29:19. 0000000000 pc: 0x7ffbbe8fcf44 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+34
I. 11/02 06:29:19. 0000000000 pc: 0x7ffbbe8fd66b ucstkgentrace(int, int)+18b

SAP IQ 16.1 SP05 PL14

hang backup s_iqstore LockFL create hg index _dbmvbio AllocateAndMarkBlksInUse st_globalFlMgr SwitchStateBitmaps DeAllocate , KBA , BC-SYB-IQ , Sybase IQ , Problem