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

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.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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

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.