Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "John Mazza" <john.mazza AT mgcworks.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Invalid Cursor State By SELECT after INSERT
  • Date: Wed, 23 Jul 2008 14:34:22 -0400

Here's a snippet from the tdsdump.log that occurs between the INSERT
and SELECT statements:

Here's the line that caught my attention:

util.c:110:logic error: cannot change query state from IDLE to PENDING

I'm not sure if that indicates a real problem or not, due to
unfamiliarity with the internals of FreeTDS. That also showed up
during the part of the log covering execution of the SELECT statement.

Should I send the full tdsdump.log?


======== BEGIN LOG =========

query.c:1631:tds_submit_execute()
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:769:Sending packet
0000 03 01 00 29 00 00 01 00-0a 00 73 00 70 00 5f 00 |...)....
..s.p._.|
0010 65 00 78 00 65 00 63 00-75 00 74 00 65 00 00 00 |e.x.e.c.
u.t.e...|
0020 00 00 26 04 04 02 00 00-00 |..&..... .|

token.c:495:tds_process_tokens(0xa01d558, 0xbf9647b8, 0xbf9647b4,
0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 1f 00 33 01 00-ff 11 00 c3 00 01 00 00 |.....3..
........|
0010 00 79 00 00 00 00 fe 00-00 e0 00 01 00 00 00 |.y...... .......|

token.c:510:processing result tokens. marker is ff(DONEINPROC)
token.c:2274:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2305: rows_affected = 1
util.c:162:Changed query state from READING to PENDING
odbc.c:3328:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3329: result_type=4054, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3393:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
odbc.c:3175:_SQLExecute: odbc_process_tokens returned result_type 4054
token.c:495:tds_process_tokens(0xa01d558, 0xbf9647b8, 0xbf9647b4,
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:510:processing result tokens. marker is fe(DONEPROC)
token.c:2274:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2290:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2305: rows_affected = 1
util.c:110:logic error: cannot change query state from IDLE to PENDING
odbc.c:3328:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3329: result_type=4053, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3369:odbc_process_tokens: row_count=1
odbc.c:3175:_SQLExecute: odbc_process_tokens returned result_type 4053



=============== END LOG ================

Here's the line that caught my attention:

util.c:110:logic error: cannot change query state from IDLE to PENDING

I'm not sure if that indicates a real problem or not, due to
unfamiliarity with the internals of FreeTDS. That also showed up
during the part of the log covering execution of the SELECT statement.



John Mazza
CTO, MGC Works Inc.
(412) 628-6214

********************************
CONFIDENTIAL
********************************
The information contained in this electronic mail may be
confidential, and is only intended for the use of the
individual(s) named above. If you are not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.

If you have received this communication in error, please
notify us by telephone [412-782-4017] and immediately forward
this message and any attachments back to the sender. Then,
proceed to delete the material from any e-mail system.

Thank you.

********************************************************







Archive powered by MHonArc 2.6.24.

Top of Page