From: | johnlumby(at)hotmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14098: misleading message "out of shared memory" when lock table space exhausted |
Date: | 2016-04-18 16:46:48 |
Message-ID: | 20160418164648.26012.40241@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14098
Logged by: John Lumby
Email address: johnlumby(at)hotmail(dot)com
PostgreSQL version: 9.5.2
Operating system: linux 64-bit
Description:
If postgresql exhausts the space reserved for locks, whose size is defined
by
max_locks_per_transaction * (max_connections + max_prepared_transactions)
locks,
then it issues this message :
psql: FATAL: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
The words "out of shared memory" are misleading (and ungrammatical, and
somewhat contradict the HINT).
Shared mem space is not exhausted, lock table space is exhausted.
Please change the message to
psql: FATAL: lock table space is exhausted
HINT: You might need to increase max_locks_per_transaction.
I believe all cases of this msg are in
src/backend/storage/lmgr/lock.c
From | Date | Subject | |
---|---|---|---|
Next Message | imraan | 2016-04-18 17:13:47 | BUG #14099: Altering temporary sequence in session has no effect |
Previous Message | David G. Johnston | 2016-04-18 14:54:16 | Re: BUG #14089: ON CONFLICT allows function variables in index expressions |