Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5C85F9FA646 for ; Mon, 16 Oct 2006 13:42:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 69966-05 for ; Mon, 16 Oct 2006 13:42:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 1B38D9FA2C7 for ; Mon, 16 Oct 2006 13:42:07 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k9GGg07a022424; Mon, 16 Oct 2006 12:42:01 -0400 (EDT) To: "George Pavlov" cc: pgsql-general@postgresql.org Subject: Re: query log corrupted-looking entries In-reply-to: <8C5B026B51B6854CBE88121DBF097A864DF42A@ehost010-33.exch010.intermedia.net> References: <8C5B026B51B6854CBE88121DBF097A864DF42A@ehost010-33.exch010.intermedia.net> Comments: In-reply-to "George Pavlov" message dated "Wed, 11 Oct 2006 16:15:53 -0700" Date: Mon, 16 Oct 2006 12:42:00 -0400 Message-ID: <22423.1161016920@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.088 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/731 X-Sequence-Number: 102257 "George Pavlov" writes: > And yes, redirect_stderr = on. I have no definitive way of reproducing > it, just a vague one: "hit the server with lots of queries". Hmm. If the messages are less than PIPE_BUF bytes long (4096 bytes on Linux) then the writes are supposed to be atomic. Can you check whether the interspersal cases involve messages whose total length (all lines) exceeds 4K? regards, tom lane