stack trace runing sap IQ 16 sp11 PL03 on AIX

[jimmycab]

Hi,

We are having a IQ crash al night when running loads during night.

** Error from IQ connection: ** Time of error: 2017-02-07 22:40:21 ** IQ Version: SAP IQ/16.0.110/10318/P/sp11.03 ** OS info: IQ built on: RS6000MP/AIX 6.1.0, Executed on: AIX/bgdcmigiq/1/7/00F79C114C00 ** Command status when error occured: COMMAND ACTIVE ** Command text: Statement text unavailable Dump all thread stacks at /cm/iqa/include/hos_mutex_inline.h:316 for PID: 18940082 ***************** This is the STACKTRACE ***************

===== Thread Number 51915 (IQ connID: 0000286442) ===== pc: 0x9000000040077c8 .pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x1c8() pc: 0x900000004007118 .ucstkgentrace(int,int)+0xb8() pc: 0x90000000400560c .DumpAllThreads(const char*,unsigned int,int)+0x3cc() pc: 0x900000003f276c0 .hos_ABORT(const char*,unsigned int,const hos_exception&,char*,char*)+0x3e0() pc: 0x900000003f2fcd4 .ThrowAbort(const hos_exception&)+0x274() pc: 0x900000003f2f99c .Throw(const hos_exception&)+0x49c() pc: 0x90000000491bbcc .rv_TabVersion::get_EBM() const+0x46c() pc: 0x900000004917730 .rv_TabVersion::PrepareToCommitMerge(st_connection*)+0x210() pc: 0x9000000047af614 .db_Catalog::PrepareToCommitRLV(rv_TxnLogSession*)+0xb4() pc: 0x900000004214ed4 .st_txncb::PrepareToCommit2()+0x6f4() pc: 0x900000004fa6b08 .st_txnMgr::PrepareToCommit(unsigned long*,unsigned long*,unsigned long*,void**,unsigned short*,unsigned int*,unsigned long*)+0x128() pc: 0x90000000480715c .db_PrepareToCommit::Execute()+0x5c() pc: 0x900000004812004 .st_command::DoCmdThroughResourceGate()+0x324() pc: 0x9000000048052d0 .st_iqtxn::PrepareToCommit(UIConnection*,unsigned long*,unsigned long*,unsigned long*,an_iq_commit_info*)+0x30() pc: 0x900000003eabb8c .UIQTxn_PrepareToCommit+0x4c() pc: 0x900000004016aa0 .st_SAIQInterfaceInfo::callFunction()+0x40() pc: 0x900000006a8abc4 .st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x164() pc: 0x90000000401788c .st_SAIQInterface::Execute(int,void*,unsigned int(*)(void*,void*),void*,unsigned int)+0x58c() pc: 0x9000000069e47a8 .saint_iqthresholdtxn::PrepareToCommit(IConnection*,an_iq_commit_info*)+0x188() pc: 0x90000000231bfd8 .DB_Commit_Chgs(Connection*)+0x7b8() pc: 0x9000000021c97a4 .ri_commit(Connection*)+0x244() pc: 0x9000000021c9068 .Connection::commit_work()+0x48() pc: 0x9000000021ca0b8 ._ri_auto_commit()+0x118() pc: 0x9000000024ca644 .CallRLVMerge(Connection*,unsigned int,unsigned long,unsigned int,unsigned int)+0x224() pc: 0x900000001fd772c .Database::RunRLVMergeWithSameConn(unsigned int,unsigned long,unsigned int)+0x4c() pc: 0x900000003e9f424 .UIDatabase_RunRLVMergeWithSameConn+0x44() pc: 0x900000004016aa0 .st_SAIQInterfaceInfo::callFunction()+0x40() pc: 0x900000004017474 .st_SAIQInterface::Execute(int,void*,unsigned int(*)(void*,void*),void*,unsigned int)+0x174() pc: 0x90000000672ebb0 .rv_AutoMergeMgr::TriggerRLVMerge(UIConnection*,unsigned int,unsigned long,unsigned int)+0xb0() pc: 0x90000000672e254 .rv_AutoMergeMgr::EvalAndTriggerRLVMerge(UIConnection*,unsigned int,unsigned int)+0x734() pc: 0x9000000069a1d60 .st_iqdml::EvalAndTriggerRLVMerge(UIConnection*,unsigned int)+0x80() pc: 0x900000003eab120 .UIQDML_EvalAndTriggerRLVMerge+0x40() pc: 0x900000004016aa0 .st_SAIQInterfaceInfo::callFunction()+0x40() pc: 0x900000006a8abc4 .st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x164() pc: 0x90000000401788c .st_SAIQInterface::Execute(int,void*,unsigned int(*)(void*,void*),void*,unsigned int)+0x58c() pc: 0x9000000069ea694 .saint_iqthresholddml::EvalAndTriggerRLVMerge(IConnection*,unsigned int)+0x94() pc: 0x900000003243c08 .RLVMergeEvent::do_request()+0x128() pc: 0x9000000020773d0 .InternalRequestProcedure::call()+0x30() pc: 0x900000001edcf98 .Worker::spawn(Procedure*)+0x98() pc: 0x90000000207120c .RQInternalBaseItem::do_work(Worker*)+0x4c() pc: 0x900000001ead244 .RequestQueue::worker_body()+0xc4() pc: 0x900000002070f00 .request_task(void*)+0x80() pc: 0x900000001f9ad88 .run_task_body+0x48() pc: 0x900000001f95254 .UnixTask::pre_body(void*)+0x134() pc: 0x900000000822d94 ()

the stack trace looks similar to this note

2286861 - RLV Concurrent DML on a table may abort in rv_TabVersion::get_EBM

and it says that the issue is fixed in SP11 an higher. The thing is that when i look for the CR number on the latest release note for SAP IQ 16 - EBF26788_README.txt it doesn't appear to be included.

It seems that the issue is not fixed.

Can anyone have face this issue before. Where can I verify the patch level where the issue was corrected other than readme notes.

Regards,