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.

memory dump

2 posts in General Discussion Last posting was on 2009-12-01 17:19:41.0Z
rick_806 Posted on 2009-11-30 22:35:03.0Z
Sender: 32b9.4b14477a.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.ase.general
Subject: memory dump
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b144897.32d9.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Nov 2009 14:35:03 -0800
X-Trace: forums-1-dub 1259620503 10.22.241.41 (30 Nov 2009 14:35:03 -0800)
X-Original-Trace: 30 Nov 2009 14:35:03 -0800, 10.22.241.41
Lines: 94
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28709
Article PK: 77951

Adaptive Server Enterprise/15.0.1/EBF 14376
ESD#3/P/RS6000/AIX 5.2/ase1501/2410/64-bit

I am getting the following memory dump from what looks like
a simple query. Does anyone know if this is a known issue?

00:00000:00103:2009/11/29 22:22:04.67 kernel current
process (0x30e700a7) infected with 11
00:00000:00103:2009/11/29 22:22:05.00 kernel Error at
address 0x00000001001bf558
(OptGlobal::_GblInitPopRules()+0xda8)
00:00000:00103:2009/11/29 22:22:05.03 server Initiating
shared memory dump for signal 11.
00:00000:00103:2009/11/29 22:22:05.97 kernel Dumping shared
memory to dump file:
/scratch2/11423103/DSS.dmp.2009112922220500
00:00000:00103:2009/11/29 22:22:06.78 kernel Writing
segment 0:
00:00000:00103:2009/11/29 22:22:06.78 kernel Thread (0):
Writing 481142784 bytes starting at 0x160000000
00:00000:00103:2009/11/29 22:24:40.13 kernel Writing
segment 1:
00:00000:00103:2009/11/29 22:24:40.13 kernel Thread (0):
Writing 278243328 bytes starting at 0x2067e1800
00:00000:00103:2009/11/29 22:24:49.30 kernel Writing
segment 2:
00:00000:00103:2009/11/29 22:24:49.30 kernel Thread (0):
Writing 12288 bytes starting at 0x217cd4000
00:00000:00103:2009/11/29 22:24:49.30 kernel
Copying errorlog into dump file.
00:00000:00103:2009/11/29 22:24:49.32 kernel Dump complete
in 164 seconds.
00:00000:00103:2009/11/29 22:24:49.32 kernel 3 segments of
total size 759398400 bytes written to dump file.
00:00000:00103:2009/11/29 22:24:49.36 server Shared memory
dump completed successfully.
00:00000:00103:2009/11/29 22:24:49.41 kernel
************************************
00:00000:00103:2009/11/29 22:24:49.43 kernel SQL causing
error : select count(*) from sybsystemprocs..sysobjects
where name = 'syssegments' and uid = ( select uid from
sybsystemprocs..sysusers where name = 'dbo')
00:00000:00103:2009/11/29 22:24:49.45 kernel
************************************
00:00000:00103:2009/11/29 22:24:49.48 server SQL Text:
select count(*) from sybsystemprocs..sysobjects where name =
'syssegments' and uid = ( select uid from
sybsystemprocs..sysusers where name = 'dbo')
00:00000:00103:2009/11/29 22:24:49.48 kernel curdb = 1
tempdb = 2 pstat = 0x10000
00:00000:00103:2009/11/29 22:24:49.48 kernel lasterror = 0
preverror = 0 transtate = 1
00:00000:00103:2009/11/29 22:24:49.48 kernel curcmd = 0
program = bcp-SQL-BackTrack
00:00000:00103:2009/11/29 22:24:49.56 kernel pc:
0x000000010053662c pcstkwalk+0x84()
00:00000:00103:2009/11/29 22:24:49.56 kernel pc:
0x0000000100536f3c ucstkgentrace+0x1fc()
00:00000:00103:2009/11/29 22:24:49.56 kernel pc:
0x0000000100534d30 ucbacktrace+0x78()
00:00000:00103:2009/11/29 22:24:49.67 kernel pc:
0x00000001006bbf80 terminate_process__fdpr_2+0x864()
00:00000:00103:2009/11/29 22:24:49.72 kernel pc:
0x0000000101c47e30 kisignal+0x14c()
00:00000:00103:2009/11/29 22:24:49.72 kernel pc:
0x0000000000000001 ()
00:00000:00103:2009/11/29 22:24:49.75 kernel pc:
0x0000000100177df4 OptGlobal::GblOptimize(int*)+0x13c()
00:00000:00103:2009/11/29 22:24:49.78 kernel pc:
0x000000010016d784 Optimize+0x11c()
00:00000:00103:2009/11/29 22:24:49.79 kernel pc:
0x00000001002bd828 s_compile_stmt+0x2dc()
00:00000:00103:2009/11/29 22:24:49.79 kernel pc:
0x00000001002bccc4 s_compile__fdpr_9+0x9c()
00:00000:00103:2009/11/29 22:24:49.81 kernel [Handler pc:
0x00000001008dfa54 s_handle+0x0 installed by the following
function:-]
00:00000:00103:2009/11/29 22:24:49.86 kernel pc:
0x00000001002085d8 sequencer__fdpr_4+0x100()
00:00000:00103:2009/11/29 22:24:49.87 kernel pc:
0x0000000100317498 tdsrecv_language+0xcc()
00:00000:00103:2009/11/29 22:24:49.88 kernel [Handler pc:
0x000000010078355c ut_handle+0x0 installed by the following
function:-]
00:00000:00103:2009/11/29 22:24:49.88 kernel pc:
0x000000010021fad4 conn_hdlr__fdpr_7+0x6c()
00:00000:00103:2009/11/29 22:24:49.88 kernel pc:
0x000000010023ea80 kpcoldstart+0x18()
00:00000:00103:2009/11/29 22:24:49.88 kernel end of stack
trace, spid 103, kpid 820445351, suid 1


thx,
rick_806


Bret Halford Posted on 2009-12-01 17:19:41.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: memory dump
References: <4b144897.32d9.1681692777@sybase.com>
In-Reply-To: <4b144897.32d9.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b15502d@forums-1-dub>
Date: 1 Dec 2009 09:19:41 -0800
X-Trace: forums-1-dub 1259687981 10.22.241.152 (1 Dec 2009 09:19:41 -0800)
X-Original-Trace: 1 Dec 2009 09:19:41 -0800, vip152.sybase.com
Lines: 99
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28718
Article PK: 77958

Looks like CR 569572 which is fixed in 15.0.3.

-bret

rick_806 wrote:
> Adaptive Server Enterprise/15.0.1/EBF 14376
> ESD#3/P/RS6000/AIX 5.2/ase1501/2410/64-bit
>
> I am getting the following memory dump from what looks like
> a simple query. Does anyone know if this is a known issue?
>
> 00:00000:00103:2009/11/29 22:22:04.67 kernel current
> process (0x30e700a7) infected with 11
> 00:00000:00103:2009/11/29 22:22:05.00 kernel Error at
> address 0x00000001001bf558
> (OptGlobal::_GblInitPopRules()+0xda8)
> 00:00000:00103:2009/11/29 22:22:05.03 server Initiating
> shared memory dump for signal 11.
> 00:00000:00103:2009/11/29 22:22:05.97 kernel Dumping shared
> memory to dump file:
> /scratch2/11423103/DSS.dmp.2009112922220500
> 00:00000:00103:2009/11/29 22:22:06.78 kernel Writing
> segment 0:
> 00:00000:00103:2009/11/29 22:22:06.78 kernel Thread (0):
> Writing 481142784 bytes starting at 0x160000000
> 00:00000:00103:2009/11/29 22:24:40.13 kernel Writing
> segment 1:
> 00:00000:00103:2009/11/29 22:24:40.13 kernel Thread (0):
> Writing 278243328 bytes starting at 0x2067e1800
> 00:00000:00103:2009/11/29 22:24:49.30 kernel Writing
> segment 2:
> 00:00000:00103:2009/11/29 22:24:49.30 kernel Thread (0):
> Writing 12288 bytes starting at 0x217cd4000
> 00:00000:00103:2009/11/29 22:24:49.30 kernel
> Copying errorlog into dump file.
> 00:00000:00103:2009/11/29 22:24:49.32 kernel Dump complete
> in 164 seconds.
> 00:00000:00103:2009/11/29 22:24:49.32 kernel 3 segments of
> total size 759398400 bytes written to dump file.
> 00:00000:00103:2009/11/29 22:24:49.36 server Shared memory
> dump completed successfully.
> 00:00000:00103:2009/11/29 22:24:49.41 kernel
> ************************************
> 00:00000:00103:2009/11/29 22:24:49.43 kernel SQL causing
> error : select count(*) from sybsystemprocs..sysobjects
> where name = 'syssegments' and uid = ( select uid from
> sybsystemprocs..sysusers where name = 'dbo')
> 00:00000:00103:2009/11/29 22:24:49.45 kernel
> ************************************
> 00:00000:00103:2009/11/29 22:24:49.48 server SQL Text:
> select count(*) from sybsystemprocs..sysobjects where name =
> 'syssegments' and uid = ( select uid from
> sybsystemprocs..sysusers where name = 'dbo')
> 00:00000:00103:2009/11/29 22:24:49.48 kernel curdb = 1
> tempdb = 2 pstat = 0x10000
> 00:00000:00103:2009/11/29 22:24:49.48 kernel lasterror = 0
> preverror = 0 transtate = 1
> 00:00000:00103:2009/11/29 22:24:49.48 kernel curcmd = 0
> program = bcp-SQL-BackTrack
> 00:00000:00103:2009/11/29 22:24:49.56 kernel pc:
> 0x000000010053662c pcstkwalk+0x84()
> 00:00000:00103:2009/11/29 22:24:49.56 kernel pc:
> 0x0000000100536f3c ucstkgentrace+0x1fc()
> 00:00000:00103:2009/11/29 22:24:49.56 kernel pc:
> 0x0000000100534d30 ucbacktrace+0x78()
> 00:00000:00103:2009/11/29 22:24:49.67 kernel pc:
> 0x00000001006bbf80 terminate_process__fdpr_2+0x864()
> 00:00000:00103:2009/11/29 22:24:49.72 kernel pc:
> 0x0000000101c47e30 kisignal+0x14c()
> 00:00000:00103:2009/11/29 22:24:49.72 kernel pc:
> 0x0000000000000001 ()
> 00:00000:00103:2009/11/29 22:24:49.75 kernel pc:
> 0x0000000100177df4 OptGlobal::GblOptimize(int*)+0x13c()
> 00:00000:00103:2009/11/29 22:24:49.78 kernel pc:
> 0x000000010016d784 Optimize+0x11c()
> 00:00000:00103:2009/11/29 22:24:49.79 kernel pc:
> 0x00000001002bd828 s_compile_stmt+0x2dc()
> 00:00000:00103:2009/11/29 22:24:49.79 kernel pc:
> 0x00000001002bccc4 s_compile__fdpr_9+0x9c()
> 00:00000:00103:2009/11/29 22:24:49.81 kernel [Handler pc:
> 0x00000001008dfa54 s_handle+0x0 installed by the following
> function:-]
> 00:00000:00103:2009/11/29 22:24:49.86 kernel pc:
> 0x00000001002085d8 sequencer__fdpr_4+0x100()
> 00:00000:00103:2009/11/29 22:24:49.87 kernel pc:
> 0x0000000100317498 tdsrecv_language+0xcc()
> 00:00000:00103:2009/11/29 22:24:49.88 kernel [Handler pc:
> 0x000000010078355c ut_handle+0x0 installed by the following
> function:-]
> 00:00000:00103:2009/11/29 22:24:49.88 kernel pc:
> 0x000000010021fad4 conn_hdlr__fdpr_7+0x6c()
> 00:00000:00103:2009/11/29 22:24:49.88 kernel pc:
> 0x000000010023ea80 kpcoldstart+0x18()
> 00:00000:00103:2009/11/29 22:24:49.88 kernel end of stack
> trace, spid 103, kpid 820445351, suid 1
>
>
> thx,
> rick_806