Re: [sqlsmith] Failing assertions in spgtextproc.c

From: Andres Freund <andres(at)anarazel(dot)de>
To: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
Cc: Peter Geoghegan <pg(at)heroku(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [sqlsmith] Failing assertions in spgtextproc.c
Date: 2015-12-19 18:42:19
Message-ID: 20151219184219.yhuvzchqwp3dftm7@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Albe Laurenz 2015-12-19 20:55:06 Re: Costing foreign joins in postgres_fdw
Previous Message Rushabh Lathia 2015-12-19 18:34:06 Re: Getting sorted data from foreign server for merge join