Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group