PostgreSQL – is our automatic testing sufficient?

[Peter Boy Uni]

There is an issue with Postgresql when updating to F41.

https://lists.fedoraproject.org/archives/list/[e-mail]/...

PostgreSQL is one of our two central services that are tested automatically. And as far as I know we did miss the above issue. There is no release note entry either.

How could this happen? Do we need to extend the PostgreSQL tests? Or have I missed something?

--
Peter Boy
https://fedoraproject.org/wiki/User:Pboy
[e-mail]

Timezone: CET (UTC+1) / CEST (UTC+2)

Fedora Server Edition Working Group member
Fedora Docs team contributor and board member
Java developer and enthusiast

[Tomasz Torcz]

On Tue, Nov 12, 2024 at 09:48:04AM +0100, Peter Boy Uni via server wrote:
> There is an issue with Postgresql when updating to F41.
>
> https://lists.fedoraproject.org/archives/list/[e-mail]/...
>
> PostgreSQL is one of our two central services that are tested
> automatically. And as far as I know we did miss the above issue. There
> is no release note entry either.
>
> How could this happen? Do we need to extend the PostgreSQL tests? Or have I missed something?

As far as I remember, this was always a case after upgrading glibc. I
recalli needign to run ALTER DATABASE few times after dist upgrade in
the past.

[Kevin Fenzi]

On Tue, Nov 12, 2024 at 10:40:32AM +0100, Tomasz Torcz via server wrote:
> On Tue, Nov 12, 2024 at 09:48:04AM +0100, Peter Boy Uni via server wrote:
> > There is an issue with Postgresql when updating to F41.
> >
> > https://lists.fedoraproject.org/archives/list/[e-mail]/...
> >
> > PostgreSQL is one of our two central services that are tested
> > automatically. And as far as I know we did miss the above issue. There
> > is no release note entry either.
> >
> > How could this happen? Do we need to extend the PostgreSQL tests? Or have I missed something?
>
> As far as I remember, this was always a case after upgrading glibc. I
> recalli needign to run ALTER DATABASE few times after dist upgrade in
> the past.

Do note also that it's just a warning, not an error.

But yeah, ideally something could be worked out to fix it.

Might be worth a bug on postgresql to see if maintainers have any ideas?

kevin

[Adam Williamson]

On Tue, 2024-11-12 at 09:48 +0100, Peter Boy Uni via server wrote:
> There is an issue with Postgresql when updating to F41.
>
> https://lists.fedoraproject.org/archives/list/[e-mail]/...
>
> PostgreSQL is one of our two central services that are tested automatically. And as far as I know we did miss the above issue. There is no release note entry either.
>
> How could this happen? Do we need to extend the PostgreSQL tests? Or have I missed something?

AFAIK this is fairly normal for postgres and something postgres admins
should be accustomed to. I know Kevin is used to special handling for
postgres DBs when upgrading Fedora on the db host.

As for testing: the automated testing does exactly what's in the test
cases,
https://fedoraproject.org/wiki/QA:Testcase_postgresql_server_installation
and
https://fedoraproject.org/wiki/QA:Testcase_database_server_remote_client
, on a fresh install. We don't currently test upgrades of a database
server at all.