Re: [NOVICE] ERROR: Not enough resources are available to complete this request.

Sorry, I forgot to indicate the PG version.  

select version();  

"PostgreSQL 8.2.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"    

From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Zubkovsky, Sergey
Sent: Thursday, December 20, 2007 4:14 PM To: pgsql-novice@postgresql.org
Subject: [NOVICE] ERROR: Not enough resources are available to complete this request.  

Hello,  

I'm trying to call my PL/pgSQL stored procedure and receive the following error message:  

ERROR: Not enough resources are available to complete this request.

SQL state: P0001  

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

With "client_min_messages = debug5" and "log_error_verbosity = verbose" settings it looks like:  

DEBUG: StartTransactionCommand

DEBUG: StartTransaction

DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 1357622/1/0, nestlvl: 1, children: <>

DEBUG: concurrent ROOT page split

CONTEXT: SQL statement "INSERT INTO "andbBusyGLines" SELECT 'Messages',
"UTC", 25 FROM "#clientReqParts_Messages""

PL/pgSQL function "_andbDoPrepareView_sp" line 61 at execute statement

SQL statement "SELECT * FROM "_andbDoPrepareView_sp"( $1 , $2 , $3 )"

Do you need more help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

PL/pgSQL function "_andbDoPrepareView_sp" line 124 at SQL statement

SQL statement "SELECT * FROM "_andbDoPrepareView_sp"( $1 , $2 , $3 )"

PL/pgSQL function "_andbDoPrepareView_sp" line 124 at SQL statement

PL/pgSQL function "PrepareView_sp" line 22 at assignment  

ERROR: Not enough resources are available to complete this request.

SQL state: P0001  

Where "andbBusyParts" is an ordinary table and
"#clientReqParts_Messages" is a temporary table.
 

I tried to increase 'shared_buffers', 'temp_buffers' and 'max_locks_per_transaction' settings appreciably (all others are default).

Can we help you?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

But this didn't change anything.  

How can I determine what kind of resource is unavailable or what is wrong?

Thanks.   Received on Thu Dec 20 08:32:01 2007