FreeTDS Development Group

["John Mazza" <john.mazza AT mgcworks.com>]

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.

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