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.

Error 24000 - Cursor not in a valid state

2 posts in General Discussion Last posting was on 2003-02-07 18:09:25Z
Boaz Ben-Porat Posted on 2003-01-14 15:54:15Z
From: "Boaz Ben-Porat" <boazb@datapharm.dk>
Subject: Error 24000 - Cursor not in a valid state
Date: Tue, 14 Jan 2003 16:54:15 +0100
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <VuEWDf#uCHA.199@forums.sybase.com>
Newsgroups: sybase.public.sqlanywhere.general
NNTP-Posting-Host: 195.215.64.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2197
Article PK: 880182

ASA 8.0.1 (build 3030 and 3080)

When trying to delete a row from a table with a phantom-lock (another row is
deleted by another connection without commit) you get the error "error 42W18
User '%1' has the row in '%2' lock"
However, if the delete is repeated enough times (empiric - 12 times), the
error changes to "Error 24000 - Cursor not in a valid state"
This behaveiour is new, it was not there in SQA 5.5.

Has anyone seen this ? (or even better, has a soloution ?)

****************************
To test this behaveiour:

1. Start 2 connections to the database (ASA 8.0.1 3030 / 3080)
2. Run the attached file (DoKuku.sql) in one of the connections.

3. Follow the sequence below (note - 2 connections)

-- 3.1. Connection 1:
call inskuku(1);
commit;

-- 3.2. connection 2:
call inskuku(2);
commit;

-- kuku has now 2 rows (Kid, Kval) : (1,1) and (2,2)

-- 3.3. Connection 1:
call delkuku(1);


-- 3.4. connection 2:
call delkuku(2);

repeat 3.4 and Watch the message window.
In our test, the first 11 executions report SQLSTATE = 42W18.
Execution no` 12 reports SQLSTATE = 24000.
(If you don`t get it within 12 executions, try some more).




TIA
Boaz Ben-Porat
DataPharm a/s


David Fishburn Posted on 2003-02-07 18:09:25Z
Subject: Re: Error 24000 - Cursor not in a valid state
From: David Fishburn <fishburn_spam_off@sybase.com>
References: <VuEWDf#uCHA.199@forums.sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns931B8296A3A2Cfishburnsybasecom@199.93.177.77>
User-Agent: Xnews/06.01.10
Newsgroups: sybase.public.sqlanywhere.general
Date: Fri, 07 Feb 2003 13:09:25 -0500
Lines: 29
NNTP-Posting-Host: 172.31.143.204
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:788
Article PK: 879240

"Boaz Ben-Porat" <boazb@datapharm.dk> wrote in
news:VuEWDf#uCHA.199@forums.sybase.com:

> ASA 8.0.1 (build 3030 and 3080)
>
> When trying to delete a row from a table with a phantom-lock (another
> row is deleted by another connection without commit) you get the error
> "error 42W18 User '%1' has the row in '%2' lock"
> However, if the delete is repeated enough times (empiric - 12 times),
> the error changes to "Error 24000 - Cursor not in a valid state"
> This behaveiour is new, it was not there in SQA 5.5.
>

If you can repro this consistently with the latest EBF I would recommend
you open a case with technical support.
Either that or submit it via CaseXpress

--
David Fishburn
NEW - Certified ASA Developer Version 8
Sybase - iAnywhere Solutions
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with EACH
post (dbeng8 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com