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 по дате отправления:

Предыдущее
От: Rushabh Lathia
Дата:
Сообщение: Re: Getting sorted data from foreign server for merge join
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Costing foreign joins in postgres_fdw