Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C966C9FB470 for ; Thu, 9 Aug 2007 14:07:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 30905-01-6 for ; Thu, 9 Aug 2007 14:06:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 5B7CA9FBEEA for ; Thu, 9 Aug 2007 14:06:56 -0300 (ADT) Received: (qmail 9939 invoked from network); 9 Aug 2007 13:10:46 -0400 Received: from unknown (HELO D1RPQZB1) (msteben@192.168.1.181) by mail.autorevenue.com with SMTP; 9 Aug 2007 13:10:46 -0400 From: "Mark Steben" To: Subject: Date: Thu, 9 Aug 2007 13:05:16 -0400 Message-ID: <006101c7daa7$757194c0$b501a8c0@D1RPQZB1> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0062_01C7DA85.EE5FF4C0" X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acfap3VjPMZrqtvnShaajlWBNw1i6Q== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2929 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.9 tagged_above=0 required=5 tests=AWL=-0.864, BAYES_50=0.001, HTML_MESSAGE=0.001, MISSING_SUBJECT=1.762 X-Spam-Level: X-Archive-Number: 200708/107 X-Sequence-Number: 26438 This is a multi-part message in MIME format. ------=_NextPart_000_0062_01C7DA85.EE5FF4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Good afternoon, We have a situation where we call our central queue processor from a remote machine using a Perl script. We can process up to 1500 'type 1' records followed by 5 'type 2 records. We process any number successfully Before we get the following error: ERROR: could not send data to client: Broken pipe There is no pattern or record that we see causing this error. When we run this manually on the local machine we do not get this error. It is a Postgres function that is called. I would appreciate any insight into this matter. Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben @autorevenue.com Visit our new website at www.autorevenue.com IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it. Thank you. ------=_NextPart_000_0062_01C7DA85.EE5FF4C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Good afternoon,

 

We have a situation where we call our central queue processor = from a remote machine using a Perl script.

We can process up to 1500 ‘type 1’ records followed = by 5 ‘type 2 records.  We process any number = successfully

Before we get the following error:

  ERROR:  could not send data to client: Broken = pipe

 

There is no pattern or record that we see causing this = error.

 

When we run this manually on the local machine we do not get = this error.  It is a Postgres function that is = called.

 

I would appreciate any insight into this = matter.

 

Thank  you,

 

 

Mark Steben

Senior Database Administrator
@utoRevenue™
A Dominion = Enterprises Company
480 = Pleasant Street
Suite = B200
Lee, MA 01238
413-243-4800 Home Office 
413-243-4809 Corporate Fax

msteben@autorevenue.com

Visit our = new website at
www.autorevenue.com

 

IMPORTANT: The information = contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is = prohibited.  If you have received this e-mail message in error, please reply to = the sender that you have received this e-mail message in error and then = delete it.  Thank you.

 

------=_NextPart_000_0062_01C7DA85.EE5FF4C0--