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

VACUUM (ANALYZE, VERBOSE) is causing collector to fail collecitng vacuum progress #113

Closed
jeroenvisser101 opened this issue Nov 21, 2020 · 0 comments · Fixed by #120
Closed

VACUUM (ANALYZE, VERBOSE) is causing collector to fail collecitng vacuum progress #113

jeroenvisser101 opened this issue Nov 21, 2020 · 0 comments · Fixed by #120

Comments

@jeroenvisser101
Copy link

jeroenvisser101 commented Nov 21, 2020 •
edited

This error log is shown when running VACUUM manually using:

VACUUM (ANALYZE, VERBOSE) <table name>;
Could not collect activity for server: error collecting pg_stat_vacuum_progress: sql: Scan error on column index 3, name "nspname": converting NULL to string is unsupported

Vacuum stats also seems to be missing during the periods those manual VACUUM + ANALYZE are running.
lfittl added a commit that referenced this issue Dec 6, 2020
@lfittl
Ignore manual vacuums if we can't access pg_stat_progress_vacuum
f93f235 
Before this was failing with an error because we couldn't determine
the relation and namespace name correctly. Without access to the
pg_stat_progress_vacuum table this is not possible to do reliably, so
skip manual vacuums instead in that situation.

Fixes #113
@lfittl lfittl mentioned this issue Dec 6, 2020
Merged
lfittl added a commit that referenced this issue Dec 6, 2020
@lfittl
Ignore manual vacuums if we can't access pg_stat_progress_vacuum
34a660b 
Before this was failing with an error because we couldn't determine
the relation and namespace name correctly. Without access to the
pg_stat_progress_vacuum table this is not possible to do reliably, so
skip manual vacuums instead in that situation.

Fixes #113
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Ignore manual vacuums if we can't access pg_stat_progress_vacuum pganalyze/collector
1 participant
@jeroenvisser101