Hello,

I have sybase 12.5.4, runing in red hat 4.7, 64bits, 8 processors and 16GB ram.
When I run a procedure to get statitics tables, I get the message down, I get to run the command outside the procedure with success, the error occurr in procedure only.

current process (0x210021) infected with 11
Address 0x0x0000000000a48252 (bt_curscanpg+0x12), siginfo (code, address) = (1, 0x(nil))
************************************
SQL causing error : advlang
************************************
SQL Text: advlang
curdb = 4 tempdb = 2 pstat = 0x10000
lasterror = 0 preverror = 0 transtate = 1
curcmd = 326 program = isql
pc: 0x0x0000000000b26449 pcstkwalk+0x289()
pc: 0x0x0000000000b2607f ucstkgentrace+0x17f()
pc: 0x0x0000000000adc4df ucbacktrace+0x8f()
pc: 0x0x00000000004481ff terminate_process+0xc2f()
pc: 0x0x0000000000af7335 kisignal+0x195()
pc: 0x0x0000000000a48252 bt_curscanpg+0x12()
pc: 0x0x000000000064a8fa scan_curindexpg+0x3a()
pc: 0x0x00000000008360e0 stu_subst_rcopy+0xd0()
pc: 0x0x000000000061e6fa getnext+0x13a()
pc: 0x0x0000000000833936 ups_deadlock_getnext+0x26()
[Handler pc: 0x0x0000000000716c00 ut_handle installed by the following function:-]
pc: 0x0x00000000008331a2 ups_build+0x262()
pc: 0x0x0000000000831eef update_statistics+0x12f()
[Handler pc: 0x0x0000000000716c00 ut_handle installed by the following function:-]
pc: 0x0x00000000008317f1 ups_main+0x371()
pc: 0x0x00000000007971df s_execute+0x4e93()
[Handler pc: 0x0x00000000007bbf00 s_handle installed by the following function:-]
pc: 0x0x00000000007b7e5b sequencer+0x49b()
[Handler pc: 0x0x00000000006cc260 intsql__handle installed by the following function:-]
pc: 0x0x00000000006cb9be internal_sql+0x53e()
pc: 0x0x00000000007959e3 s_execute+0x3697()
[Handler pc: 0x0x00000000007bbf00 s_handle installed by the following function:-]
pc: 0x0x00000000007b7e5b sequencer+0x49b()
pc: 0x0x00000000007a0056 execproc+0xbca()
pc: 0x0x0000000000795ee1 s_execute+0x3b95()
[Handler pc: 0x0x00000000007bbf00 s_handle installed by the following function:-]
pc: 0x0x00000000007b7e5b sequencer+0x49b()
pc: 0x0x000000000047aee0 tdsrecv_language+0x290()
[Handler pc: 0x0x00000000004a16c0 hdl_backout installed by the following function:-]
[Handler pc: 0x0x0000000000716c00 ut_handle installed by the following function:-]
[Handler pc: 0x0x0000000000716c00 ut_handle installed by the following function:-]
pc: 0x0x0000000000488258 conn_hdlr+0x9a8()
pc: 0x0x0000000000b12c88 kpstartproc+0x48()
pc: 0x0x0000000000b12c36 kpinitproc+0xc6()
end of stack trace, spid 16, kpid 2162721, suid 1

After ran dbcc reindex the procedure worked.

Ambrozio.