SAP Knowledge Base Article - Preview

1902207 - Update statistics may fail with signal 8 in sam_setup_ptn along with stacktrace - SAP ASE

Symptom

Update statistics using sampling sometimes fails with infected with signal 8 in function sam_setup_ptn

Current process infected with signal 8 (SIGFPE)
sam_setup_ptn
************************************
SQL causing error :
************************************
SQL Text:
curdb = 5 tempdb = 6 pstat = 0x10000
lasterror = 0 preverror = 0 transtate = 1
curcmd = 326 program = isql
extended error information: hostname: xxxxxx login: xxxxxx
pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
kisignal
sam_setup_ptn)
ut_handle
stat_sam_ins_worktable
update_statistics_col
ups__updstats_column
ut_handle
update_statistics
ut_handle
ups_main
s_execute
hdl_stack
s_handle
sequencer
tdsrecv_language
ut_handle
conn_hdlr
kpstartproc

Note: This problem can sometimes occur, even when an explict "update statistics" command has not been run, due to internal ASE processing involving activities like setting up worktables for query processing. In these cases, the stacktrace produced may include the module update_statistics_implicit .


Read more...

Environment

SAP  Adaptive Server Enterprise  (ASE) 15.0
SAP  Adaptive Server Enterprise  (ASE) 15.5 
SAP  Adaptive Server Enterprise  (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

signal 8, sam_setup_ptn, update statistics, 744389 , 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 ONE Support launchpad (Login required).

Search for additional results

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