freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Invalid Cursor State By SELECT after INSERT

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Invalid Cursor State By SELECT after INSERT
Date: Wed, 23 Jul 2008 16:09:43 -0400

John Mazza wrote:
> odbc.c:3021:_SQLExecute(0xa096b60)
> odbc.c:3026:_SQLExecute() starting with state 2
> error.c:609:SQLGetDiagRec(3, 0xa096b60, 1, 0xbf96441e, 0xbf96442c,
> 0xbf96421e, 512, 0xbf964428)
> error.c:512:_SQLGetDiagRec(3, 0xa096b60, 1, 0xbf96441e, 0xbf96442c,
> 0xbf96421e, 512, 0xbf964428)
> error.c:609:SQLGetDiagRec(3, 0xa096b60, 2, 0xbf96441e, 0xbf96442c,
> 0xbf96421e, 512, 0xbf964428)
> error.c:512:_SQLGetDiagRec(3, 0xa096b60, 2, 0xbf96441e, 0xbf96442c,
> 0xbf96421e, 512, 0xbf964428)
> error.c:609:SQLGetDiagRec(3, 0xa096b60, 1, 0x121c48, 0xbf964788,
> 0x1293b8, 0, 0xbf964784)
> error.c:512:_SQLGetDiagRec(3, 0xa096b60, 1, 0x121c48, 0xbf964788,
> 0x1293b8, 0, 0xbf964784)
> error.c:609:SQLGetDiagRec(3, 0xa096b60, 1, 0x121c48, 0xbf964788,
> 0x186428, 42, 0xbf964784)
> error.c:512:_SQLGetDiagRec(3, 0xa096b60, 1, 0x121c48, 0xbf964788,
> 0x186428, 42, 0xbf964784)
> error.c:609:SQLGetDiagRec(3, 0xa096b60, 1, 0x121c48, 0xbf964788,
> 0x186428, 0, 0xbf964784)
> error.c:512:_SQLGetDiagRec(3, 0xa096b60, 1, 0x121c48, 0xbf964788,
> 0x186428, 0, 0xbf964784)
> error.c:609:SQLGetDiagRec(3, 0xa096b60, 1, 0x121c48, 0xbf964788,
> 0x186428, 42, 0xbf964784)
> error.c:512:_SQLGetDiagRec(3, 0xa096b60, 1, 0x121c48, 0xbf964788,
> 0x186428, 42, 0xbf964784)
> error.c:609:SQLGetDiagRec(3, 0xa096b60, 2, 0x121c48, 0xbf964788,
> 0x186428, 0, 0xbf964784)
> error.c:512:_SQLGetDiagRec(3, 0xa096b60, 2, 0x121c48, 0xbf964788,
> 0x186428, 0, 0xbf964784)
> odbc.c:3764:SQLFreeHandle(3, 0x0xa096b60)
> odbc.c:3853:_SQLFreeStmt(0xa096b60, 1, 0)
> odbc.c:3932:SQLFreeStmt(0xa0aaa70, 0)
> odbc.c:3853:_SQLFreeStmt(0xa0aaa70, 0, 0)
> query.c:1935:tds_send_cancel: not in_cancel and not idle
> query.c:1944:tds_send_cancel: sending cancel packet

That doesn't look very good.

There are two diagnostic records. I guess one says the cursor state is
invalid. What does the other one say?

Attached is a patch that will print the diagnostic text to the TDSDUMP
log. Or you can fetch tomorrow's snapshot.

--jkl

Attachment: clearer_errors.diff
Description: Binary data

[freetds] Invalid Cursor State By SELECT after INSERT, John Mazza, 07/23/2008
- Re: [freetds] Invalid Cursor State By SELECT after INSERT, James K. Lowden, 07/23/2008
  - Re: [freetds] Invalid Cursor State By SELECT after INSERT, John Mazza, 07/23/2008
    - Re: [freetds] Invalid Cursor State By SELECT after INSERT, James K. Lowden, 07/23/2008
      - Re: [freetds] Invalid Cursor State By SELECT after INSERT, John Mazza, 07/23/2008
        
        Re: [freetds] Invalid Cursor State By SELECT after INSERT, James K. Lowden, 07/23/2008
        
        Re: [freetds] Invalid Cursor State By SELECT after INSERT, Frediano Ziglio, 07/23/2008
        
        Re: [freetds] Invalid Cursor State By SELECT after INSERT, John Mazza, 07/23/2008