[freetds] Weird tsql behaviour
freddy77 at gmail.com
Sat Jan 30 13:57:19 EST 2016
2016-01-30 18:21 GMT+00:00 James K. Lowden <james.k.lowden at icloud.com>:
> On Fri, 29 Jan 2016 20:54:44 +0000
> "Thomas, Christopher (LLU)" <cwthomas at llu.edu> wrote:
>> Once I connected to the database server using tsql, the line numbers
>> started to go up and up, automatically. About one digit per second.
> Those "line numbers" are a counter that appears while a connection
> request is pending. It disappears when the connection succeeds. And,
> yes, they should be really, really close to 1 second apart! ;-)
> Under the hood, libtds connects to the server using nonblocking I/O.
> connect(2) usually returns with EINPROGRESS or similar, and the library
> uses poll(2) to wait for the connection to complete. You can see
> evidence of that in a typical TDSDUMP log.
> The above information should be in the man page, but isn't. Sorry
> about that, Chief.
So looks like your server is down. Or firewall/network problems. Or
sql server is not accepting new connections. If the physical server is
up but sql server is down you should see a fast reply with connection
More information about the FreeTDS