freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Invalid Cursor State By SELECT after INSERT
- 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:58:01 -0400
Thanks for the clarification. The full log is below - it's only about
25kB....
log.c:190:Starting log file for FreeTDS 0.83.dev.20080722
on 2008-07-23 14:11:48 with debug flags 0x4fff.
iconv.c:363:iconv to convert client-side data to the "ISO-8859-1"
character set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:204:Connecting to 192.168.2.50 port 1433 (TDS version 8.0)
net.c:258:tds_open_socket: connect(2) returned "Operation now in
progress"
net.c:296:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:734:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
net.c:663:Received packet
0000 04 01 01 85 00 37 01 00-e3 2b 00 01 0e 4d 00 65 |.....7..
.+...M.e|
0010 00 64 00 46 00 61 00 73-00 74 00 46 00 61 00 78 |.d.F.a.s
.t.F.a.x|
0020 00 44 00 6f 00 63 00 73-00 06 6d 00 61 00 73 00 |.D.o.c.s
..m.a.s.|
0030 74 00 65 00 72 00 ab 6c-00 45 16 00 00 02 00 2d |t.e.r..l
.E.....-|
0040 00 43 00 68 00 61 00 6e-00 67 00 65 00 64 00 20 |.C.h.a.n .g.e.d.
|
0050 00 64 00 61 00 74 00 61-00 62 00 61 00 73 00 65 |.d.a.t.a
.b.a.s.e|
0060 00 20 00 63 00 6f 00 6e-00 74 00 65 00 78 00 74 |. .c.o.n
.t.e.x.t|
0070 00 20 00 74 00 6f 00 20-00 27 00 4d 00 65 00 64 |. .t.o.
.'.M.e.d|
0080 00 46 00 61 00 73 00 74-00 46 00 61 00 78 00 44 |.F.a.s.t
.F.a.x.D|
0090 00 6f 00 63 00 73 00 27-00 2e 00 03 4d 00 47 00 |.o.c.s.'
....M.G.|
00a0 43 00 00 00 00 e3 08 00-07 05 09 04 d0 00 34 00 |C.......
......4.|
00b0 e3 17 00 02 0a 75 00 73-00 5f 00 65 00 6e 00 67 |.....u.s
._.e.n.g|
00c0 00 6c 00 69 00 73 00 68-00 00 ab 60 00 47 16 00 |.l.i.s.h
...`.G..|
00d0 00 01 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h
.a.n.g.e|
00e0 00 64 00 20 00 6c 00 61-00 6e 00 67 00 75 00 61 |.d. .l.a
.n.g.u.a|
00f0 00 67 00 65 00 20 00 73-00 65 00 74 00 74 00 69 |.g.e. .s
.e.t.t.i|
0100 00 6e 00 67 00 20 00 74-00 6f 00 20 00 75 00 73 |.n.g. .t .o.
.u.s|
0110 00 5f 00 65 00 6e 00 67-00 6c 00 69 00 73 00 68 |._.e.n.g
.l.i.s.h|
0120 00 2e 00 03 4d 00 47 00-43 00 00 00 00 ad 36 00 |....M.G.
C.....6.|
0130 01 71 00 00 01 16 4d 00-69 00 63 00 72 00 6f 00 |.q....M.
i.c.r.o.|
0140 73 00 6f 00 66 00 74 00-20 00 53 00 51 00 4c 00 |s.o.f.t.
.S.Q.L.|
0150 20 00 53 00 65 00 72 00-76 00 65 00 72 00 00 00 | .S.e.r.
v.e.r...|
0160 00 00 08 00 07 f7 e3 13-00 04 04 34 00 30 00 39 |........
...4.0.9|
0170 00 36 00 04 34 00 30 00-39 00 36 00 fd 00 00 00 |.6..4.0.
9.6.....|
0180 00 00 00 00 00 - |.....|
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2524:tds_process_msg() reading message from server
token.c:2597:tds_process_msg() calling client msg handler
odbc.c:2084:msgno 5701 20003
token.c:2610:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2354:tds_process_env_chg(): 5 bytes of collation data received
token.c:2355:tds->collation was
0000 00 00 00 00 00 - |.....|
iconv.c:985:setting server single-byte charset to "CP1252"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
token.c:2365:tds->collation now
0000 09 04 d0 00 34 - |....4|
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2524:tds_process_msg() reading message from server
token.c:2597:tds_process_msg() calling client msg handler
odbc.c:2084:msgno 5703 20003
token.c:2610:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got ad(LOGINACK)
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got fd(DONE)
token.c:108:tds_process_default_tokens() marker is fd(DONE)
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
token.c:2305: rows_affected = 0
token.c:393:leaving tds_process_login_tokens() returning 1
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 19 bytes of "set textsize 64512 "
write.c:164:tds_put_string wrote 38 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:769:Sending packet
0000 01 01 00 2e 00 00 00 00-73 00 65 00 74 00 20 00 |........ s.e.t.
.|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t.
s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00 | .6.4.5. 1.2. .|
token.c:495:tds_process_tokens(0xa0a8f30, 0xbf961480, 0xbf96147c,
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 11 00 37 01 00-fd 00 00 be 00 00 00 00 |.....7..
........|
0010 00 - |.|
token.c:510:processing result tokens. marker is fd(DONE)
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 = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xa0a8f30, 0xbf961480, 0xbf96147c,
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:4841:SQLGetFunctions: fFunction is 999
odbc.c:5756:SQLGetInfo(0xa0a8c20, 77, 0xbf96174c, 20, (nil))
odbc.c:5010:_SQLGetInfo(0xa0a8c20, 77, 0xbf96174c, 20, (nil)
odbc.c:5756:SQLGetInfo(0xa0a8c20, 10000, 0xbf96174c, 5, (nil))
odbc.c:5010:_SQLGetInfo(0xa0a8c20, 10000, 0xbf96174c, 5, (nil)
odbc.c:1552:SQLAllocStmt(0xa01cf78, 0xa0dad98)
odbc.c:1451:_SQLAllocStmt(0xa01cf78, 0xa0dad98)
odbc.c:4169:SQLGetStmtAttr(0xa0a8e38, 10010, 0xbf9648cc, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa0a8e38, 10010, 0xbf9648cc, 4, (nil))
odbc.c:4169:SQLGetStmtAttr(0xa0a8e38, 10011, 0xbf9648cc, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa0a8e38, 10011, 0xbf9648cc, 4, (nil))
odbc.c:4169:SQLGetStmtAttr(0xa0a8e38, 10012, 0xbf9648cc, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa0a8e38, 10012, 0xbf9648cc, 4, (nil))
odbc.c:4169:SQLGetStmtAttr(0xa0a8e38, 10013, 0xbf9648cc, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa0a8e38, 10013, 0xbf9648cc, 4, (nil))
odbc.c:4214:SQLPrepare(0xa0a8e38, INSERT INTO FaxJob (FaxDeptID,
FaxSendToNo, FSID, FaxResultID, FaxSendTries,recip_id,SendImmediate,
FaxEmployeeID, FaxCreate) VALUES( -26084249, '4123880569',
5,0,0,0,0,0,'2008-7-23 14:11:48'), 192)
odbc.c:4278:Creating prepared statement
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 01 bc 00 00 01 00-ff ff 0b 00 00 00 00 01 |........
........|
0010 26 04 00 00 00 63 00 00-00 00 09 04 d0 00 34 ff |&....c..
......4.|
0020 ff ff ff 00 00 63 80 01-00 00 09 04 d0 00 34 80 |.....c..
......4.|
0030 01 00 00 49 00 4e 00 53-00 45 00 52 00 54 00 20 |...I.N.S .E.R.T.
|
0040 00 49 00 4e 00 54 00 4f-00 20 00 46 00 61 00 78 |.I.N.T.O .
.F.a.x|
0050 00 4a 00 6f 00 62 00 20-00 28 00 46 00 61 00 78 |.J.o.b.
.(.F.a.x|
0060 00 44 00 65 00 70 00 74-00 49 00 44 00 2c 00 20 |.D.e.p.t .I.D.,.
|
0070 00 46 00 61 00 78 00 53-00 65 00 6e 00 64 00 54 |.F.a.x.S
.e.n.d.T|
0080 00 6f 00 4e 00 6f 00 2c-00 20 00 46 00 53 00 49 |.o.N.o., .
.F.S.I|
0090 00 44 00 2c 00 20 00 46-00 61 00 78 00 52 00 65 |.D.,. .F
.a.x.R.e|
00a0 00 73 00 75 00 6c 00 74-00 49 00 44 00 2c 00 20 |.s.u.l.t .I.D.,.
|
00b0 00 46 00 61 00 78 00 53-00 65 00 6e 00 64 00 54 |.F.a.x.S
.e.n.d.T|
00c0 00 72 00 69 00 65 00 73-00 2c 00 72 00 65 00 63 |.r.i.e.s
.,.r.e.c|
00d0 00 69 00 70 00 5f 00 69-00 64 00 2c 00 53 00 65 |.i.p._.i
.d.,.S.e|
00e0 00 6e 00 64 00 49 00 6d-00 6d 00 65 00 64 00 69 |.n.d.I.m
.m.e.d.i|
00f0 00 61 00 74 00 65 00 2c-00 20 00 46 00 61 00 78 |.a.t.e., .
.F.a.x|
0100 00 45 00 6d 00 70 00 6c-00 6f 00 79 00 65 00 65 |.E.m.p.l
.o.y.e.e|
0110 00 49 00 44 00 2c 00 20-00 46 00 61 00 78 00 43 |.I.D.,.
.F.a.x.C|
0120 00 72 00 65 00 61 00 74-00 65 00 29 00 20 00 56 |.r.e.a.t .e.).
.V|
0130 00 41 00 4c 00 55 00 45-00 53 00 28 00 20 00 2d |.A.L.U.E .S.(.
.-|
0140 00 32 00 36 00 30 00 38-00 34 00 32 00 34 00 39 |.2.6.0.8
.4.2.4.9|
0150 00 2c 00 20 00 27 00 34-00 31 00 32 00 33 00 38 |.,. .'.4
.1.2.3.8|
0160 00 38 00 30 00 35 00 36-00 39 00 27 00 2c 00 20 |.8.0.5.6 .9.'.,.
|
0170 00 35 00 2c 00 30 00 2c-00 30 00 2c 00 30 00 2c |.5.,.0.,
.0.,.0.,|
0180 00 30 00 2c 00 30 00 2c-00 27 00 32 00 30 00 30 |.0.,.0.,
.'.2.0.0|
0190 00 38 00 2d 00 37 00 2d-00 32 00 33 00 20 00 31 |.8.-.7.- .2.3.
.1|
01a0 00 34 00 3a 00 31 00 31-00 3a 00 34 00 38 00 27 |.4.:.1.1
.:.4.8.'|
01b0 00 29 00 00 00 26 04 04-01 00 00 00 |.)...&.. ....|
token.c:495:tds_process_tokens(0xa01d558, 0xbf9647d0, 0xbf9647cc,
0x104)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 2f 00 33 01 00-ff 11 00 c3 00 00 00 00 |.../.3..
........|
0010 00 79 00 00 00 00 ac 0d-00 00 01 38 00 00 00 26 |.y......
...8...&|
0020 04 04 02 00 00 00 fe 00-00 e0 00 00 00 00 00 |........ .......|
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 = 0
token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:510:processing result tokens. marker is ac(PARAM)
token.c:567:processing parameters for sp 11
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0xa01d558, 0xbf964780)
token.c:1582:tds_get_data_info(0xa01d558, 0xa0969d0, 1) [for
parameter]token.c:1645:processing result. type = 38(integer-null),
varint_size 1
token.c:1666:processing result. column_size 4
token.c:1984:tds_get_data: type 38, varint size 1
token.c:2048:tds_get_data(): wire column size is 4
log.c:481:type integer-null has value 2
token.c:573:1 hidden return parameters
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 = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xa01d558, 0xbf9647d0, 0xbf9647cc,
0x104)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3296:SQLExecute(0xa0a8e38)
odbc.c:3021:_SQLExecute(0xa0a8e38)
odbc.c:3026:_SQLExecute() starting with state 0
odbc.c:3134:End prepare, execute
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
odbc.c:1552:SQLAllocStmt(0xa0a8c20, 0xa0dc9b0)
odbc.c:1451:_SQLAllocStmt(0xa0a8c20, 0xa0dc9b0)
odbc.c:4169:SQLGetStmtAttr(0xa0aaa70, 10010, 0xbf9647dc, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa0aaa70, 10010, 0xbf9647dc, 4, (nil))
odbc.c:4169:SQLGetStmtAttr(0xa0aaa70, 10011, 0xbf9647dc, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa0aaa70, 10011, 0xbf9647dc, 4, (nil))
odbc.c:4169:SQLGetStmtAttr(0xa0aaa70, 10012, 0xbf9647dc, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa0aaa70, 10012, 0xbf9647dc, 4, (nil))
odbc.c:4169:SQLGetStmtAttr(0xa0aaa70, 10013, 0xbf9647dc, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa0aaa70, 10013, 0xbf9647dc, 4, (nil))
odbc.c:4214:SQLPrepare(0xa0aaa70, SELECT FaxJob.FaxJobID FROM FaxJob
WHERE( FaxJob.FaxDeptID = -26084249), 71)
odbc.c:4278:Creating prepared statement
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 ca 00 00 01 00-ff ff 0b 00 00 00 00 01 |........
........|
0010 26 04 00 00 00 63 00 00-00 00 09 04 d0 00 34 ff |&....c..
......4.|
0020 ff ff ff 00 00 63 8e 00-00 00 09 04 d0 00 34 8e |.....c..
......4.|
0030 00 00 00 53 00 45 00 4c-00 45 00 43 00 54 00 20 |...S.E.L .E.C.T.
|
0040 00 46 00 61 00 78 00 4a-00 6f 00 62 00 2e 00 46 |.F.a.x.J
.o.b...F|
0050 00 61 00 78 00 4a 00 6f-00 62 00 49 00 44 00 20 |.a.x.J.o .b.I.D.
|
0060 00 46 00 52 00 4f 00 4d-00 20 00 46 00 61 00 78 |.F.R.O.M .
.F.a.x|
0070 00 4a 00 6f 00 62 00 20-00 57 00 48 00 45 00 52 |.J.o.b.
.W.H.E.R|
0080 00 45 00 28 00 20 00 46-00 61 00 78 00 4a 00 6f |.E.(. .F
.a.x.J.o|
0090 00 62 00 2e 00 46 00 61-00 78 00 44 00 65 00 70 |.b...F.a
.x.D.e.p|
00a0 00 74 00 49 00 44 00 20-00 3d 00 20 00 2d 00 32 |.t.I.D. .=.
.-.2|
00b0 00 36 00 30 00 38 00 34-00 32 00 34 00 39 00 29 |.6.0.8.4
.2.4.9.)|
00c0 00 00 00 26 04 04 01 00-00 00 |...&.... ..|
token.c:495:tds_process_tokens(0xa0a8f30, 0xbf9646e0, 0xbf9646dc,
0x104)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 48 00 37 01 00-81 01 00 00 00 10 00 38 |...H.7..
.......8|
0010 08 46 00 61 00 78 00 4a-00 6f 00 62 00 49 00 44 |.F.a.x.J
.o.b.I.D|
0020 00 ff 01 00 c1 00 00 00-00 00 79 00 00 00 00 ac |........
..y.....|
0030 0d 00 00 01 38 00 00 00-26 04 04 01 00 00 00 fe |....8...
&.......|
0040 00 00 e0 00 00 00 00 00- |........|
token.c:510:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1526:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1550:set current_results (1 column) to tds->res_info
token.c:1561:setting up column 0
token.c:1496:tds7_get_data_info:
colname = FaxJobID (8 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0xa0a8f30, 0xbf9646e0, 0xbf9646dc,
0x104)
util.c:162:Changed query state from PENDING to READING
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 = 0
token.c:2305: rows_affected = 0
token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:510:processing result tokens. marker is ac(PARAM)
token.c:567:processing parameters for sp 11
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0xa0a8f30, 0xbf964690)
token.c:1582:tds_get_data_info(0xa0a8f30, 0xa0de630, 1) [for
parameter]token.c:1645:processing result. type = 38(integer-null),
varint_size 1
token.c:1666:processing result. column_size 4
token.c:1984:tds_get_data: type 38, varint size 1
token.c:2048:tds_get_data(): wire column size is 4
log.c:481:type integer-null has value 1
token.c:573:1 hidden return parameters
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 = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xa0a8f30, 0xbf9646e0, 0xbf9646dc,
0x104)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3296:SQLExecute(0xa0aaa70)
odbc.c:3021:_SQLExecute(0xa0aaa70)
odbc.c:3026:_SQLExecute() starting with state 0
odbc.c:3134:End prepare, execute
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 01 00 00-00 |..&..... .|
token.c:495:tds_process_tokens(0xa0a8f30, 0xbf9646c8, 0xbf9646c4,
0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 3d 00 37 01 00-81 01 00 00 00 10 00 38 |...=.7..
.......8|
0010 08 46 00 61 00 78 00 4a-00 6f 00 62 00 49 00 44 |.F.a.x.J
.o.b.I.D|
0020 00 d1 57 00 00 00 ff 11-00 c1 00 01 00 00 00 79 |..W.....
.......y|
0030 00 00 00 00 fe 00 00 e0-00 01 00 00 00 |........ .....|
token.c:510:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1526:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1550:set current_results (1 column) to tds->res_info
token.c:1561:setting up column 0
token.c:1496:tds7_get_data_info:
colname = FaxJobID (8 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
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=4049, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3399:odbc_process_tokens: returning result_type 4049
odbc.c:3175:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:495:tds_process_tokens(0xa0a8f30, 0xbf9646c8, 0xbf9646c4,
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is d1(ROW)
token.c:621:tds_process_tokens::SET_RETURN stopping on current token
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=4040, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3399:odbc_process_tokens: returning result_type 4040
odbc.c:3175:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:4190:SQLNumResultCols(0xa0aaa70, 0xbf964878)
odbc.c:1751:SQLDescribeCol(0xa0aaa70, 1, 0x1863e8, 41, 0xbf964874,
0xbf96486c, 0xbf964860, 0xbf964868, 0xbf964864)
odbc.c:1552:SQLAllocStmt(0xa0a8c20, 0xa0dea40)
odbc.c:1451:_SQLAllocStmt(0xa0a8c20, 0xa0dea40)
odbc.c:4169:SQLGetStmtAttr(0xa096b60, 10010, 0xbf964768, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa096b60, 10010, 0xbf964768, 4, (nil))
odbc.c:4169:SQLGetStmtAttr(0xa096b60, 10011, 0xbf964768, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa096b60, 10011, 0xbf964768, 4, (nil))
odbc.c:4169:SQLGetStmtAttr(0xa096b60, 10012, 0xbf964768, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa096b60, 10012, 0xbf964768, 4, (nil))
odbc.c:4169:SQLGetStmtAttr(0xa096b60, 10013, 0xbf964768, 4, (nil))
odbc.c:4001:_SQLGetStmtAttr(0xa096b60, 10013, 0xbf964768, 4, (nil))
odbc.c:870:SQLPrimaryKeys(0xa096b60, (nil), 0, (nil), 0, 0x121be8, 6)
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
net.c:769:Sending packet
0000 06 01 00 08 00 00 01 00- |........|
token.c:495:tds_process_tokens(0xa0a8f30, 0xbf9647c0, (nil), 0x0)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is d1(ROW)
token.c:2239:tds_process_row(): reading column 0
token.c:1984:tds_get_data: type 56, varint size 0
token.c:2048:tds_get_data(): wire column size is 4
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
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:2305: rows_affected = 1
net.c:663:Received packet
0000 04 01 00 11 00 37 01 00-fd 20 00 fd 00 00 00 00 |.....7.. .
......|
0010 00 - |.|
token.c:510:processing result tokens. marker is fd(DONE)
token.c:2274:tds_process_end: more_results = 0
was_cancelled = 1
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 = 0
odbc.c:3932:SQLFreeStmt(0xa063268, 0)
odbc.c:3853:_SQLFreeStmt(0xa063268, 0, 0)
odbc.c:2057:SQLDisconnect(0xa01cf78)
odbc.c:3853:_SQLFreeStmt(0xa0a8e38, 1, 1)
query.c:1769:tds_submit_unprepare() q4keu39000
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 17 00 00 01 00-ff ff 0f 00 00 00 00 00 |........
........|
0010 26 04 04 02 00 00 00 - |&......|
token.c:495:tds_process_tokens(0xa01d558, 0xbf96497c, 0xbf964978,
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 16 00 33 01 00-79 00 00 00 00 fe 00 00 |.....3..
y.......|
0010 e0 00 01 00 00 00 - |......|
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
token.c:495:tds_process_tokens(0xa01d558, 0xbf96497c, 0xbf964978,
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3853:_SQLFreeStmt(0xa063268, 1, 1)
query.c:1769:tds_submit_unprepare() q4keu36000
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 17 00 00 01 00-ff ff 0f 00 00 00 00 00 |........
........|
0010 26 04 04 01 00 00 00 - |&......|
token.c:495:tds_process_tokens(0xa01d558, 0xbf96497c, 0xbf964978,
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 16 00 33 01 00-79 00 00 00 00 fe 00 00 |.....3..
y.......|
0010 e0 00 01 00 00 00 - |......|
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
token.c:495:tds_process_tokens(0xa01d558, 0xbf96497c, 0xbf964978,
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
odbc.c:3764:SQLFreeHandle(2, 0x0xa01cf78)
odbc.c:3790:_SQLFreeConnect(0xa01cf78)
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.
********************************************************
-
[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
-
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
Archive powered by MHonArc 2.6.24.