Re: query log corrupted-looking entries

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: "George Pavlov" <gpavlov(at)mynewplace(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: query log corrupted-looking entries
Date: 2007-05-29 17:19:55
Message-ID: 200705291119.55567.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrei Kovalevski 2007-05-29 17:34:46 Re: problems with SELECT query results
Previous Message Richard Huxton 2007-05-29 17:01:28 Re: problems with SELECT query results

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-05-29 17:34:23 Philadelphia area PostgreSQL party
Previous Message Bruce Momjian 2007-05-29 17:19:07 Re: TOAST usage setting