FreeTDS Development Group

[Jaye Mathisen <mrcpu AT internetcds.com>]

Bizarro.  A quick script I've been using has been running fine from my
FreeBSD 3.2 box to an SQL 7 box.

Here's the log.  It ran once today, then failed with the unknown property
26...

Attached is the freetds dump...

Sending packet @ 2000-02-29 10:12:00.556050
0000  02 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
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 70 6c 61 74 72 65 61 64 65   |.......xxxxxxxxx|
0030  72 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |x...............|
0040  00 00 00 00 00 0a 70 6c 61 74 72 65 61 64 65 72   |......xxxxxxxxxx|
0050  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0060  00 00 00 00 0a 33 37 38 37 36 00 00 00 00 00 00   |.....37876......|
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 02 00   |................|
0090  00 00 00 00 73 71 73 68 00 00 00 00 00 00 00 00   |....sqsh........|
00a0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
00b0  00 00 04 6d 61 72 73 75 70 69 61 6c 2e 63 64 73   |...marsupial.cds|
00c0  6e 65 74 2e 6e 65 74 00 00 00 00 00 00 00 00 00   |net.net.........|
00d0  00 14 70 6c 61 74 72 65 61 64 65 72 00 00 00 00   |..xxxxxxxxxx....|
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 04 02 00 00 43 54 2d 4c 69 62 72 61 72 79   |......CT-Library|
01e0  0a 00 00 00 00 00 0d 11 00 00 00 00 00 00 00 00   |................|
01f0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|


Sending packet @ 2000-02-29 10:12:00.560588
0000  02 01 00 4c 00 00 00 00 00 00 00 00 00 00 00 00   |...L............|
0010  00 00 00 00 00 00 00 00 00 00 00 00 00 69 73 6f   |.............iso|
0020  5f 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |_1..............|
0030  00 00 00 00 00 00 00 00 00 00 00 05 01 35 31 32   |.............512|
0040  00 00 00 03 00 00 00 00 00 00 00 00               |............|


2000-02-29 10:12:00.561252 inside tds_process_login_tokens()
2000-02-29 10:12:00.763602 inside tds_process_default_tokens() marker is e3
2000-02-29 10:12:00.763830 inside tds_process_default_tokens() marker is ab
2000-02-29 10:12:00.763961 inside tds_process_default_tokens() marker is e3
2000-02-29 10:12:00.764047 inside tds_process_default_tokens() marker is e3
2000-02-29 10:12:00.764168 inside tds_process_default_tokens() marker is fd
2000-02-29 10:12:00.764258 leaving tds_process_login_tokens() returning 1
2000-02-29 10:12:00.764371 leaving ct_connect() returning 1
2000-02-29 10:12:00.764463 inside ct_cmd_alloc()
2000-02-29 10:12:00.764549 inside ct_command()
2000-02-29 10:12:00.764628 inside ct_send()
Sending packet @ 2000-02-29 10:12:00.764717
0000  01 01 00 10 00 00 00 00 75 73 65 20 70 6c 61 74   |........use plat|


2000-02-29 10:12:00.786021 inside ct_results()
2000-02-29 10:12:00.790996 processing result tokens.  marker is  e3
2000-02-29 10:12:00.791119 inside tds_process_default_tokens() marker is e3
2000-02-29 10:12:00.791232 processing result tokens.  marker is  ab
2000-02-29 10:12:00.791417 processing result tokens.  marker is  fd
2000-02-29 10:12:00.791517 inside ct_cmd_drop()
2000-02-29 10:12:00.795479 inside ct_cmd_alloc()
2000-02-29 10:12:00.795572 inside ct_command()
2000-02-29 10:12:00.795743 inside ct_cmd_props()
2000-02-29 10:12:00.796008 inside ct_send()
Sending packet @ 2000-02-29 10:12:00.796186
0000  01 01 01 63 00 00 00 00 0a 0a 73 65 6c 65 63 74   |...c......select|
0010  20 0a 09 63 72 2e 63 72 69 64 20 22 43 52 49 44   | ..cr.crid "CRID|
0020  22 2c 20 0a 09 63 2e 69 64 20 22 49 64 22 2c 20   |", ..c.id "Id", |
0030  73 75 62 73 74 72 69 6e 67 28 63 2e 6e 61 6d 65   |substring(c.name|
0040  2c 31 2c 32 35 29 20 22 4e 61 6d 65 22 2c 20 0a   |,1,25) "Name", .|
0050  09 72 67 2e 69 64 20 22 52 61 74 65 20 49 44 22   |.rg.id "Rate ID"|
0060  2c 20 0a 09 73 75 62 73 74 72 69 6e 67 28 72 67   |, ..substring(rg|
0070  2e 6e 61 6d 65 2c 31 2c 33 35 29 20 22 52 61 74   |.name,1,35) "Rat|
0080  65 22 20 0a 20 20 66 72 6f 6d 0a 20 20 09 72 67   |e" .  from.  .rg|
0090  68 65 61 64 65 72 20 72 67 2c 20 0a 09 63 75 73   |header rg, ..cus|
00a0  74 6f 6d 65 72 20 63 2c 20 0a 09 63 75 73 74 72   |tomer c, ..custr|
00b0  61 74 65 20 63 72 20 0a 0a 20 20 77 68 65 72 65   |ate cr ..  where|
00c0  0a 20 20 09 63 2e 69 64 20 3d 20 63 72 2e 63 75   |.  .c.id = cr.cu|
00d0  73 74 69 64 0a 20 20 61 6e 64 0a 09 72 67 2e 69   |stid.  and..rg.i|
00e0  64 20 3d 20 63 72 2e 72 67 69 64 0a 20 20 61 6e   |d = cr.rgid.  an|
00f0  64 20 0a 09 63 72 2e 63 72 69 64 20 3e 20 28 28   |d ..cr.crid > ((|
0100  73 65 6c 65 63 74 20 6d 61 78 28 63 74 63 72 2e   |select max(ctcr.|
0110  63 72 69 64 29 20 66 72 6f 6d 20 63 64 73 6e 65   |crid) from cdsne|
0120  74 5f 74 72 61 63 6b 5f 63 75 73 74 72 61 74 65   |t_track_custrate|
0130  5f 63 72 69 64 20 63 74 63 72 20 29 20 29 0a 0a   |_crid ctcr ) )..|
0140  20 20 6f 72 64 65 72 20 62 79 20 0a 09 72 67 2e   |  order by ..rg.|
0150  69 64 20 61 73 63 2c 0a 09 63 2e 69 64 20 64 65   |id asc,..c.id de|
0160  73 63 0a                                          |sc.|


2000-02-29 10:12:00.798755 inside ct_results()
2000-02-29 10:12:01.023620 processing result tokens.  marker is  a0
2000-02-29 10:12:01.023945 processing result tokens.  marker is  a1
2000-02-29 10:12:01.024025 inside tds_process_default_tokens() marker is a1
2000-02-29 10:12:01.024139 processing result tokens.  marker is  a9
2000-02-29 10:12:01.024216 inside tds_process_default_tokens() marker is a9
2000-02-29 10:12:01.024293 processing result tokens.  marker is  fd
2000-02-29 10:12:01.024402 inside ct_res_info()
2000-02-29 10:12:01.024509 inside ct_describe()
2000-02-29 10:12:01.024590 inside _ct_get_client_type()
2000-02-29 10:12:01.024660 inside ct_describe() datafmt->datatype = 2 server 
type 56
2000-02-29 10:12:01.024894 inside ct_bind()
2000-02-29 10:12:01.025003 inside ct_bind() item = 1 datafmt->datatype = 1
2000-02-29 10:12:01.025142 inside ct_describe()
2000-02-29 10:12:01.025210 inside _ct_get_client_type()
2000-02-29 10:12:01.025276 inside ct_describe() datafmt->datatype = 2 server 
type 56
2000-02-29 10:12:01.025358 inside ct_bind()
2000-02-29 10:12:01.025424 inside ct_bind() item = 2 datafmt->datatype = 1
2000-02-29 10:12:01.025498 inside ct_describe()
2000-02-29 10:12:01.025564 inside _ct_get_client_type()
2000-02-29 10:12:01.025631 inside ct_describe() datafmt->datatype = 1 server 
type 39
2000-02-29 10:12:01.025715 inside ct_bind()
2000-02-29 10:12:01.025780 inside ct_bind() item = 3 datafmt->datatype = 1
2000-02-29 10:12:01.025855 inside ct_describe()
2000-02-29 10:12:01.025923 inside _ct_get_client_type()
2000-02-29 10:12:01.025989 inside ct_describe() datafmt->datatype = 3 server 
type 52
2000-02-29 10:12:01.026072 inside ct_bind()
2000-02-29 10:12:01.026135 inside ct_bind() item = 4 datafmt->datatype = 1
2000-02-29 10:12:01.026210 inside ct_describe()
2000-02-29 10:12:01.026276 inside _ct_get_client_type()
2000-02-29 10:12:01.026342 inside ct_describe() datafmt->datatype = 1 server 
type 39
2000-02-29 10:12:01.026424 inside ct_bind()
2000-02-29 10:12:01.026489 inside ct_bind() item = 5 datafmt->datatype = 1
2000-02-29 10:12:01.027258 inside ct_fetch()
2000-02-29 10:12:01.027347 inside _ct_bind_data()
2000-02-29 10:12:01.027413 inside _ct_bind_data() setting column size for 0 = 
4
2000-02-29 10:12:01.028199 inside _ct_get_server_type()
2000-02-29 10:12:01.028274 inside _ct_bind_data() converting column 0 from 
type 56 to type 47
2000-02-29 10:12:01.028378 inside _ct_get_server_type()
2000-02-29 10:12:01.028494 converting string dlen = 12 strlen = 47 string = 0
2000-02-29 10:12:01.028577 inside _ct_bind_data() setting column size for 1 = 
4
2000-02-29 10:12:01.028655 inside _ct_get_server_type()
2000-02-29 10:12:01.028720 inside _ct_bind_data() converting column 1 from 
type 56 to type 47
2000-02-29 10:12:01.028801 inside _ct_get_server_type()
2000-02-29 10:12:01.028872 converting string dlen = 12 strlen = 47 string = 0
2000-02-29 10:12:01.028950 inside _ct_bind_data() setting column size for 2 = 
25
2000-02-29 10:12:01.029027 inside _ct_get_server_type()
2000-02-29 10:12:01.029091 inside _ct_bind_data() converting column 2 from 
type 39 to type 47
2000-02-29 10:12:01.029171 inside _ct_get_server_type()
2000-02-29 10:12:01.029246 converting string dlen = 26 strlen = 47 string = 
2000-02-29 10:12:01.029326 inside _ct_bind_data() setting column size for 3 = 
2
2000-02-29 10:12:01.029483 inside _ct_get_server_type()
2000-02-29 10:12:01.029548 inside _ct_bind_data() converting column 3 from 
type 52 to type 47
2000-02-29 10:12:01.029628 inside _ct_get_server_type()
2000-02-29 10:12:01.029706 converting string dlen = 7 strlen = 47 string = 0
2000-02-29 10:12:01.029787 inside _ct_bind_data() setting column size for 4 = 
35
2000-02-29 10:12:01.029864 inside _ct_get_server_type()
2000-02-29 10:12:01.029928 inside _ct_bind_data() converting column 4 from 
type 39 to type 47
2000-02-29 10:12:01.030011 inside _ct_get_server_type()
2000-02-29 10:12:01.030076 converting string dlen = 36 strlen = 47 string = 
2000-02-29 10:12:01.030160 inside ct_results()
2000-02-29 10:12:01.030297 inside ct_cmd_drop()
2000-02-29 10:12:01.031076 inside ct_cmd_alloc()
2000-02-29 10:12:01.031161 inside ct_command()
2000-02-29 10:12:01.031237 inside ct_cmd_props()
2000-02-29 10:12:01.031335 inside ct_send()
Sending packet @ 2000-02-29 10:12:01.031437
0000  01 01 00 5f 00 00 00 00 0a 0a 75 70 64 61 74 65   |..._......update|
0010  20 63 64 73 6e 65 74 5f 74 72 61 63 6b 5f 63 75   | cdsnet_track_cu|
0020  73 74 72 61 74 65 5f 63 72 69 64 20 73 65 74 20   |strate_crid set |
0030  63 72 69 64 3d 28 28 73 65 6c 65 63 74 20 6d 61   |crid=((select ma|
0040  78 28 63 72 2e 63 72 69 64 29 20 66 72 6f 6d 20   |x(cr.crid) from |
0050  63 75 73 74 72 61 74 65 20 63 72 29 29 20 0a      |custrate cr)) .|


2000-02-29 10:12:01.032345 inside ct_results()
2000-02-29 10:12:01.055191 processing result tokens.  marker is  fd
2000-02-29 10:12:01.055495 inside ct_res_info()
2000-02-29 10:12:01.055619 inside ct_describe()
2000-02-29 10:12:01.055713 inside _ct_get_client_type()
2000-02-29 10:12:01.055781 inside ct_describe() datafmt->datatype = 2 server 
type 56
2000-02-29 10:12:01.055887 inside ct_bind()
2000-02-29 10:12:01.055952 inside ct_bind() item = 1 datafmt->datatype = 1
2000-02-29 10:12:01.056030 inside ct_describe()
2000-02-29 10:12:01.056097 inside _ct_get_client_type()
2000-02-29 10:12:01.056162 inside ct_describe() datafmt->datatype = 2 server 
type 56
2000-02-29 10:12:01.056245 inside ct_bind()
2000-02-29 10:12:01.056308 inside ct_bind() item = 2 datafmt->datatype = 1
2000-02-29 10:12:01.056383 inside ct_describe()
2000-02-29 10:12:01.056449 inside _ct_get_client_type()
2000-02-29 10:12:01.056516 inside ct_describe() datafmt->datatype = 1 server 
type 39
2000-02-29 10:12:01.056598 inside ct_bind()
2000-02-29 10:12:01.056664 inside ct_bind() item = 3 datafmt->datatype = 1
2000-02-29 10:12:01.056739 inside ct_describe()
2000-02-29 10:12:01.056805 inside _ct_get_client_type()
2000-02-29 10:12:01.056871 inside ct_describe() datafmt->datatype = 3 server 
type 52
2000-02-29 10:12:01.056953 inside ct_bind()
2000-02-29 10:12:01.057018 inside ct_bind() item = 4 datafmt->datatype = 1
2000-02-29 10:12:01.057093 inside ct_describe()
2000-02-29 10:12:01.057159 inside _ct_get_client_type()
2000-02-29 10:12:01.057225 inside ct_describe() datafmt->datatype = 1 server 
type 39
2000-02-29 10:12:01.057308 inside ct_bind()
2000-02-29 10:12:01.057373 inside ct_bind() item = 5 datafmt->datatype = 1
2000-02-29 10:12:01.057682 inside ct_fetch()
2000-02-29 10:12:01.057756 inside _ct_bind_data()
2000-02-29 10:12:01.057819 inside _ct_bind_data() setting column size for 0 = 
4
2000-02-29 10:12:01.057899 inside _ct_get_server_type()
2000-02-29 10:12:01.057966 inside _ct_bind_data() converting column 0 from 
type 56 to type 47
2000-02-29 10:12:01.058052 inside _ct_get_server_type()
2000-02-29 10:12:01.058132 converting string dlen = 12 strlen = 47 string = 0
2000-02-29 10:12:01.058217 inside _ct_bind_data() setting column size for 1 = 
4
2000-02-29 10:12:01.058295 inside _ct_get_server_type()
2000-02-29 10:12:01.058358 inside _ct_bind_data() converting column 1 from 
type 56 to type 47
2000-02-29 10:12:01.058440 inside _ct_get_server_type()
2000-02-29 10:12:01.058509 converting string dlen = 12 strlen = 47 string = 0
2000-02-29 10:12:01.058680 inside _ct_bind_data() setting column size for 2 = 
25
2000-02-29 10:12:01.058758 inside _ct_get_server_type()
2000-02-29 10:12:01.058823 inside _ct_bind_data() converting column 2 from 
type 39 to type 47
2000-02-29 10:12:01.058904 inside _ct_get_server_type()
2000-02-29 10:12:01.058974 converting string dlen = 26 strlen = 47 string = 
2000-02-29 10:12:01.059051 inside _ct_bind_data() setting column size for 3 = 
2
2000-02-29 10:12:01.059164 inside _ct_get_server_type()
2000-02-29 10:12:01.059231 inside _ct_bind_data() converting column 3 from 
type 52 to type 47
2000-02-29 10:12:01.059311 inside _ct_get_server_type()
2000-02-29 10:12:01.059382 converting string dlen = 7 strlen = 47 string = 0
2000-02-29 10:12:01.059460 inside _ct_bind_data() setting column size for 4 = 
35
2000-02-29 10:12:01.059537 inside _ct_get_server_type()
2000-02-29 10:12:01.059602 inside _ct_bind_data() converting column 4 from 
type 39 to type 47
2000-02-29 10:12:01.059682 inside _ct_get_server_type()
2000-02-29 10:12:01.059749 converting string dlen = 36 strlen = 47 string = 
2000-02-29 10:12:01.059832 inside ct_results()
2000-02-29 10:12:01.059961 inside ct_cmd_drop()
2000-02-29 10:12:01.060409 inside ct_con_props() action = CS_GET property = 26
2000-02-29 10:12:01.060586 inside ct_con_drop()
2000-02-29 10:12:01.060683 inside ct_exit()