SAP Knowledge Base Article - Preview

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

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

SAP Sybase IQ 15.4

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.