agora inbox for pgsql-www@postgresql.org
help / color / mirror / Atom feedarchives frequently do not load today's messages
5+ messages / 2 participants
[nested] [flat]
* archives frequently do not load today's messages
@ 2026-09-02 19:47 Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Nathan Bossart @ 2026-09-02 19:47 UTC (permalink / raw)
To: pgsql-www
I've been noticing $subject for a while. For example, navigating to
today's messages for pgsql-hackers@ [0] intermittently shows me nothing for
long stretches of time. My suspicion is that this has something to do with
the increased cache time patch committed back in March [1].
[0] https://www.postgresql.org/list/pgsql-hackers/since/202609020000/
[1] https://git.postgresql.org/gitweb/?p=pgarchives.git;a=commitdiff;h=c151a8
--
nathan
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: archives frequently do not load today's messages
@ 2026-09-02 23:07 Magnus Hagander <magnus@hagander.net>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Magnus Hagander @ 2026-09-02 23:07 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; +Cc: pgsql-www
On Wed, 2 Sept 2026 at 21:47, Nathan Bossart <nathandbossart@gmail.com>
wrote:
> I've been noticing $subject for a while. For example, navigating to
> today's messages for pgsql-hackers@ [0] intermittently shows me nothing
> for
> long stretches of time. My suspicion is that this has something to do with
> the increased cache time patch committed back in March [1].
>
> [0] https://www.postgresql.org/list/pgsql-hackers/since/202609020000/
> [1]
> https://git.postgresql.org/gitweb/?p=pgarchives.git;a=commitdiff;h=c151a8
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.
I've pushed a fix for this now, I think (
https://git.postgresql.org/gitweb/?p=pgarchives.git;a=commit;h=51485f825d7012fc5701900c2dfd562609fb1...
).
It will take up to 12 hours for all the incorrectly taggred pages to expire
from the cache.
Thanks for the report!
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: archives frequently do not load today's messages
@ 2026-09-03 13:10 Nathan Bossart <nathandbossart@gmail.com>
parent: Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 5+ messages in thread
From: Nathan Bossart @ 2026-09-03 13:10 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: 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=51485f825d7012fc5701900c2dfd562609fb1...
> ).
>
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: archives frequently do not load today's messages
@ 2026-09-11 13:16 Nathan Bossart <nathandbossart@gmail.com>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Nathan Bossart @ 2026-09-11 13:16 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-www
On Thu, Sep 03, 2026 at 08:10:16AM -0500, Nathan Bossart wrote:
> On Thu, Sep 03, 2026 at 01:07:31AM +0200, Magnus Hagander wrote:
>> I've pushed a fix for this now, I think (
>> https://git.postgresql.org/gitweb/?p=pgarchives.git;a=commit;h=51485f825d7012fc5701900c2dfd562609fb1...
>> ).
>>
>> 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!
Just following up on this one to say that the fix appears to be working. I
haven't run into the issue for some time now. Thanks again.
--
nathan
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: archives frequently do not load today's messages
@ 2026-09-11 15:59 Magnus Hagander <magnus@hagander.net>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Magnus Hagander @ 2026-09-11 15:59 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; +Cc: pgsql-www
On Fri, 11 Sept 2026 at 15:16, Nathan Bossart <nathandbossart@gmail.com>
wrote:
> On Thu, Sep 03, 2026 at 08:10:16AM -0500, Nathan Bossart wrote:
> > On Thu, Sep 03, 2026 at 01:07:31AM +0200, Magnus Hagander wrote:
> >> I've pushed a fix for this now, I think (
> >>
> https://git.postgresql.org/gitweb/?p=pgarchives.git;a=commit;h=51485f825d7012fc5701900c2dfd562609fb1...
> >> ).
> >>
> >> 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!
>
> Just following up on this one to say that the fix appears to be working. I
> haven't run into the issue for some time now. Thanks again.
>
>
Thanks for confirming!
//Magnus
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2026-09-11 15:59 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-09-02 19:47 archives frequently do not load today's messages Nathan Bossart <nathandbossart@gmail.com>
2026-09-02 23:07 ` Magnus Hagander <magnus@hagander.net>
2026-09-03 13:10 ` Nathan Bossart <nathandbossart@gmail.com>
2026-09-11 13:16 ` Nathan Bossart <nathandbossart@gmail.com>
2026-09-11 15:59 ` Magnus Hagander <magnus@hagander.net>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox