[Pkg-dns-devel] Bug#831741: pdns-backend-pgsql: new pdns spams postgres log until disk fills up

[cloos at jhcloos.com]

Package: pdns-backend-pgsql
Version: 4.0.0-4
Severity: grave
Justification: renders package unusable

The pg log gets spammed with:

2016-07-18 20:45:26 GMT ERROR:  syntax error at end of input at character 12
2016-07-18 20:45:26 GMT STATEMENT:  DEALLOCATE

constantly, hundreds of times per second.

I had to set log_min_messages and log_min_error_statement to fatal to avoid it.

Something is wrong with the sql pdns sends to pg.

This is a recent regression.  I did not notice with with the first 4.0 pres in sid.

-- System Information:
Debian Release: stretch/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.5.0-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: sysvinit (via /sbin/init)

Versions of packages pdns-backend-pgsql depends on:
ii  dbconfig-common        2.0.4
ii  dbconfig-pgsql         2.0.4
ii  debconf [debconf-2.0]  1.5.59
ii  libc6                  2.23-1
ii  libgcc1                1:6.1.1-9
ii  libpq5                 9.5.3-1
ii  libstdc++6             6.1.1-9
ii  pdns-server            4.0.0-4
ii  ucf                    3.0036

pdns-backend-pgsql recommends no packages.

Versions of packages pdns-backend-pgsql suggests:
pn  postgresql  <none>

-- debconf information:
  pdns-backend-pgsql/remove-error: abort
  pdns-backend-pgsql/pgsql/changeconf: false
  pdns-backend-pgsql/dbconfig-remove:
  pdns-backend-pgsql/upgrade-backup: true
  pdns-backend-pgsql/db/dbname: pdns
  pdns-backend-pgsql/internal/reconfiguring: false
* pdns-backend-pgsql/dbconfig-upgrade: true
  pdns-backend-pgsql/install-error: abort
  pdns-backend-pgsql/database-type: pgsql
  pdns-backend-pgsql/pgsql/manualconf:
  pdns-backend-pgsql/purge: false
  pdns-backend-pgsql/pgsql/no-empty-passwords:
  pdns-backend-pgsql/dbconfig-reinstall: false
  pdns-backend-pgsql/remote/newhost:
  pdns-backend-pgsql/upgrade-error: abort
  pdns-backend-pgsql/pgsql/authmethod-admin: ident
  pdns-backend-pgsql/remote/host: localhost
  pdns-backend-pgsql/remote/port:
  pdns-backend-pgsql/missing-db-package-error: abort
  pdns-backend-pgsql/pgsql/method: Unix socket
  pdns-backend-pgsql/pgsql/authmethod-user: ident
  pdns-backend-pgsql/passwords-do-not-match:
  pdns-backend-pgsql/internal/skip-preseed: false
  pdns-backend-pgsql/db/app-user: pdns
* pdns-backend-pgsql/dbconfig-install: true
  pdns-backend-pgsql/pgsql/admin-user: postgres