FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

All,

I've had reported a very wierd issue with FreeTDS. I am very puzzled, and I
must confess a bit worried too....


One of our groups is converting some shell scripts which access the
database.
Previously these scripts were talking to a sybase database, and fired off
"isql" sessions to retreive data from the databases.
We are changing these scripts to use sqsh instead of isql. sqsh has been
linked to FreeTDS (pretty much latest snapshot)
They are still accessing Sybase databases however, using TDS 5.0

The shell script rapidly spawns many sqsh commands, although these are
initiated serially.

Occasionally one of the spawned sqsh commands fails with a strange error,
although on other occasions it will work fine.

I managed to capture TDSDUMP output for some of the failed sessions and I do
not understand what is going on.

Here is an example.

 <<error1.txt>> 
As you can see, I get a strange error complaing about the language name in
the login record.
I have compared the login packet sent in this failed session to a successful
login packet, and the two are identical.
I'm puzzled.

Here's another error. This time we get a strange packet header back after
the login record is sent....

 <<error2.txt>> 

Other examples seem to show packet headers getting jumbled and mixed up with
TDS packets.

Does anyone have ANY ideas what might be causing this ?

regards,


¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤

Bill Thompson
Securities Services Division
Merrill Lynch Europe

For very important information relating to this e-mail please click on this
link:  http://www.ml.com/legal_info.htm


Sending packet @ 2003-03-26 11:14:38.130768
0000  02 00 02 00 00 00 00 00  6c 67 68 76 70 72 6f 63   |........ lghvproc|
0010  34 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |4....... ........|
0020  00 00 00 00 00 00 09 xx  xx xx xx xx xx xx xx xx   |.......x xxxxxxxx|
0030  xx 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |x....... ........|
0040  00 00 00 00 00 0a xx xx  xx xx xx xx xx xx 00 00   |......xx xxxxxx..|
0050  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0060  00 00 00 00 08 33 37 38  37 36 00 00 00 00 00 00   |.....378 76......|
0070  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0080  00 00 00 05 02 00 06 04  08 01 00 00 00 00 00 02   |........ ........|
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 4c 44 4e 47 43  44 32 5f 44 33 00 00 00   |...LDNGC D2_D3...|
00c0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
00d0  00 0a xx xx xx xx xx xx  xx xx 00 00 00 00 00 00   |..xxxxxx xx......|
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 08 04 02 00 00 43 54  2d 4c 69 62 72 61 72 79   |......CT -Library|
01e0  0a 00 00 00 00 00 0c 10  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...... ........|


Sending packet @ 2003-03-26 11:14:38.135182
0000  02 01 00 4c 00 00 00 00  00 00 00 00 00 00 0a 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               |........ ....|


2003-03-26 11:14:38.137624 inside tds_process_login_tokens()
Received header @ 2003-03-26 11:14:38.140052
0000  04 01 01 a8 00 00 00 00                            |........|


Received packet @ 2003-03-26 11:14:38.140687
0000  aa 00 d9 00 00 0f b1 01  10 00 c3 4e 65 69 74 68   |........ ...Neith|
0010  65 72 20 6c 61 6e 67 75  61 67 65 20 6e 61 6d 65   |er langu age name|
0020  20 69 6e 20 6c 6f 67 69  6e 20 72 65 63 6f 72 64   | in logi n record|
0030  20 27 c2 c2 22 54 c5 f9  f9 f9 f9 d9 56 02 52 5e   | '.."T.. ....V.R^|
0040  c6 ff 27 20 6e 6f 72 20  6c 61 6e 67 75 61 67 65   |..' nor  language|
0050  20 6e 61 6d 65 20 69 6e  20 73 79 73 6c 6f 67 69   | name in  syslogi|
0060  6e 73 20 27 3c 4e 55 4c  4c 3e 27 20 69 73 20 61   |ns '<NUL L>' is a|
0070  6e 20 6f 66 66 69 63 69  61 6c 20 6c 61 6e 67 75   |n offici al langu|
0080  61 67 65 20 6e 61 6d 65  20 6f 6e 20 74 68 69 73   |age name  on this|
0090  20 53 51 4c 20 53 65 72  76 65 72 2e 20 20 55 73   | SQL Ser ver.  Us|
00a0  69 6e 67 20 73 65 72 76  65 72 2d 77 69 64 65 20   |ing serv er-wide |
00b0  64 65 66 61 75 6c 74 20  27 75 73 5f 65 6e 67 6c   |default  'us_engl|
00c0  69 73 68 27 20 69 6e 73  74 65 61 64 2e 0a 0a 4c   |ish' ins tead...L|
00d0  44 4e 47 43 44 32 5f 44  33 00 00 01 e3 00 0f 01   |DNGCD2_D 3.......|
00e0  06 6d 61 73 74 65 72 06  6d 61 73 74 65 72 ab 00   |.master. master..|
00f0  3c 00 00 16 45 02 00 00  26 43 68 61 6e 67 65 64   |<...E... &Changed|
0100  20 64 61 74 61 62 61 73  65 20 63 6f 6e 74 65 78   | databas e contex|
0110  74 20 74 6f 20 27 6d 61  73 74 65 72 27 2e 0a 0a   |t to 'ma ster'...|
0120  4c 44 4e 47 43 44 32 5f  44 33 00 00 01 e3 00 0d   |LDNGCD2_ D3......|
0130  02 0a 75 73 5f 65 6e 67  6c 69 73 68 00 ab 00 40   |..us_eng lish...@|
0140  00 00 16 47 01 00 00 2a  43 68 61 6e 67 65 64 20   |...G...* Changed |
0150  6c 61 6e 67 75 61 67 65  20 73 65 74 74 69 6e 67   |language  setting|
0160  20 74 6f 20 27 75 73 5f  65 6e 67 6c 69 73 68 27   | to 'us_ english'|
0170  2e 0a 0a 4c 44 4e 47 43  44 32 5f 44 33 00 00 01   |...LDNGC D2_D3...|
0180  ad 00 14 01 04 02 00 00  0a 73 71 6c 20 73 65 72   |........ .sql ser|
0190  76 65 72 0b 09 02 00 fd  00 02 00 02 00 00 03 2a   |ver..... .......*|
Sending packet @ 2003-03-26 10:40:56.212580
0000  02 00 02 00 00 00 00 00  6c 67 68 76 70 72 6f 63   |........ lghvproc|
0010  34 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |4....... ........|
0020  00 00 00 00 00 00 09 xx  xx xx xx xx xx xx xx xx   |.......x xxxxxxxx|
0030  xx 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |x....... ........|
0040  00 00 00 00 00 0a xx xx  xx xx xx xx xx xx 00 00   |......xx xxxxxx..|
0050  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0060  00 00 00 00 08 33 37 38  37 36 00 00 00 00 00 00   |.....378 76......|
0070  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0080  00 00 00 05 02 00 06 04  08 01 00 00 00 00 00 02   |........ ........|
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 4c 44 4e 47 43  44 32 5f 44 33 00 00 00   |...LDNGC D2_D3...|
00c0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
00d0  00 0a xx xx xx xx xx xx  xx xx 00 00 00 00 00 00   |..xxxxxx xx......|
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 08 04 02 00 00 43 54  2d 4c 69 62 72 61 72 79   |......CT -Library|
01e0  0a 00 00 00 00 00 0c 10  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...... ........|


Sending packet @ 2003-03-26 10:40:56.216613
0000  02 01 00 4c 00 00 00 00  00 00 00 00 00 00 0a 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|........ ....|


2003-03-26 10:40:56.217736 inside tds_process_login_tokens()
Received header @ 2003-03-26 10:40:56.226054
0000  00 00 01 54 00 00 00 00                            |...T....|

Invalid packet header 0
2003-03-26 10:40:56.226659 inside tds_process_default_tokens() marker is 0()
Unknown marker: 0(0)!!