Skip to content

fetch pooler and fes_user system user only when corresponding features are used #2009

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 4 commits into from
Aug 24, 2022

Conversation

FxKu
Copy link
Member

@FxKu FxKu commented Aug 24, 2022

If somebody unintentionally defines reserved system users pooler or fes_user in the manifest, the updateSecret function will use the systemUsers map. But if the pooler or stream feature are not used, no corresponding PgUser object will exist in that map. The PgUser used in password rotation will be empty ultimatly leading to this error:

could not sync roles: error executing sync statements: could not execute sync requests for users: could not create user "": pq: zero-length delimited identifier at or near """"

The bug was introduced with #1953 .

@FxKu FxKu added the bug label Aug 24, 2022
@FxKu FxKu added this to the 1.9 milestone Aug 24, 2022
@FxKu FxKu changed the title updateSecret fix: fetch pooler and fes_user system user only when cor… fetch pooler and fes_user system user only when corresponding features are used Aug 24, 2022
@idanovinda
Copy link
Member

👍

1 similar comment
@FxKu
Copy link
Member Author

FxKu commented Aug 24, 2022

👍

@FxKu FxKu merged commit ef32449 into master Aug 24, 2022
@FxKu FxKu deleted the fes-user-conflict branch August 24, 2022 14:28
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants