From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: Fix for erroneous warning on Shutdown |
Date: | 2004-06-15 16:34:47 |
Message-ID: | 1087317286.12015.26.camel@stromboli |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 pgsql-patches |
On Fri, 2004-06-11 at 19:25, Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> > Minor patch to correct erroneous warning in cvs tip, believed to be a
> > very minor regression.
>
> This patch is wrong; it effectively disables the warning altogether.
>
> > When a shutdown was requested within CHECKPOINT_SECONDS of a checkpoint,
> > the shutdown code in the bgwriter (which has does checkpointing) would
> > issue the erroneous message:
>
> I don't think so ... the shutdown path doesn't go through this code.
> Could you take another look at the cause of what you saw?
Hmmm...perhaps I should submit this as a *low priority* bug then, rather
than just a patch?
As of now, (i.e. even including the new bgwriter shutdown) if you:
1. start postmaster
2. do some work that writes xlog
3. shutdown within some few seconds of startup
you get a WARNING suggesting you increase CHECKPOINT_SEGMENTS, which is
clearly erroneous since no checkpoint has taken place since startup.
Not exactly a common circumstance, I grant you, but it does seem to be a
regression nonetheless. My thinking was that the circumstance was not
limited to this edge case, but actually any shutdown within 30s of a
checkpoint, but the latter is just speculation.
Only reason I spotted it is I've been doing a lot of startup/shutdown
work recently...
Best Regards, Simon Riggs
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-06-15 18:33:21 | Re: Fix for erroneous warning on Shutdown |
Previous Message | Thomas Kellerer | 2004-06-14 20:50:39 | Re: pg_ctl vs. Windows locking |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2004-06-15 16:56:05 | Re: PITR Archival |
Previous Message | Dave Page | 2004-06-15 16:07:16 | Re: stderr & win32 admin check |