Re: [HACKERS] logical replication - still unstable after all thesemonths

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: [HACKERS] logical replication - still unstable after all thesemonths
Дата
Msg-id 221f0df9-2af6-4a4f-8c4c-7fb5509118e3@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: [HACKERS] logical replication - still unstable after all thesemonths  (Erik Rijkers <er@xs4all.nl>)
Ответы Re: [HACKERS] logical replication - still unstable after all thesemonths  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-hackers
On 05/06/17 00:04, Erik Rijkers wrote:

> On 2017-05-31 16:20, Erik Rijkers wrote:
>> On 2017-05-31 11:16, Petr Jelinek wrote:
>> [...]
>>> Thanks to Mark's offer I was able to study the issue as it happened and
>>> found the cause of this.
>>>
>>> [0001-Improve-handover-logic-between-sync-and-apply-worker.patch]
>>
>> This looks good:
>>
>> -- out_20170531_1141.txt
>>     100 -- pgbench -c 90 -j 8 -T 60 -P 12 -n   --  scale 25
>>     100 -- All is well.
>>
>> So this is 100x a 1-minute test with 100x success. (This on the most
>> fastidious machine (slow disks, meagre specs) that used to give 15%
>> failures)
>
> [Improve-handover-logic-between-sync-and-apply-worker-v2.patch]
>
> No errors after (several days of) running variants of this. (2500x 1 
> minute runs; 12x 1-hour runs)

Same here, no errors with the v2 patch applied (approx 2 days - all 1 
minute runs)

regards

Mark



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Should we standardize on a type for signal handler flags?
Следующее
От: Jing Wang
Дата:
Сообщение: [HACKERS] Support to COMMENT ON DATABASE CURRENT_DATABASE