Symptom
Concurrent DML on a RLV enabled table with a primary key may cause the server to crash in some circumstances.
DML: Data manipulation Language
RLV: Row-Level Versioning
Excerpt of the stack trace:
rv_TabVersion::get_EBM
rv_TabVersion::PrepareToCommitMerge
db_Catalog::PrepareToCommitRLV
st_txncb::PrepareToCommit2
st_txnMgr::PrepareToCommit
db_PrepareToCommit::Execute()+0x79
st_command::DoCmdThroughResourceGate()+0x82
st_iqtxn::PrepareToCommit(UIConnection*, unsigned long long*, unsigned long long*, unsigned long long*, an_iq_commit_info*)+0x32
UIQTxn_PrepareToCommit+0x25
st_SAIQInterfaceInfo::callFunction()+0x26
st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x189
st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x20a
saint_iqthresholdtxn::PrepareToCommit(IConnection*, an_iq_commit_info*)+0x98
DB_Commit_Chgs(Connection*)+0x45f
ri_commit(Connection*)+0x179
Connection::commit_work()+0x48
_ri_auto_commit()+0xfe
CallRLVMerge(Connection*, unsigned int, unsigned long long, unsigned int, unsigned int)+0x155
UIDatabase_RunRLVMergeWithSameConn+0x1e
st_SAIQInterfaceInfo::callFunction()+0x26
st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x388
rv_AutoMergeMgr::TriggerRLVMerge(UIConnection*, unsigned int, unsigned long long)+0x4c
rv_AutoMergeMgr::EvalAndTriggerRLVMerge(UIConnection*, unsigned int)+0x3ef
st_iqdml::EvalAndTriggerRLVMerge(UIConnection*, unsigned int)+0x6b
UIQDML_EvalAndTriggerRLVMerge+0x1b
Read more...
Environment
All IQ versions prior to IQ 16 SP 10 could hit this issue.
Product
Keywords
CR 774896 ; 774896 ; RLV ; DML ; crash ; abort ; rv_TabVersion ; rv_TabVersion::get_EBM ; rv_TabVersion::PrepareToCommitMerge ; db_Catalog::PrepareToCommitRLV , KBA , BC-SYB-IQ , Sybase IQ , 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.