Re: Potential G2-item cycles under serializable isolation

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Kyle Kingsbury <aphyr(at)jepsen(dot)io>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Potential G2-item cycles under serializable isolation
Date: 2020-06-08 02:59:09
Message-ID: CAH2-Wzn=YB0g6qN=HSWgXFy6ro3rm5LCV0AdPgSFGsP_Ersi7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, Jun 7, 2020 at 7:54 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> In the example RR log that I posted the other day, the update + abort
> transaction was here (jepsen process 39/xid 1680826):
>
> [rr 316505 584863]
> 1591388175.991-316505-7/407-1680826-SELECT-5edaa7f9.4d459-jepsen
> process 39 LOG: execute <unnamed>: select (val) from txn0 where id =
> $1
> 1591388175.991-316505-7/407-1680826-SELECT-5edaa7f9.4d459-jepsen
> process 39 DETAIL: parameters: $1 = '1470'
> [rr 316505 584881]
> 1591388175.992-316505-7/0-1680826-ROLLBACK-5edaa7f9.4d459-jepsen
> process 39 LOG: execute <unnamed>: ROLLBACK

I mean in the case of the G2-Item that Kyle chose to focus on
yesterday specifically -- G2-item #0 from the log_rr_recording.log
execution.

--
Peter Geoghegan

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-06-08 05:45:30 BUG #16484: pg_regress fails with --outputdir parameter
Previous Message Peter Geoghegan 2020-06-08 02:54:21 Re: Potential G2-item cycles under serializable isolation