From: Ed L. <pgsql@bluepolka.net>
To: pgsql-hackers@postgresql.org
Cc: George Pavlov <gpavlov@mynewplace.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Postgres General <pgsql-general@postgresql.org>
Subject: Re: query log corrupted-looking entries
Date: Tue, 29 May 2007 11:19:55 -0600
Message-ID: <200705291119.55567.pgsql@bluepolka.net> (raw)
In-Reply-To: <8C5B026B51B6854CBE88121DBF097A86C39FC2@ehost010-33.exch010.intermedia.net>
References: <29860.1161202644@sss.pgh.pa.us>
<8C5B026B51B6854CBE88121DBF097A86C39FC2@ehost010-33.exch010.intermedia.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: pgsql@bluepolka.net, gpavlov@mynewplace.com, tgl@sss.pgh.pa.us, pgsql-general@postgresql.org
Subject: Re: query log corrupted-looking entries
In-Reply-To: <200705291119.55567.pgsql@bluepolka.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox