Skip to Content.
Sympa Menu

freetds - Re: [freetds] DB-Lib error message 20017, severity 9:Unexpected EOF from the server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Wagner, Steve" <Steve.Wagner AT 49ers.com>
  • To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] DB-Lib error message 20017, severity 9:Unexpected EOF from the server
  • Date: Thu, 30 Nov 2017 02:34:36 +0000

Sorry to repost but I haven't received any response to this email so I don't
even know if the original post has been seen.

This is a newbie question but how can I see recent activity on this mailing
list. The latest post in the archives is from Nov 20.

I am subscribed to the list.sd

Steve

From: Wagner, Steve
Sent: Tuesday, November 28, 2017 1:41 PM
To: 'freetds AT lists.ibiblio.org' <freetds AT lists.ibiblio.org>
Subject: DB-Lib error message 20017, severity 9:Unexpected EOF from the server

We've been using pymssql and FreeTDS for over 2 years now without problems.
We recently upgraded pymssql to 2.1.3 and also from Python 3.4 to 3.6. Since
that upgrade we've been getting the following error intermittently (but
frequently).

(20017, b'DB-Lib error message 20017, severity 9:\nUnexpected EOF from the
server (FBOps-Prod:1433)\nDB-Lib error message 20002, severity 9:\nAdaptive
Server connection failed (FBOps-Prod:1433)\n')

There is no apparent pattern to the failures that we have been able to
discover. Well over 95% of the DB calls succeed. It can fail on any stored
proc or sql query.

The database calls apparently do not even get to the database because nothing
shows up in any DB log or trace.

I've scoured the web and come up empty.

I've reinstalled pymssql and FreeTDS but it still fails.

Failures occur when connected to a DB server that is remote to the app but
when connected to localhost.

I've checked max number of connections and it's 4096 which should be plenty
as there are no more than 10 active users at a time.

Below is an excerpt from the TDS log file (full log file at the end).


packet.c:639:Received packet

0000 04 01 00 11 00 5c 01 00-fd 00 00 d4 00 00 00 00 |.....\.. ........|

0010 00 - |.|



token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:2101:tds_process_end() state set to TDS_IDLE

util.c:165:Changed query state from READING to IDLE

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


I've looked at the relevant code but don't have sufficient knowledge to
understand why it's failing. Any help is appreciated.

Given that it's sporadic and the packet received just before the failure is
identical (or at least very similar), I suspect it might be a networking
issue. And that is DEFINITELY beyond my expertise although I'm ready to try
anything if given some guidance.

Full log below...

I appreciate any and all help.

Steve


log.c:167:Starting log file for FreeTDS 0.95

on 2017-11-28 09:19:48 with debug flags 0x4fff.

dblib.c:1160:tdsdbopen(0000000006F7C9B0, FBOps-Prod:1433, [microsoft])

dblib.c:1186:tdsdbopen: dbproc->dbopts = 0000000007422E90

dblib.c:1193:tdsdbopen: tds_set_server(0000000006E3D920, "FBOps-Prod:1433")

dblib.c:258:dblib_get_tds_ctx(void)

dblib.c:1210:tdsdbopen: About to call tds_read_config_info...

config.c:168:Getting connection information for [FBOps-Prod:1433].

config.c:172:Attempting to read conf files.

config.c:353:... $FREETDSCONF not set. Trying $FREETDS/etc.

config.c:366:... $FREETDS not set. Trying $HOME.

config.c:292:Could not open
'C:\Users\prospector.user\AppData\Roaming/.freetds.conf' ((.freetds.conf)).

config.c:296:Found conf file 'c:\freetds.conf' (default).

config.c:495:Looking for section global.

config.c:554: Found section global.

config.c:557:Got a match.

config.c:580: tds version = '7.3'

config.c:886:Setting tds version to 7.3 (0x703).

config.c:554: Found section fbops-prod.

config.c:568: Reached EOF

config.c:495:Looking for section FBOps-Prod:1433.

config.c:554: Found section global.

config.c:554: Found section fbops-prod.

config.c:568: Reached EOF

config.c:302:[FBOps-Prod:1433] not found.

config.c:353:... $FREETDSCONF not set. Trying $FREETDS/etc.

config.c:366:... $FREETDS not set. Trying $HOME.

config.c:292:Could not open
'C:\Users\prospector.user\AppData\Roaming/.freetds.conf' ((.freetds.conf)).

config.c:296:Found conf file 'c:\freetds.conf' (default).

config.c:495:Looking for section global.

config.c:554: Found section global.

config.c:557:Got a match.

config.c:580: tds version = '7.3'

config.c:886:Setting tds version to 7.3 (0x703).

config.c:554: Found section fbops-prod.

config.c:568: Reached EOF

config.c:495:Looking for section FBOps-Prod.

config.c:554: Found section global.

config.c:554: Found section fbops-prod.

config.c:557:Got a match.

config.c:580: host = 'fbops-prod'

config.c:617:Found host entry fbops-prod

config.c:620:IP addr is 10.164.222.55.

config.c:568: Reached EOF

config.c:300:Success: [FBOps-Prod] defined in c:\freetds.conf.

config.c:765:Setting 'dump_file' to 'c:\freetds.log' from $TDSDUMP.

config.c:689:tds_config_login: client_charset is UTF-8.

config.c:696:tds_config_login: database_name is Goldmine.

config.c:765:Setting 'dump_file' to 'c:\freetds.log' from $TDSDUMP.

dblib.c:1237:tdsdbopen: Calling tds_connect_and_login(00000000075359E0,
0000000006E3DA10)

iconv.c:328:tds_iconv_open(00000000075359E0, UTF-8)

iconv.c:346:setting up conversions for client charset "UTF-8"

iconv.c:348:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion

iconv.c:395:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion

iconv.c:400:tds_iconv_open: done

net.c:202:Connecting to 10.164.222.55 port 1433 (TDS version 7.1)

net.c:275:tds_open_socket: connect(2) returned "WSAEWOULDBLOCK: Resource
temporarily unavailable."

net.c:314:tds_open_socket() succeeded

packet.c:740:Sending packet

0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|

0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(......|

0020 55 00 00 00 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|

0030 bc 11 00 00 - |....|



packet.c:639:Received packet

0000 04 01 00 25 00 00 01 00-00 00 15 00 06 01 00 1b |...%.... ........|

0010 00 01 02 00 1c 00 01 03-00 1d 00 00 ff 0c 00 14 |........ ........|

0020 57 00 00 00 00 - |W....|



login.c:1106:detected flag 0

tls.c:116:in tds_push_func_login

tls.c:82:in tds_pull_func_login

packet.c:740:Sending packet

0000 12 01 00 5c 00 00 00 00-16 03 01 00 4f 01 00 00 |...\.... ....O...|

0010 4b 03 01 af 63 5a 07 d9-79 47 24 fb 55 ed 88 a0 |K...cZ.. yG$.U...|

0020 9a 82 5b ed e3 70 c1 27-6d c2 9b 47 b7 d0 a9 af |..[..p.' m..G....|

0030 a4 e4 68 00 00 18 00 39-00 38 00 35 00 16 00 13 |..h....9 .8.5....|

0040 00 0a 00 33 00 32 00 2f-00 05 00 04 00 ff 02 01 |...3.2./ ........|

0050 00 00 09 00 23 00 00 00-0f 00 01 01 |....#... ....|



tls.c:94:have 0

tls.c:98:before read

packet.c:639:Received packet

0000 12 01 04 75 00 00 00 00-16 03 01 04 68 02 00 00 |...u.... ....h...|

0010 4d 03 01 5a 1d 9a b4 c9-30 fb 36 35 f3 31 8f ab |M..Z.... 0.65.1..|

0020 a6 ec 20 2e 78 a4 dd 18-35 7f c6 12 94 d9 da 35 |.. .x... 5......5|

0030 9a 11 0c 20 07 08 00 00-3e c0 5b 8b 15 27 db 2c |... .... >.[..'.,|

0040 9a 2b 21 78 60 39 f2 bd-5e 86 0a bf 1a b0 07 93 |.+!x`9.. ^.......|

0050 71 47 ec e7 00 39 00 00-05 ff 01 00 01 00 0b 00 |qG...9.. ........|

0060 02 03 00 02 00 00 01 fd-30 82 01 f9 30 82 01 62 |........ 0...0..b|

0070 a0 03 02 01 02 02 10 12-4b b2 71 c2 96 23 b0 42 |........ K.q..#.B|

0080 41 e3 e3 28 a3 4a 45 30-0d 06 09 2a 86 48 86 f7 |A..(.JE0 ...*.H..|

0090 0d 01 01 05 05 00 30 3b-31 39 30 37 06 03 55 04 |......0; 1907..U.|

00a0 03 1e 30 00 53 00 53 00-4c 00 5f 00 53 00 65 00 |..0.S.S. L._.S.e.|

00b0 6c 00 66 00 5f 00 53 00-69 00 67 00 6e 00 65 00 |l.f._.S. i.g.n.e.|

00c0 64 00 5f 00 46 00 61 00-6c 00 6c 00 62 00 61 00 |d._.F.a. l.l.b.a.|

00d0 63 00 6b 30 1e 17 0d 31-37 31 31 32 31 31 37 30 |c.k0...1 71121170|

00e0 35 35 34 5a 17 0d 34 37-31 31 32 31 31 37 30 35 |554Z..47 11211705|

00f0 35 34 5a 30 3b 31 39 30-37 06 03 55 04 03 1e 30 |54Z0;190 7..U...0|

0100 00 53 00 53 00 4c 00 5f-00 53 00 65 00 6c 00 66 |.S.S.L._ .S.e.l.f|

0110 00 5f 00 53 00 69 00 67-00 6e 00 65 00 64 00 5f |._.S.i.g .n.e.d._|

0120 00 46 00 61 00 6c 00 6c-00 62 00 61 00 63 00 6b |.F.a.l.l .b.a.c.k|

0130 30 81 9f 30 0d 06 09 2a-86 48 86 f7 0d 01 01 01 |0..0...* .H......|

0140 05 00 03 81 8d 00 30 81-89 02 81 81 00 ca 61 00 |......0. ......a.|

0150 0d a1 71 34 93 f1 82 5d-55 f5 cf 11 26 96 e0 70 |..q4...] U...&..p|

0160 cf 55 c2 20 e3 48 27 e7-12 c5 8d 0d 02 1e 13 68 |.U. .H'. .......h|

0170 17 1b fe 8f 66 4b d0 79-a6 a7 94 0a 5f 0d 47 4c |....fK.y ...._.GL|

0180 04 c0 07 95 37 34 76 64-5c 33 14 96 62 2e 75 44 |....74vd \3..b.uD|

0190 1d 1b 68 00 1b 24 27 6d-d1 fe 17 55 26 71 97 28 |..h..$'m ...U&q.(|

01a0 6f 1a a7 62 2e 78 8f 7d-96 53 44 e7 4c 8a 08 3f |o..b.x.} .SD.L..?|

01b0 cd a7 57 3c 58 80 8f a1-f0 f5 f4 c2 d0 b7 4c c5 |..W<X... ......L.|

01c0 5c 44 9b 87 7f 49 49 7e-7a 7c 73 d6 9b 02 03 01 |\D...II~ z|s.....|

01d0 00 01 30 0d 06 09 2a 86-48 86 f7 0d 01 01 05 05 |..0...*. H.......|

01e0 00 03 81 81 00 bf 46 6a-81 5c f7 4c 35 30 d4 05 |......Fj .\.L50..|

01f0 c1 b5 0b 8c 06 49 7a 95-aa e4 81 1e 2d 12 32 90 |.....Iz. ....-.2.|

0200 f1 cf 9b a7 d9 96 21 db-fa 6d 0e 31 0d c2 cb 96 |......!. .m.1....|

0210 bd bd f1 b2 1e 3a c7 9d-e3 29 20 ce 6c d1 2b 3d |.....:.. .) .l.+=|

0220 e2 57 85 f4 c4 c4 47 c4-91 92 48 f9 24 3d 4e a0 |.W....G. ..H.$=N.|

0230 de f9 aa 1b 34 d4 fb 30-ba eb 0e b6 57 a6 40 33 |....4..0
....W.@3|<mailto:....W.@3|>

0240 2c 19 bf aa 3d eb 7c 8b-f4 45 48 21 e6 11 a7 37 |,...=.|. .EH!...7|

0250 70 16 f3 d3 aa f8 1e 98-b7 a4 dd 92 db a1 b5 fb |p....... ........|

0260 ae d0 55 bb af 0c 00 02-08 00 80 ff ff ff ff ff |..U..... ........|

0270 ff ff ff c9 0f da a2 21-68 c2 34 c4 c6 62 8b 80 |.......! h.4..b..|

0280 dc 1c d1 29 02 4e 08 8a-67 cc 74 02 0b be a6 3b |...).N.. g.t....;|

0290 13 9b 22 51 4a 08 79 8e-34 04 dd ef 95 19 b3 cd |.."QJ.y. 4.......|

02a0 3a 43 1b 30 2b 0a 6d f2-5f 14 37 4f e1 35 6d 6d |:C.0+.m. _.7O.5mm|

02b0 51 c2 45 e4 85 b5 76 62-5e 7e c6 f4 4c 42 e9 a6 |Q.E...vb ^~..LB..|

02c0 37 ed 6b 0b ff 5c b6 f4-06 b7 ed ee 38 6b fb 5a |7.k..\.. ....8k.Z|

02d0 89 9f a5 ae 9f 24 11 7c-4b 1f e6 49 28 66 51 ec |.....$.| K..I(fQ.|

02e0 e6 53 81 ff ff ff ff ff-ff ff ff 00 80 00 00 00 |.S...... ........|

02f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0300 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0310 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0320 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0330 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0340 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0350 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0360 00 00 00 00 00 00 00 00-00 00 00 00 02 00 80 75 |........ .......u|

0370 eb 3c 53 f2 04 55 1d 8c-37 cd 60 27 3e 07 dc 44 |.<S..U.. 7.`'>..D|

0380 ed 4b f7 04 87 9d 13 18-e5 8f 9d 00 b6 b3 53 67 |.K...... ......Sg|

0390 be 7d f9 39 59 df 06 2a-16 9e fa 5c e8 31 54 e0 |.}.9Y..* ...\.1T.|

03a0 ea 4d 2e 0d 85 9c 53 80-d3 a0 97 67 74 df ff ab |.M....S. ...gt...|

03b0 dd f7 ae af 50 5d d7 e4-a0 70 e2 fb a3 3b 59 41 |....P].. .p...;YA|

03c0 98 4f 2a 0f 91 dc 5a bf-22 79 27 db f2 0b 93 9a |.O*...Z. "y'.....|

03d0 8d 46 c5 ec 18 cf d4 36-92 d2 3c 55 57 97 36 ef |.F.....6 ..<UW.6.|

03e0 e9 48 85 96 6b 46 4d 36-1c 85 41 37 ee d7 11 00 |.H..kFM6 ..A7....|

03f0 80 6f f0 65 d4 4c f6 4b-90 12 33 3b 26 bb 7f f6 |.o.e.L.K ..3;&...|

0400 eb 04 e6 f0 a1 f3 bf b7-b9 b2 48 e7 5e 5b 21 95 |........ ..H.^[!.|

0410 ce 36 30 4b 11 63 2b e3-37 fa 22 cf 1f d3 ad 76 |.60K.c+. 7."....v|

0420 d5 0b 44 7e b4 08 15 82-26 e4 d7 d7 ac c4 7f f9 |..D~.... &.......|

0430 9c ce 62 ef 10 fa fd 12-be 02 bf 06 69 e2 ad e2 |..b..... ....i...|

0440 56 51 41 38 04 3a 82 f0-73 38 15 b9 3f 9b f0 cf |VQA8.:.. s8..?...|

0450 1e 62 e0 ba 74 4e 78 64-37 3b 83 e3 23 0e 93 1b |.b..tNxd 7;..#...|

0460 9f 0a e2 e8 eb b6 23 d0-ae b5 38 b2 23 33 dc 24 |......#. ..8.#3.$|

0470 ae 0e 00 00 00 - |.....|



tls.c:101:after read

tls.c:94:have 1133

tls.c:105:read 5 bytes

tls.c:82:in tds_pull_func_login

tls.c:94:have 1128

tls.c:105:read 1128 bytes

tls.c:116:in tds_push_func_login

packet.c:740:Sending packet

0000 12 01 00 ce 00 00 00 00-16 03 01 00 86 10 00 00 |........ ........|

0010 82 00 80 c0 85 e4 eb 17-7c 7d bb 0a 0c ac 66 d5 |........ |}....f.|

0020 00 52 f1 26 d6 69 1b e5-5f ac 4e ca 89 b0 52 ae |.R.&.i.. _.N...R.|

0030 b9 0c 83 1c ba e4 79 d4-f7 a2 6d fb db ed 4c 8c |......y. ..m...L.|

0040 ba d7 48 72 10 74 24 c4-2b 00 ba 31 3e d9 23 38 |..Hr.t$. +..1>.#8|

0050 f2 bf 39 82 69 4e 93 aa-5d 90 e0 02 88 d4 30 d6 |..9.iN.. ].....0.|

0060 40 45 04 b9 a1 0f 2f 6e-e0 da 2d 4c ca e1 22 2a
|@E..../n<mailto:|@E..../n> ..-L.."*|

0070 b5 fc 94 e1 d1 2f 24 20-a3 00 7a 4b 0e c7 ff d1 |...../$ ..zK....|

0080 12 66 84 98 b8 50 3a 16-1e 9c 88 ac 97 1e 09 19 |.f...P:. ........|

0090 a3 c0 d6 14 03 01 00 01-01 16 03 01 00 30 8a 9c |........ .....0..|

00a0 74 4d 32 74 59 cd 96 0e-33 06 ed 27 60 f2 28 3e |tM2tY... 3..'`.(>|

00b0 a3 cc 82 e4 db 69 5d 50-e4 98 7a e4 62 61 5e 3f |.....i]P ..z.ba^?|

00c0 3e 32 bf a1 ce 08 c6 08-09 29 5c 22 c4 33 |>2...... .)\".3|



tls.c:82:in tds_pull_func_login

tls.c:94:have 0

tls.c:98:before read

packet.c:639:Received packet

0000 12 01 00 43 00 00 00 00-14 03 01 00 01 01 16 03 |...C.... ........|

0010 01 00 30 8e 55 4d 00 d4-8a cc 3e c1 bc b6 07 4d |..0.UM.. ..>....M|

0020 ec de 3c c8 2b 8f a1 54-16 71 22 69 14 fb d1 1e |..<.+..T .q"i....|

0030 2b a0 09 1d bb 46 21 67-d5 66 cf fb c1 9f 31 3b |+....F!g .f....1;|

0040 f0 5a 75 - |.Zu|



tls.c:101:after read

tls.c:94:have 59

tls.c:105:read 5 bytes

tls.c:82:in tds_pull_func_login

tls.c:94:have 54

tls.c:105:read 1 bytes

tls.c:82:in tds_pull_func_login

tls.c:94:have 53

tls.c:105:read 5 bytes

tls.c:82:in tds_pull_func_login

tls.c:94:have 48

tls.c:105:read 48 bytes

tls.c:855:handshake succeeded!!

login.c:852:quietly sending TDS 7+ login packet

token.c:327:tds_process_login_tokens()

packet.c:639:Received packet

0000 04 01 01 89 00 4e 01 00-e3 1f 00 01 08 47 00 6f |.....N.. .....G.o|

0010 00 6c 00 64 00 6d 00 69-00 6e 00 65 00 06 6d 00 |.l.d.m.i .n.e..m.|

0020 61 00 73 00 74 00 65 00-72 00 ab 6e 00 45 16 00 |a.s.t.e. r..n.E..|

0030 00 02 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|

0040 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a|

0050 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e|

0060 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 47 |.x.t. .t .o. .'.G|

0070 00 6f 00 6c 00 64 00 6d-00 69 00 6e 00 65 00 27 |.o.l.d.m .i.n.e.'|

0080 00 2e 00 0a 46 00 42 00-4f 00 50 00 53 00 2d 00 |....F.B. O.P.S.-.|

0090 50 00 52 00 4f 00 44 00-00 01 00 e3 08 00 07 05 |P.R.O.D. ........|

00a0 09 04 d0 00 34 00 e3 17-00 02 0a 75 00 73 00 5f |....4... ...u.s._|

00b0 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 00 |.e.n.g.l .i.s.h..|

00c0 ab 6e 00 47 16 00 00 01-00 27 00 43 00 68 00 61 |.n.G.... .'.C.h.a|

00d0 00 6e 00 67 00 65 00 64-00 20 00 6c 00 61 00 6e |.n.g.e.d . .l.a.n|

00e0 00 67 00 75 00 61 00 67-00 65 00 20 00 73 00 65 |.g.u.a.g .e. .s.e|

00f0 00 74 00 74 00 69 00 6e-00 67 00 20 00 74 00 6f |.t.t.i.n .g. .t.o|

0100 00 20 00 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |. .u.s._ .e.n.g.l|

0110 00 69 00 73 00 68 00 2e-00 0a 46 00 42 00 4f 00 |.i.s.h.. ..F.B.O.|

0120 50 00 53 00 2d 00 50 00-52 00 4f 00 44 00 00 01 |P.S.-.P. R.O.D...|

0130 00 ad 36 00 01 71 00 00-01 16 4d 00 69 00 63 00 |..6..q.. ..M.i.c.|

0140 72 00 6f 00 73 00 6f 00-66 00 74 00 20 00 53 00 |r.o.s.o. f.t. .S.|

0150 51 00 4c 00 20 00 53 00-65 00 72 00 76 00 65 00 |Q.L. .S. e.r.v.e.|

0160 72 00 00 00 00 00 0c 00-14 57 e3 13 00 04 04 34 |r....... .W.....4|

0170 00 30 00 39 00 36 00 04-34 00 30 00 39 00 36 00 |.0.9.6.. 4.0.9.6.|

0180 fd 00 00 00 00 00 00 00-00 |........ .|



token.c:336:looking for login token, got e3(ENVCHANGE)

token.c:116:tds_process_default_tokens() marker is e3(ENVCHANGE)

dblib.c:312:db_env_chg(00000000075359E0, 1, master, Goldmine)

token.c:336:looking for login token, got ab(INFO)

token.c:116:tds_process_default_tokens() marker is ab(INFO)

token.c:2345:tds_process_msg() reading message 5701 from server

token.c:2417:tds_process_msg() calling client msg handler

dbutil.c:76:_dblib_handle_info_message(0000000002C2CFA0, 00000000075359E0,
000000000A58B3F0)

dbutil.c:77:msgno 5701: "Changed database context to 'Goldmine'."

token.c:2430:tds_process_msg() returning TDS_SUCCESS

token.c:336:looking for login token, got e3(ENVCHANGE)

token.c:116:tds_process_default_tokens() marker is e3(ENVCHANGE)

token.c:2179:tds_process_env_chg(): 5 bytes of collation data received

token.c:2180:tds->conn->collation was

0000 00 00 00 00 00 - |.....|



iconv.c:796:setting server single-byte charset to "CP1252"

token.c:2190:tds->conn->collation now

0000 09 04 d0 00 34 - |....4|



token.c:336:looking for login token, got e3(ENVCHANGE)

token.c:116:tds_process_default_tokens() marker is e3(ENVCHANGE)

dblib.c:312:db_env_chg(00000000075359E0, 2, , us_english)

token.c:336:looking for login token, got ab(INFO)

token.c:116:tds_process_default_tokens() marker is ab(INFO)

token.c:2345:tds_process_msg() reading message 5703 from server

token.c:2417:tds_process_msg() calling client msg handler

dbutil.c:76:_dblib_handle_info_message(0000000002C2CFA0, 00000000075359E0,
000000000A58B3F0)

dbutil.c:77:msgno 5703: "Changed language setting to us_english."

token.c:2430:tds_process_msg() returning TDS_SUCCESS

token.c:336:looking for login token, got ad(LOGINACK)

token.c:374:server reports TDS version 71.0.0.1

token.c:376:Product name for 0x71000001 is 2000 SP1

token.c:408:Product version 8C001457

token.c:336:looking for login token, got e3(ENVCHANGE)

token.c:116:tds_process_default_tokens() marker is e3(ENVCHANGE)

token.c:2236:changing block size from 4096 to 4096

dblib.c:312:db_env_chg(00000000075359E0, 4, 4096, 4096)

token.c:336:looking for login token, got fd(DONE)

token.c:116:tds_process_default_tokens() marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:2101:tds_process_end() state set to TDS_IDLE

token.c:440:tds_process_login_tokens() returning TDS_SUCCESS

dblib.c:224:dblib_add_connection(000007FEF8B0FA70, 00000000075359E0)

dblib.c:1280:tdsdbopen: Returning dbproc = 000000000775B3B0

dblib.c:743:dbloginfree(0000000006F7C9B0)

dblib.c:1338:dbcmd(000000000775B3B0, SET ARITHABORT ON;SET
CONCAT_NULL_YIELDS_NULL ON;SET ANSI_NULLS ON;SET ANSI_NULL_DFLT_ON ON;SET
ANSI_PADDING ON;SET ANSI_WARNINGS ON;SET ANSI_NULL_DFLT_ON ON;SET
CURSOR_CLOSE_ON_COMMIT ON;SET QUOTED_IDENTIFIER ON;SET TEXTSIZE 2147483647;)

dblib.c:1344:dbcmd() bufsz = 0

dblib.c:6845:dbsqlsend(000000000775B3B0)

mem.c:648:tds_free_all_results()

util.c:165:Changed query state from IDLE to WRITING

util.c:165:Changed query state from WRITING to PENDING

packet.c:740:Sending packet

0000 01 01 01 e2 00 00 01 00-53 00 45 00 54 00 20 00 |........ S.E.T. .|

0010 41 00 52 00 49 00 54 00-48 00 41 00 42 00 4f 00 |A.R.I.T. H.A.B.O.|

0020 52 00 54 00 20 00 4f 00-4e 00 3b 00 53 00 45 00 |R.T. .O. N.;.S.E.|

0030 54 00 20 00 43 00 4f 00-4e 00 43 00 41 00 54 00 |T. .C.O. N.C.A.T.|

0040 5f 00 4e 00 55 00 4c 00-4c 00 5f 00 59 00 49 00 |_.N.U.L. L._.Y.I.|

0050 45 00 4c 00 44 00 53 00-5f 00 4e 00 55 00 4c 00 |E.L.D.S. _.N.U.L.|

0060 4c 00 20 00 4f 00 4e 00-3b 00 53 00 45 00 54 00 |L. .O.N. ;.S.E.T.|

0070 20 00 41 00 4e 00 53 00-49 00 5f 00 4e 00 55 00 | .A.N.S. I._.N.U.|

0080 4c 00 4c 00 53 00 20 00-4f 00 4e 00 3b 00 53 00 |L.L.S. . O.N.;.S.|

0090 45 00 54 00 20 00 41 00-4e 00 53 00 49 00 5f 00 |E.T. .A. N.S.I._.|

00a0 4e 00 55 00 4c 00 4c 00-5f 00 44 00 46 00 4c 00 |N.U.L.L. _.D.F.L.|

00b0 54 00 5f 00 4f 00 4e 00-20 00 4f 00 4e 00 3b 00 |T._.O.N. .O.N.;.|

00c0 53 00 45 00 54 00 20 00-41 00 4e 00 53 00 49 00 |S.E.T. . A.N.S.I.|

00d0 5f 00 50 00 41 00 44 00-44 00 49 00 4e 00 47 00 |_.P.A.D. D.I.N.G.|

00e0 20 00 4f 00 4e 00 3b 00-53 00 45 00 54 00 20 00 | .O.N.;. S.E.T. .|

00f0 41 00 4e 00 53 00 49 00-5f 00 57 00 41 00 52 00 |A.N.S.I. _.W.A.R.|

0100 4e 00 49 00 4e 00 47 00-53 00 20 00 4f 00 4e 00 |N.I.N.G. S. .O.N.|

0110 3b 00 53 00 45 00 54 00-20 00 41 00 4e 00 53 00 |;.S.E.T. .A.N.S.|

0120 49 00 5f 00 4e 00 55 00-4c 00 4c 00 5f 00 44 00 |I._.N.U. L.L._.D.|

0130 46 00 4c 00 54 00 5f 00-4f 00 4e 00 20 00 4f 00 |F.L.T._. O.N. .O.|

0140 4e 00 3b 00 53 00 45 00-54 00 20 00 43 00 55 00 |N.;.S.E. T. .C.U.|

0150 52 00 53 00 4f 00 52 00-5f 00 43 00 4c 00 4f 00 |R.S.O.R. _.C.L.O.|

0160 53 00 45 00 5f 00 4f 00-4e 00 5f 00 43 00 4f 00 |S.E._.O. N._.C.O.|

0170 4d 00 4d 00 49 00 54 00-20 00 4f 00 4e 00 3b 00 |M.M.I.T. .O.N.;.|

0180 53 00 45 00 54 00 20 00-51 00 55 00 4f 00 54 00 |S.E.T. . Q.U.O.T.|

0190 45 00 44 00 5f 00 49 00-44 00 45 00 4e 00 54 00 |E.D._.I. D.E.N.T.|

01a0 49 00 46 00 49 00 45 00-52 00 20 00 4f 00 4e 00 |I.F.I.E. R. .O.N.|

01b0 3b 00 53 00 45 00 54 00-20 00 54 00 45 00 58 00 |;.S.E.T. .T.E.X.|

01c0 54 00 53 00 49 00 5a 00-45 00 20 00 32 00 31 00 |T.S.I.Z. E. .2.1.|

01d0 34 00 37 00 34 00 38 00-33 00 36 00 34 00 37 00 |4.7.4.8. 3.6.4.7.|

01e0 3b 00 - |;.|



dblib.c:4625:dbsqlok(000000000775B3B0)

dblib.c:4654:dbsqlok() not done, calling tds_process_tokens()

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58B918,
000000000A58B910, 0x6914)

util.c:165:Changed query state from PENDING to READING

packet.c:639:Received packet

0000 04 01 00 59 00 4e 01 00-fd 01 00 b9 00 00 00 00 |...Y.N.. ........|

0010 00 fd 01 00 b9 00 00 00-00 00 fd 01 00 b9 00 00 |........ ........|

0020 00 00 00 fd 01 00 b9 00-00 00 00 00 fd 01 00 b9 |........ ........|

0030 00 00 00 00 00 fd 01 00-b9 00 00 00 00 00 fd 01 |........ ........|

0040 00 b9 00 00 00 00 00 fd-01 00 b9 00 00 00 00 00 |........ ........|

0050 fd 00 00 be 00 00 00 00-00 |........ .|



token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

util.c:165:Changed query state from READING to PENDING

dblib.c:4687:dbsqlok() end status is SUCCEED

dblib.c:4698:dbsqlok() end status was success

dblib.c:3203:dbcancel(000000000775B3B0)

query.c:2189:tds_send_cancel: not in_cancel and not idle

packet.c:770:Sending packet

0000 06 01 00 08 00 00 01 00- |........|



token.c:550:tds_process_tokens(00000000075359E0, 000000000A58B900,
0000000000000000, 0x0)

util.c:165:Changed query state from PENDING to READING

token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

packet.c:639:Received packet

0000 04 01 00 11 00 4e 01 00-fd 20 00 fd 00 00 00 00 |.....N.. . ......|

0010 00 - |.|



token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 1

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:2101:tds_process_end() state set to TDS_IDLE

util.c:165:Changed query state from READING to IDLE

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

util.c:165:Changed query state from IDLE to IDLE

dblib.c:1419:dbuse(000000000775B3B0, Goldmine)

dblib.c:1338:dbcmd(000000000775B3B0, use [Goldmine])

dblib.c:1344:dbcmd() bufsz = 238

dblib.c:5873:dbfreebuf(000000000775B3B0)

dblib.c:1392:dbsqlexec(000000000775B3B0)

dblib.c:6845:dbsqlsend(000000000775B3B0)

mem.c:648:tds_free_all_results()

util.c:165:Changed query state from IDLE to WRITING

util.c:165:Changed query state from WRITING to PENDING

packet.c:740:Sending packet

0000 01 01 00 24 00 00 01 00-75 00 73 00 65 00 20 00 |...$.... u.s.e. .|

0010 5b 00 47 00 6f 00 6c 00-64 00 6d 00 69 00 6e 00 |[.G.o.l. d.m.i.n.|

0020 65 00 5d 00 - |e.].|



dblib.c:4625:dbsqlok(000000000775B3B0)

dblib.c:4654:dbsqlok() not done, calling tds_process_tokens()

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58B8D8,
000000000A58B8D0, 0x6914)

util.c:165:Changed query state from PENDING to READING

packet.c:639:Received packet

0000 04 01 00 b3 00 4e 01 00-e3 23 00 01 08 47 00 6f |.....N.. .#...G.o|

0010 00 6c 00 64 00 6d 00 69-00 6e 00 65 00 08 47 00 |.l.d.m.i .n.e..G.|

0020 6f 00 6c 00 64 00 6d 00-69 00 6e 00 65 00 ab 6e |o.l.d.m. i.n.e..n|

0030 00 45 16 00 00 01 00 27-00 43 00 68 00 61 00 6e |.E.....' .C.h.a.n|

0040 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d. .d.a.t.a|

0050 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|

0060 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |

0070 00 27 00 47 00 6f 00 6c-00 64 00 6d 00 69 00 6e |.'.G.o.l .d.m.i.n|

0080 00 65 00 27 00 2e 00 0a-46 00 42 00 4f 00 50 00 |.e.'.... F.B.O.P.|

0090 53 00 2d 00 50 00 52 00-4f 00 44 00 00 01 00 e3 |S.-.P.R. O.D.....|

00a0 08 00 07 05 09 04 d0 00-34 00 fd 00 00 e2 00 00 |........ 4.......|

00b0 00 00 00 - |...|



token.c:565:processing result tokens. marker is e3(ENVCHANGE)

token.c:116:tds_process_default_tokens() marker is e3(ENVCHANGE)

dblib.c:312:db_env_chg(00000000075359E0, 1, Goldmine, Goldmine)

token.c:565:processing result tokens. marker is ab(INFO)

token.c:116:tds_process_default_tokens() marker is ab(INFO)

token.c:2345:tds_process_msg() reading message 5701 from server

token.c:2417:tds_process_msg() calling client msg handler

dbutil.c:76:_dblib_handle_info_message(0000000002C2CFA0, 00000000075359E0,
000000000A58B750)

dbutil.c:77:msgno 5701: "Changed database context to 'Goldmine'."

token.c:2430:tds_process_msg() returning TDS_SUCCESS

token.c:565:processing result tokens. marker is e3(ENVCHANGE)

token.c:116:tds_process_default_tokens() marker is e3(ENVCHANGE)

token.c:2179:tds_process_env_chg(): 5 bytes of collation data received

token.c:2180:tds->conn->collation was

0000 09 04 d0 00 34 - |....4|



iconv.c:796:setting server single-byte charset to "CP1252"

token.c:2190:tds->conn->collation now

0000 09 04 d0 00 34 - |....4|



token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:2101:tds_process_end() state set to TDS_IDLE

util.c:165:Changed query state from READING to IDLE

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

util.c:165:Changed query state from IDLE to IDLE

dblib.c:4687:dbsqlok() end status is SUCCEED

dblib.c:4698:dbsqlok() end status was success

dblib.c:1689:dbresults(000000000775B3B0)

dblib.c:1694:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)

dblib.c:1679:dbresults returning 1 (SUCCEED)

dblib.c:5846:dbcanquery(000000000775B3B0)

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58B8D0,
0000000000000000, 0x108)

token.c:553:tds_process_tokens() state is COMPLETED

dblib.c:3203:dbcancel(000000000775B3B0)

query.c:2189:tds_send_cancel: not in_cancel and idle

dblib.c:1338:dbcmd(000000000775B3B0, BEGIN TRAN)

dblib.c:1344:dbcmd() bufsz = 15

dblib.c:5873:dbfreebuf(000000000775B3B0)

dblib.c:6845:dbsqlsend(000000000775B3B0)

mem.c:648:tds_free_all_results()

util.c:165:Changed query state from IDLE to WRITING

util.c:165:Changed query state from WRITING to PENDING

packet.c:740:Sending packet

0000 01 01 00 1c 00 00 01 00-42 00 45 00 47 00 49 00 |........ B.E.G.I.|

0010 4e 00 20 00 54 00 52 00-41 00 4e 00 |N. .T.R. A.N.|



dblib.c:4625:dbsqlok(000000000775B3B0)

dblib.c:4654:dbsqlok() not done, calling tds_process_tokens()

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58B828,
000000000A58B820, 0x6914)

util.c:165:Changed query state from PENDING to READING

packet.c:639:Received packet

0000 04 01 00 11 00 4e 01 00-fd 00 00 d4 00 00 00 00 |.....N.. ........|

0010 00 - |.|



token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:2101:tds_process_end() state set to TDS_IDLE

util.c:165:Changed query state from READING to IDLE

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

util.c:165:Changed query state from IDLE to IDLE

dblib.c:4687:dbsqlok() end status is SUCCEED

dblib.c:4698:dbsqlok() end status was success

dblib.c:1689:dbresults(000000000775B3B0)

dblib.c:1694:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)

dblib.c:1679:dbresults returning 1 (SUCCEED)

dblib.c:2772:dbcount(000000000775B3B0)

dblib.c:3203:dbcancel(000000000775B3B0)

query.c:2189:tds_send_cancel: not in_cancel and idle

dblib.c:3203:dbcancel(000000000775B3B0)

query.c:2189:tds_send_cancel: not in_cancel and idle

dblib.c:1338:dbcmd(000000000775B3B0, sp_PlayerFactors_iud 54, N'U', 241406,
236120, 501, 74815, 7, 1)

dblib.c:1344:dbcmd() bufsz = 11

dblib.c:5873:dbfreebuf(000000000775B3B0)

dblib.c:6845:dbsqlsend(000000000775B3B0)

mem.c:648:tds_free_all_results()

util.c:165:Changed query state from IDLE to WRITING

util.c:165:Changed query state from WRITING to PENDING

packet.c:740:Sending packet

0000 01 01 00 86 00 00 01 00-73 00 70 00 5f 00 50 00 |........ s.p._.P.|

0010 6c 00 61 00 79 00 65 00-72 00 46 00 61 00 63 00 |l.a.y.e. r.F.a.c.|

0020 74 00 6f 00 72 00 73 00-5f 00 69 00 75 00 64 00 |t.o.r.s. _.i.u.d.|

0030 20 00 35 00 34 00 2c 00-20 00 4e 00 27 00 55 00 | .5.4.,. .N.'.U.|

0040 27 00 2c 00 20 00 32 00-34 00 31 00 34 00 30 00 |'.,. .2. 4.1.4.0.|

0050 36 00 2c 00 20 00 32 00-33 00 36 00 31 00 32 00 |6.,. .2. 3.6.1.2.|

0060 30 00 2c 00 20 00 35 00-30 00 31 00 2c 00 20 00 |0.,. .5. 0.1.,. .|

0070 37 00 34 00 38 00 31 00-35 00 2c 00 20 00 37 00 |7.4.8.1. 5.,. .7.|

0080 2c 00 20 00 31 00 - |,. .1.|



dblib.c:4625:dbsqlok(000000000775B3B0)

dblib.c:4654:dbsqlok() not done, calling tds_process_tokens()

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58BB08,
000000000A58BB00, 0x6914)

util.c:165:Changed query state from PENDING to READING

packet.c:639:Received packet

0000 04 01 00 7b 00 4e 01 00-81 03 00 00 00 21 00 a7 |...{.N.. .....!..|

0010 32 00 09 04 d0 00 34 06-52 00 65 00 73 00 75 00 |2.....4. R.e.s.u.|

0020 6c 00 74 00 00 00 21 00-26 04 0a 50 00 72 00 69 |l.t...!. &..P.r.i|

0030 00 6d 00 61 00 72 00 79-00 4b 00 65 00 79 00 00 |.m.a.r.y .K.e.y..|

0040 00 21 00 26 04 07 4d 00-65 00 73 00 73 00 61 00 |.!.&..M. e.s.s.a.|

0050 67 00 65 00 d1 07 00 55-70 64 61 74 65 64 04 fe |g.e....U pdated..|

0060 ae 03 00 00 ff 01 00 c1-00 01 00 00 00 79 00 00 |........ .....y..|

0070 00 00 fe 00 00 e0 00 00-00 00 00 |........ ...|



token.c:565:processing result tokens. marker is 81(TDS7_RESULT)

token.c:1574:processing TDS7 result metadata.

mem.c:648:tds_free_all_results()

token.c:1599:set current_results (3 columns) to tds->res_info

token.c:1606:setting up 3 columns

token.c:3165:adjust_character_column_size:

Server charset: CP1252

Server column_size: 50

Client charset: UTF-8

Client column_size: 200

token.c:1543:tds7_get_data_info:

colname = Result

type = 39 (varchar)

server's type = 167 (xvarchar)

column_varint_size = 2

column_size = 200 (50 on server)

token.c:1543:tds7_get_data_info:

colname = PrimaryKey

type = 38 (integer-null)

server's type = 38 (integer-null)

column_varint_size = 1

column_size = 4 (4 on server)

token.c:1543:tds7_get_data_info:

colname = Message

type = 38 (integer-null)

server's type = 38 (integer-null)

column_varint_size = 1

column_size = 4 (4 on server)

token.c:1615: name size/wsize type/wtype utype

token.c:1616: -------------------- --------------- --------------- -------

token.c:1621: Result 200/50 39/167 0

token.c:1621: PrimaryKey 4/4 38/38 0

token.c:1621: Message 4/4 38/38 0

util.c:165:Changed query state from READING to PENDING

dblib.c:4680:dbsqlok() found result token

dblib.c:1689:dbresults(000000000775B3B0)

dblib.c:1694:dbresults: dbresults_state is 1 (_DB_RES_RESULTSET_EMPTY)

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58BA50,
000000000A58BA58, 0x6914)

util.c:165:Changed query state from PENDING to READING

token.c:565:processing result tokens. marker is d1(ROW)

token.c:681:tds_process_tokens::SET_RETURN stopping on current token

util.c:165:Changed query state from READING to PENDING

dblib.c:1715:dbresults() tds_process_tokens returned 0 (TDS_SUCCESS),

result_type TDS_ROW_RESULT

dblib.c:1679:dbresults returning 1 (SUCCEED)

dblib.c:1827:dbnumcols(000000000775B3B0)

dblib.c:2772:dbcount(000000000775B3B0)

dblib.c:1827:dbnumcols(000000000775B3B0)

dblib.c:1853:dbcolname(000000000775B3B0, 1)

dblib.c:2841:dbcoltype(000000000775B3B0, 1)

dblib.c:1853:dbcolname(000000000775B3B0, 2)

dblib.c:2841:dbcoltype(000000000775B3B0, 2)

dblib.c:1853:dbcolname(000000000775B3B0, 3)

dblib.c:2841:dbcoltype(000000000775B3B0, 3)

dblib.c:2031:dbnextrow(000000000775B3B0)

dblib.c:2043:dbnextrow() dbresults_state = 2 (_DB_RES_RESULTSET_ROWS)

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58BB40,
0000000000000000, 0x1508)

util.c:165:Changed query state from PENDING to READING

token.c:565:processing result tokens. marker is d1(ROW)

token.c:1952:tds_process_row(): reading column 0

data.c:534:tds_get_data: type 39, varint size 2

data.c:587:tds_get_data(): wire column size is 7

token.c:1952:tds_process_row(): reading column 1

data.c:534:tds_get_data: type 38, varint size 1

data.c:587:tds_get_data(): wire column size is 4

token.c:1952:tds_process_row(): reading column 2

data.c:534:tds_get_data: type 38, varint size 1

data.c:587:tds_get_data(): wire column size is -1

util.c:165:Changed query state from READING to PENDING

buffering.h:305:buffer_transfer_bound_data(000000000775B3C0 4040 -1
000000000775B3B0 0)

dblib.c:2117:leaving dbnextrow() returning REG_ROW/MORE_ROWS

dblib.c:3172:dbdata(000000000775B3B0, 1)

dblib.c:2841:dbcoltype(000000000775B3B0, 1)

dblib.c:3143:dbdatlen(000000000775B3B0, 1)

dblib.c:3151:dbdatlen() type = 39, len= 7

dblib.c:3172:dbdata(000000000775B3B0, 2)

dblib.c:2841:dbcoltype(000000000775B3B0, 2)

dblib.c:3143:dbdatlen(000000000775B3B0, 2)

dblib.c:3151:dbdatlen() type = 38, len= 4

dblib.c:3172:dbdata(000000000775B3B0, 3)

dblib.c:2841:dbcoltype(000000000775B3B0, 3)

dblib.c:3143:dbdatlen(000000000775B3B0, 3)

dblib.c:3151:dbdatlen() type = 38, len= 0

dblib.c:2031:dbnextrow(000000000775B3B0)

dblib.c:2043:dbnextrow() dbresults_state = 2 (_DB_RES_RESULTSET_ROWS)

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58BB40,
0000000000000000, 0x1508)

util.c:165:Changed query state from PENDING to READING

token.c:565:processing result tokens. marker is ff(DONEINPROC)

token.c:2081:tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 1

util.c:165:Changed query state from READING to PENDING

dblib.c:2117:leaving dbnextrow() returning NO_MORE_ROWS

dblib.c:2772:dbcount(000000000775B3B0)

dblib.c:3203:dbcancel(000000000775B3B0)

query.c:2189:tds_send_cancel: not in_cancel and not idle

packet.c:770:Sending packet

0000 06 01 00 08 00 00 01 00- |........|



token.c:550:tds_process_tokens(00000000075359E0, 000000000A58BB60,
0000000000000000, 0x0)

util.c:165:Changed query state from PENDING to READING

token.c:565:processing result tokens. marker is 79(RETURNSTATUS)

token.c:712:tds_process_tokens: return status is 0

token.c:565:processing result tokens. marker is fe(DONEPROC)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

packet.c:639:Received packet

0000 04 01 00 11 00 4e 01 00-fd 20 00 fd 00 00 00 00 |.....N.. . ......|

0010 00 - |.|



token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 1

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:2101:tds_process_end() state set to TDS_IDLE

util.c:165:Changed query state from READING to IDLE

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

util.c:165:Changed query state from IDLE to IDLE

dblib.c:1338:dbcmd(000000000775B3B0, COMMIT TRAN)

dblib.c:1344:dbcmd() bufsz = 64

dblib.c:5873:dbfreebuf(000000000775B3B0)

dblib.c:6845:dbsqlsend(000000000775B3B0)

mem.c:648:tds_free_all_results()

util.c:165:Changed query state from IDLE to WRITING

util.c:165:Changed query state from WRITING to PENDING

packet.c:740:Sending packet

0000 01 01 00 1e 00 00 01 00-43 00 4f 00 4d 00 4d 00 |........ C.O.M.M.|

0010 49 00 54 00 20 00 54 00-52 00 41 00 4e 00 |I.T. .T. R.A.N.|



dblib.c:4625:dbsqlok(000000000775B3B0)

dblib.c:4654:dbsqlok() not done, calling tds_process_tokens()

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58BBA8,
000000000A58BBA0, 0x6914)

util.c:165:Changed query state from PENDING to READING

packet.c:639:Received packet

0000 04 01 00 11 00 4e 01 00-fd 00 00 d5 00 00 00 00 |.....N.. ........|

0010 00 - |.|



token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:2101:tds_process_end() state set to TDS_IDLE

util.c:165:Changed query state from READING to IDLE

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

util.c:165:Changed query state from IDLE to IDLE

dblib.c:4687:dbsqlok() end status is SUCCEED

dblib.c:4698:dbsqlok() end status was success

dblib.c:1689:dbresults(000000000775B3B0)

dblib.c:1694:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)

dblib.c:1679:dbresults returning 1 (SUCCEED)

dblib.c:2772:dbcount(000000000775B3B0)

dblib.c:3203:dbcancel(000000000775B3B0)

query.c:2189:tds_send_cancel: not in_cancel and idle

dblib.c:3203:dbcancel(000000000775B3B0)

query.c:2189:tds_send_cancel: not in_cancel and idle

dblib.c:1338:dbcmd(000000000775B3B0, BEGIN TRAN)

dblib.c:1344:dbcmd() bufsz = 12

dblib.c:5873:dbfreebuf(000000000775B3B0)

dblib.c:6845:dbsqlsend(000000000775B3B0)

mem.c:648:tds_free_all_results()

util.c:165:Changed query state from IDLE to WRITING

util.c:165:Changed query state from WRITING to PENDING

packet.c:740:Sending packet

0000 01 01 00 1c 00 00 01 00-42 00 45 00 47 00 49 00 |........ B.E.G.I.|

0010 4e 00 20 00 54 00 52 00-41 00 4e 00 |N. .T.R. A.N.|



dblib.c:4625:dbsqlok(000000000775B3B0)

dblib.c:4654:dbsqlok() not done, calling tds_process_tokens()

token.c:550:tds_process_tokens(00000000075359E0, 000000000A58BBA8,
000000000A58BBA0, 0x6914)

util.c:165:Changed query state from PENDING to READING

packet.c:639:Received packet

0000 04 01 00 11 00 4e 01 00-fd 00 00 d4 00 00 00 00 |.....N.. ........|

0010 00 - |.|



token.c:565:processing result tokens. marker is fd(DONE)

token.c:2081:tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

token.c:2098: rows_affected = 0

token.c:2101:tds_process_end() state set to TDS_IDLE

util.c:165:Changed query state from READING to IDLE

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

util.c:165:Changed query state from IDLE to IDLE

dblib.c:4687:dbsqlok() end status is SUCCEED

dblib.c:4698:dbsqlok() end status was success

dblib.c:1689:dbresults(000000000775B3B0)

dblib.c:1694:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)

dblib.c:1679:dbresults returning 1 (SUCCEED)

dblib.c:2772:dbcount(000000000775B3B0)

dblib.c:3203:dbcancel(000000000775B3B0)

query.c:2189:tds_send_cancel: not in_cancel and idle

dblib.c:1463:dbclose(000000000775B3B0)

dblib.c:243:dblib_del_connection(000007FEF8B0FA70, 00000000075359E0)

query.c:3772:tds_disconnect()

util.c:165:Changed query state from IDLE to DEAD

mem.c:648:tds_free_all_results()

dblib.c:290:dblib_release_tds_ctx(1)

dblib.c:5873:dbfreebuf(000000000775B3B0)


Steve





Archive powered by MHonArc 2.6.24.

Top of Page