Skip to content
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.

Sign up for GitHub

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

Jump to bottom

[Bug]: PostgreSQL 17 removed some columns from pg_stat_bgwriter and introduced pg_stat_checkpointer #3411

Open
4 tasks done
sxd opened this issue Nov 27, 2023 · 0 comments · May be fixed by #4779
Open
4 tasks done

[Bug]: PostgreSQL 17 removed some columns from pg_stat_bgwriter and introduced pg_stat_checkpointer #3411

sxd opened this issue Nov 27, 2023 · 0 comments · May be fixed by #4779
Assignees
@NiccoloFei
Labels
bug 🐛 Something isn't working
Milestone
1.24.0

Comments

@sxd
Copy link
Member

sxd commented Nov 27, 2023

Is there an existing issue already for this bug?

  • I have searched for an existing issue, and could not find anything. I believe this is a new bug.

I have read the troubleshooting guide

  • I have read the troubleshooting guide and I think this is a new bug.

I am running a supported version of CloudNativePG

  • I have read the troubleshooting guide and I think this is a new bug.

Contact Details

No response

Version

1.21.1

What version of Kubernetes are you using?

1.28

What is your Kubernetes environment?

Self-managed: kind (evaluation)

How did you install the operator?

YAML manifest

What happened?

After the following ticket postgres/postgres@96f0526 some columns changed and the monitoring metrics are failing in the development trunk of PostgreSQL 17-devel

Cluster resource

No response

Relevant log output

No response

Code of Conduct

  • I agree to follow this project's Code of Conduct
@sxd sxd added the triage Pending triage label Nov 27, 2023
@sxd sxd assigned sxd and unassigned gbartolini Apr 17, 2024
@sxd sxd added bug 🐛 Something isn't working and removed triage Pending triage labels Apr 17, 2024
@NiccoloFei NiccoloFei mentioned this issue Apr 19, 2024
Closed
@NiccoloFei NiccoloFei changed the title [Bug]: PostgreSQL 17 removed some columns and changed the name [Bug]: PostgreSQL 17 removed some columns from pg_stat_bgwriter and introduced pg_stat_checkpointer Apr 19, 2024
@mnencia mnencia mentioned this issue Apr 24, 2024
Merged
mnencia added a commit that referenced this issue Apr 24, 2024
@mnencia
fix: disable metrics from pg_stat_bgwriter in v17+ (#4364)
6b98119 
PostgreSQL 17 removed some columns from `pg_stat_bgwriter`, moving them
to the new `pg_stat_checkpointer` view. This patch disables the gathering
of `pg_stat_bgwriter` metrics in PostgreSQL v17+.
A further patch will add support for the new format.

Workaround for #3411

Signed-off-by: Marco Nenciarini <marco.nenciarini@enterprisedb.com>
cnpg-bot pushed a commit that referenced this issue Apr 24, 2024
@mnencia
fix: disable metrics from pg_stat_bgwriter in v17+ (#4364)
c249aee 
PostgreSQL 17 removed some columns from `pg_stat_bgwriter`, moving them
to the new `pg_stat_checkpointer` view. This patch disables the gathering
of `pg_stat_bgwriter` metrics in PostgreSQL v17+.
A further patch will add support for the new format.

Workaround for #3411

Signed-off-by: Marco Nenciarini <marco.nenciarini@enterprisedb.com>
(cherry picked from commit 6b98119)
cnpg-bot pushed a commit that referenced this issue Apr 24, 2024
@mnencia
fix: disable metrics from pg_stat_bgwriter in v17+ (#4364)
b2f50e0 
PostgreSQL 17 removed some columns from `pg_stat_bgwriter`, moving them
to the new `pg_stat_checkpointer` view. This patch disables the gathering
of `pg_stat_bgwriter` metrics in PostgreSQL v17+.
A further patch will add support for the new format.

Workaround for #3411

Signed-off-by: Marco Nenciarini <marco.nenciarini@enterprisedb.com>
(cherry picked from commit 6b98119)
@gbartolini gbartolini mentioned this issue May 7, 2024
Merged
@fcanovai fcanovai linked a pull request Jun 4, 2024 that will close this issue
Open
@mnencia mnencia added this to the 1.24.0 milestone Jun 10, 2024
@NiccoloFei NiccoloFei assigned NiccoloFei and unassigned sxd Jun 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@NiccoloFei NiccoloFei

Labels
bug 🐛 Something isn't working
Projects
CloudNativePG operator development
Status: Waiting for Second Review
Roadmap
Status: In Progress
Milestone
1.24.0
4 participants
@mnencia @gbartolini @sxd @NiccoloFei