SAP Knowledge Base Article - Preview

2216073 - Signal 11 occured with execproc() when an insert query executed. - SAP ASE

Symptom

ASE encountered signal 11 when an execute query executed.

When an INSERT query attempts to insert an explicit value for a TIMESTAMP column a warning will be reported, but query execution continues. If the explicit value for the TIMESTAMP column is the result of evaluating an expression, and the query plan for the INSERT is re-executed (i.e. because the statement cache and literal auto parameterization are enabled or because the INSERT query is part of a stored procedure), memory corruption may occur, leading to various stack traces like below.

infected with signal 11 (SIGSEGV)
(execproc+0x13ed), siginfo (code, address) = (1, 0x0000000001e0f7cd)
Initiating shared memory dump for signal 11.
SQL Text: insert cpwAttributes
pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
kisignal
execproc
s_execute


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

execproc, TIMESTAMP column, memory corruption, s_lockstmt, CR 718879, CR 698063 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.