Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 7FD589FBB62;
	Tue, 29 May 2007 14:20:10 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 32961-05; Tue, 29 May 2007 14:20:06 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [63.240.77.83])
	by postgresql.org (Postfix) with ESMTP id E0E909FB961;
	Tue, 29 May 2007 14:20:05 -0300 (ADT)
Received: from [10.1.2.2] (c-75-71-235-22.hsd1.co.comcast.net[75.71.235.22])
	by comcast.net (sccrmhc13) with ESMTP
	id <2007052917200301300j1oh3e>; Tue, 29 May 2007 17:20:04 +0000
From: "Ed L." <pgsql@bluepolka.net>
To: pgsql-hackers@postgresql.org
Subject: Re: query log corrupted-looking entries
Date: Tue, 29 May 2007 11:19:55 -0600
User-Agent: KMail/1.9.5
Cc: "George Pavlov" <gpavlov@mynewplace.com>, "Tom Lane" <tgl@sss.pgh.pa.us>,
	"Postgres General" <pgsql-general@postgresql.org>
References: <29860.1161202644@sss.pgh.pa.us>
	<8C5B026B51B6854CBE88121DBF097A86C39FC2@ehost010-33.exch010.intermedia.net>
In-Reply-To: 
 <8C5B026B51B6854CBE88121DBF097A86C39FC2@ehost010-33.exch010.intermedia.net>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200705291119.55567.pgsql@bluepolka.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200705/1427
X-Sequence-Number: 114620

On Wednesday 23 May 2007 1:04 pm, George Pavlov wrote:
> Hoping to resurrect this thread. I am seeing more and more of
> this as the database gets more usage and it really messes up
> query log analysis.
>
>
> A quick summary: When I posted this was getting corrupted
> query log entries. I still am. They look like this (the
> problem line + one line before and after):
>
> 2007-05-15 14:24:52 PDT [3859]: [968-1] LOG:  duration: 0.071
> ms 2007-05-15 14:24:52 PDT [3859]: [969-1] LOG: 
> statement2007-05-15 14:24:52 PDT [3885]: [208-1] LOG: 
> duration: 11.800 ms

FWIW, I've also been seeing this sort of query log corruption for 
as long as I can remember, 7.1 through 8.2, HPUX (parisc, ia64), 
Linux on intel, amd...

Ed