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.

ASE terminated/Client crashed for a complex left outer join

4 posts in General Discussion Last posting was on 2010-05-31 19:54:14.0Z
djtao Posted on 2010-05-28 10:24:10.0Z
Sender: 4a1d.4bff8855.1804289383@sybase.com
From: djtao
Newsgroups: sybase.public.ase.general
Subject: ASE terminated/Client crashed for a complex left outer join
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bff99ca.4c8d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 May 2010 03:24:10 -0700
X-Trace: forums-1-dub 1275042250 10.22.241.41 (28 May 2010 03:24:10 -0700)
X-Original-Trace: 28 May 2010 03:24:10 -0700, 10.22.241.41
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29265
Article PK: 78499

Hi All,

I've met a strange problem, ASE terminated and client
crashed for a complex left outer join.
I'm using ASE server 15.0.3 and the client is 15, for
following statement, client returned ASE terminating, have
you met such problem before, and any suggestions?

1> select a1.int1, a3.c1 from(testdj a1 left outer join
(select 1 c1 from testdj a2) a3 on (a3.c1 = a1.int1)) where
(a3.c1 is null)
2> go
ASE is terminating this process.
1>

And testdj is a simple table with a int column:
1> select * from testdj
2> go
int1
-----------
1

(1 row affected)

But if I simplified the query, it would not be crashed:
1> select a1.int1, a3.c1 from(testdj a1 left outer join
(select 1 c1 from testdj a2) a3 on (a3.c1 = a1.int1))
2> go
int1 c1
----------- -----------
1 1

(1 row affected)


Anyone has any ideas? Is it a configuration problem or a
Sybase defect? Thanks a looooooooooot! BOW~~~


Rob V [ Sybase ] Posted on 2010-05-28 13:28:21.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASE terminated/Client crashed for a complex left outer join
References: <4bff99ca.4c8d.1681692777@sybase.com>
In-Reply-To: <4bff99ca.4c8d.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: <4bffc4f5$1@forums-1-dub>
Date: 28 May 2010 06:28:21 -0700
X-Trace: forums-1-dub 1275053301 10.22.241.152 (28 May 2010 06:28:21 -0700)
X-Original-Trace: 28 May 2010 06:28:21 -0700, vip152.sybase.com
Lines: 68
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29267
Article PK: 78501


On 28-May-2010 12:24, djtao wrote:
> Hi All,
>
> I've met a strange problem, ASE terminated and client
> crashed for a complex left outer join.
> I'm using ASE server 15.0.3 and the client is 15, for
> following statement, client returned ASE terminating, have
> you met such problem before, and any suggestions?
>
> 1> select a1.int1, a3.c1 from(testdj a1 left outer join
> (select 1 c1 from testdj a2) a3 on (a3.c1 = a1.int1)) where
> (a3.c1 is null)
> 2> go
> ASE is terminating this process.
> 1>
>
> And testdj is a simple table with a int column:
> 1> select * from testdj
> 2> go
> int1
> -----------
> 1
>
> (1 row affected)
>
> But if I simplified the query, it would not be crashed:
> 1> select a1.int1, a3.c1 from(testdj a1 left outer join
> (select 1 c1 from testdj a2) a3 on (a3.c1 = a1.int1))
> 2> go
> int1 c1
> ----------- -----------
> 1 1
>
> (1 row affected)
>
>
> Anyone has any ideas? Is it a configuration problem or a
> Sybase defect? Thanks a looooooooooot! BOW~~~
>

No idea. You should check the ASE errorlog which will contain a stack
trace.
You should submit that information to Sybase TechSupport who will be
able to determine whether this is a known issue. It's not really
possible to tell from here.
They will also want to know what the optimization goal was that you were
using (select @@optgoal).

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------


djtao Posted on 2010-05-31 08:33:34.0Z
Sender: 7e77.4c0373ca.1804289383@sybase.com
From: djtao
Newsgroups: sybase.public.ase.general
Subject: Re: ASE terminated/Client crashed for a complex left outer join
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c03745e.7e92.1681692777@sybase.com>
References: <4bffc4f5$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 May 2010 01:33:34 -0700
X-Trace: forums-1-dub 1275294814 10.22.241.41 (31 May 2010 01:33:34 -0700)
X-Original-Trace: 31 May 2010 01:33:34 -0700, 10.22.241.41
Lines: 88
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29268
Article PK: 78502

Hi Rob,

Thanks for your kindly reply, it might be a Sybase defect,
since I found the similar problem on the potential fix list
for ASE 15.5:

565273 signal 11 could happen in ResRelOp() during codegen
when a constant expression from a view or derived table is
SELECTed from an outer join view inner side and the constant
expression is further participating in a simple WHERE clause
(comparison involving other constant only) when the
outerjoin view is queried.

BTW, could you please tell me how to enable stack trace on
the server, I'm a total beginner on Sybase, thanks a lot!

> On 28-May-2010 12:24, djtao wrote:
> > Hi All,
> >
> > I've met a strange problem, ASE terminated and client
> > crashed for a complex left outer join.
> > I'm using ASE server 15.0.3 and the client is 15, for
> > following statement, client returned ASE terminating,
> > have you met such problem before, and any suggestions?
> >
> > 1> select a1.int1, a3.c1 from(testdj a1 left outer join
> > (select 1 c1 from testdj a2) a3 on (a3.c1 = a1.int1))
> > where (a3.c1 is null)
> > 2> go
> > ASE is terminating this process.
> > 1>
> >
> > And testdj is a simple table with a int column:
> > 1> select * from testdj
> > 2> go
> > int1
> > -----------
> > 1
> >
> > (1 row affected)
> >
> > But if I simplified the query, it would not be crashed:
> > 1> select a1.int1, a3.c1 from(testdj a1 left outer join
> > (select 1 c1 from testdj a2) a3 on (a3.c1 = a1.int1))
> > 2> go
> > int1 c1
> > ----------- -----------
> > 1 1
> >
> > (1 row affected)
> >
> >
> > Anyone has any ideas? Is it a configuration problem or
> > a Sybase defect? Thanks a looooooooooot! BOW~~~
> >
>
> No idea. You should check the ASE errorlog which will
> contain a stack trace.
> You should submit that information to Sybase TechSupport
> who will be able to determine whether this is a known
> issue. It's not really possible to tell from here.
> They will also want to know what the optimization goal was
> that you were using (select @@optgoal).
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Sybase Professional DBA for ASE
> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
> Reference Guide" "The Complete Sybase Replication Server
> Quick Reference Guide"
>
> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
> http://www.sypron.nl
> Sypron B.V., Amersfoort, The Netherlands
> Chamber of Commerce 27138666
> ----------------------------------------------------------
> -------
>


Rob V [ Sybase ] Posted on 2010-05-31 19:54:14.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASE terminated/Client crashed for a complex left outer join
References: <4bffc4f5$1@forums-1-dub> <4c03745e.7e92.1681692777@sybase.com>
In-Reply-To: <4c03745e.7e92.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: <4c0413e6$1@forums-1-dub>
Date: 31 May 2010 12:54:14 -0700
X-Trace: forums-1-dub 1275335654 10.22.241.152 (31 May 2010 12:54:14 -0700)
X-Original-Trace: 31 May 2010 12:54:14 -0700, vip152.sybase.com
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29271
Article PK: 78504


On 31-May-2010 10:33, djtao wrote:
> Hi Rob,
>
> Thanks for your kindly reply, it might be a Sybase defect,
> since I found the similar problem on the potential fix list
> for ASE 15.5:
>
> 565273 signal 11 could happen in ResRelOp() during codegen
> when a constant expression from a view or derived table is
> SELECTed from an outer join view inner side and the constant
> expression is further participating in a simple WHERE clause
> (comparison involving other constant only) when the
> outerjoin view is queried.
>
> BTW, could you please tell me how to enable stack trace on
> the server, I'm a total beginner on Sybase, thanks a lot!
>
>

You cannot enable 'stack traces' like these -- whenever such a problem occurs, there's always a stack trace in the ASE errorlog file.
It could be that the issue you refer to corresponds to the problem you're encountering. However, only Sybase techsupport can determine whether this is reaally the same problem since they have access to full details.

HTH,

Rob V.