3379644 - Infected with signal 11 or a time slice -<Number> current process infected at when running a query with ROWS LIMIT <number> OFFSET <number> with derived

ASE errorlog reports timeslice error(s):

timeslice -501, current process infected at 0x16ec679 (LeVtuple::LeVtuple(tree*, proc_hdr*, LeEvals*, LeConstantsMetaData*, LeEvals*)+0x59)

kernel  ************************************
kernel  SQL causing error : SELECT COUNT(*) FROM (SELECT * FROM CT1 ROWS LIMIT 500000 OFFSET 0) dbvrcnt

kernel  ************************************

Followed by a stack trace that contains functions:

CgGenLava::CGConsStoreOp
CgpStore::_cgpCodeGen
CgpPop::cgpCodeGen
CgpSequence::_cgpCodeGen
CgpPop::cgpCodeGen
CgpPop::prepareCodeGenCgp
CgpEmit::_cgpCodeGen
CgpPop::cgpCodeGen
GenLava
s_compile_stmt
s_compile

Note: On SP03 PL13, it results in a SEGV. On SP03 PL14 and SP04 PL04, it results in a time slice.

• SAP Adaptive Server Enterprise (ASE) 16.0

timeslice, infected, ROWS, LIMIT, derived, terminating, process , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem