2316380 - Timeslice error when running parallel create index with hash - SAP ASE | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.