From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
"George Pavlov" <gpavlov(at)mynewplace(dot)com>
Cc:
"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:36:13
Message-ID:
24195.1180733773@sss.pgh.pa.us (view raw or flat )
Thread:
2006-10-11 04:51:16 from quickcur(at)yahoo(dot)com
2006-10-11 05:31:47 from Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
2006-10-11 06:44:56 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2006-10-11 14:12:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-10-11 23:15:53 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2006-10-16 16:42:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-10-17 20:55:21 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2006-10-17 21:09:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-10-18 12:06:10 from "Magnus Hagander" <mha(at)sollentuna(dot)net>
2006-10-18 17:37:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-10-18 19:00:50 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2006-10-18 20:46:08 from "Magnus Hagander" <mha(at)sollentuna(dot)net>
2006-10-18 20:17:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-10-18 20:22:52 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2006-10-18 20:35:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-05-23 19:04:45 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2007-05-29 17:19:55 from "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
2007-06-01 21:09:04 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2007-06-01 21:20:19 from "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
2007-06-01 21:36:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-06-01 21:55:41 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2007-06-01 22:25:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-06-02 18:32:57 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2007-06-08 00:57:03 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2007-06-08 01:17:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-06-08 01:32:01 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-06-08 16:30:21 from "George Pavlov" <gpavlov(at)mynewplace(dot)com>
2007-06-08 16:34:24 from "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
2007-06-08 17:21:37 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-06-01 22:03:21 from "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
2007-06-01 22:07:25 from "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
2006-10-11 13:59:23 from "Ge Cong" <gecong(at)gmail(dot)com>
2006-10-11 14:25:49 from Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Lists:
pgsql-general pgsql-hackers
"George Pavlov" <gpavlov(at)mynewplace(dot)com> writes:
> On 5/29/2007 10:19 AM, Ed L. 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...
What *exactly* is the logging setup you guys use, and have you tried
alternatives?
As best I can tell, the variant with a downstream syslogger process
ought to be OK for messages up to PIPEBUF bytes long on most standard
Unixen. Of course that's no help if you've got lots of very verbose
queries, but the examples posted so far didn't seem to indicate that.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Magnus HaganderDate: 2007-06-01 21:44:34Subject : Re: syslogger line-end processing infelicityPrevious :From : Tom LaneDate : 2007-06-01 21:33:31Subject : Re: syslogger line-end processing infelicity
pgsql-general by date
Next :From: Tyler DurdenDate: 2007-06-01 21:38:12Subject : Re: Seq ScanPrevious :From : Andrew SullivanDate : 2007-06-01 21:31:20Subject : Re: Slightly OT.
