Re: query log corrupted-looking entries

From: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: query log corrupted-looking entries
Date: 2007-06-01 21:09:04
Message-ID: 8C5B026B51B6854CBE88121DBF097A86CDD9A4@ehost010-33.exch010.intermedia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 5/29/2007 10:19 AM, Ed L. wrote:
> On Wednesday 23 May 2007 1:04 pm, George Pavlov wrote:
> 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...

Do you have any tricks for dealing with the problem from a query
analyzer perspective? That is, if you use something like pgfouine do you
have any quick and easy way to remove those lines (and the affected
lines around them)? Or someway to "fix" the corrupted lines? I'd say
that lately ~40% of my daily query logs are suffering from this problem
making query analysis very hard.

George

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Wittig 2007-06-01 21:14:44 Re: warm standby server stops doingcheckpointsafterawhile
Previous Message Ian Harding 2007-06-01 21:08:58 Re: collision in serial numbers after INSERT?

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-06-01 21:15:26 syslogger line-end processing infelicity
Previous Message Tom Lane 2007-06-01 21:08:14 Re: Constraint exclusion oddity with composite index