SAP Knowledge Base Article - Preview

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

Symptom

  • 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 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Linux

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

parallel, consumers, "statistics hashing", SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, registers, stats, CR817795, CR#817795, 817795 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.