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