vchebolu
03-20-02, 19:10
| 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 |