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.

SQL Anywhere 10 crash application

5 posts in General Discussion Last posting was on 2008-04-01 09:06:52.0Z
G. Avella Posted on 2008-03-31 12:50:21.0Z
Reply-To: "G. Avella" <g.avella@eldes.it>
From: "G. Avella" <g.avella@eldes.it>
Newsgroups: ianywhere.public.general
Subject: SQL Anywhere 10 crash application
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f0de0d$1@forums-1-dub>
Date: 31 Mar 2008 04:50:21 -0800
X-Trace: forums-1-dub 1206967821 10.22.241.152 (31 Mar 2008 04:50:21 -0800)
X-Original-Trace: 31 Mar 2008 04:50:21 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6778
Article PK: 5019

Hello,
I did the upgrade from ASa 8 to SQL Anywhere 10 and I am having some
problems with the INSERT made on existing primary keys from 2 sessions with
a single database connection.I developed a testing program and I found the
following behaviors:

1) I tried to make a connection to the engine 10 and make the insert without
the "ON EXISTING" clauses, without that the pronlem occurs.

2) I make a connection and I leave two parallel threads running, both making
the INSERT without the "ON EXISTING" clauses; at the moment the second
thread will be running and will make it's query it is verfied the
application crash.

3) I make the same test as described in the section 2, introducing the "ON
EXISTING SKIP" clause,in this way the problem does not occur.

4) Making the two parallel threads running, each one making its own
connection to the database and its INSERT, with or without the clause, the
problem does not occur.

5) I have performed the same tests as in the secton 2 and 3 with the 8
Sybase engine and the problem does not occur in any way.


Josh Savill Posted on 2008-03-31 14:26:09.0Z
From: Josh Savill <no_spam_jsavill@ianywhere.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 10 crash application
References: <47f0de0d$1@forums-1-dub>
In-Reply-To: <47f0de0d$1@forums-1-dub>
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: <47f0f481$1@forums-1-dub>
Date: 31 Mar 2008 06:26:09 -0800
X-Trace: forums-1-dub 1206973569 10.22.241.152 (31 Mar 2008 06:26:09 -0800)
X-Original-Trace: 31 Mar 2008 06:26:09 -0800, vip152.sybase.com
Lines: 40
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6779
Article PK: 5021


G. Avella wrote:
> Hello,
> I did the upgrade from ASa 8 to SQL Anywhere 10 and I am having some
> problems with the INSERT made on existing primary keys from 2 sessions with
> a single database connection.I developed a testing program and I found the
> following behaviors:
>
> 1) I tried to make a connection to the engine 10 and make the insert without
> the "ON EXISTING" clauses, without that the pronlem occurs.
>
> 2) I make a connection and I leave two parallel threads running, both making
> the INSERT without the "ON EXISTING" clauses; at the moment the second
> thread will be running and will make it's query it is verfied the
> application crash.
>
> 3) I make the same test as described in the section 2, introducing the "ON
> EXISTING SKIP" clause,in this way the problem does not occur.
>
> 4) Making the two parallel threads running, each one making its own
> connection to the database and its INSERT, with or without the clause, the
> problem does not occur.
>
> 5) I have performed the same tests as in the secton 2 and 3 with the 8
> Sybase engine and the problem does not occur in any way.
>
>

What version and build and SQL Anywhere 10 are you running?

If you can consistently reproduce this problem on that latest EBF for SA
10.0.1, I recommend opening a technical support case or submitting a
free bug case here: http://www.sybase.com/support

Be sure to provide all the necessary instructions on how to reproduce
the behaivour.


--
Joshua Savill
Sybase iAnywhere - Product Manager


G. Avella Posted on 2008-03-31 14:45:17.0Z
Reply-To: "G. Avella" <g.avella@eldes.it>
From: "G. Avella" <g.avella@eldes.it>
Newsgroups: ianywhere.public.general
References: <47f0de0d$1@forums-1-dub> <47f0f481$1@forums-1-dub>
Subject: Re: SQL Anywhere 10 crash application
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f0f8fd@forums-1-dub>
Date: 31 Mar 2008 06:45:17 -0800
X-Trace: forums-1-dub 1206974717 10.22.241.152 (31 Mar 2008 06:45:17 -0800)
X-Original-Trace: 31 Mar 2008 06:45:17 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6780
Article PK: 5020

Hi,
I'm using SQL Anywhere OEM version 10.0.1.3649 succesfully authenticated.
That build should be the last available.

Is that a bug? Shell i submit a bug case at the link above?



"Josh Savill" <no_spam_jsavill@ianywhere.com> ha scritto nel messaggio
news:47f0f481$1@forums-1-dub...

> G. Avella wrote:
>> Hello,
>> I did the upgrade from ASa 8 to SQL Anywhere 10 and I am having some
>> problems with the INSERT made on existing primary keys from 2 sessions
>> with a single database connection.I developed a testing program and I
>> found the following behaviors:
>>
>> 1) I tried to make a connection to the engine 10 and make the insert
>> without the "ON EXISTING" clauses, without that the pronlem occurs.
>>
>> 2) I make a connection and I leave two parallel threads running, both
>> making the INSERT without the "ON EXISTING" clauses; at the moment the
>> second thread will be running and will make it's query it is verfied the
>> application crash.
>>
>> 3) I make the same test as described in the section 2, introducing the
>> "ON EXISTING SKIP" clause,in this way the problem does not occur.
>>
>> 4) Making the two parallel threads running, each one making its own
>> connection to the database and its INSERT, with or without the clause,
>> the problem does not occur.
>>
>> 5) I have performed the same tests as in the secton 2 and 3 with the 8
>> Sybase engine and the problem does not occur in any way.
>>
>>
>
> What version and build and SQL Anywhere 10 are you running?
>
> If you can consistently reproduce this problem on that latest EBF for SA
> 10.0.1, I recommend opening a technical support case or submitting a free
> bug case here: http://www.sybase.com/support
>
> Be sure to provide all the necessary instructions on how to reproduce the
> behaivour.
>
>
> --
> Joshua Savill
> Sybase iAnywhere - Product Manager


Chris Keating (Sybase iAnywhere) Posted on 2008-03-31 17:15:38.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 10 crash application
References: <47f0de0d$1@forums-1-dub> <47f0f481$1@forums-1-dub> <47f0f8fd@forums-1-dub>
In-Reply-To: <47f0f8fd@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f11c3a$1@forums-1-dub>
Date: 31 Mar 2008 09:15:38 -0800
X-Trace: forums-1-dub 1206983738 10.22.241.152 (31 Mar 2008 09:15:38 -0800)
X-Original-Trace: 31 Mar 2008 09:15:38 -0800, vip152.sybase.com
Lines: 67
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6781
Article PK: 5022

It may be a bug but you have not provided much in terms of details about
the application. For embedded SQL, you must be careful in using a single
SQLCA. See the following documenation reference:

SQL Anywhere® Server - Programming

> SQL Anywhere Embedded SQL

> The SQL Communication Area (SQLCA)
> Using multiple SQLCAs
When to use multiple SQLCAs

You should pursue this either as a support case or a "report a bug" case
depending on you specific requirements. Read the Important Message if
you opt to use "report a bug" as it outlines the service levels you can
expect.

G. Avella wrote:
> Hi,
> I'm using SQL Anywhere OEM version 10.0.1.3649 succesfully authenticated.
> That build should be the last available.
>
> Is that a bug? Shell i submit a bug case at the link above?
>
>
>
> "Josh Savill" <no_spam_jsavill@ianywhere.com> ha scritto nel messaggio
> news:47f0f481$1@forums-1-dub...
>> G. Avella wrote:
>>> Hello,
>>> I did the upgrade from ASa 8 to SQL Anywhere 10 and I am having some
>>> problems with the INSERT made on existing primary keys from 2 sessions
>>> with a single database connection.I developed a testing program and I
>>> found the following behaviors:
>>>
>>> 1) I tried to make a connection to the engine 10 and make the insert
>>> without the "ON EXISTING" clauses, without that the pronlem occurs.
>>>
>>> 2) I make a connection and I leave two parallel threads running, both
>>> making the INSERT without the "ON EXISTING" clauses; at the moment the
>>> second thread will be running and will make it's query it is verfied the
>>> application crash.
>>>
>>> 3) I make the same test as described in the section 2, introducing the
>>> "ON EXISTING SKIP" clause,in this way the problem does not occur.
>>>
>>> 4) Making the two parallel threads running, each one making its own
>>> connection to the database and its INSERT, with or without the clause,
>>> the problem does not occur.
>>>
>>> 5) I have performed the same tests as in the secton 2 and 3 with the 8
>>> Sybase engine and the problem does not occur in any way.
>>>
>>>
>> What version and build and SQL Anywhere 10 are you running?
>>
>> If you can consistently reproduce this problem on that latest EBF for SA
>> 10.0.1, I recommend opening a technical support case or submitting a free
>> bug case here: http://www.sybase.com/support
>>
>> Be sure to provide all the necessary instructions on how to reproduce the
>> behaivour.
>>
>>
>> --
>> Joshua Savill
>> Sybase iAnywhere - Product Manager
>
>


G. Avella Posted on 2008-04-01 09:06:52.0Z
Reply-To: "G. Avella" <g.avella@eldes.it>
From: "G. Avella" <g.avella@eldes.it>
Newsgroups: ianywhere.public.general
References: <47f0de0d$1@forums-1-dub> <47f0f481$1@forums-1-dub> <47f0f8fd@forums-1-dub> <47f11c3a$1@forums-1-dub>
Subject: Re: SQL Anywhere 10 crash application
Lines: 86
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f1fb2c$1@forums-1-dub>
Date: 1 Apr 2008 01:06:52 -0800
X-Trace: forums-1-dub 1207040812 10.22.241.152 (1 Apr 2008 01:06:52 -0800)
X-Original-Trace: 1 Apr 2008 01:06:52 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6782
Article PK: 5025

To perform the tests described above, I used an MFC application developed
with C+ + language. This application makes a connection to the database
using
ODBC drivers, with the start line "dbsrv10.exe -c 8m -ti 10080 -x tcpip".
The version of Sybase that is actually used is OEM 10.0.1.3649. The tests
were
run on a machine fitted with Windows XP Professional SP2 equipped with all
updates avalable at the moment. It is made a single connection to the
application global level, used by 2 threads to perform the INSERT query on
an already existing primary key which generate the application crash. The
same
operation performed on a database created with a version of Sybase 8 does
not generate any kind of problem.
For details on the behavior during testing see the earlyer e-mails.



"Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com> ha
scritto nel messaggio news:47f11c3a$1@forums-1-dub...

> It may be a bug but you have not provided much in terms of details about
> the application. For embedded SQL, you must be careful in using a single
> SQLCA. See the following documenation reference:
>
> SQL Anywhere® Server - Programming
> > SQL Anywhere Embedded SQL
> > The SQL Communication Area (SQLCA)
> > Using multiple SQLCAs
> When to use multiple SQLCAs
>
> You should pursue this either as a support case or a "report a bug" case
> depending on you specific requirements. Read the Important Message if you
> opt to use "report a bug" as it outlines the service levels you can
> expect.
>
> G. Avella wrote:
>> Hi,
>> I'm using SQL Anywhere OEM version 10.0.1.3649 succesfully authenticated.
>> That build should be the last available.
>>
>> Is that a bug? Shell i submit a bug case at the link above?
>>
>>
>>
>> "Josh Savill" <no_spam_jsavill@ianywhere.com> ha scritto nel messaggio
>> news:47f0f481$1@forums-1-dub...
>>> G. Avella wrote:
>>>> Hello,
>>>> I did the upgrade from ASa 8 to SQL Anywhere 10 and I am having some
>>>> problems with the INSERT made on existing primary keys from 2 sessions
>>>> with a single database connection.I developed a testing program and I
>>>> found the following behaviors:
>>>>
>>>> 1) I tried to make a connection to the engine 10 and make the insert
>>>> without the "ON EXISTING" clauses, without that the pronlem occurs.
>>>>
>>>> 2) I make a connection and I leave two parallel threads running, both
>>>> making the INSERT without the "ON EXISTING" clauses; at the moment the
>>>> second thread will be running and will make it's query it is verfied
>>>> the application crash.
>>>>
>>>> 3) I make the same test as described in the section 2, introducing the
>>>> "ON EXISTING SKIP" clause,in this way the problem does not occur.
>>>>
>>>> 4) Making the two parallel threads running, each one making its own
>>>> connection to the database and its INSERT, with or without the clause,
>>>> the problem does not occur.
>>>>
>>>> 5) I have performed the same tests as in the secton 2 and 3 with the 8
>>>> Sybase engine and the problem does not occur in any way.
>>>>
>>>>
>>> What version and build and SQL Anywhere 10 are you running?
>>>
>>> If you can consistently reproduce this problem on that latest EBF for SA
>>> 10.0.1, I recommend opening a technical support case or submitting a
>>> free bug case here: http://www.sybase.com/support
>>>
>>> Be sure to provide all the necessary instructions on how to reproduce
>>> the behaivour.
>>>
>>>
>>> --
>>> Joshua Savill
>>> Sybase iAnywhere - Product Manager
>>