Amavisd 2.5.4, freebsd, mysql 5.0, innodb (most likely) lock wait timeout on first DSN doesn't force a switchover to second DSN: (something to consider for 2.6.2?)
Given this email log entry on node2: Jun 30 06:17:32 node2 amavis[3602]: (03602-01) (!)WARN save_info_preliminary: sql exec: err=1205, HY000, DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at (eval 67) line 169, <GEN14> line 11. Jun 30 06:17:32 node2 amavis[3602]: (03602-01) (!!)ERROR sql_storage: too many retries on storing preliminary, info not saved Given this DSN: @lookup_sql_dsn = ( ['DBI:mysql:host=localhost;dbname=mail', 'amavis', ''], ['DBI:mysql:host=node1;dbname=mail', 'amavis', ''] ); @storage_sql_dsn = @lookup_sql_dsn; I would have expected (hoped) that th ssql_storage engine would try the node1 connection if localhost timed out. Yes, it looks like if I completly disable sql on node2 it WILL try node 1, but what about if lock wait exceeded or other time outs? (in this case, lock wait is expected. the lock wait itself isn't an error) -- Michael Scheidell, President Main: 561-999-5000, Office: 561-939-7259 > *| *SECNAP Network Security Corporation Winner 2008 Technosium hot company award. www.technosium.com/hotcompanies/ <http://www.technosium.com/hotcompanies/> _________________________________________________________________________ This email has been scanned and certified safe by SpammerTrap(r). For Information please see http://www.spammertrap.com _________________________________________________________________________ ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
