how well can you identify these issues. On Tue, Mar 23, 2010 at 1:31 PM, Haggai Nyang <haggai.nyang@gmail.com>wrote:
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
On Tue, Mar 23, 2010 at 1:25 PM, wambugu esther <essiekui@gmail.com>wrote:
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 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
--
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-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
_______________________________________________ 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