A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=736 ====================================================================== Reported By: niki Assigned To: netvulture ====================================================================== Project: DBMail Issue ID: 736 Category: Database layer Reproducibility: always Severity: block Priority: normal Status: acknowledged target: ====================================================================== Date Submitted: 20-Nov-08 22:08 CET Last Modified: 20-Nov-08 22:56 CET ====================================================================== Summary: DBMail consuming db connections, and stops responding Description: Just updated DBMail to 2.3.4 "official" dbmail experimental
When I connect with Evo, dbmail starts to consume connections up until 32 (have configred it to to max 50) while logging some db errors, after it has stopped at 32 db connections it, I can still filter a couple of ails into folders before it dops all connections to the db. Lmtp is still running fine. The db is Postgres 8.3.3 (Debian) ====================================================================== ---------------------------------------------------------------------- niki - 20-Nov-08 22:38 ---------------------------------------------------------------------- Her is a log with log level 128 ---------------------------------------------------------------------- netvulture - 20-Nov-08 22:45 ---------------------------------------------------------------------- Can you please post the new log using these settings. FILE_LOGGING_LEVELS = 511 errorlog = /path/to/log/file Your last log file only said SQLException: a bunch of times. Syslog probably cut off the messages. Also, is your database running on the same box, or a different host? If over the network, describe the connection (10? 100? 1000? mbit LAN, or other?). How many connections is your db server set to handle? Try setting it to 150 using max_connections(150) in the db config file. ---------------------------------------------------------------------- niki - 20-Nov-08 22:56 ---------------------------------------------------------------------- The 2nd file I uploaded is a copy of the dbmail error log at loglevel 128 (dbmail-2.err.bz2), but I'll get you a copy of the same file at log leve 511 in a sec, I'll just answer a couple of you questions first. Postgres is running on a dedicated host, right next to the mail server, connected via an ethernet switch (all of it is 100M), and the dbmail user is set to have no connection limit in Postgres. Issue History Date Modified Username Field Change ====================================================================== 20-Nov-08 22:08 niki New Issue 20-Nov-08 22:08 niki File Added: dbmail-1.log 20-Nov-08 22:38 niki Note Added: 0002636 20-Nov-08 22:38 niki File Added: dbmail-2.err.bz2 20-Nov-08 22:45 netvulture Note Added: 0002637 20-Nov-08 22:45 netvulture Assigned To => netvulture 20-Nov-08 22:45 netvulture Status new => acknowledged 20-Nov-08 22:56 niki Note Added: 0002638 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
