Search Postgresql Archives

server process (PID 1304) was terminated by exception 0xC0000142

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux