Your message dated Wed, 05 Jul 2006 21:57:24 +0200
with message-id <[EMAIL PROTECTED]>
and subject line libdspam7-drv-pgsql: hangs with error after postgresql
database cluster restart.
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
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=, [EMAIL PROTECTED] (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:
--- End Message ---
--- Begin Message ---
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
This bug is fixed in the current release in unstable / testing (etch).
Regards,
Matthijs Mohlmann
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFErBmk2n1ROIkXqbARAjsNAJsHW2gLcZg7MaCWClRQ9C+tEVueDgCgmkz2
WPfc+W32WUYHi2qjxhzY6ms=
=NSKQ
-----END PGP SIGNATURE-----
--- End Message ---
