Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem when the SQLExecute failed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "V.Kukushkin" <kvd AT internet2.ru>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem when the SQLExecute failed
  • Date: Thu, 2 Dec 2004 11:24:30 +0300

Hi,
I've looked at 0.63 and 0.64 for this patch in write.c (ok, no goodwrite()
there, but around)
and not found it.
Has been this patch included in 0.63 or 0.64 ?
---
Best regards,
Vladimir

----- Original Message -----
From: ZIGLIO, Frediano, VF-IT
To: FreeTDS Development Group
Sent: Wednesday, December 01, 2004 12:22 PM
Subject: RE: [freetds] Problem when the SQLExecute failed

[skipped]
>
> at this point the program freeze and all threads freeze totally
>
> any ideas ?
>

It seems a problem related to state of socket. In write.c we have a code
like

if (retval <= 0) {
tdsdump_log(TDS_DBG_NETWORK, "TDS: Write failed
in tds_write_packet\nError: %d (%s)\n", sock_errno,
strerror(sock_errno));
tds_client_msg(tds->tds_ctx, tds, 20006, 9, 0,
0, "Write to SQL Server failed.");
tds->in_pos = 0;
tds->in_len = 0;
tds_close_socket(tds);
return TDS_FAIL;
}

Change in

if (retval <= 0) {
tdsdump_log(TDS_DBG_NETWORK, "TDS: Write failed
in tds_write_packet\nError: %d (%s)\n", sock_errno,
strerror(sock_errno));
tds_client_msg(tds->tds_ctx, tds, 20006, 9, 0,
0, "Write to SQL Server failed.");
tds->state = TDS_DEAD;
tds->in_pos = 0;
tds->in_len = 0;
tds_close_socket(tds);
return TDS_FAIL;
}

this should solve your problem. I didn't try to reproduce it. 8 minutes
should be the time to detect disconnection (by keep-alive flag). I don't
understand why you are using 0.62.1 instead of 0.62.4. We closed 0.62
trunk, we are 3 developer so it's very hard to update 3 versions (0.62,
0.63 and 0.64). Give a try to 0.63. If you don't like the idea of using
a too young version use 0.62 version from CVS (BRANCH0_62) it contains
0.62.4 with sligth fixes. If you want I can send (privately) a post
0.62.4 patch.

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page