Re: [sqlsmith] Failing assertions in spgtextproc.c

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [sqlsmith] Failing assertions in spgtextproc.c
Дата
Msg-id 20151219184219.yhuvzchqwp3dftm7@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [sqlsmith] Failing assertions in spgtextproc.c  (Andreas Seltenreich <seltenreich@gmx.de>)
Список pgsql-hackers
On 2015-12-19 07:04:09 +0100, Andreas Seltenreich wrote:
> output below.  Since sqlsmith ist no longer restricted to read-only
> statements, the chances for reproduction are low :-/.

How many backends are concurrently writing data with sqlsmith? Just one?
If so, and possibly even otherwise, it might be worthwhile to set up
PITR and record the LSN at the beginning of transactions. That'd allow
to replay the state of the database to just before the failing xact.

Regards,

Andres



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