FreeTDS Development Group

[James K. Lowden <jklowden AT speakeasy.org>]

On Tue, 18 Jun 2002 10:11:06 -0400, "alexis AT mobiliant.om"
<alexis AT mobiliant.om> wrote:
> I'm using freetds with sql-relay (www.firstworks.com), but I have a
> problem. I'm connecting to a MSSQL-Server and that far it works just
> fine. However, when a connection dies or if the MSSQL-server dies I get
> the errors:
> Unknown marker: 0!!
> TDS: Write failed in tds_write_packet
> Error: 32 (Broken pipe)
> 
> And then sql-relay starts eating cpu. Is there anyway around this
> problem? I've tried todays 'daily snapshot', but that didn't help.

Alexis, 

The thing to do is find out what's wrong and fix it. ;)

The question is, Is FreeTDS failing to report a broken condition back to
sql-relay, and relay is spinning, or is sql-relay failing to pay attention
to FreeTDS's perfectly fine error code?  Or do we not notice our own
pipe's brokenness and spin within?  

Here's a suggestion:

1.      Compile with debug symbols, both projects.  
2.      Let'er rip.
3.      When it happens, kill it.
4.      gdb the core dump.
5.      Send us the backtrace.  

I'd look at the bt.  It would at least make it easier to locate the
problem; it might even tell us which mailing list it belongs on. :)

Regards, 

--jkl