Skip to content

Instantly share code, notes, and snippets.

@metaskills

metaskills/gist:605209

Created September 30, 2010 19:53
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save metaskills/605209 to your computer and use it in GitHub Desktop.
Save metaskills/605209 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
# result = @client.execute('SELECT 1 AS [one]')
# result.cancel
# result.cancel
write.c:136:tds_put_string converting 17 bytes of "SELECT 1 AS [one]"
write.c:164:tds_put_string wrote 34 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 2a 00 00 01 00-53 00 45 00 4c 00 45 00 |...*.... S.E.L.E.|
0010 43 00 54 00 20 00 31 00-20 00 41 00 53 00 20 00 |C.T. .1. .A.S. .|
0020 5b 00 6f 00 6e 00 65 00-5d 00 |[.o.n.e. ].|
dblib.c:4532:dbsqlok(0x10151e580)
net.c:592:Received header
0000 04 01 00 25 00 34 01 00- |...%.4..|
net.c:671:Received packet
0000 81 01 00 00 00 20 00 38-03 6f 00 6e 00 65 00 d1 |..... .8 .o.n.e..|
0010 01 00 00 00 fd 10 00 c1-00 01 00 00 00 |........ .....|
dblib.c:4556:dbsqlok() exits on result token 0x81
dblib.c:3093:dbcancel(0x10151e580)
query.c:1934:tds_send_cancel: not in_cancel and not idle
query.c:1943:tds_send_cancel: sending cancel packet
net.c:779:Sending packet
0000 06 01 00 08 00 00 01 00- |........|
token.c:495:tds_process_tokens(0x10151e7b0, 0x7fff5fbf331c, 0x0, 0x0)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (1 column) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info:
colname = one (3 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:510:processing result tokens. marker is d1(ROW)
token.c:2166:tds_process_row(): reading column 0
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:510:processing result tokens. marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2232: rows_affected = 1
net.c:592:Received header
0000 04 01 00 11 00 34 01 00- |.....4..|
net.c:671:Received packet
0000 fd 20 00 fd 00 00 00 00-00 |. ...... .|
token.c:510:processing result tokens. marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 1
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
# assert_raise(TinyTds::Error) { @client.execute('SELECT * FROM [foobar]') }
# assert_nothing_raised() { @client.execute(@query1).each }
# static VALUE rb_tinytds_raise_error(DBPROCESS *dbproc, char *error, char *source, int severity, int dberr, int oserr) {
# dbcancel(dbproc);
dblib.c:1298:dbsqlexec(0x10151e580)
dblib.c:6722:dbsqlsend(0x10151e580)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 22 bytes of "SELECT * FROM [foobar]"
write.c:164:tds_put_string wrote 44 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 34 00 00 01 00-53 00 45 00 4c 00 45 00 |...4.... S.E.L.E.|
0010 43 00 54 00 20 00 2a 00-20 00 46 00 52 00 4f 00 |C.T. .*. .F.R.O.|
0020 4d 00 20 00 5b 00 66 00-6f 00 6f 00 62 00 61 00 |M. .[.f. o.o.b.a.|
0030 72 00 5d 00 - |r.].|
dblib.c:4532:dbsqlok(0x10151e580)
net.c:592:Received header
0000 04 01 00 70 00 34 01 00- |...p.4..|
net.c:671:Received packet
0000 aa 5c 00 d0 00 00 00 01-10 1d 00 49 00 6e 00 76 |.\...... ...I.n.v|
0010 00 61 00 6c 00 69 00 64-00 20 00 6f 00 62 00 6a |.a.l.i.d . .o.b.j|
0020 00 65 00 63 00 74 00 20-00 6e 00 61 00 6d 00 65 |.e.c.t. .n.a.m.e|
0030 00 20 00 27 00 66 00 6f-00 6f 00 62 00 61 00 72 |. .'.f.o .o.b.a.r|
0040 00 27 00 2e 00 0b 53 00-51 00 4c 00 53 00 45 00 |.'....S. Q.L.S.E.|
0050 52 00 56 00 45 00 52 00-30 00 38 00 00 01 00 fd |R.V.E.R. 0.8.....|
0060 02 00 fd 00 00 00 00 00- |........|
dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(0x10151e7b0, 0x7fff5fbee068, 0x7fff5fbee06c, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is aa(ERROR)
token.c:108:tds_process_default_tokens() marker is aa(ERROR)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0x10151ee60, 0x10151e7b0, 0x7fff5fbede90)
dbutil.c:87:msgno 208: "Invalid object name 'foobar'."
dblib.c:3093:dbcancel(0x10151e580)
query.c:1934:tds_send_cancel: not in_cancel and not idle
query.c:1943:tds_send_cancel: sending cancel packet
net.c:779:Sending packet
0000 06 01 00 08 00 00 01 00- |........|
dblib.c:1243:dbcmd(0x10151e580, SELECT 1 AS [one])
dblib.c:1250:dbcmd() bufsz = 23
dblib.c:5727:dbfreebuf(0x10151e580)
dblib.c:1298:dbsqlexec(0x10151e580)
dblib.c:6722:dbsqlsend(0x10151e580)
util.c:142:logic error: cannot change query state from READING to QUERYING
util.c:334:tdserror(0x10151ee60, 0x10151e7b0, 20019, 0)
dblib.c:7782:dbperror(0x10151e580, 20019, 0)
dblib.c:7835:20019: "Attempt to initiate a new Adaptive Server operation with results pending"
dblib.c:3093:dbcancel(0x10151e580)
query.c:1934:tds_send_cancel: in_cancel and not idle
dblib.c:718:dbloginfree(0x10151ee90)
dblib.c:1372:dbclose(0x10151e580)
dblib.c:256:dblib_del_connection(0x100711ac0, 0x10151e7b0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from READING to DEAD
dblib.c:303:dblib_release_tds_ctx(1)
dblib.c:5727:dbfreebuf(0x10151e580)
# RETCODE rc_send, rc_ok;
#
# printf("\n\nMETASKILLS: BEFORE - dbsqlsend(cwrap->client)\n");
# rc_send = dbsqlsend(cwrap->client);
# printf("METASKILLS: AFTER - dbsqlsend(cwrap->client)\n");
# printf("METASKILLS: AFTER - %i",rc_send);
#
# printf("\n\nMETASKILLS: BEFORE - dbsqlok(cwrap->client)\n");
# rc_ok = dbsqlok(cwrap->client);
# printf("METASKILLS: AFTER - dbsqlok(cwrap->client)\n");
# printf("METASKILLS: AFTER - %i",rc_ok);
# METASKILLS: BEFORE - dbsqlsend(cwrap->client)
# METASKILLS: AFTER - dbsqlsend(cwrap->client)
# METASKILLS: AFTER - 1
#
# METASKILLS: BEFORE - dbsqlok(cwrap->client)
dblib.c:1243:dbcmd(0x10151c850, SELECT * FROM [foobar])
dblib.c:1250:dbcmd() bufsz = 0
dblib.c:6722:dbsqlsend(0x10151c850)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 22 bytes of "SELECT * FROM [foobar]"
write.c:164:tds_put_string wrote 44 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 34 00 00 01 00-53 00 45 00 4c 00 45 00 |...4.... S.E.L.E.|
0010 43 00 54 00 20 00 2a 00-20 00 46 00 52 00 4f 00 |C.T. .*. .F.R.O.|
0020 4d 00 20 00 5b 00 66 00-6f 00 6f 00 62 00 61 00 |M. .[.f. o.o.b.a.|
0030 72 00 5d 00 - |r.].|
dblib.c:4532:dbsqlok(0x10151c850)
net.c:592:Received header
0000 04 01 00 70 00 35 01 00- |...p.5..|
net.c:671:Received packet
0000 aa 5c 00 d0 00 00 00 01-10 1d 00 49 00 6e 00 76 |.\...... ...I.n.v|
0010 00 61 00 6c 00 69 00 64-00 20 00 6f 00 62 00 6a |.a.l.i.d . .o.b.j|
0020 00 65 00 63 00 74 00 20-00 6e 00 61 00 6d 00 65 |.e.c.t. .n.a.m.e|
0030 00 20 00 27 00 66 00 6f-00 6f 00 62 00 61 00 72 |. .'.f.o .o.b.a.r|
0040 00 27 00 2e 00 0b 53 00-51 00 4c 00 53 00 45 00 |.'....S. Q.L.S.E.|
0050 52 00 56 00 45 00 52 00-30 00 38 00 00 01 00 fd |R.V.E.R. 0.8.....|
0060 02 00 fd 00 00 00 00 00- |........|
dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(0x10151cb30, 0x7fff5fbedf88, 0x7fff5fbedf8c, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is aa(ERROR)
token.c:108:tds_process_default_tokens() marker is aa(ERROR)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0x10151d400, 0x10151cb30, 0x7fff5fbeddb0)
dbutil.c:87:msgno 208: "Invalid object name 'foobar'."
# (kencollins@mc1) - (~)
# ∴ tsql -S mc2008 -U tinytds -P ""
# locale is "en_US.UTF-8"
# locale charset is "UTF-8"
# 1> SELECT * FROM [foobar]
# 2> GO
# Msg 208, Level 16, State 1, Server SQLSERVER08, Line 1
# Invalid object name 'foobar'.
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 23 bytes of "SELECT * FROM [foobar]
"
write.c:164:tds_put_string wrote 46 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 36 00 00 01 00-53 00 45 00 4c 00 45 00 |...6.... S.E.L.E.|
0010 43 00 54 00 20 00 2a 00-20 00 46 00 52 00 4f 00 |C.T. .*. .F.R.O.|
0020 4d 00 20 00 5b 00 66 00-6f 00 6f 00 62 00 61 00 |M. .[.f. o.o.b.a.|
0030 72 00 5d 00 0a 00 - |r.]...|
token.c:495:tds_process_tokens(0x1002007b0, 0x7fff5fbfed0c, 0x0, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 70 00 35 01 00- |...p.5..|
net.c:671:Received packet
0000 aa 5c 00 d0 00 00 00 01-10 1d 00 49 00 6e 00 76 |?\.?.... ...I.n.v|
0010 00 61 00 6c 00 69 00 64-00 20 00 6f 00 62 00 6a |.a.l.i.d . .o.b.j|
0020 00 65 00 63 00 74 00 20-00 6e 00 61 00 6d 00 65 |.e.c.t. .n.a.m.e|
0030 00 20 00 27 00 66 00 6f-00 6f 00 62 00 61 00 72 |. .'.f.o .o.b.a.r|
0040 00 27 00 2e 00 0b 53 00-51 00 4c 00 53 00 45 00 |.'....S. Q.L.S.E.|
0050 52 00 56 00 45 00 52 00-30 00 38 00 00 01 00 fd |R.V.E.R. 0.8....?|
0060 02 00 fd 00 00 00 00 00- |..?.....|
token.c:510:processing result tokens. marker is aa(ERROR)
token.c:108:tds_process_default_tokens() marker is aa(ERROR)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:510:processing result tokens. marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x1002007b0, 0x7fff5fbfed0c, 0x0, 0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
# 1> SELECT 1 AS [one]
# 2> GO
# one
# 1
# (1 row affected)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 18 bytes of "SELECT 1 AS [one]
"
write.c:164:tds_put_string wrote 36 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 2c 00 00 01 00-53 00 45 00 4c 00 45 00 |...,.... S.E.L.E.|
0010 43 00 54 00 20 00 31 00-20 00 41 00 53 00 20 00 |C.T. .1. .A.S. .|
0020 5b 00 6f 00 6e 00 65 00-5d 00 0a 00 |[.o.n.e. ]...|
token.c:495:tds_process_tokens(0x1002007b0, 0x7fff5fbfed0c, 0x0, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 25 00 35 01 00- |...%.5..|
net.c:671:Received packet
0000 81 01 00 00 00 20 00 38-03 6f 00 6e 00 65 00 d1 |..... .8 .o.n.e.?|
0010 01 00 00 00 fd 10 00 c1-00 01 00 00 00 |....?..? .....|
token.c:510:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (1 column) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info:
colname = one (3 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(0x1002007b0, 0x7fff5fbfed0c, 0x0, 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
token.c:495:tds_process_tokens(0x1002007b0, 0x7fff5fbfed0c, 0x0, 0x1508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is d1(ROW)
token.c:2166:tds_process_row(): reading column 0
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x1002007b0, 0x7fff5fbfed0c, 0x0, 0x1508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 1
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x1002007b0, 0x7fff5fbfed0c, 0x0, 0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment