I am absolutely not a sybase expert but this stinks of a hardware problem.
In my experience all random kernel errors that I see on unix/linux have a physical component to them, either temperature threshold issues or faulty ram sticks.
My Ksh 0.02
yes very many..funny enough this error occurs at diffrent stages.
On Tue, Mar 23, 2010 at 1:19 PM, Rad! <conradakunga@gmail.com> wrote:
You have dropped it completely from the database and created it again? This should generally sort you out.If not then you might have a hardware error -- this error by the way is triggered as a result of a Unix error. Does your application invoke other stored procedures OK?
On Tue, Mar 23, 2010 at 1:11 PM, wambugu esther <essiekui@gmail.com> wrote:
sorry i meant i hv recompiled all procedures but the error is still occuring--
On Tue, Mar 23, 2010 at 1:09 PM, wambugu esther <essiekui@gmail.com> wrote:
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 LinuxIf 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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
Best regards
Esther Wambugu
Best regards
Esther Wambugu
_______________________________________________
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
--
Best regards
Esther Wambugu
_______________________________________________
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke