freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Panos Stavroulis <pstavroulis AT yahoo.co.uk>
- To: FreeTDS AT lists.ibiblio.org
- Subject: [freetds] bcp problems
- Date: Thu, 20 Jan 2011 11:16:43 +0000 (GMT)
Hi,
I have a bcp related problem. I am trying to insert the following table via
bcp:
insert bulk #Tran_Driver (msg_id int, local_id int, parent_id int, splitno
int, drivertype char(4), drivercode char(4), status char(4))
In principal do you have to adjust the size of each column to cater for
strings or chars? I don't think need to do anything for numerics.
It fails on function :_bcp_get_col_data(39f78, 90538), see below and also
attachment with more info. It's compaining about the terminator and always
fails on the last row of the temp table. I've changed the order so an
insertion to a different tables again failed with the last column.
Pls see attached the output. does anyone know what's wrong? FYI bcp works in
other places of the code.
bcp.c:3187:_bcp_send_bcp_record(39f78, 1)
bcp.c:3401:_bcp_get_col_data(39f78, 69040)
dblib.c:2141:dbconvert(39f78, SYBINT4, 5fcc0, 4, SYBINT4, 4f5b8, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 1, length 4 (not null)
bcp.c:3283:new_record_size = 0 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 4
bcp.c:3401:_bcp_get_col_data(39f78, 694b8)
dblib.c:2141:dbconvert(39f78, SYBINT4, 5fcc4, 4, SYBINT4, 4f538, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 2, length 4 (not null)
bcp.c:3283:new_record_size = 4 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 8
bcp.c:3401:_bcp_get_col_data(39f78, 69da8)
dblib.c:2141:dbconvert(39f78, SYBINT4, 5fcc8, 4, SYBINT4, 4f468, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 3, length 4 (not null)
bcp.c:3283:new_record_size = 8 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 12
bcp.c:3401:_bcp_get_col_data(39f78, 6a220)
dblib.c:2141:dbconvert(39f78, SYBINT4, 5fccc, 4, SYBINT4, 4f3f8, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 4, length 4 (not null)
bcp.c:3275:varint_1 = 4
bcp.c:3283:new_record_size = 13 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 17
bcp.c:3401:_bcp_get_col_data(39f78, 6a698)
dblib.c:2141:dbconvert(39f78, SYBCHAR, 5fcd0, -1, SYBCHAR, 4f658, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 5, length 4 (not null)
bcp.c:3283:new_record_size = 19 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 23
bcp.c:3401:_bcp_get_col_data(39f78, 6ab10)
dblib.c:2141:dbconvert(39f78, SYBCHAR, 5fcd5, -1, SYBCHAR, 6b9a0, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 6, length 3 (not null)
bcp.c:3283:new_record_size = 25 datalen = 3
bcp.c:3307:old_record_size = 35 new size = 28
bcp.c:3401:_bcp_get_col_data(39f78, 90538)
00000059 2011/01/19 04:03:59.443 C -6 SERI SERVER
Found system error (6)
token.c:2139:swapping coltype 47
token.c:2166:tds_process_row(): reading column 1
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:2139:swapping coltype 56
token.c:2166:tds_process_row(): reading column 2
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:2139:swapping coltype 56
util.c:162:Changed query state from READING to PENDING
buffering.h:231:buffer_transfer_bound_data(4db58 4040 -1 4db50 0)
dblib.c:7083:copy_data_to_host_var(47 [SYBCHAR] len 1 => 47 [SYBCHAR] len 1)
dblib.c:7100:copy_data_to_host_var() srctype == desttype
dblib.c:7083:copy_data_to_host_var(56 [SYBINT4] len 4 => 56 [SYBINT4] len 4)
dblib.c:7100:copy_data_to_host_var() srctype == desttype
dblib.c:7083:copy_data_to_host_var(56 [SYBINT4] len 4 => 56 [SYBINT4] len 4)
dblib.c:7100:copy_data_to_host_var() srctype == desttype
dblib.c:2030:leaving dbnextrow() returning REG_ROW/MORE_ROWS
dblib.c:1745:dbnumcols(4db50)
dblib.c:2957:dbcollen(4db50, 1)
dblib.c:2741:dbcoltype(4db50, 1)
dblib.c:2957:dbcollen(4db50, 2)
dblib.c:2741:dbcoltype(4db50, 2)
dblib.c:2957:dbcollen(4db50, 3)
dblib.c:2741:dbcoltype(4db50, 3)
temp table Tran_Settle size at the moment 460
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:4747:dbdead(4db50) [alive]
dblib.c:5608:dbsetuserdata(4db50, ffbfd8b8)
dblib.c:1948:dbnextrow(4db50)
dblib.c:1961:dbnextrow() dbresults_state = 2 (_DB_RES_RESULTSET_ROWS)
token.c:495:tds_process_tokens(3e1e0, ffbfb42c, 0, 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 = 21
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:2030:leaving dbnextrow() returning NO_MORE_ROWS
size of temp table = 31
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:4747:dbdead(39f78) [alive]
dblib.c:1327:dbuse(39f78, tempdb)
dblib.c:1243:dbcmd(39f78, use tempdb)
dblib.c:1250:dbcmd() bufsz = 10676
dblib.c:5727:dbfreebuf(39f78)
dblib.c:1298:dbsqlexec(39f78)
dblib.c:6722:dbsqlsend(39f78)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 10 bytes of "use tempdb"
write.c:164:tds_put_string wrote 20 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 1c 00 00 01 00-75 00 73 00 65 00 20 00 |........ u.s.e. .|
0010 74 00 65 00 6d 00 70 00-64 00 62 00 |t.e.m.p. d.b.|
dblib.c:4532:dbsqlok(39f78)
net.c:592:Received header
0000 04 01 00 dd 00 35 01 00- |.....5..|
net.c:671:Received packet
0000 e3 2b 00 01 06 74 00 65-00 6d 00 70 00 64 00 62 |.+...t.e .m.p.d.b|
0010 00 0e 67 00 6c 00 73 00-70 00 65 00 72 00 66 00 |..g.l.s. p.e.r.f.|
0020 5f 00 74 00 73 00 74 00-31 00 5f 00 74 00 ab 90 |_.t.s.t. 1._.t...|
0030 00 45 16 00 00 01 00 25-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 74 00 65 00 6d-00 70 00 64 00 62 00 27 |.'.t.e.m .p.d.b.'|
0080 00 2e 00 1d 48 00 42 00-41 00 44 00 54 00 41 00 |....H.B. A.D.T.A.|
0090 52 00 4f 00 54 00 56 00-4d 00 30 00 35 00 5c 00 |R.O.T.V. M.0.5.\.|
00a0 4d 00 53 00 53 00 51 00-4c 00 53 00 45 00 52 00 |M.S.S.Q. L.S.E.R.|
00b0 56 00 45 00 52 00 32 00-30 00 30 00 38 00 00 01 |V.E.R.2. 0.0.8...|
00c0 00 e3 08 00 07 05 09 04-c0 00 00 00 fd 00 00 e2 |........ ........|
00d0 00 00 00 00 00 - |.....|
dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(3aeb0, ffbfa1c4, ffbfa1c0, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(3aeb0, 1, glsperf_tst1_t, tempdb)
token.c:510:processing result tokens. marker is ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
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(3a128, 3aeb0, ffbfa030)
dbutil.c:87:msgno 5701: "Changed database context to 'tempdb'."
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:510:processing result tokens. marker is e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 09 04 c0 00 00 - |.....|
iconv.c:985:setting server single-byte charset to "CP1252"
token.c:2292:tds->collation now
0000 09 04 c0 00 00 - |.....|
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 = 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
dblib.c:4601:dbsqlok() end status was success
dblib.c:1599:dbresults(39f78)
dblib.c:1608:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:5699:dbcanquery(39f78)
token.c:495:tds_process_tokens(3aeb0, ffbfa234, 0, 0x108)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:5608:dbsetuserdata(39f78, ffbfd838)
dblib.c:1243:dbcmd(39f78, select * from #Tran_Driver where 1=2)
dblib.c:1250:dbcmd() bufsz = 11
dblib.c:5727:dbfreebuf(39f78)
dblib.c:1298:dbsqlexec(39f78)
dblib.c:6722:dbsqlsend(39f78)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 36 bytes of "select * from #Tran_Driver
where 1=2"
write.c:164:tds_put_string wrote 72 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 50 00 00 01 00-73 00 65 00 6c 00 65 00 |...P.... s.e.l.e.|
0010 63 00 74 00 20 00 2a 00-20 00 66 00 72 00 6f 00 |c.t. .*. .f.r.o.|
0020 6d 00 20 00 23 00 54 00-72 00 61 00 6e 00 5f 00 |m. .#.T. r.a.n._.|
0030 44 00 72 00 69 00 76 00-65 00 72 00 20 00 77 00 |D.r.i.v. e.r. .w.|
0040 68 00 65 00 72 00 65 00-20 00 31 00 3d 00 32 00 |h.e.r.e. .1.=.2.|
dblib.c:4532:dbsqlok(39f78)
net.c:592:Received header
0000 04 01 00 c4 00 35 01 00- |.....5..|
net.c:671:Received packet
0000 81 07 00 00 00 08 00 38-06 6d 00 73 00 67 00 5f |.......8 .m.s.g._|
0010 00 69 00 64 00 00 00 08-00 38 08 6c 00 6f 00 63 |.i.d.... .8.l.o.c|
0020 00 61 00 6c 00 5f 00 69-00 64 00 00 00 08 00 38 |.a.l._.i .d.....8|
0030 09 70 00 61 00 72 00 65-00 6e 00 74 00 5f 00 69 |.p.a.r.e .n.t._.i|
0040 00 64 00 00 00 09 00 26-04 07 73 00 70 00 6c 00 |.d.....& ..s.p.l.|
0050 69 00 74 00 6e 00 6f 00-00 00 0a 00 af 04 00 09 |i.t.n.o. ........|
0060 04 c0 00 00 0a 64 00 72-00 69 00 76 00 65 00 72 |.....d.r .i.v.e.r|
0070 00 74 00 79 00 70 00 65-00 00 00 0a 00 af 04 00 |.t.y.p.e ........|
0080 09 04 c0 00 00 0a 64 00-72 00 69 00 76 00 65 00 |......d. r.i.v.e.|
0090 72 00 63 00 6f 00 64 00-65 00 00 00 0b 00 af 04 |r.c.o.d. e.......|
00a0 00 09 04 c0 00 00 06 73-00 74 00 61 00 74 00 75 |.......s .t.a.t.u|
00b0 00 73 00 fd 10 00 c1 00-00 00 00 00 |.s...... ....|
dblib.c:4556:dbsqlok() exits on result token 0x81
dblib.c:1599:dbresults(39f78)
dblib.c:1608:dbresults: dbresults_state is 0 (_DB_RES_INIT)
token.c:495:tds_process_tokens(3aeb0, ffbf9acc, ffbf9ac8, 0x6914)
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 (7 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info:
colname = msg_id (6 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:1490:tds7_get_data_info:
colname = local_id (8 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 2
token.c:1490:tds7_get_data_info:
colname = parent_id (9 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 3
token.c:1490:tds7_get_data_info:
colname = splitno (7 bytes)
type = 38 (integer-null)
server's type = 38 (integer-null)
column_varint_size = 1
column_size = 4 (4 on server)
token.c:1555:setting up column 4
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 4
Client charset: ISO-8859-1
Client column_size: 4
token.c:1490:tds7_get_data_info:
colname = drivertype (10 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 4 (4 on server)
token.c:1555:setting up column 5
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 4
Client charset: ISO-8859-1
Client column_size: 4
token.c:1490:tds7_get_data_info:
colname = drivercode (10 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 4 (4 on server)
token.c:1555:setting up column 6
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 4
Client charset: ISO-8859-1
Client column_size: 4
token.c:1490:tds7_get_data_info:
colname = status (6 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 4 (4 on server)
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
result_type TDS_ROWFMT_RESULT
token.c:495:tds_process_tokens(3aeb0, ffbf9acc, ffbf9ac8, 0x6914)
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 = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
result_type TDS_DONE_RESULT
dblib.c:1657:dbresults(): dbresults_state is 1 (_DB_RES_RESULTSET_EMPTY)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:1599:dbresults(39f78)
dblib.c:1608:dbresults: dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(3aeb0, ffbf9acc, ffbf9ac8, 0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:1630:dbresults() tds_process_tokens returned 2 (TDS_NO_MORE_RESULTS),
result_type TDS_DONE_RESULT
dblib.c:1587:dbresults returning 2 (NO_MORE_RESULTS)
dblib.c:1745:dbnumcols(39f78)
dblib.c:2957:dbcollen(39f78, 1)
dblib.c:2741:dbcoltype(39f78, 1)
ww_dba.c 2038 dbcoltype: 4 dbcollen 56
dblib.c:2957:dbcollen(39f78, 2)
dblib.c:2741:dbcoltype(39f78, 2)
ww_dba.c 2038 dbcoltype: 4 dbcollen 56
dblib.c:2957:dbcollen(39f78, 3)
dblib.c:2741:dbcoltype(39f78, 3)
ww_dba.c 2038 dbcoltype: 4 dbcollen 56
dblib.c:2957:dbcollen(39f78, 4)
dblib.c:2741:dbcoltype(39f78, 4)
ww_dba.c 2038 dbcoltype: 4 dbcollen 56
dblib.c:2957:dbcollen(39f78, 5)
dblib.c:2741:dbcoltype(39f78, 5)
ww_dba.c 2038 dbcoltype: 4 dbcollen 47
dblib.c:2957:dbcollen(39f78, 6)
dblib.c:2741:dbcoltype(39f78, 6)
ww_dba.c 2038 dbcoltype: 4 dbcollen 47
dblib.c:2957:dbcollen(39f78, 7)
dblib.c:2741:dbcoltype(39f78, 7)
ww_dba.c 2038 dbcoltype: 4 dbcollen 47
dblib.c:1948:dbnextrow(39f78)
dblib.c:1961:dbnextrow() dbresults_state = 4 (_DB_RES_NO_MORE_RESULTS)
dblib.c:1966:leaving dbnextrow() returning -2 (NO_MORE_ROWS)
bcp.c:138:bcp_init(39f78, #Tran_Driver, NULL, NULL, 1)
bcp.c:3582:_bcp_free_storage(39f78)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 57 bytes of "SET FMTONLY ON select *
from #Tran_Driver SET FMTONLY OFF"
write.c:164:tds_put_string wrote 114 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 7a 00 00 01 00-53 00 45 00 54 00 20 00 |...z.... S.E.T. .|
0010 46 00 4d 00 54 00 4f 00-4e 00 4c 00 59 00 20 00 |F.M.T.O. N.L.Y. .|
0020 4f 00 4e 00 20 00 73 00-65 00 6c 00 65 00 63 00 |O.N. .s. e.l.e.c.|
0030 74 00 20 00 2a 00 20 00-66 00 72 00 6f 00 6d 00 |t. .*. . f.r.o.m.|
0040 20 00 23 00 54 00 72 00-61 00 6e 00 5f 00 44 00 | .#.T.r. a.n._.D.|
0050 72 00 69 00 76 00 65 00-72 00 20 00 53 00 45 00 |r.i.v.e. r. .S.E.|
0060 54 00 20 00 46 00 4d 00-54 00 4f 00 4e 00 4c 00 |T. .F.M. T.O.N.L.|
0070 59 00 20 00 4f 00 46 00-46 00 |Y. .O.F. F.|
token.c:495:tds_process_tokens(3aeb0, ffbfaf34, 0, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 d6 00 35 01 00- |.....5..|
net.c:671:Received packet
0000 fd 01 00 b9 00 00 00 00-00 81 07 00 00 00 08 00 |........ ........|
0010 38 06 6d 00 73 00 67 00-5f 00 69 00 64 00 00 00 |8.m.s.g. _.i.d...|
0020 08 00 38 08 6c 00 6f 00-63 00 61 00 6c 00 5f 00 |..8.l.o. c.a.l._.|
0030 69 00 64 00 00 00 08 00-38 09 70 00 61 00 72 00 |i.d..... 8.p.a.r.|
0040 65 00 6e 00 74 00 5f 00-69 00 64 00 00 00 09 00 |e.n.t._. i.d.....|
0050 26 04 07 73 00 70 00 6c-00 69 00 74 00 6e 00 6f |&..s.p.l .i.t.n.o|
0060 00 00 00 0a 00 af 04 00-09 04 c0 00 00 0a 64 00 |........ ......d.|
0070 72 00 69 00 76 00 65 00-72 00 74 00 79 00 70 00 |r.i.v.e. r.t.y.p.|
0080 65 00 00 00 0a 00 af 04-00 09 04 c0 00 00 0a 64 |e....... .......d|
0090 00 72 00 69 00 76 00 65-00 72 00 63 00 6f 00 64 |.r.i.v.e .r.c.o.d|
00a0 00 65 00 00 00 0b 00 af-04 00 09 04 c0 00 00 06 |.e...... ........|
00b0 73 00 74 00 61 00 74 00-75 00 73 00 fd 11 00 c1 |s.t.a.t. u.s.....|
00c0 00 00 00 00 00 fd 00 00-ba 00 00 00 00 00 |........ ......|
token.c:510:processing result tokens. marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2232: rows_affected = 0
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(3aeb0, ffbfaf34, 0, 0x6914)
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 (7 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info:
colname = msg_id (6 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:1490:tds7_get_data_info:
colname = local_id (8 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 2
token.c:1490:tds7_get_data_info:
colname = parent_id (9 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 3
token.c:1490:tds7_get_data_info:
colname = splitno (7 bytes)
type = 38 (integer-null)
server's type = 38 (integer-null)
column_varint_size = 1
column_size = 4 (4 on server)
token.c:1555:setting up column 4
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 4
Client charset: ISO-8859-1
Client column_size: 4
token.c:1490:tds7_get_data_info:
colname = drivertype (10 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 4 (4 on server)
token.c:1555:setting up column 5
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 4
Client charset: ISO-8859-1
Client column_size: 4
token.c:1490:tds7_get_data_info:
colname = drivercode (10 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 4 (4 on server)
token.c:1555:setting up column 6
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 4
Client charset: ISO-8859-1
Client column_size: 4
token.c:1490:tds7_get_data_info:
colname = status (6 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 4 (4 on server)
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(3aeb0, ffbfaf34, 0, 0x6914)
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 = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2232: rows_affected = 0
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(3aeb0, ffbfaf34, 0, 0x6914)
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 = 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(3aeb0, ffbfaf34, 0, 0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:4747:dbdead(39f78) [alive]
dblib.c:5608:dbsetuserdata(39f78, ffbfd838)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:4747:dbdead(39f78) [alive]
li_coltype : 56
in SYBINT4 line 1676 ww_dba.c
dblib.c:6103:dbprtype(56)
bcp.c:3074:bcp_bind(39f78, 5fcc0, 0, -1 -- 0, 0, int, 1)
li_coltype : 56
in SYBINT4 line 1676 ww_dba.c
dblib.c:6103:dbprtype(56)
bcp.c:3074:bcp_bind(39f78, 5fcc4, 0, -1 -- 0, 0, int, 2)
li_coltype : 56
in SYBINT4 line 1676 ww_dba.c
dblib.c:6103:dbprtype(56)
bcp.c:3074:bcp_bind(39f78, 5fcc8, 0, -1 -- 0, 0, int, 3)
li_coltype : 56
in SYBINT4 line 1676 ww_dba.c
dblib.c:6103:dbprtype(56)
bcp.c:3074:bcp_bind(39f78, 5fccc, 0, -1 -- 0, 0, int, 4)
li_coltype : 47
in SYBCHAR line 1648 ww_dba.c length = 4
dblib.c:6103:dbprtype(47)
bcp.c:3074:bcp_bind(39f78, 5fcd0, 0, -1 -- fef8a5e0, 1, char, 5)
li_coltype : 47
in SYBCHAR line 1648 ww_dba.c length = 4
dblib.c:6103:dbprtype(47)
bcp.c:3074:bcp_bind(39f78, 5fcd5, 0, -1 -- fef8a5e0, 1, char, 6)
li_coltype : 47
in SYBCHAR line 1648 ww_dba.c length = 4
dblib.c:6103:dbprtype(47)
bcp.c:3074:bcp_bind(39f78, 5fcda, 0, -1 -- fef8a5e0, 1, char, 7)
first char of string = ^
first char of string =
first char of string =
first char of string =
first char of string =
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:4747:dbdead(39f78) [alive]
dblib.c:5608:dbsetuserdata(39f78, ffbfd838)
bcp.c:1819:bcp_sendrow(39f78)
bcp.c:2117:_bcp_start_copy_in(39f78)
bcp.c:2317:_bcp_build_bulk_insert_stmt(3aeb0, ffbfb038, 69040, 1)
bcp.c:2317:_bcp_build_bulk_insert_stmt(3aeb0, ffbfb038, 694b8, 0)
bcp.c:2317:_bcp_build_bulk_insert_stmt(3aeb0, ffbfb038, 69da8, 0)
bcp.c:2317:_bcp_build_bulk_insert_stmt(3aeb0, ffbfb038, 6a220, 0)
bcp.c:2317:_bcp_build_bulk_insert_stmt(3aeb0, ffbfb038, 6a698, 0)
bcp.c:2317:_bcp_build_bulk_insert_stmt(3aeb0, ffbfb038, 6ab10, 0)
bcp.c:2317:_bcp_build_bulk_insert_stmt(3aeb0, ffbfb038, 90538, 0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 136 bytes of "insert bulk #Tran_Driver
(msg_id int, local_id int, parent_id int, splitno int, drivertype char(4),
drivercode char(4), status char(4)) "
write.c:136:tds_put_string converting 8 bytes of "har(4)) "
write.c:164:tds_put_string wrote 272 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 01 18 00 00 01 00-69 00 6e 00 73 00 65 00 |........ i.n.s.e.|
0010 72 00 74 00 20 00 62 00-75 00 6c 00 6b 00 20 00 |r.t. .b. u.l.k. .|
0020 23 00 54 00 72 00 61 00-6e 00 5f 00 44 00 72 00 |#.T.r.a. n._.D.r.|
0030 69 00 76 00 65 00 72 00-20 00 28 00 6d 00 73 00 |i.v.e.r. .(.m.s.|
0040 67 00 5f 00 69 00 64 00-20 00 69 00 6e 00 74 00 |g._.i.d. .i.n.t.|
0050 2c 00 20 00 6c 00 6f 00-63 00 61 00 6c 00 5f 00 |,. .l.o. c.a.l._.|
0060 69 00 64 00 20 00 69 00-6e 00 74 00 2c 00 20 00 |i.d. .i. n.t.,. .|
0070 70 00 61 00 72 00 65 00-6e 00 74 00 5f 00 69 00 |p.a.r.e. n.t._.i.|
0080 64 00 20 00 69 00 6e 00-74 00 2c 00 20 00 73 00 |d. .i.n. t.,. .s.|
0090 70 00 6c 00 69 00 74 00-6e 00 6f 00 20 00 69 00 |p.l.i.t. n.o. .i.|
00a0 6e 00 74 00 2c 00 20 00-64 00 72 00 69 00 76 00 |n.t.,. . d.r.i.v.|
00b0 65 00 72 00 74 00 79 00-70 00 65 00 20 00 63 00 |e.r.t.y. p.e. .c.|
00c0 68 00 61 00 72 00 28 00-34 00 29 00 2c 00 20 00 |h.a.r.(. 4.).,. .|
00d0 64 00 72 00 69 00 76 00-65 00 72 00 63 00 6f 00 |d.r.i.v. e.r.c.o.|
00e0 64 00 65 00 20 00 63 00-68 00 61 00 72 00 28 00 |d.e. .c. h.a.r.(.|
00f0 34 00 29 00 2c 00 20 00-73 00 74 00 61 00 74 00 |4.).,. . s.t.a.t.|
0100 75 00 73 00 20 00 63 00-68 00 61 00 72 00 28 00 |u.s. .c. h.a.r.(.|
0110 34 00 29 00 29 00 20 00- |4.).). .|
token.c:495:tds_process_tokens(3aeb0, ffbf9fbc, ffbf9fb8, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 35 01 00- |.....5..|
net.c:671:Received packet
0000 fd 00 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 = 0
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
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(3aeb0, ffbf9fbc, ffbf9fb8, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
bcp.c:2282:current_record_size = 28
bcp.c:2283:bcp_record_size = 35
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
bcp.c:2527:_bcp_send_colmetadata(39f78)
write.c:136:tds_put_string converting 6 bytes of "msg_id"
write.c:164:tds_put_string wrote 12 bytes
write.c:136:tds_put_string converting 8 bytes of "local_id"
write.c:164:tds_put_string wrote 16 bytes
write.c:136:tds_put_string converting 9 bytes of "parent_id"
write.c:164:tds_put_string wrote 18 bytes
write.c:136:tds_put_string converting 7 bytes of "splitno"
write.c:164:tds_put_string wrote 14 bytes
write.c:136:tds_put_string converting 10 bytes of "drivertype"
write.c:164:tds_put_string wrote 20 bytes
write.c:136:tds_put_string converting 10 bytes of "drivercode"
write.c:164:tds_put_string wrote 20 bytes
write.c:136:tds_put_string converting 6 bytes of "status"
write.c:164:tds_put_string wrote 12 bytes
bcp.c:3187:_bcp_send_bcp_record(39f78, 1)
bcp.c:3401:_bcp_get_col_data(39f78, 69040)
dblib.c:2141:dbconvert(39f78, SYBINT4, 5fcc0, 4, SYBINT4, 4f5b8, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 1, length 4 (not null)
bcp.c:3283:new_record_size = 0 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 4
bcp.c:3401:_bcp_get_col_data(39f78, 694b8)
dblib.c:2141:dbconvert(39f78, SYBINT4, 5fcc4, 4, SYBINT4, 4f538, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 2, length 4 (not null)
bcp.c:3283:new_record_size = 4 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 8
bcp.c:3401:_bcp_get_col_data(39f78, 69da8)
dblib.c:2141:dbconvert(39f78, SYBINT4, 5fcc8, 4, SYBINT4, 4f468, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 3, length 4 (not null)
bcp.c:3283:new_record_size = 8 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 12
bcp.c:3401:_bcp_get_col_data(39f78, 6a220)
dblib.c:2141:dbconvert(39f78, SYBINT4, 5fccc, 4, SYBINT4, 4f3f8, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 4, length 4 (not null)
bcp.c:3275:varint_1 = 4
bcp.c:3283:new_record_size = 13 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 17
bcp.c:3401:_bcp_get_col_data(39f78, 6a698)
dblib.c:2141:dbconvert(39f78, SYBCHAR, 5fcd0, -1, SYBCHAR, 4f658, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 5, length 4 (not null)
bcp.c:3283:new_record_size = 19 datalen = 4
bcp.c:3307:old_record_size = 35 new size = 23
bcp.c:3401:_bcp_get_col_data(39f78, 6ab10)
dblib.c:2141:dbconvert(39f78, SYBCHAR, 5fcd5, -1, SYBCHAR, 6b9a0, 4)
dblib.c:2174:dbconvert() srctype == desttype
bcp.c:3217:parsed column 6, length 3 (not null)
bcp.c:3283:new_record_size = 25 datalen = 3
bcp.c:3307:old_record_size = 35 new size = 28
bcp.c:3401:_bcp_get_col_data(39f78, 90538)
00000059 2011/01/19 04:03:59.443 C -6 SERI SERVER
Found system error (6)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:4747:dbdead(4e540) [alive]
dblib.c:1327:dbuse(4e540, glsperf_tst1_c)
dblib.c:1243:dbcmd(4e540, use glsperf_tst1_c)
dblib.c:1250:dbcmd() bufsz = 75
dblib.c:5727:dbfreebuf(4e540)
dblib.c:1298:dbsqlexec(4e540)
dblib.c:6722:dbsqlsend(4e540)
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 "use glsperf_tst1_c"
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-75 00 73 00 65 00 20 00 |...,.... u.s.e. .|
0010 67 00 6c 00 73 00 70 00-65 00 72 00 66 00 5f 00 |g.l.s.p. e.r.f._.|
0020 74 00 73 00 74 00 31 00-5f 00 63 00 |t.s.t.1. _.c.|
dblib.c:4532:dbsqlok(4e540)
net.c:592:Received header
0000 04 01 01 01 00 3b 01 00- |.....;..|
net.c:671:Received packet
0000 e3 3f 00 01 0e 67 00 6c-00 73 00 70 00 65 00 72 |.?...g.l .s.p.e.r|
0010 00 66 00 5f 00 74 00 73-00 74 00 31 00 5f 00 63 |.f._.t.s .t.1._.c|
0020 00 10 67 00 6c 00 73 00-70 00 65 00 72 00 66 00 |..g.l.s. p.e.r.f.|
0030 5f 00 74 00 73 00 74 00-31 00 5f 00 68 00 75 00 |_.t.s.t. 1._.h.u.|
0040 62 00 ab a0 00 45 16 00-00 01 00 2d 00 43 00 68 |b....E.. ...-.C.h|
0050 00 61 00 6e 00 67 00 65-00 64 00 20 00 64 00 61 |.a.n.g.e .d. .d.a|
0060 00 74 00 61 00 62 00 61-00 73 00 65 00 20 00 63 |.t.a.b.a .s.e. .c|
0070 00 6f 00 6e 00 74 00 65-00 78 00 74 00 20 00 74 |.o.n.t.e .x.t. .t|
0080 00 6f 00 20 00 27 00 67-00 6c 00 73 00 70 00 65 |.o. .'.g .l.s.p.e|
0090 00 72 00 66 00 5f 00 74-00 73 00 74 00 31 00 5f |.r.f._.t .s.t.1._|
00a0 00 63 00 27 00 2e 00 1d-48 00 42 00 41 00 44 00 |.c.'.... H.B.A.D.|
00b0 54 00 41 00 52 00 4f 00-54 00 56 00 4d 00 30 00 |T.A.R.O. T.V.M.0.|
00c0 35 00 5c 00 4d 00 53 00-53 00 51 00 4c 00 53 00 |5.\.M.S. S.Q.L.S.|
00d0 45 00 52 00 56 00 45 00-52 00 32 00 30 00 30 00 |E.R.V.E. R.2.0.0.|
00e0 38 00 00 01 00 e3 08 00-07 05 09 04 c0 00 00 00 |8....... ........|
00f0 fd 00 00 e2 00 00 00 00-00 |........ .|
dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(4dd30, ffbf8a74, ffbf8a70, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(4dd30, 1, glsperf_tst1_hub, glsperf_tst1_c)
token.c:510:processing result tokens. marker is ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
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(3a128, 4dd30, ffbf88e0)
dbutil.c:87:msgno 5701: "Changed database context to 'glsperf_tst1_c'."
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:510:processing result tokens. marker is e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 09 04 c0 00 00 - |.....|
iconv.c:985:setting server single-byte charset to "CP1252"
token.c:2292:tds->collation now
0000 09 04 c0 00 00 - |.....|
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 = 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
dblib.c:4601:dbsqlok() end status was success
dblib.c:1599:dbresults(4e540)
dblib.c:1608:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:5699:dbcanquery(4e540)
token.c:495:tds_process_tokens(4dd30, ffbf8ae4, 0, 0x108)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:5608:dbsetuserdata(4e540, ffbf9a64)
dblib.c:5727:dbfreebuf(4e540)
dblib.c:1243:dbcmd(4e540, begin transaction)
dblib.c:1250:dbcmd() bufsz = 0
dblib.c:5727:dbfreebuf(4e540)
dblib.c:1298:dbsqlexec(4e540)
dblib.c:6722:dbsqlsend(4e540)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 17 bytes of "begin transaction"
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-62 00 65 00 67 00 69 00 |...*.... b.e.g.i.|
0010 6e 00 20 00 74 00 72 00-61 00 6e 00 73 00 61 00 |n. .t.r. a.n.s.a.|
0020 63 00 74 00 69 00 6f 00-6e 00 |c.t.i.o. n.|
dblib.c:4532:dbsqlok(4e540)
net.c:592:Received header
0000 04 01 00 11 00 3b 01 00- |.....;..|
net.c:671:Received packet
0000 fd 00 00 d4 00 00 00 00-00 |........ .|
dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(4dd30, ffbf97ec, ffbf97e8, 0x6914)
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 = 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
dblib.c:4601:dbsqlok() end status was success
dblib.c:5727:dbfreebuf(4e540)
dblib.c:1243:dbcmd(4e540, delete user_login where login_no = 785352 )
dblib.c:1250:dbcmd() bufsz = 0
dblib.c:5727:dbfreebuf(4e540)
dblib.c:1298:dbsqlexec(4e540)
dblib.c:6722:dbsqlsend(4e540)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 42 bytes of "delete user_login where
login_no = 785352 "
write.c:164:tds_put_string wrote 84 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 5c 00 00 01 00-64 00 65 00 6c 00 65 00 |...\.... d.e.l.e.|
0010 74 00 65 00 20 00 75 00-73 00 65 00 72 00 5f 00 |t.e. .u. s.e.r._.|
0020 6c 00 6f 00 67 00 69 00-6e 00 20 00 77 00 68 00 |l.o.g.i. n. .w.h.|
0030 65 00 72 00 65 00 20 00-6c 00 6f 00 67 00 69 00 |e.r.e. . l.o.g.i.|
0040 6e 00 5f 00 6e 00 6f 00-20 00 3d 00 20 00 37 00 |n._.n.o. .=. .7.|
0050 38 00 35 00 33 00 35 00-32 00 20 00 |8.5.3.5. 2. .|
dblib.c:4532:dbsqlok(4e540)
net.c:592:Received header
0000 04 01 00 11 00 3b 01 00- |.....;..|
net.c:671:Received packet
0000 fd 10 00 c4 00 00 00 00-00 |........ .|
dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(4dd30, ffbf9864, ffbf9860, 0x6914)
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 = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
dblib.c:4601:dbsqlok() end status was success
dblib.c:1599:dbresults(4e540)
dblib.c:1608:dbresults: dbresults_state is 5 (_DB_RES_SUCCEED)
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:3960:dbcmdrow(4e540)
dblib.c:1599:dbresults(4e540)
dblib.c:1608:dbresults: dbresults_state is 3 (_DB_RES_NEXT_RESULT)
token.c:495:tds_process_tokens(4dd30, ffbf985c, ffbf9858, 0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:1630:dbresults() tds_process_tokens returned 2 (TDS_NO_MORE_RESULTS),
result_type TDS_DONE_RESULT
dblib.c:1587:dbresults returning 2 (NO_MORE_RESULTS)
dblib.c:1243:dbcmd(4e540, commit transaction)
dblib.c:1250:dbcmd() bufsz = 43
dblib.c:5727:dbfreebuf(4e540)
dblib.c:1298:dbsqlexec(4e540)
dblib.c:6722:dbsqlsend(4e540)
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 "commit transaction"
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-63 00 6f 00 6d 00 6d 00 |...,.... c.o.m.m.|
0010 69 00 74 00 20 00 74 00-72 00 61 00 6e 00 73 00 |i.t. .t. r.a.n.s.|
0020 61 00 63 00 74 00 69 00-6f 00 6e 00 |a.c.t.i. o.n.|
dblib.c:4532:dbsqlok(4e540)
net.c:592:Received header
0000 04 01 00 11 00 3b 01 00- |.....;..|
net.c:671:Received packet
0000 fd 00 00 d5 00 00 00 00-00 |........ .|
dblib.c:4565:dbsqlok() not done, calling tds_process_tokens()
token.c:495:tds_process_tokens(4dd30, ffbf9864, ffbf9860, 0x6914)
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 = 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
dblib.c:4601:dbsqlok() end status was success
dblib.c:5727:dbfreebuf(4e540)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:4747:dbdead(4e540) [alive]
dblib.c:5608:dbsetuserdata(4e540, ffbf7b80)
dblib.c:1243:dbcmd(4e540, SELECT output_wil, action, text_wil FROM
glsperf_tst1_c..message WHERE database_type = 'C' AND message_no = 1 )
dblib.c:1250:dbcmd() bufsz = 0
dblib.c:5727:dbfreebuf(4e540)
dblib.c:1298:dbsqlexec(4e540)
dblib.c:6722:dbsqlsend(4e540)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 116 bytes of "SELECT output_wil,
action, text_wil FROM glsperf_tst1_c..message WHERE database_type = 'C'
AND message_no = 1 "
write.c:164:tds_put_string wrote 232 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 f0 00 00 01 00-53 00 45 00 4c 00 45 00 |........ S.E.L.E.|
0010 43 00 54 00 20 00 6f 00-75 00 74 00 70 00 75 00 |C.T. .o. u.t.p.u.|
0020 74 00 5f 00 77 00 69 00-6c 00 2c 00 20 00 61 00 |t._.w.i. l.,. .a.|
0030 63 00 74 00 69 00 6f 00-6e 00 2c 00 20 00 74 00 |c.t.i.o. n.,. .t.|
0040 65 00 78 00 74 00 5f 00-77 00 69 00 6c 00 20 00 |e.x.t._. w.i.l. .|
0050 46 00 52 00 4f 00 4d 00-20 00 20 00 20 00 67 00 |F.R.O.M. . . .g.|
0060 6c 00 73 00 70 00 65 00-72 00 66 00 5f 00 74 00 |l.s.p.e. r.f._.t.|
0070 73 00 74 00 31 00 5f 00-63 00 2e 00 2e 00 6d 00 |s.t.1._. c.....m.|
0080 65 00 73 00 73 00 61 00-67 00 65 00 20 00 57 00 |e.s.s.a. g.e. .W.|
0090 48 00 45 00 52 00 45 00-20 00 20 00 64 00 61 00 |H.E.R.E. . .d.a.|
00a0 74 00 61 00 62 00 61 00-73 00 65 00 5f 00 74 00 |t.a.b.a. s.e._.t.|
00b0 79 00 70 00 65 00 20 00-3d 00 20 00 27 00 43 00 |y.p.e. . =. .'.C.|
00c0 27 00 20 00 41 00 4e 00-44 00 20 00 20 00 20 00 |'. .A.N. D. . . .|
00d0 20 00 6d 00 65 00 73 00-73 00 61 00 67 00 65 00 | .m.e.s. s.a.g.e.|
00e0 5f 00 6e 00 6f 00 20 00-3d 00 20 00 31 00 20 00 |_.n.o. . =. .1. .|
dblib.c:4532:dbsqlok(4e540)
net.c:592:Received header
0000 04 01 00 97 00 3b 01 00- |.....;..|
net.c:671:Received packet
0000 81 03 00 00 00 0a 00 af-04 00 09 04 c0 00 00 0a |........ ........|
0010 6f 00 75 00 74 00 70 00-75 00 74 00 5f 00 77 00 |o.u.t.p. u.t._.w.|
0020 69 00 6c 00 00 00 0a 00-af 04 00 09 04 c0 00 00 |i.l..... ........|
0030 06 61 00 63 00 74 00 69-00 6f 00 6e 00 00 00 0a |.a.c.t.i .o.n....|
0040 00 a7 ff 00 09 04 c0 00-00 08 74 00 65 00 78 00 |........ ..t.e.x.|
0050 74 00 5f 00 77 00 69 00-6c 00 d1 04 00 4c 4f 47 |t._.w.i. l....LOG|
0060 20 04 00 20 20 20 20 1d-00 54 68 69 73 20 75 73 | .. . .This us|
0070 65 72 20 61 62 6f 72 74-65 64 20 66 72 6f 6d 20 |er abort ed from |
0080 47 4c 4f 53 53 2e fd 10-00 c1 00 01 00 00 00 |GLOSS... .......|
dblib.c:4556:dbsqlok() exits on result token 0x81
dblib.c:1599:dbresults(4e540)
dblib.c:1608:dbresults: dbresults_state is 0 (_DB_RES_INIT)
token.c:495:tds_process_tokens(4dd30, ffbf7974, ffbf7970, 0x6914)
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 (3 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 4
Client charset: ISO-8859-1
Client column_size: 4
token.c:1490:tds7_get_data_info:
colname = output_wil (10 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 4
Client charset: ISO-8859-1
Client column_size: 4
token.c:1490:tds7_get_data_info:
colname = action (6 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 4 (4 on server)
token.c:1555:setting up column 2
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 255
Client charset: ISO-8859-1
Client column_size: 255
token.c:1490:tds7_get_data_info:
colname = text_wil (8 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 255 (255 on server)
util.c:162:Changed query state from READING to PENDING
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
result_type TDS_ROWFMT_RESULT
token.c:495:tds_process_tokens(4dd30, ffbf7974, ffbf7970, 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
dblib.c:1630:dbresults() tds_process_tokens returned 1 (TDS_SUCCEED),
result_type TDS_ROW_RESULT
dblib.c:1587:dbresults returning 1 (SUCCEED)
dblib.c:3960:dbcmdrow(4e540)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:3875:dbgetmaxprocs(void)
dblib.c:4747:dbdead(4e540) [alive]
dblib.c:1745:dbnumcols(4e540)
dblib.c:1745:dbnumcols(4e540)
dblib.c:2957:dbcollen(4e540, 1)
dblib.c:2741:dbcoltype(4e540, 1)
dblib.c:2509:dbbind(4e540, 1, 2, 5, ffbf7be2)
dblib.c:2722:dbwillconvert(47, 47)
convert.c:2845:tds_willconvert()
convert.c:2849:tds_willconvert() 47 47 1
dblib.c:2957:dbcollen(4e540, 2)
dblib.c:2741:dbcoltype(4e540, 2)
dblib.c:2509:dbbind(4e540, 2, 2, 5, ffbf7be7)
dblib.c:2722:dbwillconvert(47, 47)
convert.c:2845:tds_willconvert()
convert.c:2849:tds_willconvert() 47 47 1
dblib.c:2957:dbcollen(4e540, 3)
dblib.c:2741:dbcoltype(4e540, 3)
dblib.c:2509:dbbind(4e540, 3, 2, 256, ffbf7bec)
dblib.c:2722:dbwillconvert(39, 47)
convert.c:2845:tds_willconvert()
convert.c:2849:tds_willconvert() 39 47 1
dblib.c:1948:dbnextrow(4e540)
dblib.c:1961:dbnextrow() dbresults_state = 2 (_DB_RES_RESULTSET_ROWS)
token.c:495:tds_process_tokens(4dd30, ffbf79ec, 0, 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 47, varint size 2
token.c:1975:tds_get_data(): wire column size is 4
token.c:2139:swapping coltype 47
token.c:2166:tds_process_row(): reading column 1
token.c:1915:tds_get_data: type 47, varint size 2
token.c:1975:tds_get_data(): wire column size is 4
token.c:2139:swapping coltype 47
token.c:2166:tds_process_row(): reading column 2
token.c:1915:tds_get_data: type 39, varint size 2
token.c:1975:tds_get_data(): wire column size is 29
token.c:2139:swapping coltype 39
util.c:162:Changed query state from READING to PENDING
buffering.h:231:buffer_transfer_bound_data(4e548 4040 -1 4e540 0)
dblib.c:7083:copy_data_to_host_var(47 [SYBCHAR] len 4 => 47 [SYBCHAR] len 5)
dblib.c:7100:copy_data_to_host_var() srctype == desttype
dblib.c:7083:copy_data_to_host_var(47 [SYBCHAR] len 4 => 47 [SYBCHAR] len 5)
dblib.c:7100:copy_data_to_host_var() srctype == desttype
dblib.c:7083:copy_data_to_host_var(39 [SYBVARCHAR] len 29 => 47 [SYBCHAR] len
256)
dblib.c:7100:copy_data_to_host_var() srctype == desttype
dblib.c:2030:leaving dbnextrow() returning REG_ROW/MORE_ROWS
dblib.c:1745:dbnumcols(4e540)
dblib.c:2957:dbcollen(4e540, 1)
dblib.c:2741:dbcoltype(4e540, 1)
dblib.c:2957:dbcollen(4e540, 2)
dblib.c:2741:dbcoltype(4e540, 2)
dblib.c:2957:dbcollen(4e540, 3)
dblib.c:2741:dbcoltype(4e540, 3)
dblib.c:3093:dbcancel(4e540)
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(4dd30, ffbf797c, 0, 0x0)
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:2232: rows_affected = 1
net.c:592:Received header
0000 04 01 00 11 00 3b 01 00- |.....;..|
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
dblib.c:1442:dbexit(void)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from QUERYING to DEAD
dblib.c:1372:dbclose(39f78)
dblib.c:5727:dbfreebuf(39f78)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
dblib.c:1372:dbclose(4db50)
dblib.c:5727:dbfreebuf(4db50)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
dblib.c:1372:dbclose(4e540)
dblib.c:5727:dbfreebuf(4e540)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
dblib.c:1372:dbclose(56bd0)
dblib.c:5727:dbfreebuf(56bd0)
dblib.c:303:dblib_release_tds_ctx(5)
-
[freetds] bcp problems,
Panos Stavroulis, 01/20/2011
- Re: [freetds] bcp problems, Panos Stavroulis, 01/20/2011
- Re: [freetds] bcp problems, James K. Lowden, 01/22/2011
Archive powered by MHonArc 2.6.24.