From: | "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: ERROR: Not enough resources are available to complete this request. |
Date: | 2007-12-20 13:26:16 |
Message-ID: | 528853D3C5ED2C4AA8990B504BA7FB850106DEA8@sol.transas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Zubkovsky,
Sergey
Sent: Thursday, December 20, 2007 4:14 PM
To: pgsql-novice(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-12-20 15:47:06 | Re: ERROR: Not enough resources are available to complete this request. |
Previous Message | Zubkovsky, Sergey | 2007-12-20 13:14:24 | ERROR: Not enough resources are available to complete this request. |