infected with 11 means the dataserver process received
a signal 11 from the OS. Signal 11 means the process
tried to access a memory address that doesn't belong to it.
So the cause is a bad pointer value in a memory structure.
I don't find any known 12.5.x bugs that are a good match.
The only interesting function name on the stack is
bin__sqlhilo_X, which is used in string comparison.
Is either server using traceflag 1628?
-bret
On 11/28/2010 8:44 PM, Shane wrote:
> Before I take the monumental step of logging a call with
> Sybase I thought I'd leverage the wisdom of the newsgroup
> experts first.
>
> Basically I'm getting a stack trace when executing a stored
> proc within a batch series of sp's, unfortunately that's all
> I get. There is no specific mention of an error and it
> isn't preceded by an error message. Can anyone give me a
> indication as to what it is crashing on in the sp.
>
> This is the version of Sybase we are using
> Adaptive Server Enterprise/12.5.4/EBF 16792 ESD#10/P/Linux
> Intel/Enterprise Linux/ase1254/2159/32-bit/OPT/Mon Nov 2
> 03:16:49 2009
>
> intersting I don' encounter this error on another machine
> without ESD 10.
> Adaptive Server Enterprise/12.5.4/EBF 13388/P/Linux
> Intel/Enterprise Linux/ase1254/2006/32-bit/OPT/Fri May 19
> 23:17:01 2006
>
> Adittidly the resources between these machines are different
> but not hugely, namely difference in RAM (2.7GB and 1.5GB)
> with the former encountering the error, and disk speed.
> Both are in VM enviornments.
>
> 00:00000:00030:2010/11/29 15:14:40.54 kernel Current
> process (0x38230014) infected with signal 11 (SIGSEGV)
> 00:00000:00030:2010/11/29 15:14:40.54 kernel Address
> 0x0x089114f4 (memhilo+0x20), siginfo (code, address) = (1,
> 0x(nil))
> 00:00000:00030:2010/11/29 15:14:40.54 kernel
> ************************************
> 00:00000:00030:2010/11/29 15:14:40.54 kernel SQL causing
> error : xxxx_xxx @batch_no = 37254 , @run_key = 66737
>
> 00:00000:00030:2010/11/29 15:14:40.54 kernel
> ************************************
> 00:00000:00030:2010/11/29 15:14:40.54 server SQL Text:
> xxxx_xxx @batch_no = 37254 , @run_key = 66737
> 00:00000:00030:2010/11/29 15:14:40.54 kernel curdb = 6
> tempdb = 2 pstat = 0x10100
> 00:00000:00030:2010/11/29 15:14:40.54 kernel lasterror = 0
> preverror = 0 transtate = 0
> 00:00000:00030:2010/11/29 15:14:40.54 kernel curcmd = 197
> program = isql
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x088daa1b
> pcstkwalk+0x2b(0x5834b820, 0x5834b5dc, 0x0000270f,
> 0x00000002, 0x09301a58)
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x088da956
> ucstkgentrace+0x1b6(0x38230014, 0x00000002, 0x0000270f,
> (nil), (nil))
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x08875bc0
> ucbacktrace+0xa0((nil), 0x00000001, 0x09301a58, 0x5834c0f8,
> (nil))
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x08183871
> terminate_process+0xcb1((nil), 0xffffffff, 0x09301a58,
> 0x5bf32540, (nil))
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x088a53bf
> kisignal+0x1ff(0x0000000b, 0x5834e10c, 0x5834e18c,
> 0x0000000b, (nil))
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0xb7f36440
> init_dummy+0xaf2f8c90((nil), 0x00000001, 0x5bf32540,
> 0x00000001, 0x09301a58)
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x08576a16
> bin__sqlhilo_X+0x33a(0x5819b100, (nil), 0x00000001,
> 0x5bf32540, 0x00000001)
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x0861be9d
> run+0xfd5(0x5e407800, 0x5e40fc40, 0x09301a58, (nil),
> 0x5e40f8f0)
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x085dd389
> exec_eop+0xf89(0x5e407800, 0x5e40fc40, 0x583520a0,
> 0x09301a58, 0x583520a0)
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x085dca79
> exec_eop+0x679(0x5e407800, 0x5e40f8f0, 0x583520a0,
> 0x5e407800, (nil))
> 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc:
> 0x0x085e0c60 execerr installed by the following function:-]
> 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc:
> 0x0x0875f3f8 jcsExHandler installed by the following
> function:-]
> 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc:
> 0x0x085832ac sortmerr installed by the following function:-]
> 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc:
> 0x0x085e0c60 execerr installed by the following function:-]
> 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc:
> 0x0x085e0c60 execerr installed by the following function:-]
> 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc:
> 0x0x084e7cd4 aritherr installed by the following function:-]
> 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x085dc0b8
> execute+0x9ac(0x5a68e744, 0x5e407800, 0x000000c5,
> 0x583520a0, 0x09301a58)
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08515c06
> s_execute+0x2b1e(0x09301a58, 0x00001000, 0x00000020, (nil),
> 0x58fedac0)
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x081e3710 hdl_stack installed by the following
> function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x085345ac s_handle installed by the following function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559
> sequencer+0x1065(0x5ae46000, 0x09301a58, 0x57f9e720,
> 0x57f9e720, 0x00000020)
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x0851ce24
> execproc+0x970(0x5bb4da80, 0x5bb4db28, (nil), (nil), (nil))
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08516061
> s_execute+0x2f79(0x09301a58, (nil), (nil), (nil),
> 0x5fd455d8)
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x081e3710 hdl_stack installed by the following
> function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x085345ac s_handle installed by the following function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559
> sequencer+0x1065(0x5d6b1000, 0x09301a58, 0x57f9e720,
> 0x57f9e720, (nil))
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x0851ce24
> execproc+0x970(0x5fd455d8, 0x5fd45680, (nil), (nil), (nil))
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08516061
> s_execute+0x2f79(0x09301a58, (nil), (nil), (nil),
> 0x5ad54d28)
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x081e3710 hdl_stack installed by the following
> function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x085345ac s_handle installed by the following function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559
> sequencer+0x1065(0x5f600000, 0x09301a58, 0x57f9e720,
> 0x57f9e720, (nil))
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x0851ce24
> execproc+0x970(0x5ad54d28, 0x5ad54dd0, (nil), (nil), (nil))
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08516061
> s_execute+0x2f79(0x09301a58, (nil), (nil), (nil),
> 0x203d2079)
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x081e3710 hdl_stack installed by the following
> function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x085345ac s_handle installed by the following function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559
> sequencer+0x1065(0x5af8d800, 0x09301a58, (nil), (nil),
> 0x0819809a)
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x081b86b9
> tdsrecv_language+0x2e5((nil), (nil), (nil), (nil), (nil))
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x081e3744 hdl_backout installed by the following
> function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x08494880 ut_handle installed by the following
> function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc:
> 0x0x08494880 ut_handle installed by the following
> function:-]
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x081c8899
> conn_hdlr+0x2c35(0x0000001b, 0x583542ac, 0x895eed31, (nil),
> (nil))
> 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x088cac48
> kpexit((nil), (nil), (nil), 0x581ef100, 0x00000015)
> 00:00000:00030:2010/11/29 15:14:40.56 kernel end of stack
> trace, spid 30, kpid 941817876, suid 15