Re: archives frequently do not load today's messages

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: pgsql-www(at)postgresql(dot)org
Subject: Re: archives frequently do not load today's messages
Date: 2026-09-03 13:10:16
Message-ID: aplxuPRx6dSRgVKN@nathan
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-www

On Thu, Sep 03, 2026 at 01:07:31AM +0200, Magnus Hagander wrote:
> You're on the right track, but that's not the actual bug. But the
> increasing of the cache time has exposed a bug that has been there all
> along.
>
> The bug is that *someone* hits the URL, in this case for Sep 2, when there
> are zero messages from Sep 2 yet. When that happens the empty page is
> cached but it's cached *without* the key that say it's in September. So
> when the first Sep 2 message actually arrives, it failes to to purge it
> because it purges everything in September only. Not in NULL.

Got it.

> I've pushed a fix for this now, I think (
> https://git.postgresql.org/gitweb/?p=pgarchives.git;a=commit;h=51485f825d7012fc5701900c2dfd562609fb1a06
> ).
>
> It will take up to 12 hours for all the incorrectly taggred pages to expire
> from the cache.
>
> Thanks for the report!

Thanks for fixing!

--
nathan

In response to

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Michael Verheij 2026-09-05 10:37:01 Enhancement request for patch release announcements and READMEs
Previous Message Étienne BERSAC 2026-09-03 08:24:41 Re: Wiki editor request: Bersace03