SAP Knowledge Base Article - Preview

2366977 - Signal 11 in amc_finish_command() on REORG REBUILD or ALTER TABLE on a table with a trigger - SAP ASE 16.0

Symptom

  • Commands like:
    • REORG REBUILD on a table with a trigger 
    • ALTER TABLE...MODIFY to change the column nullability on a table with multiple triggers
    • ALTER TABLE...DROP a column on a table with multiple triggers

  is terminated:
           
       ASE is terminating this process.

  • The "Infected with Signal 11" error in the module amc_finish_command() is reported in the ASE errorlog:

Current process (0x230012) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001caba21 (amc_finish_command+0x281), siginfo (code, address) = (1, 0x0x0000000000000044)
 

  • The stack trace shows the following modules:
     
       amc_finish_command
       s__finish_alttab
     
    also some of these modules can be seen (depending on the command and platform):
     
    exc_raise
    sdes_hookup
    crt_work
    run_crtable
    onlutl_crt_pts_table
    LeEmittOp::_LeOpAcquire
    LePlanAcquire
    exec_lava
    s_execute
    sequencer
    exectrig
    s_execute
    sequencer
    internal_sql
    rbld__table_via_amc
    reorg_main

  • reorg rebuild with online command on a table with a trigger may fail due to a 622 error and the process is terminated with a stack trace including exectrig(), onlutl_crt_pts_table() and crt_work().  For example:

    reorg rebuild <table name> with online
    go

    Beginning REORG REBUILD of table '<table name>'.
    Msg 622, Level 20, State 1:
    Server '<ASE name>', Procedure '<trigger name>', Line <line number>:
    Opentable was passed a varno of 251. Object '' in database 'tempdb' already has that session descriptor in use. This occured while opening object id <negative object ID> in database id 2.
    ASE is terminating this process.
     
  • Note: Exmaples of complete stack traces are available under Attachments.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR801921, reorg, rebuild, signal 11, trigger, order, SYBASE, CR#801921, 801921, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, registers , 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.