FreeTDS 1.1 - missing CS_ROWFMT_RESULT row in ct_results
Fredy Paquet <[email protected]> Sat, 08 Jul 2017 17:03:25 +0200
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Organization | OPAG Informatik AG |
| Message-ID | <[email protected]> |
Hello Frediano
Sorry to bother you again.
I'm testing FreeTDS 1.1 (current master branch) with our Sybase ASE 15.7
ctLib application.
We found our application to crash after the first SELECT has been
issued, returning result rows.
Attached there are two TDSDUMP files:
ctlib_ok.log - taken with FreeTDS 0.91
ctlib_bad.log - taken with FreeTDS 1.1
If we look at the tds dump, we find that token.c is recognizing the
ROWFMT2 result, but doesn't pass correct information back to ct_result()
in ct.c (~Line 1215) to process CS_ROWFMT_RESULT. In ctlib_ok.log, you
can find ct_res_info() calls after "process_result_tokens returned", but
not in ctlib_bad.log.
ctlib_ok.log Line 452ff
token.c:555:processing result tokens. marker is 61(ROWFMT2)
token.c:1740:tds5_process_result
mem.c:615:tds_free_all_results()
token.c:1764:num_cols=2
token.c:1837:col 0:
token.c:1838: column_name=[name]
token.c:1844: flags=10 utype=42 type=47 varint=5
token.c:1847: colsize=510 prec=0 scale=0
token.c:1837:col 1:
token.c:1838: column_name=[type]
token.c:1844: flags=10 utype=1 type=47 varint=5
token.c:1847: colsize=4 prec=0 scale=0
util.c:156:Changed query state from READING to PENDING
ct.c:1179:ct_results() process_result_tokens returned 1 (type 4049)
ct.c:2346:ct_res_info(0x14285c0, 801, 0x1427c88, -99999, (nil))
ct.c:2346:ct_res_info(0x14285c0, 803, 0x7fff77c3425c, -99999, (nil))
ct.c:2365:ct_res_info(): Number of columns is 2
ctlib_bad.log line 417ff
token.c:548:processing result tokens. marker is 61(ROWFMT2)
token.c:577:calling tds5_process_result2/1
token.c:1778:tds5_process_result2
mem.c:660:tds_free_all_results()
token.c:1802:num_cols=2
token.c:1868:col 0:
token.c:1869: column_name=[name]
token.c:1875: flags=10 utype=42 type=39 server type 39 varint=1
token.c:1879: colsize=255 prec=0 scale=0
token.c:1868:col 1:
token.c:1869: column_name=[type]
token.c:1875: flags=10 utype=1 type=47 server type 47 varint=1
token.c:1879: colsize=2 prec=0 scale=0
token.c:1882:tds5_process_result2(): exit
mem.c:529:tds_alloc_row()
mem.c:565:tds_alloc_row(): SUCCESS
token.c:579: tds5_process_result2() = 0
util.c:165:Changed query state from READING to PENDING
ct.c:1215:ct_results() process_result_tokens returned 0 (type 4049)
token.c:533:tds_process_tokens(0x18bde20, 0x7ffe79e073b8,
0x7ffe79e073bc, 0x6a14)
util.c:165:Changed query state from PENDING to READING
token.c:548:processing result tokens. marker is
ae(CONTROL/FEATUREEXTACK)
token.c:132:tds_process_default_tokens() marker is
ae(CONTROL/FEATUREEXTACK)
token.c:252:Eating CONTROL/FEATUREEXTACK token
token.c:548:processing result tokens. marker is a9(ORDERBY)
token.c:132:tds_process_default_tokens() marker is a9(ORDERBY)
token.c:252:Eating ORDERBY token
token.c:548:processing result tokens. marker is d1(ROW)
token.c:656:tds_process_tokens::SET_RETURN stopping on current token
util.c:165:Changed query state from READING to PENDING
----
The related code change was introduced by the following commit.
> Date: 2016-05-01 00:24:32
> Revision: 4fea9e776e5475c4c607b9c2fa85a563e6feb700
> Comment: fix ct-library rows count
After experimentally adding the following code segment to the switch,
case CS_ROWFMT_RESULT the application doesn't crash anymore processing
the results. These lines have been replaced in commit 4fea9.
case CS_ROWFMT_RESULT:
...
if (context->config.cs_expose_formats) {
*result_type = res_type;
return CS_SUCCEED;
}
...
break;
Instead of crashing, our application is processing quite a few SELECT
results, but starts hanging in ct_fetch() later, when processing a
SELECT statements returning 0 rows.
Got any ideas about this?
fp
--
Fredy Paquet
Mitglied der Geschäftsleitung
OPAG Informatik AG
Fabrikmattenweg 11
CH-4144 Arlesheim
http://www.opag.ch
Tel. ++41 61 716 92 22
Fax. ++41 61 716 92 29
crlib_bad.log
(text/x-log, 25.7 KB)
log.c:168:Starting log file for FreeTDS 1.1.dev.20170708
on 2017-07-08 16:48:33 with debug flags 0x4fff.
iconv.c:325:tds_iconv_open(0x18bde20, ISO-8859-1)
iconv.c:355:Using trivial iconv
iconv.c:185:local name for ISO-8859-1 is ISO-8859-1
iconv.c:185:local name for UTF-8 is UTF-8
iconv.c:185:local name for UCS-2LE is UCS-2LE
iconv.c:185:local name for UCS-2BE is UCS-2BE
iconv.c:347:setting up conversions for client charset "ISO-8859-1"
iconv.c:349:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:388:tds_iconv_open: done
net.c:362:Connecting with protocol version 5.0
net.c:289:Connecting to 127.0.0.1 port 5012
net.c:311:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:499:tds_open_socket() succeeded
packet.c:742:Sending packet
0000 02 00 02 00 00 00 00 00-62 73 61 2e 6f 70 61 67 |........ bsa.opag|
0010 2e 63 68 00 00 00 00 00-00 00 00 00 00 00 00 00 |.ch..... ........|
0020 00 00 00 00 00 00 0b 6b-6f 6d 6d 65 72 7a 00 00 |.......k ommerz..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 67 75-72 75 67 75 72 75 00 00 |......gu ruguru..|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 08 32 37 33-34 39 00 00 00 00 00 00 |.....273 49......|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 00 00 |........ ........|
0090 00 00 00 00 4f 50 47 00-00 00 00 00 00 00 00 00 |....OPG. ........|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 03 54 55 4e 4e 45-4c 5f 4d 4f 52 49 4e 49 |...TUNNE L_MORINI|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 0d 00 08 67 75 72 75-67 75 72 75 00 00 00 00 |....guru guru....|
00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01d0 00 0a 05 00 00 00 43 54-2d 4c 69 62 72 61 72 79 |......CT -Library|
01e0 0a 05 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|
packet.c:742:Sending packet
0000 02 01 00 6b 00 00 00 00-00 00 00 00 00 00 0a 00 |...k.... ........|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0020 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0030 00 00 00 00 00 00 00 00-00 00 00 00 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00-e2 20 00 01 0e 00 00 60 |........ â .....`|
0050 08 81 85 ea 8f 6d 7f ff-ff ff fe 02 0e 00 00 00 |...ê.m.ÿ ÿÿþ.....|
0060 00 00 00 00 00 00 02 68-00 00 00 |.......h ...|
token.c:306:tds_process_login_tokens()
packet.c:640:Received packet
0000 04 01 00 ff 00 00 00 00-e3 0d 00 03 05 69 73 6f |...ÿ.... ã....iso|
0010 5f 31 05 69 73 6f 5f 31-e5 4c 00 48 16 00 00 01 |_1.iso_1 åL.H....|
0020 0a 05 5a 5a 5a 5a 5a 00-01 00 31 00 43 68 61 6e |..ZZZZZ. ..1.Chan|
0030 67 65 64 20 63 6c 69 65-6e 74 20 63 68 61 72 61 |ged clie nt chara|
0040 63 74 65 72 20 73 65 74-20 73 65 74 74 69 6e 67 |cter set setting|
0050 20 74 6f 20 27 69 73 6f-5f 31 27 2e 0a 06 4d 4f | to 'iso _1'...MO|
0060 52 49 4e 49 00 00 00 e3-0d 00 01 04 63 61 73 79 |RINI...ã ....casy|
0070 06 6d 61 73 74 65 72 e5-3f 00 45 16 00 00 02 0a |.masterå ?.E.....|
0080 05 5a 5a 5a 5a 5a 00 01-00 24 00 43 68 61 6e 67 |.ZZZZZ.. .$.Chang|
0090 65 64 20 64 61 74 61 62-61 73 65 20 63 6f 6e 74 |ed datab ase cont|
00a0 65 78 74 20 74 6f 20 27-63 61 73 79 27 2e 0a 06 |ext to ' casy'...|
00b0 4d 4f 52 49 4e 49 00 00-00 e3 07 00 04 04 32 30 |MORINI.. .ã....20|
00c0 34 38 00 ad 0d 00 05 05-00 00 00 03 41 53 45 0f |48..... ....ASE.|
00d0 07 00 00 e2 20 00 01 0e-00 00 60 08 81 85 ea 8b |...â ... ..`...ê.|
00e0 61 7f ff ff ff e6 02 0e-00 00 00 00 00 00 00 00 |a.ÿÿÿæ.. ........|
00f0 00 02 00 00 00 00 fd 00-00 02 00 1f 00 00 00 |......ý. .......|
token.c:314:looking for login token, got e3(ENVCHANGE)
token.c:132:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2262:server indicated charset change to "iso_1"
iconv.c:784:setting server single-byte charset to "ISO-8859-1"
token.c:314:looking for login token, got e5(EED)
token.c:132:tds_process_default_tokens() marker is e5(EED)
token.c:2354:tds_process_info() reading message 5704 from server
token.c:2426:tds_process_info() calling client msg handler
ctutil.c:141:_ct_handle_server_message(0x18bda40, 0x18bde20, 0x7ffe79e07360)
token.c:2443:tds_process_info() returning TDS_SUCCESS
token.c:314:looking for login token, got e3(ENVCHANGE)
token.c:132:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:314:looking for login token, got e5(EED)
token.c:132:tds_process_default_tokens() marker is e5(EED)
token.c:2354:tds_process_info() reading message 5701 from server
token.c:2426:tds_process_info() calling client msg handler
ctutil.c:141:_ct_handle_server_message(0x18bda40, 0x18bde20, 0x7ffe79e07360)
token.c:2443:tds_process_info() returning TDS_SUCCESS
token.c:314:looking for login token, got e3(ENVCHANGE)
token.c:132:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2246:changing block size from to 2048
token.c:314:looking for login token, got ad(LOGINACK)
token.c:352:server reports TDS version 5.0.0.0
token.c:354:Product name for 0x5000000 is unknown
token.c:386:Product version F070000
token.c:314:looking for login token, got e2(CAPABILITY)
token.c:132:tds_process_default_tokens() marker is e2(CAPABILITY)
token.c:314:looking for login token, got fd(DONE)
token.c:132:tds_process_default_tokens() marker is fd(DONE)
token.c:2091:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2108: rows_affected = 31
token.c:2111:tds_process_end() state set to TDS_IDLE
token.c:423:tds_process_login_tokens() returning TDS_SUCCESS
mem.c:660: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:742:Sending packet
0000 0f 01 00 2f 00 00 00 00-21 22 00 00 00 00 73 65 |.../.... !"....se|
0010 74 20 74 65 78 74 73 69-7a 65 20 36 34 35 31 32 |t textsi ze 64512|
0020 20 73 65 6c 65 63 74 20-40 40 73 70 69 64 20 | select @@spid |
token.c:533:tds_process_tokens(0x18bde20, 0x7ffe79e074c0, 0x7ffe79e074d0, 0x500)
util.c:165:Changed query state from PENDING to READING
packet.c:640:Received packet
0000 04 01 00 39 00 00 00 00-fd 01 00 02 00 00 00 00 |...9.... ý.......|
0010 00 61 12 00 00 00 01 00-00 00 00 00 00 30 00 00 |.a...... .....0..|
0020 00 06 00 00 00 26 02 00-ae 01 00 00 d1 02 1f 00 |.....&.. ®...Ñ...|
0030 fd 10 00 02 00 01 00 00-00 |ý....... .|
token.c:548:processing result tokens. marker is fd(DONE)
token.c:2091:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2108: rows_affected = 0
util.c:165:Changed query state from READING to PENDING
token.c:533:tds_process_tokens(0x18bde20, 0x7ffe79e074c0, 0x7ffe79e074d0, 0x500)
util.c:165:Changed query state from PENDING to READING
token.c:548:processing result tokens. marker is 61(ROWFMT2)
token.c:577:calling tds5_process_result2/1
token.c:1778:tds5_process_result2
mem.c:660:tds_free_all_results()
token.c:1802:num_cols=1
token.c:1868:col 0:
token.c:1869: column_name=[]
token.c:1875: flags=30 utype=6 type=38 server type 38 varint=1
token.c:1879: colsize=2 prec=0 scale=0
token.c:1882:tds5_process_result2(): exit
mem.c:529:tds_alloc_row()
mem.c:565:tds_alloc_row(): SUCCESS
token.c:579: tds5_process_result2() = 0
token.c:548:processing result tokens. marker is ae(CONTROL/FEATUREEXTACK)
token.c:132:tds_process_default_tokens() marker is ae(CONTROL/FEATUREEXTACK)
token.c:252:Eating CONTROL/FEATUREEXTACK token
token.c:548:processing result tokens. marker is d1(ROW)
token.c:1944:tds_process_row(): reading column 0
data.c:739:tds_get_data: type 38, varint size 1
data.c:783:tds_get_data(): wire column size is 2
util.c:165:Changed query state from READING to PENDING
token.c:533:tds_process_tokens(0x18bde20, 0x7ffe79e074c0, 0x7ffe79e074d0, 0x500)
util.c:165:Changed query state from PENDING to READING
token.c:548:processing result tokens. marker is fd(DONE)
token.c:2091:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2108: rows_affected = 1
token.c:2111: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
token.c:533:tds_process_tokens(0x18bde20, 0x7ffe79e074c0, 0x7ffe79e074d0, 0x500)
token.c:536:tds_process_tokens() state is COMPLETED
ct.c:685:leaving ct_connect() returning 1
ct.c:701:ct_cmd_alloc(0x18bdce0, 0x18bd930)
ct.c:236:ct_describe_cmd_state(0)
ct.c:236:ct_describe_cmd_state(0)
ct.c:224:setting command state to IDLE (from IDLE)
ct.c:717:ct_cmd_alloc() : allocating command list to head
ct.c:733:ct_command(0x18be350, 148, 0x7ffe79e076a0, -9, 16)
ct.c:869:_ct_initialise_cmd(0x18be350)
ct.c:236:ct_describe_cmd_state(0)
ct.c:236:ct_describe_cmd_state(0)
ct.c:224:setting command state to IDLE (from IDLE)
ct.c:4049:rpc_clear((nil))
ct.c:236:ct_describe_cmd_state(0)
ct.c:236:ct_describe_cmd_state(0)
ct.c:224:setting command state to IDLE (from IDLE)
ct.c:236:ct_describe_cmd_state(0)
ct.c:236:ct_describe_cmd_state(1)
ct.c:224:setting command state to BUILDING (from IDLE)
ct.c:733:ct_command(0x18be350, 148, 0x4ed740, -9, 32)
ct.c:236:ct_describe_cmd_state(1)
ct.c:236:ct_describe_cmd_state(2)
ct.c:224:setting command state to READY (from BUILDING)
ct.c:888:ct_send(0x18be350)
ct.c:893:ct_send() command_type = 148
mem.c:660: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:742:Sending packet
0000 0f 01 00 18 00 00 00 00-21 0b 00 00 00 00 75 73 |........ !.....us|
0010 65 20 63 61 73 79 0a 0a- |e casy..|
ct.c:236:ct_describe_cmd_state(2)
ct.c:236:ct_describe_cmd_state(3)
ct.c:224:setting command state to SENT (from READY)
ct.c:1015:ct_send() succeeded
ct.c:1151:ct_results(0x18be350, 0x7ffe79e075bc)
token.c:533:tds_process_tokens(0x18bde20, 0x7ffe79e073f8, 0x7ffe79e073fc, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:640:Received packet
0000 04 01 00 61 00 00 00 00-e3 0b 00 01 04 63 61 73 |...a.... ã....cas|
0010 79 04 63 61 73 79 e5 3f-00 45 16 00 00 01 0a 05 |y.casyå? .E......|
0020 5a 5a 5a 5a 5a 00 01 00-24 00 43 68 61 6e 67 65 |ZZZZZ... $.Change|
0030 64 20 64 61 74 61 62 61-73 65 20 63 6f 6e 74 65 |d databa se conte|
0040 78 74 20 74 6f 20 27 63-61 73 79 27 2e 0a 06 4d |xt to 'c asy'...M|
0050 4f 52 49 4e 49 00 01 00-fd 00 00 02 00 00 00 00 |ORINI... ý.......|
0060 00 - |.|
token.c:548:processing result tokens. marker is e3(ENVCHANGE)
token.c:132:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:548:processing result tokens. marker is e5(EED)
token.c:132:tds_process_default_tokens() marker is e5(EED)
token.c:2354:tds_process_info() reading message 5701 from server
token.c:2426:tds_process_info() calling client msg handler
ctutil.c:141:_ct_handle_server_message(0x18bda40, 0x18bde20, 0x7ffe79e07270)
token.c:2443:tds_process_info() returning TDS_SUCCESS
token.c:548:processing result tokens. marker is fd(DONE)
token.c:2091:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2108: rows_affected = 0
token.c:2111: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
ct.c:1215:ct_results() process_result_tokens returned 0 (type 4052)
ct.c:1334:ct_results() results state = 0
ct.c:1335:ct_results() command type = 148
ct.c:1336:ct_results() dynamic cmd = 0
ct.c:1151:ct_results(0x18be350, 0x7ffe79e075bc)
ct.c:1151:ct_results(0x18be350, 0x7ffe79e0736c)
token.c:533:tds_process_tokens(0x18bde20, 0x7ffe79e071a8, 0x7ffe79e071ac, 0x6914)
token.c:536:tds_process_tokens() state is COMPLETED
ct.c:1215:ct_results() process_result_tokens returned 1 (type 4052)
ct.c:236:ct_describe_cmd_state(3)
ct.c:236:ct_describe_cmd_state(2)
ct.c:224:setting command state to READY (from SENT)
ct.c:733:ct_command(0x18be350, 148, 0x4edb80, -9, 16)
ct.c:869:_ct_initialise_cmd(0x18be350)
ct.c:236:ct_describe_cmd_state(2)
ct.c:236:ct_describe_cmd_state(0)
ct.c:224:setting command state to IDLE (from READY)
ct.c:4049:rpc_clear((nil))
ct.c:236:ct_describe_cmd_state(0)
ct.c:236:ct_describe_cmd_state(0)
ct.c:224:setting command state to IDLE (from IDLE)
ct.c:236:ct_describe_cmd_state(0)
ct.c:236:ct_describe_cmd_state(1)
ct.c:224:setting command state to BUILDING (from IDLE)
ct.c:733:ct_command(0x18be350, 148, 0x4ed740, -9, 32)
ct.c:236:ct_describe_cmd_state(1)
ct.c:236:ct_describe_cmd_state(2)
ct.c:224:setting command state to READY (from BUILDING)
ct.c:888:ct_send(0x18be350)
ct.c:893:ct_send() command_type = 148
mem.c:660: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:742:Sending packet
0000 0f 01 00 59 00 00 00 00-21 4c 00 00 00 00 73 65 |...Y.... !L....se|
0010 6c 65 63 74 20 6e 61 6d-65 2c 74 79 70 65 20 66 |lect nam e,type f|
0020 72 6f 6d 20 73 79 73 6f-62 6a 65 63 74 73 20 77 |rom syso bjects w|
0030 68 65 72 65 20 74 79 70-65 20 69 6e 20 28 27 55 |here typ e in ('U|
0040 27 2c 27 53 27 2c 27 56-27 29 20 6f 72 64 65 72 |','S','V ') order|
0050 20 62 79 20 6e 61 6d 65-0a | by name .|
ct.c:236:ct_describe_cmd_state(2)
ct.c:236:ct_describe_cmd_state(3)
ct.c:224:setting command state to SENT (from READY)
ct.c:1015:ct_send() succeeded
ct.c:1151:ct_results(0x18be350, 0x7ffe79e0757c)
token.c:533:tds_process_tokens(0x18bde20, 0x7ffe79e073b8, 0x7ffe79e073bc, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:640:Received packet
0000 04 00 08 00 00 00 00 00-61 4c 00 00 00 02 00 00 |........ aL......|
0010 04 63 61 73 79 03 64 62-6f 0a 73 79 73 6f 62 6a |.casy.db o.sysobj|
0020 65 63 74 73 04 6e 61 6d-65 10 00 00 00 2a 00 00 |ects.nam e....*..|
0030 00 27 ff 00 00 04 63 61-73 79 03 64 62 6f 0a 73 |.'ÿ...ca sy.dbo.s|
0040 79 73 6f 62 6a 65 63 74-73 04 74 79 70 65 10 00 |ysobject s.type..|
0050 00 00 01 00 00 00 2f 02-00 ae 02 00 00 00 a9 01 |....../. .®....©.|
0060 00 01 d1 05 41 32 46 41-51 02 55 20 d1 0b 41 62 |..Ñ.A2FA Q.U Ñ.Ab|
0070 66 72 61 67 65 55 73 65-72 02 55 20 d1 08 43 48 |frageUse r.U Ñ.CH|
0080 42 65 7a 69 72 6b 02 55-20 d1 0a 43 48 47 65 6d |Bezirk.U Ñ.CHGem|
0090 65 69 6e 64 65 02 55 20-d1 08 43 48 4b 61 6e 74 |einde.U Ñ.CHKant|
00a0 6f 6e 02 55 20 d1 06 43-48 50 4c 5a 31 02 55 20 |on.U Ñ.C HPLZ1.U |
00b0 d1 06 43 48 50 4c 5a 32-02 55 20 d1 0a 44 6f 6b |Ñ.CHPLZ2 .U Ñ.Dok|
00c0 75 41 41 72 74 65 6e 02-55 20 d1 0a 44 6f 6b 75 |uAArten. U Ñ.Doku|
00d0 49 41 72 74 65 6e 02 55-20 d1 09 44 6f 6b 75 49 |IArten.U Ñ.DokuI|
00e0 64 65 6e 74 02 55 20 d1-0e 44 6f 6b 75 49 64 65 |dent.U Ñ .DokuIde|
00f0 6e 74 69 74 69 65 73 02-55 20 d1 08 44 6f 6b 75 |ntities. U Ñ.Doku|
0100 49 74 65 6d 02 55 20 d1-0a 44 6f 6b 75 52 41 72 |Item.U Ñ .DokuRAr|
0110 74 65 6e 02 55 20 d1 0c-44 6f 6b 75 52 65 6c 61 |ten.U Ñ. DokuRela|
0120 74 69 6f 6e 02 55 20 d1-08 44 6f 6b 75 54 65 78 |tion.U Ñ .DokuTex|
0130 74 02 55 20 d1 0d 44 72-75 63 6b 44 65 66 61 75 |t.U Ñ.Dr uckDefau|
0140 6c 74 73 02 55 20 d1 0e-44 72 75 63 6b 50 61 72 |lts.U Ñ. DruckPar|
0150 61 6d 65 74 65 72 02 55-20 d1 07 44 72 75 63 6b |ameter.U Ñ.Druck|
0160 65 72 02 55 20 d1 0d 44-72 75 63 6b 65 72 47 72 |er.U Ñ.D ruckerGr|
0170 75 70 70 65 02 55 20 d1-0d 44 72 75 63 6b 65 72 |uppe.U Ñ .Drucker|
0180 53 70 65 72 72 65 02 55-20 d1 10 44 72 75 63 6b |Sperre.U Ñ.Druck|
0190 65 72 5a 75 6f 72 64 6e-75 6e 67 02 55 20 d1 0c |erZuordn ung.U Ñ.|
01a0 45 42 69 6c 61 6e 7a 5f-67 61 61 70 02 55 20 d1 |EBilanz_ gaap.U Ñ|
01b0 0b 45 42 69 6c 61 6e 7a-5f 67 63 64 02 55 20 d1 |.EBilanz _gcd.U Ñ|
01c0 03 46 41 51 02 55 20 d1-06 46 41 51 32 52 4e 02 |.FAQ.U Ñ .FAQ2RN.|
01d0 55 20 d1 0e 46 43 44 42-43 61 74 65 67 6f 72 69 |U Ñ.FCDB Categori|
01e0 65 73 02 55 20 d1 15 46-43 44 42 43 6f 64 65 73 |es.U Ñ.F CDBCodes|
01f0 42 65 73 74 45 73 74 69-6d 61 74 65 02 55 20 d1 |BestEsti mate.U Ñ|
0200 0e 46 43 44 42 43 6f 6d-70 6f 6e 65 6e 74 73 02 |.FCDBCom ponents.|
0210 55 20 d1 13 46 43 44 42-43 6f 6d 70 6f 6e 65 6e |U Ñ.FCDB Componen|
0220 74 73 55 6e 69 74 73 02-55 20 d1 09 46 43 44 42 |tsUnits. U Ñ.FCDB|
0230 46 6f 6f 64 73 02 55 20-d1 13 46 43 44 42 46 6f |Foods.U Ñ.FCDBFo|
0240 6f 64 73 43 6f 6d 70 6f-6e 65 6e 74 73 02 55 20 |odsCompo nents.U |
0250 d1 15 46 43 44 42 46 6f-6f 64 73 54 6f 43 61 74 |Ñ.FCDBFo odsToCat|
0260 65 67 6f 72 69 65 73 02-55 20 d1 04 46 6f 72 6d |egories. U Ñ.Form|
0270 02 55 20 d1 09 46 6f 72-6d 50 61 72 61 6d 02 55 |.U Ñ.For mParam.U|
0280 20 d1 0d 46 6f 72 6d 53-74 61 74 69 73 74 69 6b | Ñ.FormS tatistik|
0290 02 55 20 d1 13 46 6f 72-6d 53 74 61 74 69 73 74 |.U Ñ.For mStatist|
02a0 69 6b 44 65 74 61 69 6c-02 55 20 d1 08 46 6f 72 |ikDetail .U Ñ.For|
02b0 6d 54 65 78 74 02 55 20-d1 0b 46 6f 72 6d 54 65 |mText.U Ñ.FormTe|
02c0 78 74 55 73 65 02 55 20-d1 0c 46 72 65 69 65 41 |xtUse.U Ñ.FreieA|
02d0 6e 66 72 61 67 65 02 55-20 d1 12 46 72 65 69 65 |nfrage.U Ñ.Freie|
02e0 41 6e 66 72 61 67 65 46-65 6c 64 65 72 02 55 20 |AnfrageF elder.U |
02f0 d1 08 47 48 53 5f 54 65-78 74 02 55 20 d1 08 47 |Ñ.GHS_Te xt.U Ñ.G|
0300 6c 6f 62 61 6c 65 73 02-55 20 d1 0f 47 72 75 70 |lobales. U Ñ.Grup|
0310 70 65 6e 52 65 63 68 74-65 50 48 02 55 20 d1 17 |penRecht ePH.U Ñ.|
0320 47 72 75 70 70 65 6e 52-65 63 68 74 65 50 48 5f |GruppenR echtePH_|
0330 48 69 73 74 6f 72 79 02-55 20 d1 0e 4b 6f 6e 73 |History. U Ñ.Kons|
0340 6f 6c 69 64 69 65 72 75-6e 67 02 55 20 d1 07 4c |olidieru ng.U Ñ.L|
0350 61 65 6e 64 65 72 02 55-20 d1 07 4c 6f 6b 61 6c |aender.U Ñ.Lokal|
0360 65 73 02 55 20 d1 04 4d-61 69 6c 02 55 20 d1 07 |es.U Ñ.M ail.U Ñ.|
0370 4d 61 6e 64 61 6e 74 02-55 20 d1 0c 4d 6f 64 75 |Mandant. U Ñ.Modu|
0380 6c 45 69 6e 68 65 69 74-02 55 20 d1 06 4d 6f 64 |lEinheit .U Ñ.Mod|
0390 75 6c 65 02 55 20 d1 04-4e 61 76 69 02 55 20 d1 |ule.U Ñ. Navi.U Ñ|
03a0 0a 4e 61 76 69 4c 65 69-73 74 65 02 55 20 d1 0f |.NaviLei ste.U Ñ.|
03b0 4f 62 6a 65 63 74 44 69-72 65 63 74 6f 72 79 02 |ObjectDi rectory.|
03c0 55 20 d1 06 50 61 70 69-65 72 02 55 20 d1 0d 50 |U Ñ.Papi er.U Ñ.P|
03d0 6f 73 74 5a 45 42 55 44-61 74 65 6e 02 55 20 d1 |ostZEBUD aten.U Ñ|
03e0 06 50 72 6f 66 69 6c 02-55 20 d1 0a 50 72 6f 66 |.Profil. U Ñ.Prof|
03f0 69 6c 4b 6f 70 66 02 55-20 d1 10 52 65 63 68 74 |ilKopf.U Ñ.Recht|
0400 65 44 65 66 69 6e 69 74-69 6f 6e 02 55 20 d1 0c |eDefinit ion.U Ñ.|
0410 52 65 6c 65 61 73 65 4e-6f 74 65 73 02 55 20 d1 |ReleaseN otes.U Ñ|
0420 0e 53 70 65 64 44 50 44-44 65 70 6f 74 73 31 02 |.SpedDPD Depots1.|
0430 55 20 d1 0c 53 70 65 64-44 50 44 4c 61 6e 64 31 |U Ñ.Sped DPDLand1|
0440 02 55 20 d1 0f 53 70 65-64 44 50 44 52 6f 75 74 |.U Ñ.Spe dDPDRout|
0450 69 6e 67 31 02 55 20 d1-0f 53 70 65 64 44 50 44 |ing1.U Ñ .SpedDPD|
0460 53 65 72 76 69 63 65 31-02 55 20 d1 13 53 70 65 |Service1 .U Ñ.Spe|
0470 64 44 50 44 53 65 72 76-69 63 65 49 6e 66 6f 31 |dDPDServ iceInfo1|
0480 02 55 20 d1 10 53 70 65-64 44 50 44 53 74 61 6e |.U Ñ.Spe dDPDStan|
0490 64 6f 72 74 31 02 55 20-d1 0f 53 70 65 64 44 50 |dort1.U Ñ.SpedDP|
04a0 5f 47 52 4f 53 53 5f 44-41 02 55 20 d1 0a 53 70 |_GROSS_D A.U Ñ.Sp|
04b0 65 64 44 50 5f 49 4e 54-02 55 20 d1 0d 53 70 65 |edDP_INT .U Ñ.Spe|
04c0 64 44 50 5f 4f 52 54 5f-44 41 02 55 20 d1 0d 53 |dDP_ORT_ DA.U Ñ.S|
04d0 70 65 64 44 50 5f 4f 54-4c 5f 44 42 02 55 20 d1 |pedDP_OT L_DB.U Ñ|
04e0 0d 53 70 65 64 44 50 5f-50 4c 5a 5f 44 41 02 55 |.SpedDP_ PLZ_DA.U|
04f0 20 d1 0a 53 70 65 64 44-50 5f 52 4b 5a 02 55 20 | Ñ.SpedD P_RKZ.U |
0500 d1 0e 53 70 65 64 44 50-5f 53 54 52 41 5f 44 42 |Ñ.SpedDP _STRA_DB|
0510 02 55 20 d1 12 53 70 65-64 4e 61 63 68 76 65 72 |.U Ñ.Spe dNachver|
0520 66 6f 6c 67 75 6e 67 02-55 20 d1 0f 53 70 65 64 |folgung. U Ñ.Sped|
0530 54 4e 54 5f 45 78 70 72-65 73 73 02 55 20 d1 0f |TNT_Expr ess.U Ñ.|
0540 53 70 65 64 54 4e 54 5f-50 4c 5a 54 6f 75 72 02 |SpedTNT_ PLZTour.|
0550 55 20 d1 0e 53 70 65 64-54 4e 54 5f 53 6f 72 74 |U Ñ.Sped TNT_Sort|
0560 43 64 02 55 20 d1 0e 53-70 65 64 54 4f 46 52 6f |Cd.U Ñ.S pedTOFRo|
0570 75 74 69 6e 67 02 55 20-d1 08 53 70 72 61 63 68 |uting.U Ñ.Sprach|
0580 65 6e 02 55 20 d1 0f 53-74 61 6e 64 61 72 64 44 |en.U Ñ.S tandardD|
0590 72 75 63 6b 65 72 02 55-20 d1 13 53 74 61 6e 64 |rucker.U Ñ.Stand|
05a0 61 72 64 45 69 6e 73 74-65 6c 6c 75 6e 67 02 55 |ardEinst ellung.U|
05b0 20 d1 0d 53 74 61 6e 64-61 72 64 4c 69 73 74 65 | Ñ.Stand ardListe|
05c0 02 55 20 d1 17 53 74 61-6e 64 61 72 64 4c 69 73 |.U Ñ.Sta ndardLis|
05d0 74 65 6e 50 61 72 61 6d-65 74 65 72 02 55 20 d1 |tenParam eter.U Ñ|
05e0 0c 53 74 61 6e 64 61 72-64 54 65 78 74 02 55 20 |.Standar dText.U |
05f0 d1 0b 53 74 61 74 75 73-43 6f 64 65 73 02 55 20 |Ñ.Status Codes.U |
0600 d1 0f 53 77 69 66 74 57-61 65 68 72 75 6e 67 65 |Ñ.SwiftW aehrunge|
0610 6e 02 55 20 d1 0c 54 65-6d 70 54 61 62 6c 65 44 |n.U Ñ.Te mpTableD|
0620 65 66 02 55 20 d1 08 54-72 69 67 67 65 72 73 02 |ef.U Ñ.T riggers.|
0630 55 20 d1 08 55 73 65 72-41 75 74 68 02 55 20 d1 |U Ñ.User Auth.U Ñ|
0640 09 55 73 65 72 47 72 6f-75 70 02 55 20 d1 11 55 |.UserGro up.U Ñ.U|
0650 73 65 72 47 72 6f 75 70-5f 48 69 73 74 6f 72 79 |serGroup _History|
0660 02 55 20 d1 0b 55 73 65-72 4d 61 6e 64 61 6e 74 |.U Ñ.Use rMandant|
0670 02 55 20 d1 13 55 73 65-72 4d 61 6e 64 61 6e 74 |.U Ñ.Use rMandant|
0680 5f 48 69 73 74 6f 72 79-02 55 20 d1 0a 55 73 65 |_History .U Ñ.Use|
0690 72 52 69 67 68 74 73 02-55 20 d1 12 55 73 65 72 |rRights. U Ñ.User|
06a0 52 69 67 68 74 73 5f 48-69 73 74 6f 72 79 02 55 |Rights_H istory.U|
06b0 20 d1 09 55 73 65 72 6c-6f 67 69 6e 02 55 20 d1 | Ñ.Userl ogin.U Ñ|
06c0 11 55 73 65 72 6c 6f 67-69 6e 5f 48 69 73 74 6f |.Userlog in_Histo|
06d0 72 79 02 55 20 d1 05 55-73 65 72 73 02 55 20 d1 |ry.U Ñ.U sers.U Ñ|
06e0 0d 55 73 65 72 73 5f 48-69 73 74 6f 72 79 02 55 |.Users_H istory.U|
06f0 20 d1 08 56 61 72 69 61-62 6c 65 02 55 20 d1 0d | Ñ.Varia ble.U Ñ.|
0700 56 61 72 69 61 62 6c 65-6e 57 65 72 74 02 55 20 |Variable nWert.U |
0710 d1 0a 5a 65 72 74 69 66-69 6b 61 74 02 55 20 d1 |Ñ.Zertif ikat.U Ñ|
0720 09 69 74 73 67 6b 6b 41-44 52 02 55 20 d1 09 69 |.itsgkkA DR.U Ñ.i|
0730 74 73 67 6b 6b 42 4e 54-02 55 20 d1 09 69 74 73 |tsgkkBNT .U Ñ.its|
0740 67 6b 6b 42 54 53 02 55-20 d1 09 69 74 73 67 6b |gkkBTS.U Ñ.itsgk|
0750 6b 45 42 53 02 55 20 d1-09 69 74 73 67 6b 6b 48 |kEBS.U Ñ .itsgkkH|
0760 44 52 02 55 20 d1 0a 69-74 73 67 6b 6b 4b 49 42 |DR.U Ñ.i tsgkkKIB|
0770 53 02 55 20 d1 09 69 74-73 67 6b 6b 55 4d 45 02 |S.U Ñ.it sgkkUME.|
0780 55 20 d1 09 69 74 73 67-6b 6b 55 4d 4c 02 55 20 |U Ñ.itsg kkUML.U |
0790 d1 09 69 74 73 67 6b 6b-56 53 53 02 55 20 d1 0d |Ñ.itsgkk VSS.U Ñ.|
07a0 73 79 73 61 6c 74 65 72-6e 61 74 65 73 02 53 20 |sysalter nates.S |
07b0 d1 0d 73 79 73 61 74 74-72 69 62 75 74 65 73 02 |Ñ.sysatt ributes.|
07c0 53 20 d1 0a 73 79 73 63-6f 6c 75 6d 6e 73 02 53 |S Ñ.sysc olumns.S|
07d0 20 d1 0b 73 79 73 63 6f-6d 6d 65 6e 74 73 02 53 | Ñ.sysco mments.S|
07e0 20 d1 0e 73 79 73 63 6f-6e 73 74 72 61 69 6e 74 | Ñ.sysco nstraint|
07f0 73 02 53 20 d1 0a 73 79-73 64 65 70 65 6e 64 73 |s.S Ñ.sy sdepends|
token.c:548:processing result tokens. marker is 61(ROWFMT2)
token.c:577:calling tds5_process_result2/1
token.c:1778:tds5_process_result2
mem.c:660:tds_free_all_results()
token.c:1802:num_cols=2
token.c:1868:col 0:
token.c:1869: column_name=[name]
token.c:1875: flags=10 utype=42 type=39 server type 39 varint=1
token.c:1879: colsize=255 prec=0 scale=0
token.c:1868:col 1:
token.c:1869: column_name=[type]
token.c:1875: flags=10 utype=1 type=47 server type 47 varint=1
token.c:1879: colsize=2 prec=0 scale=0
token.c:1882:tds5_process_result2(): exit
mem.c:529:tds_alloc_row()
mem.c:565:tds_alloc_row(): SUCCESS
token.c:579: tds5_process_result2() = 0
util.c:165:Changed query state from READING to PENDING
ct.c:1215:ct_results() process_result_tokens returned 0 (type 4049)
token.c:533:tds_process_tokens(0x18bde20, 0x7ffe79e073b8, 0x7ffe79e073bc, 0x6a14)
util.c:165:Changed query state from PENDING to READING
token.c:548:processing result tokens. marker is ae(CONTROL/FEATUREEXTACK)
token.c:132:tds_process_default_tokens() marker is ae(CONTROL/FEATUREEXTACK)
token.c:252:Eating CONTROL/FEATUREEXTACK token
token.c:548:processing result tokens. marker is a9(ORDERBY)
token.c:132:tds_process_default_tokens() marker is a9(ORDERBY)
token.c:252:Eating ORDERBY token
token.c:548:processing result tokens. marker is d1(ROW)
token.c:656:tds_process_tokens::SET_RETURN stopping on current token
util.c:165:Changed query state from READING to PENDING
ct.c:1215:ct_results() process_result_tokens returned 0 (type 4040)
ct.c:2387:ct_res_info(0x18be350, 803, 0x7ffe79e0760c, -99999, (nil))
ct.c:2406:ct_res_info(): Number of columns is 2
ct.c:2327:ct_describe(0x18be350, 1, 0x7ffe79e07410)
ct.c:1925:_ct_get_client_type(type 39, user 42, size 255)
ct.c:2344:ct_describe() datafmt->datatype = 0 server type 39
ctlib_ok.log
(text/x-log, 717.1 KB) - not displayed