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.

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

inputs.pgbouncer Error in plugin: ERROR: unsupported pkt type: 80 (SQLSTATE 08P01) #5455

Closed
urusha opened this issue Feb 20, 2019 · 6 comments · Fixed by #5772 or #5814
Closed

inputs.pgbouncer Error in plugin: ERROR: unsupported pkt type: 80 (SQLSTATE 08P01) #5455

urusha opened this issue Feb 20, 2019 · 6 comments · Fixed by #5772 or #5814
Labels
area/postgresql bug unexpected problem or unintended behavior regression something that used to work, but is now broken upstream bug or issues that rely on dependency fixes
Milestone

Comments

@urusha
Copy link
Contributor

urusha commented Feb 20, 2019

Relevant telegraf.conf:

[[inputs.pgbouncer]]
    address = "postgres://telegraf:telegraf@localhost:6432/pgbouncer"

System info:

debian 9 amd64, telegraf 1.9.1
tested with
https://dl.influxdata.com/telegraf/releases/telegraf_1.9.1-1_amd64.deb
https://dl.influxdata.com/telegraf/releases/telegraf_1.9.4-1_amd64.deb

Steps to reproduce:

  1. Use https://dl.influxdata.com/telegraf/releases/telegraf_1.9.0-1_amd64.deb with above pgbouncer input. No errors.
  2. Upgrade to https://dl.influxdata.com/telegraf/releases/telegraf_1.9.1-1_amd64.deb . See errors

Expected behavior:

no errors

Actual behavior:

errors in log:

E! [inputs.pgbouncer]: Error in plugin: ERROR: unsupported pkt type: 80 (SQLSTATE 08P01)
E! [inputs.pgbouncer]: Error in plugin: EOF

Additional info:

pgbouncer log:

ERROR unsupported pkt type: 80
WARNING C-0x7f3e81e60438: pgbouncer/[email protected]:39156 Pooler Error: unsupported pkt type: 80
WARNING C-0x7f3e81e60438: pgbouncer/[email protected]:39156 Pooler Error: bad pkt
@danielnelson
Copy link
Contributor

This appears to have happened when we updated pgx to add TLS support, I opened this issue upstream:

jackc/pgx#512

@danielnelson danielnelson added bug unexpected problem or unintended behavior regression something that used to work, but is now broken upstream bug or issues that rely on dependency fixes area/postgresql labels Feb 20, 2019
@vauboy
Copy link

vauboy commented Mar 21, 2019

Seems like already fixed in #3253

@danielnelson
Copy link
Contributor

This has broken since that issue was originally done. A fix has been applied upstream but is not yet part of a released version.

@ricky-ticky
Copy link

ricky-ticky commented Apr 16, 2019

telegraf_1.10.2-1_amd64.deb inputs.pgbouncer plugin still broken

@glinton
Copy link
Contributor

glinton commented Apr 16, 2019

ricky-ticky, that's correct. As daniel pointed out, the upstream fix hasn't been included in a released version yet.

@jfduque
Copy link

jfduque commented Apr 26, 2019

Still broken in telegraf_1.10.3-1_amd64.deb

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/postgresql bug unexpected problem or unintended behavior regression something that used to work, but is now broken upstream bug or issues that rely on dependency fixes
Projects
None yet
6 participants