Angel, 2.3.4 is leaking database connectors (among other things).
this was solved already, and the fix will be in 2.3.5 the number of connections maintained in the connection pool is between 5 and 20 by default which should be way enough for any but very highly loaded servers (100+ concurrent and very busy clients) Angel Alvarez wrote: > Hi > > Im just testing 2.3.4 > > Im copying a bunch of messages (+30K) from two imapd server via a kmail > client (just to see how well is 2.3.4) speed is no problem but eventually > dbmail-imapd (2.3.4) stops running and exists. > > All i can see from logs is > > Dec 14 02:58:27 sushiba dbmail-imapd[30313]: [0x811d990] Alert:[db] > db_con_get(+239): Thread is having trouble obtaining a database connection. > Try [10] > Dec 14 02:58:32 sushiba dbmail-imapd[30313]: [0x811d990] Alert:[db] > db_con_get(+239): Thread is having trouble obtaining a database connection. > Try [15] > Dec 14 02:58:37 sushiba dbmail-imapd[30313]: [0x811d990] Alert:[db] > db_con_get(+239): Thread is having trouble obtaining a database connection. > Try [20] > Dec 14 02:58:42 sushiba dbmail-imapd[30313]: [0x811d990] Alert:[db] > db_con_get(+239): Thread is having trouble obtaining a database connection. > Try [25] > Dec 14 02:58:47 sushiba dbmail-imapd[30313]: [0x811d990] Alert:[db] > db_con_get(+239): Thread is having trouble obtaining a database connection. > Try [30] > > and > > Dec 14 13:40:33 sushiba dbmail-imapd[9163]: [0x811ca00] EMERGENCY:[db] > db_con_get(+250): [0x81062a0] can't get a database connection from the pool! > max [2] size [2] active [2] > Dec 14 13:48:46 sushiba dbmail-imapd[9317]: [0x811d9a8] EMERGENCY:[db] > db_con_get(+250): [0x81062a0] can't get a database connection from the pool! > max [2] size [2] active [2] > Dec 14 14:22:46 sushiba dbmail-imapd[9668]: [0x811db18] EMERGENCY:[db] > db_con_get(+250): [0x81062a0] can't get a database connection from the pool! > max [2] size [2] active [2] > .... > > I ve limited db connections to 2 (just for testing purpouses) and seem a lot > of workers more than 2 got created so they cant' connect.. > > How can one limit the workers? > > Maybe is just better use pgpool between Postgres and imapd and serialize > queries when mac cons exceded?? > > Regards, Angel > > > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
