Mixed SQL construction causes PgPool dbtype monitoring failure

[palmalcheg]

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]

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

[palmalcheg]

Any news ?

[palmalcheg]

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"