Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

centos6 freetds problems 20004 Read from the server failed

92 views
Skip to first unread message

sembsl

unread,
Nov 22, 2011, 9:37:39 AM11/22/11
to
I wonder if anyone can help - I have installed:

rpm -i http://download.fedora.redhat.com/pub/epel/6/x86_64/freetds-0.82-6.el6.x86_64.rpm
rpm -i --force http://pkgs.repoforge.org/perl-DBD-Sybase-1.10-1.el6.rf.x86_64.rpm

freetds.conf has:

host = 192.168.XXX.X
port = 1433
tds version = 7.0


The connection works for small queries. however when i start a backup,
it works for about 1minute then bombs out:

Msg 20004, Level 9, State -1, Server OpenClient, Line -1
Read from the server failed

The freetds log has this error:

0140 20 00 31 00 34 00 3a 00-33 00 34 00 3a 00 31 00 | .1.4.:.
3.4.:.1.|
0150 38 00 20 00 47 00 4d 00-54 00 20 00 32 00 30 00 |8. .G.M. T. .
2.0.|
0160 31 00 31 00 27 00 0a 00- |1.1.'...|

token.c:495:tds_process_tokens(0x258c320, 0x7ffff94837f8, (nil),
0x6914)
util.c:162:Changed query state from PENDING to READING
util.c:334:tdserror(0x258b150, 0x258c320, 20004, 104)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
util.c:162:Changed query state from READING to DEAD
token.c:510:processing result tokens. marker is 0()
token.c:108:tds_process_default_tokens() marker is 0()
token.c:111:leaving tds_process_default_tokens() connection dead
util.c:110:logic error: cannot change query state from DEAD to PENDING

jered...@gmail.com

unread,
Apr 9, 2012, 4:23:18 PM4/9/12
to
Did u ever ge5t this figured out?
0 new messages