Postgres Pro
Downloads
Home   >   mailing lists

Thread: LockAcquire: lock table 1 is out of memory

LockAcquire: lock table 1 is out of memory

From
Betsy Barker
Date:
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

Re: LockAcquire: lock table 1 is out of memory

From
Tom Lane
Date:
Betsy Barker <betsy.barker@supportservicesinc.com> writes:
> 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?

Raise it further ...

Note also that you need a postmaster restart (not just SIGHUP) to make
the increase take effect.

            regards, tom lane

Re: LockAcquire: lock table 1 is out of memory

From
Betsy Barker
Date:
I raised the parameter to 256 and the process finished. Thank you Tom. Does raising that parameter cause the database
toslow down? The process ended up taking 14.5 hours to finish! That seems like a long long time.  

Also, do you think that the use of a temporary table inside an inner loop, being created and dropped over and over
againcould have caused the problem in the beginning? 

Thank you,
Betsy Barker

On Mon, 13 Sep 2004 10:47:55 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Betsy Barker <betsy.barker@supportservicesinc.com> writes:
> > 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?
>
> Raise it further ...
>
> Note also that you need a postmaster restart (not just SIGHUP) to make
> the increase take effect.
>
>             regards, tom lane
>


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

unsubcribe

From
Burçin Gülen
Date:
Once I subcribed this mail group but I wish to unsubscribe now.
Can anyone help me by unsubscribing me or tell me how I can do it.

Thanks for your help.

Burçin