WARNING: missing lock on database "postgres" (OID 5) @ TID (0,4)

From: Alexander Kukushkin <cyberdemn(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, noah(at)leadboat(dot)com
Subject: WARNING: missing lock on database "postgres" (OID 5) @ TID (0,4)
Date: 2024-12-09 10:27:06
Message-ID: CAFh8B=mpKjAy4Cuun-HP-f_vRzh2HSvYFG3rhVfYbfEBUhBAGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello Hacker,

When Postgres is compiled with --enable-cassert I get subj when doing the
following:
postgres=# create user test;
CREATE ROLE
postgres=# alter database postgres owner to test;
ALTER DATABASE
postgres=# reassign owned by test to postgres;
WARNING: missing lock on database "postgres" (OID 5) @ TID (0,4)
REASSIGN OWNED

It was discovered on 16.6, however the master shows the same behaviour.
I suspect it to be due to aac2c9b4fde889d13f859c233c2523345e72d32b.

Regards,
--
Alexander Kukushkin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jakub Wartak 2024-12-09 10:27:40 Re: FileFallocate misbehaving on XFS
Previous Message Tomas Vondra 2024-12-09 10:14:22 Re: FileFallocate misbehaving on XFS