Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Location
    New Jersey
    Posts
    7

    Unanswered: Stack trace while deleting rows from a table in Sybase 12.0

    All,
    I have recently migrated from ASE 11.9.2 to 12.0 . I had loaded the databases in 12.0 with pre-12.0 dumps and brought the databases online.

    I am getting a stack trace when I try to delete a row from a table which has delete trigger on it. I am able to delete by dropping the trigger and manually carrying out the operations in the trigger.


    The stack trace is as follows

    00:00000:00009:2002/03/20 13:51:48.84 server Could not find virtual page for logical page 1308961064 in database 'mydatabase'.
    00:00000:00009:2002/03/20 13:51:48.84 kernel ************************************
    00:00000:00009:2002/03/20 13:51:48.84 kernel SQL causing error : exec my_delete_procedure
    00:00000:00009:2002/03/20 13:51:48.84 kernel ************************************
    00:00000:00009:2002/03/20 13:51:48.84 server SQL Text: exec my_delete_procedure
    00:00000:00009:2002/03/20 13:51:48.84 kernel curdb = 5 pstat = 0x10108 lasterror = 806
    00:00000:00009:2002/03/20 13:51:48.84 kernel preverror = 0 transtate = 0
    00:00000:00009:2002/03/20 13:51:48.84 kernel curcmd = 196 program = isql
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00633430 pcstkwalk+0x24(0xde90fe60, 0x00000000, 0x0000270f, 0x00000002, 0xfffffff8)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x0063333c ucstkgentrace+0x194(0x00140014, 0xdedd9380, 0xdedd9380, 0xdeaa0248, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00603138 ucbacktrace+0xa8(0xdeaa0248, 0x00000001, 0x00140014, 0xded937a0, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x000f43f0 terminate_process+0xcf8(0x00bc1494, 0x000054e8, 0x000054e4, 0xffffffff, 0x00005000)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x0013a9a4 hdl_default+0x48(0x00000008, 0x00000006, 0x00000015, 0x00000001, 0xde9101f0)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00399814 s_handle+0x1100(0x00006800, 0x00000015, 0x00000001, 0xdedd9380, 0xde9101f0)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x0013a550 ex_raise+0x1ac(0xdedde8c0, 0x00000000, 0x00000015, 0x00000001, 0x4e052928)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00177318 log_to_virt+0x4c(0xdf4f0984, 0x4e052928, 0x00000005, 0xffffffff, 0x00000001)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00177148 virtmap+0x88(0x00000000, 0x00000000, 0xdf4f0984, 0x00000005, 0xfd8d4398)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00174e04 bufgrab+0x22c(0x00000001, 0x00000000, 0xdec33d80, 0xffffffff, 0x00000004)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00280960 getpage_with_validation+0x380(0xdec33d80, 0x00bb2c00, 0x00000000, 0xdec33e14, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00282094 getpage_noscan_with_validation+0x78(0x00006ccc, 0xde91050c, 0xdedd9380, 0x00000000, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00200fdc gettxtpage+0x160(0x4e052928, 0xdec33d80, 0x00000000, 0x00000800, 0xdec33e4c)
    00:00000:00009:2002/03/20 13:51:48.84 kernel [Handler pc: 0x00208dcc text_handler installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x0020371c deletetext+0x1f4(0xde9115a8, 0xde9115a8, 0xdec33d80, 0x00000800, 0xdec33e4c)
    00:00000:00009:2002/03/20 13:51:48.84 kernel [Handler pc: 0x00208dcc text_handler installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00203814 deletetext+0x2ec(0xfd908c88, 0xde9115a8, 0xdec33d80, 0x000000ab, 0x0000002c)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x0045d930 run+0x7f64(0xdec33d80, 0x00000000, 0xfffffff5, 0xfd908b20, 0x00000001)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x0041741c exec_eop+0x510(0x00002000, 0xdedd9380, 0x00000000, 0x00000000, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x00417598 exec_eop+0x68c(0x00002000, 0xdedd9380, 0xe0038888, 0x00000000, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.84 kernel [Handler pc: 0x0041c244 execerr installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.84 kernel [Handler pc: 0x00558220 jcsExHandler installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.84 kernel [Handler pc: 0x003cf264 sortmerr installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.84 kernel [Handler pc: 0x0041c244 execerr installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.84 kernel [Handler pc: 0x0041c244 execerr installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.84 kernel [Handler pc: 0x0035a7a8 aritherr installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.84 kernel pc: 0x0041685c execute+0xb78(0xe003a240, 0x0000702c, 0xe003a240, 0xdedd9380, 0x00005000)
    00:00000:00009:2002/03/20 13:51:48.84 kernel [Handler pc: 0x0013a7a0 hdl_backout installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x0037ee28 s_execute+0x2288(0x80000000, 0x000000c4, 0xe003a240, 0x00005393, 0x00001000)
    00:00000:00009:2002/03/20 13:51:48.85 kernel [Handler pc: 0x00398714 s_handle installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x003957e4 sequencer+0x10d8(0x00bb2c00, 0x00bc1400, 0xde813280, 0x00005388, 0xdedd9380)
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x003865f4 exectrig+0x420(0x00000000, 0x00005400, 0x00000001, 0x00400000, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.85 kernel [Handler pc: 0x0013a7a0 hdl_backout installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x00381388 s_execute+0x47e8(0x00bc1400, 0x00bb5000, 0xde813280, 0x00000004, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.85 kernel [Handler pc: 0x00398714 s_handle installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x003957e4 sequencer+0x10d8(0x00bb2c00, 0x00bc1400, 0xde813280, 0x00005388, 0xdedd9380)
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x00385ea8 execproc+0x734(0x00000019, 0xdedd9380, 0x00000001, 0x00000005, 0x00000001)
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x0037f2f4 s_execute+0x2754(0x00bc1400, 0x00bb5000, 0xde813280, 0x00000004, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.85 kernel [Handler pc: 0x00398714 s_handle installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x003957e4 sequencer+0x10d8(0x00bb2c00, 0x00bc1400, 0xde813280, 0x00005388, 0xdedd9380)
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x00385ea8 execproc+0x734(0x0000001b, 0xdedd9380, 0x00000001, 0x00000005, 0x00000001)
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x0037f2f4 s_execute+0x2754(0x00bc1400, 0x00bb5000, 0xde813280, 0x00000004, 0x00000000)
    00:00000:00009:2002/03/20 13:51:48.85 kernel [Handler pc: 0x00398714 s_handle installed by the following function:-]
    00:00000:00009:2002/03/20 13:51:48.85 kernel pc: 0x003957e4 sequencer+0x10d8(0x00bb2c00, 0x00bc1400, 0xde813280, 0x00005388, 0xdedd9380)
    00:00000:00009:2002/03/20 13:51:48.85 kernel end of stack trace, spid 9, kpid 1310740, suid 1


    Can anyone tell me why this is happening. I am on the base release of Sybase 12.0 . I am currently downloading the EBF to rollup to 12.0.1 . I wanted to check if anyone had experienced similar issues and if yes, any suggestions would be helpful.

    Thanks,
    Chebolu

  2. #2
    Join Date
    Mar 2002
    Location
    New Jersey
    Posts
    7
    Applying EBF 10044 solved the issue. I was hitting Bug 8947

    A trigger with the statement 'rollback trigger with raiserror ' will fail during trigger execution and the message 'process infected with signal 11' with a stack trace including the modules 's_execute', 'execproc', and 'sequencer'will be printed in the error log.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •