[YSQL][SQLsmith] ERROR: Operation failed. Try again: [Operation failed. Try again (yb/tablet/transaction_participant.cc:296): Unknown transaction, could be recently aborted (pgsql error 40001)] #11226
Description
Jira Link: DB-866
Description
Sporadic SQLsmith failure during UPDATEs, can't reproduce:
CREATE TABLE test_yb (col int);
update public.test_yb set
col = public.test_yb.col
returning
public.test_yb.col as c0,
(select pg_catalog.max(amopstrategy) from pg_catalog.pg_amop)
as c1,
(select pg_catalog.stddev_pop(heap_blks_read) from pg_catalog.pg_statio_user_tables)
as c2,
public.test_yb.col as c3,
public.test_yb.col as c4,
public.test_yb.col as c5,
public.test_yb.col as c6;
Failed with:
ERROR: Operation failed. Try again: [Operation failed. Try again (yb/tablet/transaction_participant.cc:296): Unknown transaction, could be recently aborted: 40d74095-d58f-40a6-83f5-8367f9503a10 (pgsql error 40001)]