From: | "Gavin M(dot) Roy" <gmr(at)myyearbook(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 8.3.0 Core with concurrent vacuum fulls |
Date: | 2008-03-05 15:39:37 |
Message-ID: | af1bce590803050739u48aa37d5k9c9c0381886dd305@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Mar 5, 2008 at 10:31 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Gavin M. Roy" <gmr(at)myyearbook(dot)com> writes:
> > 2008-03-04 05:45:47 EST [6698]: [1-1] LOG: process 6698 still waiting
> for
> > AccessShareLock on relation 1247 of database 16385 after 1001.519 ms
> > 2008-03-04 05:45:47 EST [6698]: [2-1] STATEMENT: VACUUM FULL
> > autograph.autograph_creators
> > 2008-03-04 05:46:28 EST [6730]: [1-1] LOG: process 6730 still waiting
> for
> > AccessShareLock on relation 1247 of database 16385 after 1000.887 ms
> > 2008-03-04 05:46:28 EST [6730]: [2-1] STATEMENT: VACUUM FULL
> > lunchmoney.totals
> > 2008-03-04 05:47:55 EST [3809]: [18-1] LOG: server process (PID 6742)
> was
> > terminated by signal 6: Aborted
> > 2008-03-04 05:47:55 EST [3809]: [19-1] LOG: terminating any other
> active
> > server processes
> > 2008-03-04 05:47:55 EST [6741]: [12-1] WARNING: terminating connection
> > because of crash of another server process
>
> How annoying ... the PANIC message doesn't seem to have reached the log.
> elog.c is careful to fflush(stderr) before abort(), so that isn't
> supposed to happen. But it looks like you are using syslog for logging
> (correct?) so maybe this is a problem with the syslog implementation
> you're using. What's the platform exactly?
>
> I wonder if it'd be reasonable to put a closelog() call just before
> the abort() ...
>
> regards, tom lane
I'm using stderr, emulated to look like syslog for pgfouine.
log_destination = 'stderr'
logging_collector = on # Enable capturing of stderr and
csvlog
log_directory = '/var/log/postgres/' # Directory where log files are
written
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern.
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin M. Roy | 2008-03-05 15:40:39 | Re: 8.3.0 Core with concurrent vacuum fulls |
Previous Message | Tom Lane | 2008-03-05 15:31:05 | Re: 8.3.0 Core with concurrent vacuum fulls |