I have done that but no error is occuring On Tue, Mar 23, 2010 at 12:31 PM, Rad! <conradakunga@gmail.com> wrote:
Presumably this is Sybase ASA on Unix or Linux
If so first try dropping and recreating the errant procedure csp_get_accrue_bal
On Tue, Mar 23, 2010 at 12:23 PM, wambugu esther <essiekui@gmail.com>wrote:
Hi guys, im having this error when i run some application in the sybase server..the funny thing is it disconnects the server and sometimes shutdown the database server.. Is there anyone who can help on this:
the error is:
04:00000:00148:2010/03/23 12:13:16.21 kernel current process (0xd600d6) infecte d with 10 04:00000:00148:2010/03/23 12:13:16.21 kernel Error at address 0x4000000000548d0 b (getpage_with_validation+0x193) 04:00000:00148:2010/03/23 12:13:16.21 kernel ir=0000000000000000.400000000054cd 07 04:00000:00148:2010/03/23 12:13:16.21 kernel pc=0000000000000000.4000000000548d 0f psw=0000000000000000 04:00000:00148:2010/03/23 12:13:16.21 kernel gr0-3 0000000000000000 000000000 0000000 4000000000548e97 400000000054cbdf 04:00000:00148:2010/03/23 12:13:16.22 kernel gr4-7 c000000051881b40 800000000 0396b60 0000000000000000 c00000008c312708 04:00000:00148:2010/03/23 12:13:16.22 kernel gr8-11 800000000040fc98 000000000 0000000 0000000000000000 0000000000000000 04:00000:00148:2010/03/23 12:13:16.22 kernel gr12-15 c00000008c312708 000000000 0000020 c000000044f6f138 0000000000000000 04:00000:00148:2010/03/23 12:13:16.22 kernel gr16-19 0000000000000000 000000000 0000001 0000000000000901 0000000000000001 04:00000:00148:2010/03/23 12:13:16.22 kernel gr20-23 c00000008c312708 000000000 0000000 0000000000000002 0000000000000000 04:00000:00148:2010/03/23 12:13:16.22 kernel gr24-27 c000000042b7e8b0 c00000004 002b280 0000000000000000 80000000003aeec0 04:00000:00148:2010/03/23 12:13:16.22 kernel gr28-31 0000000000000000 c00000004 1a74300 c000000044f6f5a0 c00000004001e500 04:00000:00148:2010/03/23 12:13:16.22 kernel ********************************** ** 04:00000:00148:2010/03/23 12:13:16.22 kernel SQL causing error : EXEC csp_get_a ccrue_bal '2010-03-19', 220, '', NULL 04:00000:00148:2010/03/23 12:13:16.23 kernel ********************************** ** 04:00000:00148:2010/03/23 12:13:16.23 server SQL Text: EXEC csp_get_accrue_bal '2010-03-19', 220, '', NULL 04:00000:00148:2010/03/23 12:13:16.23 kernel curdb = 4 pstat = 0x10010000 laste rror = 0 04:00000:00148:2010/03/23 12:13:16.23 kernel preverror = 0 transtate = 1 04:00000:00148:2010/03/23 12:13:16.23 kernel curcmd = 264 program =
04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x4000000000b571f0 pcstkwalk+0 x50() 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x4000000000b57a90 ucstkgentra ce+0x2c8() 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x4000000000b1f6a0 ucbacktrace +0x80() 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x400000000043d08c terminate_p rocess+0xfa4() 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x4000000000b35bd0 kisignal+0x 108() 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x40000000005db510 _sigreturn( ) 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x4000000000548d08 getpage_wit h_validation+0x190() 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x400000000054bb30 dol_bt_getn ext+0x438() 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x4000000000515de4 getnext+0xf 4() 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x400000000053b638 exec_eop+0x 488() 04:00000:00148:2010/03/23 12:13:16.23 kernel pc: 0x400000000053c080 exec_eop+0x ed0() 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x400000000095c970 ex ecerr installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x4000000000a60898 jc sExHandler installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x40000000009177c8 so rtmerr installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x400000000095c970 ex ecerr installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x400000000095c970 ex ecerr installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x40000000006b8520 ar itherr installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x400000000053d950 execute+0x4 48() 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x40000000005950c0 curs_fetch+ 0x88() 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x40000000005407c8 s_execute+0 x1658() 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x40000000003e0518 s_ handle installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x4000000000578a58 sequencer+0 x268() 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x400000000057a6c4 execproc+0x 424() 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x4000000000541134 s_execute+0 x1fc4() 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x40000000003e0518 s_ handle installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x4000000000578a58 sequencer+0 x268() 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x4000000000462160 tdsrecv_lan guage+0xb0() 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x40000000006b70a8 hd l_backout installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x400000000088dc70 ut _handle installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel [Handler pc: 0x400000000088dc70 ut _handle installed by the following function:-] 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x40000000005969ec conn_hdlr+0 x774() 04:00000:00148:2010/03/23 12:13:16.24 kernel pc: 0x400000000053d500 proc_stack_ switch+0x60() 04:00000:00148:2010/03/23 12:13:16.24 kernel end of stack trace, spid 148, kpid 14024918, suid 1667 --
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Best regards Esther Wambugu