Skip to Content.
Sympa Menu

freetds - [freetds] short read during bcp?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Lowden, James K" <LowdenJK AT bernstein.com>
  • To: 'TDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: [freetds] short read during bcp?
  • Date: Mon, 15 Dec 2003 17:03:05 -0500

Using Friday's CVS code, my bcp loads are failing, and the log looks odd to
me. Here's the end of it:

pid: 14800:Sending packet @ 15:42:46.700205
0000 07 01 01 0f 00 00 01 00-81 07 00 00 00 08 00 38 |........ .......8|
0010 12 53 00 70 00 63 00 50-00 65 00 72 00 6d 00 61 |.S.p.c.P .e.r.m.a|
0020 00 6e 00 65 00 6e 00 74-00 4e 00 75 00 6d 00 62 |.n.e.n.t .N.u.m.b|
0030 00 65 00 72 00 00 00 08-00 3a 0e 42 00 65 00 67 |.e.r.... .:.B.e.g|
0040 00 69 00 6e 00 49 00 6e-00 63 00 6c 00 75 00 73 |.i.n.I.n .c.l.u.s|
0050 00 69 00 76 00 65 00 00-00 08 00 3a 0c 45 00 6e |.i.v.e.. ...:.E.n|
0060 00 64 00 45 00 78 00 63-00 6c 00 75 00 73 00 69 |.d.E.x.c .l.u.s.i|
0070 00 76 00 65 00 00 00 09-00 26 04 0b 43 00 72 00 |.v.e.... .&..C.r.|
0080 73 00 70 00 53 00 74 00-6f 00 63 00 6b 00 49 00 |s.p.S.t. o.c.k.I.|
0090 44 00 00 00 09 00 26 04-0d 43 00 72 00 73 00 70 |D.....&. .C.r.s.p|
00a0 00 43 00 6f 00 6d 00 70-00 61 00 6e 00 79 00 49 |.C.o.m.p .a.n.y.I|
00b0 00 44 00 00 00 0a 00 af-02 00 0a 4c 00 69 00 6e |.D...... ...L.i.n|
00c0 00 6b 00 74 00 79 00 70-00 65 00 49 00 44 00 00 |.k.t.y.p .e.I.D..|
00d0 00 08 00 30 13 49 00 73-00 49 00 6e 00 4c 00 61 |...0.I.s .I.n.L.a|
00e0 00 73 00 74 00 43 00 72-00 73 00 70 00 4d 00 6f |.s.t.C.r .s.p.M.o|
00f0 00 6e 00 74 00 68 00 6c-00 79 00 d1 01 00 00 00 |.n.t.h.l .y......|
0100 93 58 00 00 ff ff 00 00-00 00 02 00 4e 52 00 |.X...... ....NR.|


pid: 14800:15:42:46.701183 tds_process_result_tokens() state is COMPLETED
pid: 14800:Received header @ 15:42:46.802849
0000 04 01 00 11 00 00 00 00- |........|


pid: 14800:Received packet @ 15:42:46.803827
0000 fd 10 00 f0 00 01 00 00-00 |........ .|


pid: 14800:15:42:46.803827 processing result tokens. marker is fd(DONE)
pid: 14800:15:42:46.803827 tds_process_end: more_results = 0
15:42:46.804804 was_cancelled = 0
15:42:46.804804 error = 0
15:42:46.804804 done_count_valid = 1
pid: 14800:15:42:46.804804 tds_process_end() state set to TDS_IDLE
pid: 14800:15:42:46.804804 rows_affected = 1
pid: 14800:15:42:46.805782 tds_process_result_tokens() state is COMPLETED

[so far, so good]

pid: 14800:Sending packet @ 15:42:46.830221
0000 07 01 01 67 00 00 01 00-74 00 72 00 00 00 09 00 |...g.... t.r.....|
0010 26 02 19 4c 00 61 00 74-00 65 00 73 00 74 00 51 |&..L.a.t .e.s.t.Q|
0020 00 74 00 72 00 6c 00 79-00 44 00 61 00 74 00 61 |.t.r.l.y .D.a.t.a|
0030 00 46 00 69 00 73 00 63-00 61 00 6c 00 59 00 65 |.F.i.s.c .a.l.Y.e|
0040 00 61 00 72 00 00 00 09-00 26 01 18 4c 00 61 00 |.a.r.... .&..L.a.|
0050 74 00 65 00 73 00 74 00-51 00 74 00 72 00 6c 00 |t.e.s.t. Q.t.r.l.|
0060 79 00 44 00 61 00 74 00-61 00 46 00 69 00 73 00 |y.D.a.t. a.F.i.s.|
0070 63 00 61 00 6c 00 51 00-74 00 72 00 00 00 08 00 |c.a.l.Q. t.r.....|
0080 38 09 41 00 76 00 61 00-69 00 6c 00 46 00 6c 00 |8.A.v.a. i.l.F.l.|
0090 61 00 67 00 00 00 08 00-38 16 49 00 6e 00 64 00 |a.g..... 8.I.n.d.|
00a0 75 00 73 00 74 00 72 00-79 00 43 00 6c 00 61 00 |u.s.t.r. y.C.l.a.|
00b0 73 00 73 00 69 00 66 00-69 00 63 00 61 00 74 00 |s.s.i.f. i.c.a.t.|
00c0 69 00 6f 00 6e 00 00 00-09 00 26 04 04 47 00 69 |i.o.n... ..&..G.i|
00d0 00 63 00 73 00 00 00 0b-00 a7 06 00 05 4e 00 61 |.c.s.... .....N.a|
00e0 00 69 00 63 00 73 00 00-00 0b 00 a7 1c 00 0c 49 |.i.c.s.. .......I|
00f0 00 6e 00 64 00 75 00 73-00 74 00 72 00 79 00 4e |.n.d.u.s .t.r.y.N|
0100 00 61 00 6d 00 65 00 d1-02 00 00 00 08 00 30 30 |.a.m.e.. ......00|
0110 30 30 30 30 30 30 13 00-53 26 50 20 49 4e 44 55 |000000.. S&P INDU|
0120 53 54 52 49 41 4c 53 2d-4c 54 44 05 00 49 30 30 |STRIALS- LTD..I00|
0130 30 32 00 00 00 00 00 04-93 58 00 00 04 e4 93 00 |02...... .X......|
0140 00 00 00 00 00 00 00 69-00 20 00 02 00 00 00 00 |.......i . ......|
0150 ff ff 13 00 53 26 50 20-49 4e 44 55 53 54 52 49 |....S&P INDUSTRI|
0160 41 4c 53 2d 4c 54 44 - |ALS-LTD|


pid: 14800:15:42:46.831199 tds_process_result_tokens() state is COMPLETED
pid: 14800:15:42:46.837064 processing result tokens. marker is 0()
pid: 14800:15:42:46.838042 tds_process_default_tokens() marker is 0()
pid: 14800:15:42:46.838042 leaving tds_process_default_tokens() connection
dead

The last three lines don't have corresponding data. This makes me think
that we got a short read when we were looking for a DONE token, and instead
of waiting for the server, we returned a zero length?

I don't know enough about socket programming to say anything definitive yet,
but if someone could confirm/deny my hypothesis, it would sure help.

Thanks.

--jkl

-----------------------------------------
The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above. If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the original
message. Please note that we do not accept account orders and/or instructions
by e-mail, and therefore will not be responsible for carrying out such orders
and/or instructions.






Archive powered by MHonArc 2.6.24.

Top of Page