Symptom
- A timeslice error occurs or system exception (0xc0000094) or SIGFPE while executing hash-based update statistics on a table which has over 150,000 unique datetime records:
update statistics test_a (col7) with hashing
- The error is followed by a stack trace that contains the following functions:
stu_sortrange_to_hist()
stu_nosort_create_hist_high_domain()
stu_nosort_merge_hist()
stu_nosort_range()
stat_nosort_tabscan_end()
at_ins_worktable()
date_statistics_col_hash()
update_statistics_colset_driver()
ups__updstats_column()
update_statistics()
ups_main()
s_execute()
sequencer()
tdsrecv_language()
conn_hdlr()
kpntwrapper()
CreateFiberEx()
Note: A sample of a full stack trace is available under Attachments.
- SIGFPE is also reported with create index command with consumes = 3 and statistics hashing like below on Linux platform.
CREATE UNIQUE INDEX index_name ON table_name ( column name list ) with consumers = 3, statistics hashing
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
Product
Keywords
CR781728, CR#781728, 781728, CR823218, CR#823218, 823218, stacktrace, segmentation, storage, access, violation, fault, segfault, stu_sortrange_to_hist() , KBA , ups__updstats_column , update_statistics , update_statistics_col_hash , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.
SAP Knowledge Base Article - Preview