Re: server process (PID 1304) was terminated by exception 0xC0000142 - Mailing list pgsql-general

Hi all,

 

I am Haiming, a software engineer.

 

One of our product is depending on PostgreSQL. I am facing a problem that it somehow always gave me an error " server process (PID 1304) was terminated by exception 0xC0000142." or " No buffer space available (maximum connections reached?): connect". I searched around and tried different configuration, but I still have not gotten any luck.

Any help would be appreciated.

 

Setup:

                1. Postgresql 9.1

                2. Product language: Java

                3. JDBC Pool: BoneCP 

Here is my config:

idleConnectionTestPeriod = 60

idleMaxAge = 240

maxConnectionsPerPartition  = 35

minConnectionsPerPartition = 10

partitionCount =  5

 

and in postgresql.conf:

max_connections = 600

shared_buffers = 32MB

others are as default.

 

This configuration is deployed in Windows XP with 4G Ram.

 

I also tried Windows 7 and Windows Server 2008, the same issue occured.

For Server 2008, my config is:

idleConnectionTestPeriod = 60

idleMaxAge = 240

maxConnectionsPerPartition  = 100

minConnectionsPerPartition = 5

partitionCount =  5

 

and in postgresql.conf:

max_connections = 2000

shared_buffers = 2G

others are as default.

 

Many thanks

 

Haiming Zhang

Software Engineer

 

---

If you are not an authorised recipient of this e-mail, please contact me at Redflex immediately by return phone call or by email. In this case, you should not read, print, retransmit, store or act in reliance on this e-mail or any attachments, and should destroy all copies of them. This e-mail and any attachments are confidential and may contain privileged information and/or copyright material of Redflex or third parties. You should only retransmit, distribute or commercialise the material if you are authorised to do so. This notice should not be removed.