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

On Sun, Oct 7, 2012 at 9:27 PM, gelin yan <dynamicgl(at)gmail(dot)com> wrote:
>
>
> On Mon, Oct 8, 2012 at 9:02 AM, Haiming Zhang <Haiming(dot)Zhang(at)redflex(dot)com(dot)au>
> wrote:
>>
>> 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.
>>
>
> Hi
>
> Could you try reducing your max_connection to 100 or some smaller numbers?
> also you may try 64 bit version if yours isn't.

If the OP needs > 100 connections on the app end, he should add a
connection pooler like pgbouncer or pgpool. pgbouncer is the easier
of the two to configure.