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 23:43 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. ---------------------------------------------------------------------- niki - 20-Nov-08 23:20 ---------------------------------------------------------------------- Here is the log at loglevel 511, and max connections set to 150. When Evo connects, dbmail starts to consume connections again, and it still stops at 32 connections, when it's done I can manually do 5 successful filter actions, when I hit Ctrl+y the 6th time, Evo returns with an error saying it couldn't complete the action. http://www.guldbrand.net/dbmail-3.err.bz2 ---------------------------------------------------------------------- paul - 20-Nov-08 23:34 ---------------------------------------------------------------------- this smell very much like a libzdb buglet. Could you please test the attached patch? ---------------------------------------------------------------------- niki - 20-Nov-08 23:40 ---------------------------------------------------------------------- I will, but I don't have that mutch experience with debian package building, stay tuned. ---------------------------------------------------------------------- netvulture - 20-Nov-08 23:43 ---------------------------------------------------------------------- I was wanting you to make sure that your database server was setup to handle 150 connections. max_db_connections in dbmail.conf should be something like 20 or 25. IDLE clients will use the excess connections. If you have trouble with log entries saying could get a db connection, try [5] with a lot of active clients. Then increase this by about 5 at a time until it goes away. 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 20-Nov-08 23:20 niki Note Added: 0002639 20-Nov-08 23:34 paul Note Added: 0002640 20-Nov-08 23:35 paul File Added: 0001-workaround-connection-leakage.patch 20-Nov-08 23:40 niki Note Added: 0002641 20-Nov-08 23:43 netvulture Note Added: 0002642 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
