[Pkg-dspam-misc] Bug#368790: libdspam7-drv-pgsql: hangs with error after postgresql database cluster restart.

[Anton 'tony' Bangratz]

Package: libdspam7-drv-pgsql
Version: 3.6.4-4
Severity: important

After updating postgresql-8.1, following the automatic restart of the
cluster, dspam reports the following errors to syslog:

#v+
May 24 22:59:28 localhost dspam[12972]: query error: FATAL:  terminating
connection due to administrator command server closed the connection
unexpectedly ^IThis probably means the server terminated abnormally
^Ibefore or while processing the request. : see sql.errors for more details
May 24 22:59:28 localhost dspam[12972]: query error: : see sql.errors for
more details
May 24 23:02:15 localhost dspam[12972]: query error: FATAL:  terminating
connection due to administrator command server closed the connection
unexpectedly ^IThis probably means the server terminated abnormally
^Ibefore or while processing the request. : see sql.errors for more details
May 24 23:02:15 localhost dspam[12972]: query error: : see sql.errors for
more details
#v-

/var/log/dspam/sql.errors shows:
#v+
[05/24/2006 22:59:28] 12972: FATAL:  terminating connection due to
administrator command
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
: SELECT split_part(split_part(version(),' ',2),'.',1)::int2
[05/24/2006 22:59:28] 12972: : SELECT typname FROM pg_type WHERE typelem IN
( SELECT atttypid 
FROM pg_attribute WHERE attname = 'token' AND attrelid IN ( SELECT oid FROM
pg_class WHERE rel
name = 'dspam_token_data'));
[05/24/2006 23:02:15] 12972: FATAL:  terminating connection due to
administrator command
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
: SELECT split_part(split_part(version(),' ',2),'.',1)::int2
[05/24/2006 23:02:15] 12972: : SELECT typname FROM pg_type WHERE typelem IN
( SELECT atttypid 
FROM pg_attribute WHERE attname = 'token' AND attrelid IN ( SELECT oid FROM
pg_class WHERE rel
name = 'dspam_token_data'));
#v-

Mail is still being delivered, but not processed by dspam. Restarting the
dspam daemon fixes the problem. The behaviour is reproducable by restarting
the postgresql cluster.


-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.16-1-686
Locale: LANG=, LC_CTYPE=de_AT at euro (charmap=ISO-8859-15)

Versions of packages libdspam7-drv-pgsql depends on:
ii  dbconfig-common               1.8.13     common framework for packaging dat
ii  debconf [debconf-2.0]         1.5.1      Debian configuration management sy
ii  libc6                         2.3.6-9    GNU C Library: Shared libraries
ii  libdspam7                     3.6.4-4    DSPAM is a scalable and statistica
ii  libldap2                      2.1.30-13  OpenLDAP libraries
ii  libpq4                        8.1.4-1    PostgreSQL C client library
ii  postgresql-client-8.1         8.1.4-1    front-end programs for PostgreSQL 
ii  ucf                           2.0010     Update Configuration File: preserv

Versions of packages libdspam7-drv-pgsql recommends:
ii  postgresql-8.1                8.1.4-1    object-relational SQL database, ve

-- debconf information:
  libdspam7-drv-pgsql/pgsql/method: unix socket
  libdspam7-drv-pgsql/remote/host:
  libdspam7-drv-pgsql/pgsql/manualconf:
  libdspam7-drv-pgsql/pgsql/authmethod-admin: ident
  libdspam7-drv-pgsql/db/dbname: libdspam7drvpgsql
  libdspam7-drv-pgsql/pgsql/changeconf: false
  libdspam7-drv-pgsql/install-error: retry
  libdspam7-drv-pgsql/import-oldsettings:
  libdspam7-drv-pgsql/internal/reconfiguring: false
* libdspam7-drv-pgsql/pgsql/authmethod-user: ident
  libdspam7-drv-pgsql/database-type: pgsql
  libdspam7-drv-pgsql/performing_upgrade: false
  libdspam7-drv-pgsql/remove-error: abort
  libdspam7-drv-pgsql/remote/newhost:
  libdspam7-drv-pgsql/db/app-user: dspam
  libdspam7-drv-pgsql/purge: false
  libdspam7-drv-pgsql/dbconfig-remove: true
* libdspam7-drv-pgsql/dbconfig-install: true
  libdspam7-drv-pgsql/dbconfig-upgrade: true
  libdspam7-drv-pgsql/pgsql/admin-user: postgres
  libdspam7-drv-pgsql/pgsql/no-empty-passwords:
  libdspam7-drv-pgsql/upgrade-backup: true
  libdspam7-drv-pgsql/upgrade-error: abort
  libdspam7-drv-pgsql/remote/port:
  libdspam7-drv-pgsql/passwords-do-not-match: