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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.