SAP Knowledge Base Article - Preview

2746772 - Downgrade failed from 16.0.3.5 to 16.0.2.7 using sp_downgrade_esd

Symptom

  • I cannot run the downgrade procedure from ASE 16.0.3.5 to ASE 16.0.2.7 on Solars:
    -downgrade hits SIG11 while downgrading sybsecurity database and halts.

    00:0006:00000:00002:2019/01/22 16:54:09.90 server Database 'sybsecurity' is now online.
    00:0006:00000:00014:2019/01/22 16:54:09.90 server audproc: Loading global audit options from sysauditoptions.
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel **** Saved signal context (0x0007ffe540794050): ****
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel uc_flags: 0x2f, uc_link: 0x0
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel uc_sigmask: 0xefbe7877 0xfffffff7 0xff 0x0
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel uc_stack: ss_sp: 0xffffffff7a800000, ss_size: 0x2080768, ss_flags: 0x0
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel General Registers (uc_mcontext.gregs):
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel PC : 00000000817ab5e4 (sparclock+0x4)
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel Next PC : 00000000817ab5e8 (sparclock+0x8)
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel CCR : 0000000000000000 Y : 0000000000000000
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel ASI : 0000000000000082 FPRS : 0000000000000007
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel g0 : 0000000000000000 g1 : 0000000000000000 g2 : 0000000000001220
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel g3 : 0007ffe503fc0380 g4 : 0000000000000000 g5 : 0000000000005000
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel g6 : 0000000000000000 g7 : ffffffff7bb05a40
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel o0 : 0000000000000000 o1 : ffffffffffffffff o2 : 0000000000000000
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel o3 : 0000000080ed7dd4 o4 : 0007ffe6351d5c50 o5 : 0000000000000000
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel o6 : 0007ffe540793c31 o7 : 0000000080ed911c
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel Windowed Registers (from stack frame 0007ffe540794430):
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel l0 : 0000000000004c00 l1 : 0000000000000000 l2 : 0000000000000000
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel l3 : 0007ffe6351ca288 l4 : 0000000000002000 l5 : fffffffffffffff8
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel l6 : 0000000000000000 l7 : 0000000000000000
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel i0 : 0007ffe5f4fb95c0 i1 : 000000000000000e i2 : 0007ffe5f4fb95c0
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel i3 : 0000000000000000 i4 : 0000000000000000 i5 : 0000000000004e98
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel i6 : 0007ffe540793ce1 i7 : 0000000080ed0f78
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel previous stack frame : 0007ffe5407944e0
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel **** end of signal context ****
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel ************************************
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel SQL causing error : @y?!
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel ************************************
    00:0006:00000:00002:2019/01/22 16:54:09.91 server SQL Text: @y?!
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel curdb = 1 tempdb = 2 pstat = 0x1000 p2stat = 0x101110
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel p3stat = 0x804 p4stat = 0x0 p5stat = 0x0 p6stat = 0x8000001 p7stat = 0x10000
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel lasterror = 0 preverror = 0 transtate = 1
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel curcmd = 0 program =
    00:0006:00000:00002:2019/01/22 16:54:09.91 kernel extended error information: hostname: login: 

    pcstkwalk+0x18()
    ucstkgentrace+0x23c()
    ucbacktrace+0xe4()
    terminate_process+0x1918()
    kisignal+0x954()
    sparclock+0x4()
    des_discardall+0x1c()
    dbt_removeall+0xa8()
    _$o1cezaQ0.dbt_get+0x4fc()
    dbt_get_with_statuscheck+0x8()
    dbcontext_change+0x40()
    usedb+0x58()
    hdl_backout_msg installed by the following function:-]
    specialrecover+0x1b0()
    ds__recoverdbs+0x62c()
    dsinit+0xec8()
    _coldstart()

    kernel end of stack trace, spid 2, kpid 26411210, suid 0
    server audproc: Global audit options successfully loaded. 

  • Other stacktraces from downgrading tests

1.
00:0006:00000:00002:2019/01/23 13:26:16.57 server Opening Master Database ...
00:0006:00000:00002:2019/01/23 13:26:16.58 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
00:0006:00000:00002:2019/01/23 13:26:16.58 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)
...
00:0006:00000:00002:2019/01/23 13:26:16.58 kernel pc: 0x00000000806a65b8 usedb+0x58(0x0000000000000000, 0x0001000000000000,

2.
00:0006:00000:00002:2019/01/23 08:54:03.71 server Database 'tempdb' is now online.
00:0006:00000:00002:2019/01/23 08:54:03.71 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
00:0006:00000:00002:2019/01/23 08:54:03.71 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)
...
00:0006:00000:00002:2019/01/23 08:54:03.72 kernel pc: 0x00000000806a65b8 usedb+0x58(0x0000000000000000, 0x7b1a000000000000,

3.
*** Bypassing recovery of the 'sybsecurity' database

00:0006:00000:00002:2019/01/23 08:06:58.87 server Timestamp for database 'sybsecurity' is (0x0080, 0x0000a200).
00:0006:00000:00002:2019/01/23 08:06:58.87 server ***** WARNING: AUDITING CANNOT BE ENABLED DUE TO PROBLEMS WITH THE SYBSECURITY DATABASE. *****
00:0006:00000:00002:2019/01/23 08:06:58.87 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
00:0006:00000:00002:2019/01/23 08:06:58.87 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)
...
00:0006:00000:00002:2019/01/23 08:06:58.88 kernel pc: 0x00000000806a65b8 usedb+0x58(0x0000000000000000, 0x7b1a000000000000,


4.
00:0006:00000:00002:2019/01/22 16:54:09.90 server Database 'sybsecurity' is now online.
00:0006:00000:00014:2019/01/22 16:54:09.90 server audproc: Loading global audit options from sysauditoptions.
00:0006:00000:00002:2019/01/22 16:54:09.91 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
00:0006:00000:00002:2019/01/22 16:54:09.91 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)
...
00:0006:00000:00002:2019/01/22 16:54:09.91 kernel pc: 0x00000000806a65b8 usedb+0x58(0x0000000000000000, 0x7b1a000000000000,


5.
00:0006:00000:00002:2019/01/23 10:43:36.94 server Database 'tempdb' is now online.
00:0006:00000:00002:2019/01/23 10:43:36.94 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
00:0006:00000:00002:2019/01/23 10:43:36.94 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)
...
00:0006:00000:00002:2019/01/23 10:43:36.94 kernel pc: 0x00000000806a65b8 usedb+0x58(0x0000000000000000, 0x7b1a000000000000,
fffff8, 0x000000000000bc00)


6.
00:0002:00000:00002:2019/01/23 12:11:19.25 server Opening Master Database ...
00:0002:00000:00002:2019/01/23 12:11:19.25 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
00:0002:00000:00002:2019/01/23 12:11:19.25 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)
...
00:0002:00000:00002:2019/01/23 12:11:19.26 kernel pc: 0x00000000806a65b8 usedb+0x58(0x0000000000000000, 0x0001000000000000,


7.
00:0002:00000:00002:2019/01/23 13:01:39.74 server Database 'tempdb' is now online.
00:0002:00000:00002:2019/01/23 13:01:39.74 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
00:0002:00000:00002:2019/01/23 13:01:39.74 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)
...
00:0002:00000:00002:2019/01/23 13:01:39.75 kernel pc: 0x00000000806a65b8 usedb+0x58(0x0000000000000000, 0x7b1a000000000000,


8.
00:0002:00000:00002:2019/01/23 14:49:36.76 server Opening Master Database ...
00:0002:00000:00002:2019/01/23 14:49:36.80 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
00:0002:00000:00002:2019/01/23 14:49:36.80 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)
...
00:0002:00000:00002:2019/01/23 14:49:36.80 kernel pc: 0x00000000806a65b8 usedb+0x58(0x0000000000000000, 0x0001000000000000,


9.
00:0002:00000:00002:2019/01/24 07:20:54.73 server Database 'sybsecurity' is now online.
00:0002:00000:00014:2019/01/24 07:20:54.73 server audproc: Loading global audit options from sysauditoptions.
00:0002:00000:00002:2019/01/24 07:20:54.73 kernel Current process (0x19300ca) infected with signal 11 (SIGSEGV)
00:0002:00000:00002:2019/01/24 07:20:54.73 kernel Address 0x00000000817ab5e4 (sparclock+0x4), siginfo (code, address) = (1, 0x0000000000000000)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16 SP03 PL 05 for Solaris
  • SAP Adaptive Server Enterprise (ASE) 16 SP02 PL 07 for Solaris

Product

SAP Adaptive Server Enterprise 16.0

Keywords

SEGV, segmentation, segfault, kisignal, stacktrace,  stack, registers, sysindexes


, KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.