Re: [PATCH] Add CHECK_FOR_INTERRUPTS in scram_SaltedPassword loop.

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: [PATCH] Add CHECK_FOR_INTERRUPTS in scram_SaltedPassword loop.
Дата
Msg-id CAJ7c6TMdDdC5f1qmS=UVx22Bvjqz=PhY=aeefwoXxGc_bK+WKQ@mail.gmail.com
обсуждение исходный текст
Ответ на [PATCH] Add CHECK_FOR_INTERRUPTS in scram_SaltedPassword loop.  (Bowen Shi <zxwsbg12138@gmail.com>)
Ответы Re: [PATCH] Add CHECK_FOR_INTERRUPTS in scram_SaltedPassword loop.  (Daniel Gustafsson <daniel@yesql.se>)
Список pgsql-hackers
Hi,

> When the scram_iterations value is set too large, the backend would hang for
> a long time.  And we can't use Ctrl+C to cancel this query, cause the loop don't
> process signal interrupts.
>
> Add CHECK_FOR_INTERRUPTS within the loop of scram_SaltedPassword
> to handle any signals received during this period may be a good choice.
>
> I wrote a patch to solve this problem. What's your suggestions?

Thanks for the patch.

It sort of makes sense. I wonder though if we should limit the maximum
number of iterations instead. If somebody specified 1_000_000+
iteration this could also indicate a user error.

If we want to add CHECK_FOR_INTERRUPTS inside the loop I think a brief
comment would be appropriate.

-- 
Best regards,
Aleksander Alekseev



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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: remaining sql/json patches
Следующее
От: Aleksander Alekseev
Дата:
Сообщение: Re: How to accurately determine when a relation should use local buffers?