Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    3

    Unhappy Unanswered: Infected with 11

    Hello all;

    I'm working with ASE 11.9.3 SWR 9450 ESD 9 on Digital Unix V4.0D, sometimes when I'm running one stored procedure called sp_busca_cuotas_aseg_new I got a message infected with 11 in the errorlog; I don't have any corrupt table or object in the database; I recreated the stored procedure many times and always I got the same error, moreover I ran diagnostics on the machine but everything is ok.

    This is the message in the errorlog:

    02:00000:00421:2002/09/30 09:45:04.17 kernel current process (0x9ff0190) infected with 11
    02:00000:00421:2002/09/30 09:45:04.18 kernel Error at address 0x000003ff800ce060 (_call_remove_gp_range)
    02:00000:00421:2002/09/30 09:45:04.18 kernel ************************************
    02:00000:00421:2002/09/30 09:45:04.18 kernel SQL causing error : exec sp_busca_cuotas_aseg_new 234130
    02:00000:00421:2002/09/30 09:45:04.18 kernel ************************************
    02:00000:00421:2002/09/30 09:45:04.18 server SQL Text: exec sp_busca_cuotas_aseg_new 234130
    02:00000:00421:2002/09/30 09:45:04.18 kernel curdb = 5 pstat = 0x50000 lasterror = 0
    02:00000:00421:2002/09/30 09:45:04.18 kernel preverror = 0 transtate = 1
    02:00000:00421:2002/09/30 09:45:04.18 kernel curcmd = 193 program =
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012064dac0 pcstkwalk+0x60()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012064d7b8 ucstkgentrace+0x1e8()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x0000000120622850 ucbacktrace+0xc0()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x00000001200a4f10 terminate_process+0xad0()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012065cd60 kisignal+0x140()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000003ff800d0ba0 _call_remove_gp_range+0x3fe5f9c8910()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012048c5e0 static procedure (no name)+0x210()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012048c5e0 static procedure (no name)+0x210()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012048bdf8 s_exec_subquery+0xc8()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x0000000120471d68 run+0x14d88()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012044c890 exec_eop+0xf60()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012044c910 exec_eop+0xfe0()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012044c910 exec_eop+0xfe0()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012044c910 exec_eop+0xfe0()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012044c910 exec_eop+0xfe0()
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x0000000120450cb0 execerr installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x00000001203d5660 sortmerr installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x0000000120450cb0 execerr installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x0000000120450cb0 execerr installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x00000001203602c0 aritherr installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012044b0f8 execute+0xf88()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x0000000120386d70 s_execute+0x28b0()
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x0000000120364f80 s_handle installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x0000000120361f40 sequencer+0x10c0()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x000000012038d094 execproc+0x8e4()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x0000000120386a10 s_execute+0x2550()
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x0000000120364f80 s_handle installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x0000000120361f40 sequencer+0x10c0()
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x00000001200d5314 tdsrecv_language+0x3c4()
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x00000001200f4740 hdl_backout installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x00000001202decd0 ut_handle installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel [Handler pc: 0x00000001202decd0 ut_handle installed by the following function:-]
    02:00000:00421:2002/09/30 09:45:04.18 kernel pc: 0x00000001200ab9b0 conn_hdlr+0x2560()
    02:00000:00421:2002/09/30 09:45:04.18 kernel end of stack trace, spid 421, kpid 167707024, suid 1134

    I appreciated any help

    Maricel

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya Maricel,

    Stack traces can be best investigated through Sybase Technical Support.

    One thing that I'd like to say is move away from 11.9.3, upgrade to ASE 12.0(Dump and Load)

    Cheers
    Willy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •