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

[Matthijs Mohlmann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

tags 368790 + upstream
thanks

Anton 'tony' Bangratz wrote:
> 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.
> 

This is due to dspam not reconnecting after a failure. I've reported
this issue upstream.

Regards,

Matthijs Mohlmann

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEeYhQ2n1ROIkXqbARAk+VAJ0cEBCNxEr3SqcwVv6EE47HdJox7gCgsZj2
fTTUO8EXtLCcEooD4QIKHiU=
=K/K5
-----END PGP SIGNATURE-----