Обсуждение: ERROR: Not enough resources are available to complete this request.

Поиск
Список
Период
Сортировка

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

От
"Zubkovsky, Sergey"
Дата:

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

 

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  )"

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).

But this didn’t change anything.

 

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

Thanks.

 

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

От
"Zubkovsky, Sergey"
Дата:

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

 

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  )"

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).

But this didn’t change anything.

 

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

Thanks.

 

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

От
Tom Lane
Дата:
"Zubkovsky, Sergey" <Sergey.Zubkovsky@transas.com> writes:
> 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

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

You tell us.  P0001 is RAISE_EXCEPTION, meaning that this message is
coming from a RAISE EXCEPTION command in your own plpgsql code.

            regards, tom lane

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

От
"Zubkovsky, Sergey"
Дата:
Yes, it's my negligence!

Thank you, Tom!


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, December 20, 2007 6:47 PM
To: Zubkovsky, Sergey
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] ERROR: Not enough resources are available to
complete this request.

"Zubkovsky, Sergey" <Sergey.Zubkovsky@transas.com> writes:
> 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

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

You tell us.  P0001 is RAISE_EXCEPTION, meaning that this message is
coming from a RAISE EXCEPTION command in your own plpgsql code.

            regards, tom lane