More Broken Pipes!

We have been experiencing the same error ("Write error: Broken Pipe"). We have an ESQL/C program that scans a list of streets in a street table, and generates (inserts) intersection information into another table. About 5 - 10,000 streets are being processed. This program worked fine under Informix 4.0, and also works if the ESQL/C is compiled using Informix 4 and is run against a 5 SE engine. However, if we compile the program using ESQL/C 5 (or whatever the latest version is), and run it against the 5 engine, we get the broken pipe error about halfway through processing the streets. The problem is easily repeatable. Could the engine be running out of memory or something? Maybe it's not freeing file descriptors? We have determined that it is the engine that is dying (and thus breaking the pipe), not our program. We have another batch ESQL/C program that is also behaving oddly. Again, part-way through processing we get errors -408 (invalid msg type) and -468 (which is very bizarre -- something about trying to get user id from system, can't start engine, etc., which is obviously not the real error). Anyone have any ideas? Anyone else seeing these errors? _______________________________________________________________________________ To: informix-list@rmy.emory.edu From: aland@informix.com on Sat, Sep 18, 1993 8:50 AM Subject: Re: pipe error: Broken pipe ???? RFC Header:Received: by cidermill.qed.com with SMTP;18 Sep 1993 08:49:16 -0500 Received: from uunet by qedinc.qed.COM id aa01500; Sat, 18 Sep 93 8:42:50 EDT Received: from rmy.rmy.emory.edu by relay2.UU.NET with SMTP (5.61/UUNET-internet-primary) id AA12032; Fri, 17 Sep 93 20:10:10 -0400 Received: by rmy.rmy.emory.edu (5.65/Emory_rmy.3.4.0) via MAILPROG id AA28695 ; Fri, 17 Sep 93 20:12:56 -0400 Return-Path: ilist@rmy.emory.edu From: Colonel Panic <aland@informix.com> Message-Id: <1993Sep17.040654.9451@informix.com> Subject: Re: pipe error: Broken pipe ???? Date: 17 Sep 93 04:06:54 GMT Reply-To: aland@informix.com Organization: Enterprise Technologies, Informix Software, Inc. Sender: informix-list-owner@rmy.emory.edu To: informix-list@rmy.emory.edu X-Informix-List-To: infmxlist@qed.com X-Informix-List-Id: <news.4361> In article <CD3xs2.9GH@sugar.NeoSoft.COM> astaff@NeoSoft.com (Administaff) writes: >AAAGGGHH!! >Does anyone know the source of (or anything about) >an INFORMIX runtime error that has been troubling me lately?? >this error is: > " pipe write error: Broken pipe ". >This 'pipe' error seems to kill the process that created the error, and >then kills ANY related processes. It's probably happening the other way around -- the process is probably dying first, and *that's* what breaks the pipe. > | Research & Support _| ~_. astaff@NeoSoft.com | > | Kristin Bradley \\, _} ----------- | > | Administaff, Inc. \\( Kingwood, Texas | -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland 'I bought a box of animal crackers. It said, "Do not eat if seal is broken." Sure enough...' -- Bryant Kiely