Postgres issues "Not enough storage is available to complete this operation" exception

All,

I am running on a Windows XP machine, 4GB of RAM and over 26GB of
free hard-disk an application that all it does is insert records into
the Postgres 8.3 database. When the database is approx 17GB Postgres
issues the "Not enough storage is available to complete this operation"
and refuses to insert records. I normally shut down and restart the
application and data collection continues normally until it reaches the
26GB and issues the same error: "Not enough storage is available to
complete this operation." I'm very puzzled to say the least. The
Postgres configuration is attached. For some reason Postgres would no
load if shared_buffers > 900MB.

I should say that my Windows is running with the /3GB flag.

Thanks in advance for any help you can offer.

Maria Cianci

Software Engineer

CAE USA Professional Services

CONSIM Group

3501 Quadrangle Blvd., Suite 271

Orlando, FL 32817

maria(dot)cianci(at)cae(dot)com

CAE: (407)745-2609

Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person) you may not use, copy, disclose or deliver this message to anyone. If you have received this message in error, kindly notify the sender by reply email or at the phone number listed above, and then delete this message.

2009/11/16 Maria Cianci <Maria(dot)Cianci(at)cae(dot)com>:
> All,
>
>
>
>    I am running on a Windows XP machine, 4GB of RAM and over 26GB of free
> hard-disk an application that all it does is insert records into the
> Postgres 8.3 database.  When the database is approx 17GB Postgres issues the
> “Not enough storage is available to complete this operation” and refuses to
> insert records.  I normally shut down and restart the application and data
> collection continues normally until it reaches the 26GB and issues the same
> error: “Not enough storage is available to complete this operation.”  I’m
> very puzzled to say the least.  The Postgres configuration is attached.  For
> some reason Postgres would no load if shared_buffers > 900MB.
>
>
>
> I should say that my Windows is running with the /3GB flag.
>
>
>
> Thanks in advance for any help you can offer.
>

From looking at a previous post, you'd need to install/reinstall MDAC
2.6: http://archives.postgresql.org/pgadmin-support/2002-05/msg00063.php

Regards

Thom

"Maria Cianci" <Maria(dot)Cianci(at)cae(dot)com> wrote:
>
> I am running on a Windows XP machine, 4GB of RAM and over 26GB of
> free hard-disk an application that all it does is insert records into
> the Postgres 8.3 database. When the database is approx 17GB Postgres
> issues the "Not enough storage is available to complete this operation"
> and refuses to insert records.

What method are you using to gauge the size of the database? Keep in
mind that PG needs disk space for things other than the DB itself, WAL
logs, for example. If PG doesn't have space to create more WAL logs,
it can't process data changes.

> I normally shut down and restart the
> application and data collection continues normally until it reaches the
> 26GB and issues the same error: "Not enough storage is available to
> complete this operation." I'm very puzzled to say the least.

Really? If you're using all 26G, what other error would you expect?

I find it odd that it would have problems when there are nearly 10G free,
though. What methods are you using to measure DB size, and disk usage?

Keep in mind that unless you check disk usage at the exact moment the
error occurs, you don't really know what the usage was, as Postgres may
have cleaned up some files after the error was detected. I recommend
using SNMP or some similar method to record disk usage on an ongoing
basis, then correlate that data with timing of the errors. Based on
past experience, I'd be willing to bet that you really _are_ running
out of disk space at the time the error is reported. I believe that
large transactions can cause this, because they take up a lot of disk
space during processing that is then freed once the transaction is either
completed or rolled back. Does your application do large transactions?

--
Bill Moran
http://www.potentialtech.com