[YSQL][SQLsmith] ERROR: Remote error: Illegal state (yb/client/transaction.cc:678): Attempt to release transaction in the wrong state: kAborted

[def-]

Jira Link: DB-1051

Description

This happens sporadically with SQLsmith, can't reproduce it:

CREATE TABLE pg_temp_foo (col int);

update public.pg_temp_foo set
  col = public.pg_temp_foo.col
returning
  public.pg_temp_foo.col as c0,
  public.pg_temp_foo.col as c1,
  public.pg_temp_foo.col as c2,
  public.pg_temp_foo.col as c3;

Fails with:

ERROR:  Remote error: Illegal state (yb/client/transaction.cc:678): Attempt to release transaction in the wrong state 26e34c72-9ccf-4d4a-99d0-c0c0e29f97a7: kAborted

[tedyu]

Can you outline the table definition for public.pg_temp_foo ?

Thanks

[def-]

CREATE TABLE pg_temp_foo (col int);

It's possible that this is caused by concurrent queries running, which would explain why I can't reproduce it easily in isolation.