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) , 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.