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

• 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):

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

  Note: Examples of complete stack traces are available under Attachments.

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

SAP Adaptive Server Enterprise (ASE) 16.0

CR801921, 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