SAP Knowledge Base Article - Preview

2316380 - Timeslice error when running parallel create index with hash - SAP ASE

Symptom

When running parallel CREATE INDEX with hash based statistics gathering there may be a timeslice error.
The stack would look like the following
#0  0x00000000202c9a2 in stphd_release_last_mvcc_histogram (
    nosortp=0x1adc6abd0)
    at /generic/source/utils/statshashparallel.c:631
#1  0x000000000202cd94 in stphd_release_unreferenced_mvcc_histograms (
    nosortp=0x1adc6abd0)
    at /generic/source/utils/statshashparallel.c:852
#2  0x000000000202ffb3 in stphd_parallel_statend (nosortp=0x1adc6abd0)
    at /generic/source/utils/statshashparallel.c:1924
#3  0x00000000020370df in stphd_mvcc_end (nosortp=0x1adc6abd0)
    at /generic/source/utils/statshashparallel.c:5551
#4  0x00000000020fae22 in stu_nosort_range (nosortp=0x1adc6abd0,
    is_intermediate_histogram=0)
    at /generic/source/utils/statshashhigh.c:11356
#5  0x0000000002028c37 in ups_nosort_create_hist (nosortp=0x1adc6abd0,
    ptnp=0x1cef5d7a8, assert_rowtotal=165945)
    at /generic/source/utils/statshashlow.c:4901
#6  0x000000000202910d in ups_nosort_end (indp=0x1cef57000, statp=0x1cef5d360)
    at /generic/source/utils/statshashlow.c:5011
#7  0x000000000187ed38 in statend (indp=0x1cef57000, ptnp=0x1cef57690,
    statp=0x1cef5d360)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

timeslice, create index, hash stats, parallel, serial, CR774082, CR#774082, 774082 , 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.