Skip to Content.
Sympa Menu

freetds - [freetds] a REALLY wierd one

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] a REALLY wierd one
  • Date: Wed, 26 Mar 2003 17:52:21 -0000

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)!!



Archive powered by MHonArc 2.6.24.

Top of Page