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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.