I would like to reduce the mysql transport retry time (or perhaps the proxymap retry time?), is there a variable that I can tweak down to reduce the time between retries of mysql transport connection losses?
I'm using mysql for transport_maps and virtual_mailbox_maps. transport_maps = proxy:mysql:$maps_dir/mysql_transport.cf virtual_mailbox_maps = mysql:$maps_dir/mysql_aliases.cf these are configured to contact a locat stunnel process which connects to a mysql cluster over an encrypted connection. This works great, except when the active node of the cluster crashes (and it seems to be doing that more frequently lately). The cluster fails-over to the standby, the connections are re-established and things return to normal. When the node fails, postfix naturally cannot communicate over the mysql connection, until the cluster has failed over. This failover is fairly fast, within seconds, but I think postfix, probably due to the use of the proxy map, is not retrying very quickly. Is there a tunable parameter that I can use to tweak this down to a shorter delay? The erorrs that arrive are expected in this scenario, for example, here is a subset: Oct 27 13:24:23 mx1 postfix/smtpd[11045]: warning: mysql:/etc/postfix/checks/mysql_suspended.cf: table lookup problem Oct 27 13:24:37 mx1 postfix/proxymap[14768]: warning: mysql query failed: Lost connection to MySQL server during query Oct 27 13:24:37 mx1 postfix/trivial-rewrite[11124]: fatal: proxy:mysql:/etc/postfix/maps/mysql_aliases.cf(0,lock|fold_fix): table lookup problem Oct 27 13:24:38 mx1 postfix/master[7511]: warning: process /usr/lib/postfix/trivial-rewrite pid 11124 exit status 1 Oct 27 13:24:38 mx1 postfix/smtpd[12834]: warning: problem talking to service rewrite: Connection reset by peer Oct 28 09:01:57 mx1 postfix/smtpd[4945]: warning: problem talking to service rewrite: Success Oct 28 09:01:57 mx1 postfix/smtpd[4948]: warning: problem talking to service rewrite: Connection reset by peer Postmaster also gets quite a large number of bounces when this happens: In: MAIL FROM:<x...@xxx.net> SIZE=2158 BODY=8BITMIME Out: 250 2.1.0 Ok In: RCPT TO:<x...@xxx.net> ORCPT=rfc822;x...@riseup.net Out: 451 4.3.0 <x...@xxx.net>: Temporary lookup failure In: DATA Out: 554 5.5.1 Error: no valid recipients In: RSET Out: 250 2.0.0 Ok In: QUIT Out: 221 2.0.0 Bye Presumably these are non-fatal, due to the 451, and only postmaster sees these, not the sender, and they are just retried, is that correct? Thanks for any advice, I haven't found anything that specifically would be related to this in http://www.postfix.org/postconf.5.html#command_time_limit but I might have missed something. micah
signature.asc
Description: Digital signature
