SAP Knowledge Base Article - Preview

2147566 - A timeslice error or signal 8 may occur while hash-based update statistics executed - SAP ASE

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

SAP Adaptive Server Enterprise 16.0

Keywords

CR781728, CR#781728, 781728, CR823218, CR#823218, 823218, stacktrace,  segmentation, storage, access, violation, fault, segfault , 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.