2551698 - Signal 11 in stu_collapse_range_freq_newvalues() during parallel index creation - SAP ASE

• CREATE INDEX run in parallel with "statistics hashing" fails with the following errors:
   
• signal 11 (SIGSEGV) in the module stu_collapse_range_freq_newvalues():

Current process (0x39001d) infected with signal 11 (SIGSEGV)
Address 0x0x00000000015b9346 (stu_collapse_range_freq_newvalues+0x1f1), siginfo (code, address) = (1, 0x0x0000000000000004)

• This error comes with a stack trace with the following functions: 

stu_collapse_range_freq_newvalues
stu_collapse_range
st_reduce_frequency_cell_range1
stu_nosort_merge_hist
stphd_mvcc_histogram_iteration
stphd_mvcc_histogram_iteration_driver
stu_nosort_range
ups_nosort_insert
bt__cr_from_sorted
soblddolpages
sort_ind_heap_bld
psort_consumer

  Note: A complete stack trace can be found in Attachment section.

• Sample CREATE INDEX command:
  
  CREATE INDEX "ABCD~002" ON "ABCD" ( "LIFNR" , "RMWWR" , "STATUS" , "GROSS_AMOUNT" ) with consumers = 8, statistics hashing 
  
  

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Warehouse
• SAP Adaptive Server Enterprise (ASE) 16.0
• SAP Netweaver

parallel, consumers, "statistics hashing", SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, registers, stats, CR817795, CR#817795, 817795

Avoid use of hash-based stats while creating indexes in parallel
Disable ASE configuration parameter: 'utility statistics hashing'