Re: [sqlsmith] Failing assertions in spgtextproc.c - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [sqlsmith] Failing assertions in spgtextproc.c
Date
Msg-id 20151219184219.yhuvzchqwp3dftm7@alap3.anarazel.de
Whole thread Raw
In response to Re: [sqlsmith] Failing assertions in spgtextproc.c  (Andreas Seltenreich <seltenreich@gmx.de>)
List 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 by date:

Previous
From: Rushabh Lathia
Date:
Subject: Re: Getting sorted data from foreign server for merge join
Next
From: Albe Laurenz
Date:
Subject: Re: Costing foreign joins in postgres_fdw