Rogerio,

 

I think postgre allows less connection than your max_connections setting.

 

From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf
Of Rogerio Pereira
Sent: sexta-feira, 31 de Outubro de 2014 14:29
To: dbmail@dbmail.org
Subject: [Dbmail] max_db_connections

 

Hi,

I need suggestions about max_db_connections.

Imapd usually hangs in my DBmail instance running 3.1.17 in a daily basis.

dbmail-imapd[10702]: [0x18e6f90] Alert:[db] db_con_get(+254): Thread is
having trouble obtaining a database connection. Try [0]

 pool[10726]: segfault at 0 ip:00007fc0c2b53e20 sp 00007fc0b9fa5660 error 4
in libzdb.so.9.0.2[7fc0c2b4b000+1a

I decided to change max_db_connections from 10 to 20.

Is it OK? What are the chances to get it worst than before? My server has
1900 users, average of 30 simultaneous user connections, PgSQL 9.3 in a
separate server and 120 GB total DB size.

Another question: Pop3d does not throw this error in dbmail.err. I guess
this service will be impacted by the same DB imapd connection issue. Is this
pop3d error a symptom of the same problem?

 dbmail-pop3d[17231] general protection ip:7ffd411f180a sp:7fff0c6799c8
error:0 in libdbmail.so.0.0.0[7ffd411ad000+6b000]

Regards.

 

 

Rogerio



  

_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to