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
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 |
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 |