FreeTDS Development Group

["V.Kukushkin" <kvd AT internet2.ru>]

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