public inbox for [email protected]
help / color / mirror / Atom feedFrom: Magnus Hagander <[email protected]>
To: Andrej <[email protected]>
Cc: postgresql Forums <[email protected]>
Cc: Adrian Klaver <[email protected]>
Subject: Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15
Date: Tue, 13 May 2025 16:06:52 +0200
Message-ID: <CABUevEyvNqJHmbYKWfgu0EAReYSRr4R7FKHmqU9JCFd6e-0zaQ@mail.gmail.com> (raw)
In-Reply-To: <CACMx3pMEtyVctXXcrC3k5-xub46dx9ZYY4BJ5-skBmCSZogWaA@mail.gmail.com>
References: <CACMx3pNvi=kxdo1L9zjrp-Qhm9QpdtqxyJO2WriosV_sXQPLSQ@mail.gmail.com>
<[email protected]>
<CACMx3pMEtyVctXXcrC3k5-xub46dx9ZYY4BJ5-skBmCSZogWaA@mail.gmail.com>
On Sun, May 11, 2025 at 11:23 PM Andrej <[email protected]> wrote:
> Hi Adrian,
>
> Thank you for the super-quick response!
>
Just a quick check-back on this: has this issue basically resolve itself by
now, or does it still show up?
> > We have two clusters of postgres running, and a couple of machines have
>> > local postgres databases installed via ansible, using ANXS.postgresql.
>> > This has been working fine for years, installing varied versions of
>> > postgres, doing upgrades & migrations without a hitch.
>> >
>> > Since last week we're seeing odd errors which look like they're caused
>> > by repo:
>>
>> May 8th a round of new releases where made:
>>
>>
>> https://www.postgresql.org/about/news/postgresql-175-169-1513-1418-and-1321-released-3072/
>
>
> I see ... but was there anything new in the process of publishing them?
>
>
>>
>> > a) W: An error occurred during the signature verification. The
>> > repository is not updated and the previous index files will be used.
>> GPG
>> > error: http://apt.postgresql.org/pub/repos/apt
>> > <http://apt.postgresql.org/pub/repos/apt; bookworm-pgdg InRelease:
>>
>> Shouldn't the above be?:
>>
>> https://apt.postgresql.org/pub/repos/apt/dists/bookworm-pgdg/InRelease
>
> For browser sessions yes, not inside the sources-file
> `/etc/apt/sources.list.d/apt_postgresql_org_pub_repos_apt.list` ... they're
> structured like this, for example:
>
> cat apt_postgresql_org_pub_repos_apt.list
> deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15
>
>
>> > b) E: Failed to fetch
>> >
>> http://apt.postgresql.org/pub/repos/apt/dists/focal-pgdg/main/binary-amd64/Packages.bz2
>> <
>> http://apt.postgresql.org/pub/repos/apt/dists/focal-pgdg/main/binary-amd64/Packages.bz2;
>> File has unexpected size (350884 != 350996). Mirror sync in progress? [IP:
>> v.w.x.y[1] 3142]
>> > Hashes of expected file:
>> > - Filesize:350996 [weak]
>> > -
>> > SHA256:b946f1cb499ffca9331f532cea373ca5f5d39551fdc156effef354e001a5b865
>> > - SHA1:7aabca4a364ee2b4b891465b02f60d7609b79f8f [weak]
>> > - MD5Sum:738420fcc2da36f7728502eb2809aa43 [weak]
>> > Release file created at: Mon, 28 Apr 2025 16:16:01 +0000
>> > E: Some index files failed to download. They have been ignored, or old
>> > ones used instead.
>>
>
Something weird here. You have bookworm-pgdg in your repository config
file, but the error is from focal-pgdg.. Have you somehow ended up with two
repos configured?
>
>> From here:
>>
>>
>> http://apt.postgresql.org/pub/repos/apt/dists/focal-pgdg/main/binary-amd64/
>>
>> Packages.bz2 09-May-2025 19:58 350884
>>
>> Not sure where the Filesize:350996 [weak] and Release file created at:
>> Mon, 28 Apr 2025 16:16:01 +0000 is coming from?
>>
>
> Me neither, I'll confess - possibly a version in use that *didn't* receive
> an update?
>
If you still have the issue, or f it reappears, can you please provider the
header output from basically a "curl -I <url>" for th different URLs
involved at the time of failure?
And also note the exact timestamp of when you're doing it, to correlate
with logs.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15
In-Reply-To: <CABUevEyvNqJHmbYKWfgu0EAReYSRr4R7FKHmqU9JCFd6e-0zaQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox