BUG #14098: misleading message "out of shared memory" when lock table space exhausted

Поиск
Список
Период
Сортировка
От johnlumby@hotmail.com
Тема BUG #14098: misleading message "out of shared memory" when lock table space exhausted
Дата
Msg-id 20160418164648.26012.40241@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14098: misleading message "out of shared memory" when lock table space exhausted  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14098
Logged by:          John Lumby
Email address:      johnlumby@hotmail.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #14089: ON CONFLICT allows function variables in index expressions
Следующее
От: imraan@techie.com
Дата:
Сообщение: BUG #14099: Altering temporary sequence in session has no effect