FreeTDS Bad token from the server (SQL Server)

Question

Today we had a lot more activity than normal between our Ruby on Rails application and our remote legacy SQL Server 2005 database, and we started getting the error below intermittently. What is is? How can I prevent it (besides avoiding the situation, which we're working on)?

Error Message:

ActiveRecord::StatementInvalid: DBI::DatabaseError: 08S01 (20020) [unixODBC][FreeTDS][SQL Server] Bad token from the server: Datastream processing out of sync: SELECT * FROM [marketing] WHERE ([marketing].[contact_id] = 832085)

score 1 · Answer 1 · edited Sep 05 '20 at 15:28

1

You need to use some sort of connection pooling.

Windows itself (including Windows Server X) will only allow a certain number of socket connections to be created in a given time frame, even if you close them. All others will fail after that.

A connection pool will keep the same sockets open, avoiding the problem. Also, new connections are real slow.

edited Sep 05 '20 at 15:28

Peter Mortensen

30,738
21
105
131

answered Mar 21 '11 at 16:24

DaveTheC

11
1

What is *"Windows Server X"*? – Peter Mortensen Sep 05 '20 at 15:28

score 0 · Accepted Answer · edited Sep 05 '20 at 15:25

0

This Microsoft article says:

Often caused by an abruptly terminated network connection, which causes a damaged Tabular Data Stream token to be read by the client.

Was the server network bound? I have no experience with SQL Server, but does it have a limit on the number of connections you can make?

edited Sep 05 '20 at 15:25

Peter Mortensen

30,738
21
105
131

answered Nov 13 '09 at 02:47

BJ Clark

3,215
2
17
16

score -1 · Answer 3 · edited Jul 28 '16 at 02:55

-1

Add the following to your script; the first statement you run:

SET NO_BROWSETABLE OFF

edited Jul 28 '16 at 02:55

Ryan K

3,985
4
39
42

answered Jul 27 '16 at 15:18

user3379574

1

FreeTDS Bad token from the server (SQL Server)

Error Message:

3 Answers3