Query cancellation on hot standby because of buffer pins
От | Drazen Kacar |
---|---|
Тема | Query cancellation on hot standby because of buffer pins |
Дата | |
Msg-id | CAFxrd3tm_1_4UUL4ULnPzB04JJbvM1FdHpOMuF3fC7dW_8kJ2Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Query cancellation on hot standby because of buffer
pins
|
Список | pgsql-admin |
I'm seeing query cancellation on hot standby (Postgres 9.3.4, configured with hot_standby_feedback=on) because of buffer pins being held for too long.
Database message looks like this:ERROR: canceling statement due to conflict with recovery
DETAIL: User was holding shared buffer pin for too long.
STATEMENT: ...
http://t61224.db-postgresql-bugs.dbtalk.info/bug-7546-backups-on-hot-standby-cancelled-despite-hot-standby-on-t61224.html
В списке pgsql-admin по дате отправления: