Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Got error when running sp

4 posts in General Discussion Last posting was on 2009-11-13 02:18:58.0Z
Taylor Posted on 2009-11-12 11:14:14.0Z
From: Taylor <heroxulei@hotmail.com>
Newsgroups: sybase.public.ase.general
Subject: Got error when running sp
Date: Thu, 12 Nov 2009 03:14:14 -0800 (PST)
Organization: http://groups.google.com
Lines: 76
Message-ID: <746ded66-522c-437e-a6c4-5ce68801fe1c@z41g2000yqz.googlegroups.com>
NNTP-Posting-Host: 205.181.240.194
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1258024454 22377 127.0.0.1 (12 Nov 2009 11:14:14 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 12 Nov 2009 11:14:14 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z41g2000yqz.googlegroups.com; posting-host=205.181.240.194; posting-account=CZamOQoAAAAUHTdhCDOUmRkybCZwE5Ph
User-Agent: G2/1.0
X-HTTP-Via: 1.0 nowbdcpx01b.statestr.com:80 (IronPort-WSA/5.6.2-102)
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
X-Original-Bytes: 5310
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!z41g2000yqz.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28630
Article PK: 77870

Hi,

I got error when running sp today. The sp used to work fine two days
ago. I found a stack trace in the errorlog. Can anyone advice?

00:00000:00494:2009/11/12 05:48:04.01 kernel curdb = 6 tempdb = 2
pstat = 0x10000
00:00000:00494:2009/11/12 05:48:04.01 kernel lasterror = 0 preverror
= 0 transtate = 1
00:00000:00494:2009/11/12 05:48:04.01 kernel curcmd = 224 program =
DBArtisan
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x00858ee4 pcstkwalk
+0x28(0x00000000, 0x5a39490c, 0x0000270f, 0x00000002, 0x00000000)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x00858dd0
ucstkgentrace+0x1ac(0x66a44958, 0x67790b70, 0x0000270f, 0x00000000,
0x00000000)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x007fcfd4
ucbacktrace+0xa8(0x00000000, 0x00000001, 0x0000001e, 0x66a53444,
0x56c00000)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x0017f03c
terminate_process+0xea4(0x66a44958, 0x00000000, 0x00000000,
0x00000000, 0x00006ee4)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x0081d140 kisignal
+0x1ac(0x014262a4, 0x0001ac00, 0x01569800, 0x00000001, 0x66a44958)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0xff0c5924 __sighndlr
+0xc(0x0000000b, 0x5a3959d8, 0x5a395720, 0x0081cf94, 0x00000000)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0xff0ba868
call_user_handler+0x3b8(0x0000000b, 0x00000000, 0x00000008,
0x00000000, 0xff162000)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004adb3c
norm3_propagate+0x460(0x694aa000, 0x5a395b1c, 0x5a395b18, 0x6bf62658,
0x66a4a158)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x00497780 clean_vars
+0x1c(0x694aa000, 0x5a395b84, 0x5a395b80, 0x6bf622f0, 0xffffffe0)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e5cb4
s_normquery+0x1b0(0x00000000, 0x6bf62120, 0x00000000, 0x6bf622f0,
0x66a4a4c4)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004ea958
s__call_normquery+0xec(0x6bf622f8, 0x00000001, 0x6d6bd800, 0x0156a800,
0x00008000)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e4a58
s_normalize+0x2e4(0x000059d4, 0x00000000, 0x6bf62120, 0x000059d0,
0x00000006)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e6b90
s_renormalize+0x80(0x6e4da800, 0x6d6bd800, 0x00000006, 0x00006c00,
0x00000001)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e68d4
s_recompile+0x43c(0x00005800, 0x66a4b558, 0x014dbc00, 0x66a4a158,
0x000059d0)
00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x004e762c
s_handle installed by the following function:-]
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e36b4 sequencer
+0xbc0(0x6e4da800, 0x00000000, 0x00000016, 0x5a396048, 0x00000006)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004cfd08 execproc
+0x928(0x00000000, 0x00000006, 0x00005800, 0x00000163, 0x00000000)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004c8124 s_execute
+0x2a10(0x00000000, 0x56ed4fc0, 0x00000001, 0x014de000, 0x00e66800)
00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x004e762c
s_handle installed by the following function:-]
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e3bfc sequencer
+0x1108(0x00007400, 0x014de000, 0x66a4a550, 0x00007720, 0x66a4a4c4)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x001b0628
tdsrecv_language+0xb4(0x66a4a158, 0x00000000, 0x66a4a158, 0x00000021,
0x00006c00)
00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x001da058
hdl_backout installed by the following function:-]
00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x00456738
ut_handle installed by the following function:-]
00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x00456738
ut_handle installed by the following function:-]
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x001c2518 conn_hdlr
+0x2244(0x01571c00, 0x66a4a158, 0x66a4b558, 0xffffffff, 0x00000001)
00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x0086ee64 _coldstart
(0x000000c9, 0x001c02d4, 0x00000000, 0x00000000, 0x00000000)
00:00000:00494:2009/11/12 05:48:04.01 kernel end of stack trace, spid
494, kpid 793903447, suid 1


Taylor Posted on 2009-11-12 11:15:14.0Z
From: Taylor <heroxulei@hotmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Got error when running sp
Date: Thu, 12 Nov 2009 03:15:14 -0800 (PST)
Organization: http://groups.google.com
Lines: 81
Message-ID: <a21e09ce-ac21-4049-ae2b-59e50a32a12b@h34g2000yqm.googlegroups.com>
References: <746ded66-522c-437e-a6c4-5ce68801fe1c@z41g2000yqz.googlegroups.com>
NNTP-Posting-Host: 205.181.240.194
Mime-Version: 1.0
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1258024515 22765 127.0.0.1 (12 Nov 2009 11:15:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 12 Nov 2009 11:15:15 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: h34g2000yqm.googlegroups.com; posting-host=205.181.240.194; posting-account=CZamOQoAAAAUHTdhCDOUmRkybCZwE5Ph
User-Agent: G2/1.0
X-HTTP-Via: 1.0 nowbdcpx01b.statestr.com:80 (IronPort-WSA/5.6.2-102)
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!h34g2000yqm.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28631
Article PK: 77874


On 11月12日, 下午7时14分, Taylor <heroxu...@hotmail.com> wrote:
> Hi,
>
> I got error when running sp today. The sp used to work fine two days
> ago. I found a stack trace in the errorlog. Can anyone advice?
>
> 00:00000:00494:2009/11/12 05:48:04.01 kernel curdb = 6 tempdb = 2
> pstat = 0x10000
> 00:00000:00494:2009/11/12 05:48:04.01 kernel lasterror = 0 preverror
> = 0 transtate = 1
> 00:00000:00494:2009/11/12 05:48:04.01 kernel curcmd = 224 program =
> DBArtisan
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x00858ee4 pcstkwalk
> +0x28(0x00000000, 0x5a39490c, 0x0000270f, 0x00000002, 0x00000000)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x00858dd0
> ucstkgentrace+0x1ac(0x66a44958, 0x67790b70, 0x0000270f, 0x00000000,
> 0x00000000)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x007fcfd4
> ucbacktrace+0xa8(0x00000000, 0x00000001, 0x0000001e, 0x66a53444,
> 0x56c00000)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x0017f03c
> terminate_process+0xea4(0x66a44958, 0x00000000, 0x00000000,
> 0x00000000, 0x00006ee4)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x0081d140 kisignal
> +0x1ac(0x014262a4, 0x0001ac00, 0x01569800, 0x00000001, 0x66a44958)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0xff0c5924 __sighndlr
> +0xc(0x0000000b, 0x5a3959d8, 0x5a395720, 0x0081cf94, 0x00000000)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0xff0ba868
> call_user_handler+0x3b8(0x0000000b, 0x00000000, 0x00000008,
> 0x00000000, 0xff162000)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004adb3c
> norm3_propagate+0x460(0x694aa000, 0x5a395b1c, 0x5a395b18, 0x6bf62658,
> 0x66a4a158)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x00497780 clean_vars
> +0x1c(0x694aa000, 0x5a395b84, 0x5a395b80, 0x6bf622f0, 0xffffffe0)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e5cb4
> s_normquery+0x1b0(0x00000000, 0x6bf62120, 0x00000000, 0x6bf622f0,
> 0x66a4a4c4)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004ea958
> s__call_normquery+0xec(0x6bf622f8, 0x00000001, 0x6d6bd800, 0x0156a800,
> 0x00008000)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e4a58
> s_normalize+0x2e4(0x000059d4, 0x00000000, 0x6bf62120, 0x000059d0,
> 0x00000006)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e6b90
> s_renormalize+0x80(0x6e4da800, 0x6d6bd800, 0x00000006, 0x00006c00,
> 0x00000001)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e68d4
> s_recompile+0x43c(0x00005800, 0x66a4b558, 0x014dbc00, 0x66a4a158,
> 0x000059d0)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x004e762c
> s_handle installed by the following function:-]
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e36b4 sequencer
> +0xbc0(0x6e4da800, 0x00000000, 0x00000016, 0x5a396048, 0x00000006)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004cfd08 execproc
> +0x928(0x00000000, 0x00000006, 0x00005800, 0x00000163, 0x00000000)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004c8124 s_execute
> +0x2a10(0x00000000, 0x56ed4fc0, 0x00000001, 0x014de000, 0x00e66800)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x004e762c
> s_handle installed by the following function:-]
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x004e3bfc sequencer
> +0x1108(0x00007400, 0x014de000, 0x66a4a550, 0x00007720, 0x66a4a4c4)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x001b0628
> tdsrecv_language+0xb4(0x66a4a158, 0x00000000, 0x66a4a158, 0x00000021,
> 0x00006c00)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x001da058
> hdl_backout installed by the following function:-]
> 00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x00456738
> ut_handle installed by the following function:-]
> 00:00000:00494:2009/11/12 05:48:04.01 kernel [Handler pc: 0x00456738
> ut_handle installed by the following function:-]
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x001c2518 conn_hdlr
> +0x2244(0x01571c00, 0x66a4a158, 0x66a4b558, 0xffffffff, 0x00000001)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel pc: 0x0086ee64 _coldstart
> (0x000000c9, 0x001c02d4, 0x00000000, 0x00000000, 0x00000000)
> 00:00000:00494:2009/11/12 05:48:04.01 kernel end of stack trace, spid
> 494, kpid 793903447, suid 1

Adaptive Server Enterprise/12.5.3/EBF 12330 ESD#1/P/Sun_svr4/OS 5.8/
ase1253/1900/32-bit/FBO/Tue Jan 25 07:02:08 2005


Bret Halford Posted on 2009-11-12 16:19:33.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Got error when running sp
References: <746ded66-522c-437e-a6c4-5ce68801fe1c@z41g2000yqz.googlegroups.com> <a21e09ce-ac21-4049-ae2b-59e50a32a12b@h34g2000yqm.googlegroups.com>
In-Reply-To: <a21e09ce-ac21-4049-ae2b-59e50a32a12b@h34g2000yqm.googlegroups.com>
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4afc3595$1@forums-1-dub>
Date: 12 Nov 2009 08:19:33 -0800
X-Trace: forums-1-dub 1258042773 10.22.241.152 (12 Nov 2009 08:19:33 -0800)
X-Original-Trace: 12 Nov 2009 08:19:33 -0800, vip152.sybase.com
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28632
Article PK: 77873

As the procedure is having to renormalize, I suspect that
one of the objects it depends on was dropped and rebuilt,
which would cause ASE to have to renormalize the query tree.

I don't find an exact match for this stacktrace, but it seems
a bit similar to CR 380122 which was fixed in 12.5.4 and 15.0.2.

You might try dropping and creating the procedure from it's source
code, that might either just work or point more directly to a problem
with one of the dependent objects.

-bret


Taylor Posted on 2009-11-13 02:18:58.0Z
From: Taylor <heroxulei@hotmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Got error when running sp
Date: Thu, 12 Nov 2009 18:18:58 -0800 (PST)
Organization: http://groups.google.com
Lines: 16
Message-ID: <cbbdf72a-8b61-4d2f-a514-9aedfb388a18@o10g2000yqa.googlegroups.com>
References: <746ded66-522c-437e-a6c4-5ce68801fe1c@z41g2000yqz.googlegroups.com> <a21e09ce-ac21-4049-ae2b-59e50a32a12b@h34g2000yqm.googlegroups.com> <4afc3595$1@forums-1-dub>
NNTP-Posting-Host: 205.181.240.194
Mime-Version: 1.0
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1258078738 19808 127.0.0.1 (13 Nov 2009 02:18:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 13 Nov 2009 02:18:58 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: o10g2000yqa.googlegroups.com; posting-host=205.181.240.194; posting-account=CZamOQoAAAAUHTdhCDOUmRkybCZwE5Ph
User-Agent: G2/1.0
X-HTTP-Via: 1.0 nowbdcpx01b.statestr.com:80 (IronPort-WSA/5.6.2-102)
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!transit4.readnews.com!postnews.google.com!o10g2000yqa.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28635
Article PK: 77877


On 11月13日, 上午12时19分, Bret Halford <b...@sybase.com> wrote:
> As the procedure is having to renormalize, I suspect that
> one of the objects it depends on was dropped and rebuilt,
> which would cause ASE to have to renormalize the query tree.
>
> I don't find an exact match for this stacktrace, but it seems
> a bit similar to CR 380122 which was fixed in 12.5.4 and 15.0.2.
>
> You might try dropping and creating the procedure from it's source
> code, that might either just work or point more directly to a problem
> with one of the dependent objects.
>
> -bret

Greate, thank you very much