Update or Delete causes canceling of long running slave queries

Поиск
Список
Период
Сортировка
От Viswanath
Тема Update or Delete causes canceling of long running slave queries
Дата
Msg-id 1463060247489-5903250.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Update or Delete causes canceling of long running slave queries  (Sameer Kumar <sameer.kumar@ashnik.com>)
Re: Update or Delete causes canceling of long running slave queries  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Hi,
I have the following configurations.

On master:
autovacuum=off
vacuum_defer_cleanup_age=0

On slave:
hot_standby_feedback = off
max_standby_streaming_delay = 30s

Now when I try to run a long query on slave and do some update or delete on
the table on master I am getting the following error.

ERROR:  canceling statement due to conflict with recovery
DETAIL:  User query might have needed to see row versions that must be
removed.

The error code was : 40001

I am not running vacuum manually and autovacuum is 'off'
What could possibly causing the conflict?



--
View this message in context:
http://postgresql.nabble.com/Update-or-Delete-causes-canceling-of-long-running-slave-queries-tp5903250.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: index on ILIKE/LIKE - PostgreSQL 9.2
Следующее
От: db042190
Дата:
Сообщение: downloaded 9.1 pg driver but odbcad32 doesnt see it