Skip to content
This repository has been archived by the owner on Dec 17, 2024. It is now read-only.

Mixed SQL construction causes PgPool dbtype monitoring failure #498

Closed
palmalcheg opened this issue Jun 23, 2022 · 3 comments
Closed

Mixed SQL construction causes PgPool dbtype monitoring failure #498

palmalcheg opened this issue Jun 23, 2022 · 3 comments
Assignees
@pashagolub
Labels
bug gatherer-daemon

Comments

@palmalcheg
Copy link
Contributor

palmalcheg commented Jun 23, 2022 •
edited
Loading

Testing :

postgres@postgres-db-pg-cluster-0:~$ psql -h postgres-db-pg-cluster-pgpool.pf -c "SET lock_timeout TO '100ms';SHOW POOL_VERSION"
Password for user postgres:
ERROR: unrecognized configuration parameter "pool_version"

postgres@postgres-db-pg-cluster-0:~$ psql -h postgres-db-pg-cluster-pgpool.pf -c "SHOW POOL_VERSION"
Password for user postgres:
pool_version

4.2.2 (chichiriboshi)
(1 row)

Potential bug:
https://github.com/cybertec-postgresql/pgwatch2/blob/master/pgwatch2/pgwatch2.go#L736
@palmalcheg palmalcheg changed the title PGPool dbtype failed to read pgpool stats PGPool dbtype failed to read pgpool version and stopped pgpool monitoring Jun 23, 2022
@palmalcheg palmalcheg changed the title PGPool dbtype failed to read pgpool version and stopped pgpool monitoring Mixed SQL construction causes PgPool dbtype monitoring failure Jun 23, 2022
@palmalcheg
Copy link
Contributor Author

palmalcheg commented Jun 24, 2022 •
edited
Loading

Added related issue to pgpool
https://www.pgpool.net/mantisbt/view.php?id=758

@palmalcheg
Copy link
Contributor Author

Any news ?

@palmalcheg
Copy link
Contributor Author

2022/06/28 11:14:51 DEBU DBExecRead: failed to query pgpool sql: SET lock_timeout TO '100ms';SHOW POOL_VERSION err: pq: unrecognized configuration parameter "pool_version"

palmalcheg added a commit to palmalcheg/pgwatch2 that referenced this issue Jun 28, 2022
@palmalcheg
fix for issue#498
7db478f 
cybertec-postgresql#498
@palmalcheg palmalcheg mentioned this issue Jun 28, 2022
Merged
@pashagolub pashagolub self-assigned this Jun 28, 2022
@pashagolub pashagolub moved this to Todo in pgwatch2 Jun 28, 2022
@pashagolub pashagolub moved this from Todo to Done in pgwatch2 Jun 28, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@pashagolub pashagolub

Labels
bug gatherer-daemon
Projects
No open projects
pgwatch2
Status: Done
Milestone
No milestone
Development

No branches or pull requests
2 participants
@palmalcheg @pashagolub