[prev in list] [next in list] [prev in thread] [next in thread] 

List:       amavis-user
Subject:    [AMaViS-user] Database reconnection with PostgreSQL
From:       "Brian Wong" <bwlist () gmail ! com>
Date:       2006-02-24 6:58:13
Message-ID: e1c904a40602232258o18f05c1bkeb2945e84c0f02a4 () mail ! gmail ! com
[Download RAW message or body]

List,
Can anyone else confirm that reconnection does not work with
PostgreSQL? Im suspecting that the line:

  eval { $self->dbh->begin_work(@_) }; # line 9575 of amavisd 2.3.3

always returns true for the DBD::Pg module regardless of the state of
the connection. Therefore constantly making false attempts to store
sql information with save_info_preliminary() if the connection is
actually lost.

(13517-06) WARN save_info_final: sql execute: sts=7, DBD::Pg::st
execute failed: no connection to the server at (eval 40) line 131,
<GEN5> line 875.
(13517-06) sql_storage: retrying on final, 2 attempts remain
(13517-06) save_info_final: rollback done
(13517-06) WARN save_info_final: sql execute: sts=7, DBD::Pg::st
execute failed: no connection to the server at (eval 40) line 131,
<GEN5> line 875.
(13517-06) sql_storage: retrying on final, 1 attempts remain
(13517-06) save_info_final: rollback done
(13517-06) WARN save_info_final: sql execute: sts=7, DBD::Pg::st
execute failed: no connection to the server at (eval 40) line 131,
<GEN5> line 875.
(13517-06) ERROR sql_storage: too many retries on storing final, info not saved


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/

[prev in list] [next in list] [prev in thread] [next in thread]