Could you paste some last lines from /var/log/messages so that we have some idea what's going on. cat /var/log/messages or cat /var/log/messages | grep kernel On Tue, Mar 23, 2010 at 1:48 PM, wambugu esther <essiekui@gmail.com> wrote:
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
_______________________________________________ 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