ASE 12.5.3 Stack trace

louws · #1 (**permalink**) 07-02-08, 16:52

Hi

I installed an HP-UX 11iv3 server with Sybase ASE 12.5.3. Also configured the system as to the software vendors specification.

When a user commits a specific transaction to the database, he recieves a generic application error.

But when I view the sybase log file, I find a stack trace at exactly the same time then the user tried to commit the transaction.

03:00000:00051:2008/07/02 20:41:32.80 kernel current process (0x1f001f) infected with 11
03:00000:00051:2008/07/02 20:41:32.80 kernel Error at address 0x40000000008b07c7 (set_cast+0x89f)
03:00000:00051:2008/07/02 20:41:32.82 kernel ir=0000000005926c00.0000000000000020
03:00000:00051:2008/07/02 20:41:32.82 kernel pc=000000000268d400.40000000008b07cb psw=0000000000000001
03:00000:00051:2008/07/02 20:41:32.82 kernel gr0-3 0000000000000000 000000000000003f c00000001f28c000 c00000
001f319780
03:00000:00051:2008/07/02 20:41:32.82 kernel gr4-7 0000000000000037 0000000000000038 c00000001175d304 000000
0000000023
03:00000:00051:2008/07/02 20:41:32.82 kernel gr8-11 000000000000000b 800000000025b770 0000000000000037 000000
0000000080
03:00000:00051:2008/07/02 20:41:32.82 kernel gr12-15 80000000005e28e0 8000000000615a28 0000000000000055 000000
0000000024
03:00000:00051:2008/07/02 20:41:32.82 kernel gr16-19 0000000000000080 c00000001a128420 0000000000000000 000000
000471b57b
03:00000:00051:2008/07/02 20:41:32.82 kernel gr20-23 c00000001f31bff0 0000000000000000 c00000001a12d568 000000
0000000080
03:00000:00051:2008/07/02 20:41:32.82 kernel gr24-27 c00000001f11f428 0000000000000020 0000000000000000 800000
00005fc0e0
03:00000:00051:2008/07/02 20:41:32.82 kernel gr28-31 0000000040000020 c00000001f11f520 c00000001175d610 000000
0040000000
03:00000:00051:2008/07/02 20:41:32.83 kernel ************************************
03:00000:00051:2008/07/02 20:41:32.83 kernel SQL causing error : .770000,NULL,NULL,NULL,NULL,NULL,NULL,
NULL, NULL,'M', 'M', 'M', 'M', NULL,
NULL,
NULL
Select @nRC
03:00000:00051:2008/07/02 20:41:32.83 kernel ************************************
03:00000:00051:2008/07/02 20:41:32.83 server SQL Text: .770000,NULL,NULL,NULL,NULL,NULL,NULL,
NULL, NULL,'M', 'M', 'M', 'M', NULL,
NULL,
NULL
Select @nRC
03:00000:00051:2008/07/02 20:41:32.83 kernel curdb = 5 tempdb = 2 pstat = 0x10000
03:00000:00051:2008/07/02 20:41:32.83 kernel lasterror = 0 preverror = 0 transtate = 0
03:00000:00051:2008/07/02 20:41:32.83 kernel curcmd = 224 program = CENTURA Sybase App
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000e8e280 pcstkwalk+0x50()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000e8eb20 ucstkgentrace+0x2c8()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000e4ad30 ucbacktrace+0x80()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008e36e8 terminate_process+0xf00()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000e677a8 kisignal+0x230()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000869800 _sigreturn()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008b07c4 set_cast+0x89c()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000916e40 n3__subq_set_cast+0x40()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008d4884 n3_binaryop+0x344()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008be728 norm3_expr+0x438()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008bf120 norm3_propagate+0x188()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000006cf158 norm3+0x18()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000006ced34 norm3__idriver+0x9c()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000006cec5c norm3_driver+0x3c()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000006cebd4 normalize+0x7c()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008b1220 s_normquery+0x170()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008a6ab4 s__call_normquery+0x9c()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000890f4c s_normalize+0x14c()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000bea824 s_renormalize+0xc4()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000939b3c s_recompile+0x53c()
03:00000:00051:2008/07/02 20:41:32.83 kernel [Handler pc: 0x400000000068bb10 s_handle installed by the followi
ng function:-]
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000811984 sequencer+0x8ac()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008103a0 execproc+0x4b8()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000007a8634 s_execute+0x2094()
03:00000:00051:2008/07/02 20:41:32.83 kernel [Handler pc: 0x400000000068bb10 s_handle installed by the followi
ng function:-]
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x400000000081133c sequencer+0x264()
03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008103a0 execproc+0x4b8()
03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x40000000007a8634 s_execute+0x2094()
03:00000:00051:2008/07/02 20:41:32.84 kernel [Handler pc: 0x400000000068bb10 s_handle installed by the followi
ng function:-]
03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x400000000081133c sequencer+0x264()
03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x40000000008bca18 tdsrecv_language+0xb0()
03:00000:00051:2008/07/02 20:41:32.84 kernel [Handler pc: 0x4000000000961428 hdl_backout installed by the foll
owing function:-]
03:00000:00051:2008/07/02 20:41:32.84 kernel [Handler pc: 0x4000000000b85328 ut_handle installed by the follow
ing function:-]
03:00000:00051:2008/07/02 20:41:32.84 kernel [Handler pc: 0x4000000000b85328 ut_handle installed by the follow
ing function:-]
03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x4000000000835198 conn_hdlr+0x798()
03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x40000000007b0ce0 proc_stack_switch+0x60()
03:00000:00051:2008/07/02 20:41:32.84 kernel end of stack trace, spid 51, kpid 2031647, suid 1

Can anyone help?

trvishi · #2 (**permalink**) 07-11-08, 11:27

If you see the last meaninful function.

Its set_cast. So, from what it looks like ASE is unable to convert a particular datatype.

It looks like you may be hitting CR 374710

Try doing one of the below
a) drop/recreate stored proc
b) check the datatypes of variables used in the SQL and the column datatypes.
c) traceflag 291 in the startup

louws · #3 (**permalink**) 07-15-08, 16:48

thx trvishi

Trace Flag 291 was already configured at sybase startup, we managed to bypass the error by also configuring T7710.