2067579 - Signal 11 error (SIGSEGV) in CgpPop::_CgpSubstExprVirtCol - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2067579 - Signal 11 error (SIGSEGV) in CgpPop::_CgpSubstExprVirtCol - SAP ASE

Symptom

  • INSERT SELECT statement involving UNIONS is performed.
  • INSERT is not specifying values for some columns in the table that have defaults.
  • User session terminates unexpectedly.
  • Error written to the client session could include

    "trying to write when connection is expecting read"

  • ASE errorlog contains an infected with signal 11 error in tree*CgpPop::_CgpSubstExprVirtCol(OptBlock*,GcvVirtual*,OptMap<short,tree*,_STL::less<short> >*).
  • Stack trace contains the following functions (offsets will vary by platform):

tree*CgpPop::_CgpSubstExprVirtCol
void CgpUnion::_cgpInit
void CgpUnion::cgpInit
CgpPop*PopAppendUnionAll<ParallelCost,ParallelProps>::popGenCgp
CgpPop*PopSort<ParallelCost,ParallelProps>::popGenCgp
CgpPop*PopInsert<ParallelCost,ParallelProps>::popGenCgp
CgpPop*PopEmit<ParallelCost,ParallelProps>::popGenCgp
CgpPop*CgpGlobal::CgpGenerate 
Optimize


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Sybase Adaptive Server Enterprise (ASE) 15.5
  • Sybase Adaptive Server Enterprise (ASE) 15.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

CR591842, 591842, SEGV, "segment violation", "storage access violation", kisignal, union, "default value" , 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.