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

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.

Regards

gelin yan