Skip to Content.
Sympa Menu

freetds - Session is hanging

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Greg Connaughton <greg.connaughton AT corp.usa.net>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Session is hanging
  • Date: Mon, 03 Dec 2001 16:37:34 -0700

I am trying to get my application to connect to a SQL Server database
and it just goes out and hangs. My connection works fine from isql, and
from what I can see of the dump file, it looks like it behaving
properly. Anybody know what might be making my application hang? I am
trying to use brio server with this on Solaris 2.8. The TDSDUMP file
looks like this for the last stmt executed:

Sending packet @ 2001-12-03 23:34:41
0000 01 01 00 3b 00 00 00 00 53 45 4c 45 43 54 20 2a |...;....SELECT
*|
0010 20 46 52 4f 4d 20 74 64 73 5f 74 79 70 65 69 6e | FROM
tds_typein|
0020 66 6f 20 57 48 45 52 45 20 53 51 4c 5f 44 41 54 |fo WHERE
SQL_DAT|
0030 41 5f 54 59 50 45 20 3d 20 2d 32 |A_TYPE = -2|


2001-12-03 23:34:41 processing result tokens. marker is a0
2001-12-03 23:34:41 processing result tokens. marker is a1
2001-12-03 23:34:41 inside tds_process_default_tokens() marker is a1
2001-12-03 23:34:41 processing result tokens. marker is d1
2001-12-03 23:34:41 processing row tokens. marker is d1
2001-12-03 23:34:41 setting column 0 to NULL
2001-12-03 23:34:41 setting column 1 to NULL
2001-12-03 23:34:41 setting column 2 to NULL
2001-12-03 23:34:41 setting column 3 to NULL
2001-12-03 23:34:41 setting column 4 to NULL
2001-12-03 23:34:41 setting column 5 to NULL
2001-12-03 23:34:41 setting column 6 to NULL
2001-12-03 23:34:41 setting column 7 to NULL
2001-12-03 23:34:41 setting column 8 to NULL
2001-12-03 23:34:41 setting column 9 to NULL
2001-12-03 23:34:41 setting column 10 to NULL
2001-12-03 23:34:41 setting column 11 to NULL
2001-12-03 23:34:41 setting column 12 to NULL
2001-12-03 23:34:41 setting column 13 to NULL
2001-12-03 23:34:41 setting column 14 to NULL
2001-12-03 23:34:41 setting column 15 to NULL
2001-12-03 23:34:41 setting column 16 to NULL
2001-12-03 23:34:41 setting column 17 to NULL
2001-12-03 23:34:41 setting column 18 to NULL
2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string =
BINARY
2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string = 0x
2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string =
2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string =
2001-12-03 23:34:41 processing row tokens. marker is fd

I have attached the complete log if it helps.

Thanks,

--
Greg Connaughton Oracle DBA ***********
Ph: 303.865.1243 USA.Net * * *
Pager: 303.528.6170 7900 E.Union Ave * * *
Fax: 303.865.1205 Suite 800 * * *
Greg.Connaughton AT corp.usa.net Denver, CO 80237-2735 ***********2001-12-03 23:34:41 Connecting addr 204.68.29.195 port 1433
Sending packet @ 2001-12-03 23:34:41
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 6f 64 62 63 74 65 73 74 00 |.......odbctest.|
0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
0040 00 00 00 00 00 08 6f 64 62 63 74 65 73 74 00 00 |......odbctest..|
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 |.....37876......|
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 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00b0 00 00 00 32 30 34 2e 36 38 2e 32 39 2e 31 39 35 |...204.68.29.195|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00d0 00 0d 6f 64 62 63 74 65 73 74 00 00 00 00 00 00 |..odbctest......|
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 00 00 00 00 00 00 00 00 00 00 |................|
01e0 00 00 00 00 00 00 0c 10 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 @ 2001-12-03 23:34:41
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 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 30 00 00 |.............0..|
0040 00 00 00 01 00 00 00 00 00 00 00 00 |............|


2001-12-03 23:34:41 inside tds_process_login_tokens()
2001-12-03 23:34:41 inside tds_process_default_tokens() marker is e3
2001-12-03 23:34:41 inside tds_process_default_tokens() marker is ab
2001-12-03 23:34:41 Msg 5701, Level 0, State 2, Server ESS-ORL-DB1, Line 0
Changed database context to 'Onyx'.
2001-12-03 23:34:41 inside tds_process_default_tokens() marker is e3
2001-12-03 23:34:41 inside tds_process_default_tokens() marker is e3
2001-12-03 23:34:41 inside tds_process_default_tokens() marker is fd
2001-12-03 23:34:41 leaving tds_process_login_tokens() returning 1
Sending packet @ 2001-12-03 23:34:41
0000 01 01 00 10 00 00 00 00 75 73 65 20 6f 6e 79 78 |........use onyx|


2001-12-03 23:34:41 inside tds_process_default_tokens() marker is e3
2001-12-03 23:34:41 inside tds_process_default_tokens() marker is ab
2001-12-03 23:34:41 Msg 5701, Level 0, State 1, Server ESS-ORL-DB1, Line 1
Changed database context to 'Onyx'.
2001-12-03 23:34:41 inside tds_process_default_tokens() marker is fd
Sending packet @ 2001-12-03 23:34:41
0000 01 01 00 3b 00 00 00 00 53 45 4c 45 43 54 20 2a |...;....SELECT *|
0010 20 46 52 4f 4d 20 74 64 73 5f 74 79 70 65 69 6e | FROM tds_typein|
0020 66 6f 20 57 48 45 52 45 20 53 51 4c 5f 44 41 54 |fo WHERE SQL_DAT|
0030 41 5f 54 59 50 45 20 3d 20 2d 32 |A_TYPE = -2|


2001-12-03 23:34:41 processing result tokens. marker is a0
2001-12-03 23:34:41 processing result tokens. marker is a1
2001-12-03 23:34:41 inside tds_process_default_tokens() marker is a1
2001-12-03 23:34:41 processing result tokens. marker is d1
2001-12-03 23:34:41 processing row tokens. marker is d1
2001-12-03 23:34:41 setting column 0 to NULL
2001-12-03 23:34:41 setting column 1 to NULL
2001-12-03 23:34:41 setting column 2 to NULL
2001-12-03 23:34:41 setting column 3 to NULL
2001-12-03 23:34:41 setting column 4 to NULL
2001-12-03 23:34:41 setting column 5 to NULL
2001-12-03 23:34:41 setting column 6 to NULL
2001-12-03 23:34:41 setting column 7 to NULL
2001-12-03 23:34:41 setting column 8 to NULL
2001-12-03 23:34:41 setting column 9 to NULL
2001-12-03 23:34:41 setting column 10 to NULL
2001-12-03 23:34:41 setting column 11 to NULL
2001-12-03 23:34:41 setting column 12 to NULL
2001-12-03 23:34:41 setting column 13 to NULL
2001-12-03 23:34:41 setting column 14 to NULL
2001-12-03 23:34:41 setting column 15 to NULL
2001-12-03 23:34:41 setting column 16 to NULL
2001-12-03 23:34:41 setting column 17 to NULL
2001-12-03 23:34:41 setting column 18 to NULL
2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string = BINARY
2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string = 0x
2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string =
2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string =
2001-12-03 23:34:41 processing row tokens. marker is fd



Archive powered by MHonArc 2.6.24.

Top of Page