Skip site navigation (1) Skip section navigation (2)

LockAcquire: lock table 1 is out of memory

From: Betsy Barker <betsy(dot)barker(at)supportservicesinc(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: LockAcquire: lock table 1 is out of memory
Date: 2004-09-13 15:16:58
Message-ID: 20040913091658.49270015.betsy.barker@supportservicesinc.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,
I am getting the following error while running a series of stored procedures. I have increased the max_locks_per_transaction
parameter from 64 (the default) to 128 and I still received this error. Can anyone tell me waht else I could do? 

Thank you!

WARNING:  ShmemAlloc: out of memory
WARNING:  Error occurred while executing PL/pgSQL function get_facility_percentiles
WARNING:  line 37 at execute statement
ERROR:  LockAcquire: lock table 1 is out of memory

-- 
Betsy Barker
IT Manager
Support Services, Inc
(720)489-1630 X 38

Responses

pgsql-novice by date

Next:From: A GilmoreDate: 2004-09-13 16:30:54
Subject: Re: timestamp precision
Previous:From: Tom LaneDate: 2004-09-13 14:47:55
Subject: Re: LockAcquire: lock table 1 is out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group