Major Version Upgrade failure due to orphan roles entries in catalog
| От | Virender Singla |
|---|---|
| Тема | Major Version Upgrade failure due to orphan roles entries in catalog |
| Дата | |
| Msg-id | CAM6Zo8woa62ZFHtMKox6a4jb8qQ=w87R2L0K8347iE-juQL2EA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Major Version Upgrade failure due to orphan roles entries in catalog
Re: Major Version Upgrade failure due to orphan roles entries in catalog |
| Список | pgsql-bugs |
Hi,
We have identified an issue causing upgrade failures. The following steps detail how to reproduce the issue:
Create an orphan role entry
/* Postgres version:: PostgreSQL 16.6 */
/* The same can be reproduced in version 17 as well */
create role my_group;
create role dropped_member;
begin;
grant my_group to dropped_member;
OTHER SESSION: drop role dropped_member;
BACK IN ORIGINAL SESSION:
commit;
create role dropped_member;
begin;
grant my_group to dropped_member;
OTHER SESSION: drop role dropped_member;
BACK IN ORIGINAL SESSION:
commit;
Upgrade to Postgres v17
And the upgrade fails with an error :
GRANT "my_group" TO "" WITH INHERIT TRUE GRANTED BY "postgres";
ERROR: zero-length delimited identifier at or near """"
ERROR: zero-length delimited identifier at or near """"
The issue seems to be coming from pg_dumpall for building grants during pg_upgrade.
-Virender
В списке pgsql-bugs по дате отправления: