2025-01-09 14:06:06.248 UTC [14426][postmaster] LOG:  starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-01-09 14:06:06.248 UTC [14426][postmaster] LOG:  listening on Unix socket "/tmp/pg_regress-COg2XT/.s.PGSQL.65312"
2025-01-09 14:06:06.274 UTC [14434][startup] LOG:  database system was shut down at 2025-01-09 14:06:00 UTC
2025-01-09 14:06:06.292 UTC [14435][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:06.292 UTC [14435][client backend] [[unknown]][:0] FATAL:  the database system is starting up
2025-01-09 14:06:06.304 UTC [14426][postmaster] LOG:  database system is ready to accept connections
2025-01-09 14:06:06.364 UTC [14439][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:06.366 UTC [14439][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:06.366 UTC [14439][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=pg_regress
2025-01-09 14:06:06.443 UTC [14439][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.080 user=postgres database=postgres host=[local]
2025-01-09 14:06:06.520 UTC [14454][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:06.521 UTC [14454][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:06.521 UTC [14454][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=pg_regress
2025-01-09 14:06:06.739 UTC [14454][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.228 user=postgres database=postgres host=[local]
2025-01-09 14:06:06.848 UTC [14485][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:06.849 UTC [14485][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:06.849 UTC [14485][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly
2025-01-09 14:06:06.924 UTC [14489][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:06.926 UTC [14489][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:06.926 UTC [14489][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly
2025-01-09 14:06:06.957 UTC [14492][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:06.959 UTC [14492][client backend] [[unknown]][4/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:06.959 UTC [14492][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly
2025-01-09 14:06:06.974 UTC [14498][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:06.975 UTC [14498][client backend] [[unknown]][5/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:06.975 UTC [14498][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly
2025-01-09 14:06:07.035 UTC [14489][client backend] [isolation/read-only-anomaly/s1][:0] LOG:  disconnection: session time: 0:00:00.119 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.036 UTC [14492][client backend] [isolation/read-only-anomaly/s2][:0] LOG:  disconnection: session time: 0:00:00.083 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.044 UTC [14498][client backend] [isolation/read-only-anomaly/s3][:0] LOG:  disconnection: session time: 0:00:00.071 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.068 UTC [14485][client backend] [isolation/read-only-anomaly/control connection][:0] LOG:  disconnection: session time: 0:00:00.227 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.112 UTC [14517][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.114 UTC [14517][client backend] [[unknown]][6/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.114 UTC [14517][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly-2
2025-01-09 14:06:07.152 UTC [14519][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.153 UTC [14519][client backend] [[unknown]][7/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.153 UTC [14519][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly-2
2025-01-09 14:06:07.200 UTC [14520][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.201 UTC [14520][client backend] [[unknown]][8/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.201 UTC [14520][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly-2
2025-01-09 14:06:07.218 UTC [14523][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.220 UTC [14523][client backend] [[unknown]][9/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.220 UTC [14523][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly-2
2025-01-09 14:06:07.283 UTC [14520][client backend] [isolation/read-only-anomaly-2/s2][8/4:755] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:07.283 UTC [14520][client backend] [isolation/read-only-anomaly-2/s2][8/4:755] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:07.283 UTC [14520][client backend] [isolation/read-only-anomaly-2/s2][8/4:755] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:07.283 UTC [14520][client backend] [isolation/read-only-anomaly-2/s2][8/4:755] STATEMENT:  UPDATE bank_account SET balance = -11 WHERE id = 'X';
2025-01-09 14:06:07.291 UTC [14519][client backend] [isolation/read-only-anomaly-2/s1][:0] LOG:  disconnection: session time: 0:00:00.146 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.292 UTC [14520][client backend] [isolation/read-only-anomaly-2/s2][:0] LOG:  disconnection: session time: 0:00:00.099 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.298 UTC [14523][client backend] [isolation/read-only-anomaly-2/s3][:0] LOG:  disconnection: session time: 0:00:00.085 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.312 UTC [14517][client backend] [isolation/read-only-anomaly-2/control connection][:0] LOG:  disconnection: session time: 0:00:00.204 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.422 UTC [14575][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.424 UTC [14575][client backend] [[unknown]][10/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.425 UTC [14575][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly-3
2025-01-09 14:06:07.442 UTC [14578][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.444 UTC [14578][client backend] [[unknown]][11/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.444 UTC [14578][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly-3
2025-01-09 14:06:07.458 UTC [14581][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.462 UTC [14581][client backend] [[unknown]][12/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.462 UTC [14581][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly-3
2025-01-09 14:06:07.499 UTC [14591][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.501 UTC [14591][client backend] [[unknown]][13/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.501 UTC [14591][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-only-anomaly-3
2025-01-09 14:06:07.571 UTC [14575][client backend] [isolation/read-only-anomaly-3/control connection][:0] LOG:  disconnection: session time: 0:00:00.149 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.571 UTC [14581][client backend] [isolation/read-only-anomaly-3/s2][:0] LOG:  disconnection: session time: 0:00:00.114 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.573 UTC [14578][client backend] [isolation/read-only-anomaly-3/s1][:0] LOG:  disconnection: session time: 0:00:00.131 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.579 UTC [14591][client backend] [isolation/read-only-anomaly-3/s3][:0] LOG:  disconnection: session time: 0:00:00.081 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.757 UTC [14653][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.758 UTC [14653][client backend] [[unknown]][14/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.758 UTC [14653][client backend] [[unknown]][14/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique
2025-01-09 14:06:07.816 UTC [14664][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.817 UTC [14664][client backend] [[unknown]][15/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.817 UTC [14664][client backend] [[unknown]][15/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique
2025-01-09 14:06:07.845 UTC [14666][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:07.846 UTC [14666][client backend] [[unknown]][16/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:07.847 UTC [14666][client backend] [[unknown]][16/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique
2025-01-09 14:06:07.883 UTC [14666][client backend] [isolation/read-write-unique/s2][16/3:763] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:07.883 UTC [14666][client backend] [isolation/read-write-unique/s2][16/3:763] DETAIL:  Reason code: Canceled on identification as a pivot, during conflict in checking.
2025-01-09 14:06:07.883 UTC [14666][client backend] [isolation/read-write-unique/s2][16/3:763] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:07.883 UTC [14666][client backend] [isolation/read-write-unique/s2][16/3:763] STATEMENT:  INSERT INTO test VALUES (42);
2025-01-09 14:06:07.915 UTC [14666][client backend] [isolation/read-write-unique/s2][16/4:767] ERROR:  duplicate key value violates unique constraint "test_pkey"
2025-01-09 14:06:07.915 UTC [14666][client backend] [isolation/read-write-unique/s2][16/4:767] DETAIL:  Key (i)=(42) already exists.
2025-01-09 14:06:07.915 UTC [14666][client backend] [isolation/read-write-unique/s2][16/4:767] STATEMENT:  INSERT INTO test VALUES (42);
2025-01-09 14:06:07.940 UTC [14666][client backend] [isolation/read-write-unique/s2][:0] LOG:  disconnection: session time: 0:00:00.094 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.950 UTC [14664][client backend] [isolation/read-write-unique/s1][:0] LOG:  disconnection: session time: 0:00:00.140 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:07.971 UTC [14653][client backend] [isolation/read-write-unique/control connection][:0] LOG:  disconnection: session time: 0:00:00.214 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.076 UTC [14681][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.077 UTC [14681][client backend] [[unknown]][17/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.077 UTC [14681][client backend] [[unknown]][17/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique-2
2025-01-09 14:06:08.112 UTC [14685][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.115 UTC [14685][client backend] [[unknown]][18/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.115 UTC [14685][client backend] [[unknown]][18/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique-2
2025-01-09 14:06:08.142 UTC [14687][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.145 UTC [14687][client backend] [[unknown]][19/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.145 UTC [14687][client backend] [[unknown]][19/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique-2
2025-01-09 14:06:08.181 UTC [14687][client backend] [isolation/read-write-unique-2/s2][19/3:771] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:08.181 UTC [14687][client backend] [isolation/read-write-unique-2/s2][19/3:771] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:08.181 UTC [14687][client backend] [isolation/read-write-unique-2/s2][19/3:771] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:08.181 UTC [14687][client backend] [isolation/read-write-unique-2/s2][19/3:771] STATEMENT:  INSERT INTO test VALUES (42);
2025-01-09 14:06:08.240 UTC [14687][client backend] [isolation/read-write-unique-2/s2][19/4:775] ERROR:  duplicate key value violates unique constraint "test_pkey"
2025-01-09 14:06:08.240 UTC [14687][client backend] [isolation/read-write-unique-2/s2][19/4:775] DETAIL:  Key (i)=(42) already exists.
2025-01-09 14:06:08.240 UTC [14687][client backend] [isolation/read-write-unique-2/s2][19/4:775] STATEMENT:  INSERT INTO test VALUES (42);
2025-01-09 14:06:08.252 UTC [14685][client backend] [isolation/read-write-unique-2/s1][:0] LOG:  disconnection: session time: 0:00:00.142 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.256 UTC [14687][client backend] [isolation/read-write-unique-2/s2][:0] LOG:  disconnection: session time: 0:00:00.115 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.276 UTC [14681][client backend] [isolation/read-write-unique-2/control connection][:0] LOG:  disconnection: session time: 0:00:00.203 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.324 UTC [14699][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.325 UTC [14699][client backend] [[unknown]][20/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.325 UTC [14699][client backend] [[unknown]][20/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique-3
2025-01-09 14:06:08.355 UTC [14701][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.357 UTC [14701][client backend] [[unknown]][21/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.357 UTC [14701][client backend] [[unknown]][21/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique-3
2025-01-09 14:06:08.391 UTC [14704][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.392 UTC [14704][client backend] [[unknown]][22/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.392 UTC [14704][client backend] [[unknown]][22/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique-3
2025-01-09 14:06:08.440 UTC [14704][client backend] [isolation/read-write-unique-3/s2][22/3:779] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:08.440 UTC [14704][client backend] [isolation/read-write-unique-3/s2][22/3:779] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:08.440 UTC [14704][client backend] [isolation/read-write-unique-3/s2][22/3:779] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:08.440 UTC [14704][client backend] [isolation/read-write-unique-3/s2][22/3:779] CONTEXT:  SQL function "insert_unique" statement 1
2025-01-09 14:06:08.440 UTC [14704][client backend] [isolation/read-write-unique-3/s2][22/3:779] STATEMENT:  SELECT insert_unique(1, '2');
2025-01-09 14:06:08.449 UTC [14701][client backend] [isolation/read-write-unique-3/s1][:0] LOG:  disconnection: session time: 0:00:00.096 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.456 UTC [14704][client backend] [isolation/read-write-unique-3/s2][:0] LOG:  disconnection: session time: 0:00:00.067 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.465 UTC [14699][client backend] [isolation/read-write-unique-3/control connection][:0] LOG:  disconnection: session time: 0:00:00.141 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.543 UTC [14715][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.545 UTC [14715][client backend] [[unknown]][23/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.545 UTC [14715][client backend] [[unknown]][23/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique-4
2025-01-09 14:06:08.555 UTC [14717][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.556 UTC [14717][client backend] [[unknown]][24/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.556 UTC [14717][client backend] [[unknown]][24/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique-4
2025-01-09 14:06:08.578 UTC [14719][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.581 UTC [14719][client backend] [[unknown]][25/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.581 UTC [14719][client backend] [[unknown]][25/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/read-write-unique-4
2025-01-09 14:06:08.628 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/3:783] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:08.628 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/3:783] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:08.628 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/3:783] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:08.628 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/3:783] STATEMENT:  INSERT INTO invoice VALUES (2016, 3);
2025-01-09 14:06:08.652 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/4:787] ERROR:  duplicate key value violates unique constraint "invoice_pkey"
2025-01-09 14:06:08.652 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/4:787] DETAIL:  Key (year, invoice_number)=(2016, 3) already exists.
2025-01-09 14:06:08.652 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/4:787] STATEMENT:  INSERT INTO invoice VALUES (2016, 3);
2025-01-09 14:06:08.672 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/5:791] ERROR:  duplicate key value violates unique constraint "invoice_pkey"
2025-01-09 14:06:08.672 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/5:791] DETAIL:  Key (year, invoice_number)=(2016, 3) already exists.
2025-01-09 14:06:08.672 UTC [14719][client backend] [isolation/read-write-unique-4/s2][25/5:791] STATEMENT:  INSERT INTO invoice VALUES (2016, 3);
2025-01-09 14:06:08.678 UTC [14717][client backend] [isolation/read-write-unique-4/s1][:0] LOG:  disconnection: session time: 0:00:00.123 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.682 UTC [14719][client backend] [isolation/read-write-unique-4/s2][:0] LOG:  disconnection: session time: 0:00:00.105 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.691 UTC [14715][client backend] [isolation/read-write-unique-4/control connection][:0] LOG:  disconnection: session time: 0:00:00.159 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.735 UTC [14739][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.737 UTC [14739][client backend] [[unknown]][26/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.737 UTC [14739][client backend] [[unknown]][26/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/simple-write-skew
2025-01-09 14:06:08.747 UTC [14741][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.748 UTC [14741][client backend] [[unknown]][27/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.749 UTC [14741][client backend] [[unknown]][27/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/simple-write-skew
2025-01-09 14:06:08.769 UTC [14744][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.770 UTC [14744][client backend] [[unknown]][28/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.770 UTC [14744][client backend] [[unknown]][28/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/simple-write-skew
2025-01-09 14:06:08.816 UTC [14744][client backend] [isolation/simple-write-skew/s2][28/4:799] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:08.816 UTC [14744][client backend] [isolation/simple-write-skew/s2][28/4:799] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:08.816 UTC [14744][client backend] [isolation/simple-write-skew/s2][28/4:799] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:08.816 UTC [14744][client backend] [isolation/simple-write-skew/s2][28/4:799] STATEMENT:  COMMIT;
2025-01-09 14:06:08.827 UTC [14741][client backend] [isolation/simple-write-skew/s1][27/5:802] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:08.827 UTC [14741][client backend] [isolation/simple-write-skew/s1][27/5:802] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:08.827 UTC [14741][client backend] [isolation/simple-write-skew/s1][27/5:802] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:08.827 UTC [14741][client backend] [isolation/simple-write-skew/s1][27/5:802] STATEMENT:  COMMIT;
2025-01-09 14:06:08.849 UTC [14744][client backend] [isolation/simple-write-skew/s2][28/6:806] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:08.849 UTC [14744][client backend] [isolation/simple-write-skew/s2][28/6:806] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:08.849 UTC [14744][client backend] [isolation/simple-write-skew/s2][28/6:806] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:08.849 UTC [14744][client backend] [isolation/simple-write-skew/s2][28/6:806] STATEMENT:  COMMIT;
2025-01-09 14:06:08.872 UTC [14741][client backend] [isolation/simple-write-skew/s1][27/7:811] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:08.872 UTC [14741][client backend] [isolation/simple-write-skew/s1][27/7:811] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:08.872 UTC [14741][client backend] [isolation/simple-write-skew/s1][27/7:811] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:08.872 UTC [14741][client backend] [isolation/simple-write-skew/s1][27/7:811] STATEMENT:  COMMIT;
2025-01-09 14:06:08.928 UTC [14741][client backend] [isolation/simple-write-skew/s1][:0] LOG:  disconnection: session time: 0:00:00.182 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.932 UTC [14744][client backend] [isolation/simple-write-skew/s2][:0] LOG:  disconnection: session time: 0:00:00.164 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.952 UTC [14739][client backend] [isolation/simple-write-skew/control connection][:0] LOG:  disconnection: session time: 0:00:00.216 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:08.991 UTC [14758][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:08.992 UTC [14758][client backend] [[unknown]][29/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:08.992 UTC [14758][client backend] [[unknown]][29/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/receipt-report
2025-01-09 14:06:09.009 UTC [14759][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:09.011 UTC [14759][client backend] [[unknown]][30/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:09.011 UTC [14759][client backend] [[unknown]][30/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/receipt-report
2025-01-09 14:06:09.036 UTC [14761][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:09.037 UTC [14761][client backend] [[unknown]][31/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:09.037 UTC [14761][client backend] [[unknown]][31/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/receipt-report
2025-01-09 14:06:09.072 UTC [14763][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:09.073 UTC [14763][client backend] [[unknown]][32/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:09.073 UTC [14763][client backend] [[unknown]][32/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/receipt-report
2025-01-09 14:06:09.749 UTC [14763][client backend] [isolation/receipt-report/s3][32/18:0] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:09.749 UTC [14763][client backend] [isolation/receipt-report/s3][32/18:0] DETAIL:  Reason code: Canceled on conflict out to pivot 878, during read.
2025-01-09 14:06:09.749 UTC [14763][client backend] [isolation/receipt-report/s3][32/18:0] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:09.749 UTC [14763][client backend] [isolation/receipt-report/s3][32/18:0] STATEMENT:  SELECT * FROM receipt WHERE deposit_date = DATE '2008-12-22';
2025-01-09 14:06:09.780 UTC [14759][client backend] [isolation/receipt-report/s1][30/19:882] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:09.780 UTC [14759][client backend] [isolation/receipt-report/s1][30/19:882] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:09.780 UTC [14759][client backend] [isolation/receipt-report/s1][30/19:882] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:09.780 UTC [14759][client backend] [isolation/receipt-report/s1][30/19:882] STATEMENT:  COMMIT;
2025-01-09 14:06:09.814 UTC [14759][client backend] [isolation/receipt-report/s1][30/20:886] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:09.814 UTC [14759][client backend] [isolation/receipt-report/s1][30/20:886] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:09.814 UTC [14759][client backend] [isolation/receipt-report/s1][30/20:886] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:09.814 UTC [14759][client backend] [isolation/receipt-report/s1][30/20:886] STATEMENT:  COMMIT;
2025-01-09 14:06:11.197 UTC [14763][client backend] [isolation/receipt-report/s3][32/68:0] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:11.197 UTC [14763][client backend] [isolation/receipt-report/s3][32/68:0] DETAIL:  Reason code: Canceled on conflict out to pivot 1079, during read.
2025-01-09 14:06:11.197 UTC [14763][client backend] [isolation/receipt-report/s3][32/68:0] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:11.197 UTC [14763][client backend] [isolation/receipt-report/s3][32/68:0] STATEMENT:  SELECT * FROM receipt WHERE deposit_date = DATE '2008-12-22';
2025-01-09 14:06:11.232 UTC [14759][client backend] [isolation/receipt-report/s1][30/69:1083] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:11.232 UTC [14759][client backend] [isolation/receipt-report/s1][30/69:1083] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:11.232 UTC [14759][client backend] [isolation/receipt-report/s1][30/69:1083] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:11.232 UTC [14759][client backend] [isolation/receipt-report/s1][30/69:1083] STATEMENT:  COMMIT;
2025-01-09 14:06:11.262 UTC [14759][client backend] [isolation/receipt-report/s1][30/70:1087] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:11.262 UTC [14759][client backend] [isolation/receipt-report/s1][30/70:1087] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:11.262 UTC [14759][client backend] [isolation/receipt-report/s1][30/70:1087] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:11.262 UTC [14759][client backend] [isolation/receipt-report/s1][30/70:1087] STATEMENT:  COMMIT;
2025-01-09 14:06:14.612 UTC [14759][client backend] [isolation/receipt-report/s1][:0] LOG:  disconnection: session time: 0:00:05.602 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:14.615 UTC [14761][client backend] [isolation/receipt-report/s2][:0] LOG:  disconnection: session time: 0:00:05.582 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:14.620 UTC [14758][client backend] [isolation/receipt-report/control connection][:0] LOG:  disconnection: session time: 0:00:05.629 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:14.620 UTC [14763][client backend] [isolation/receipt-report/s3][:0] LOG:  disconnection: session time: 0:00:05.559 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:14.675 UTC [15332][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:14.677 UTC [15332][client backend] [[unknown]][33/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:14.677 UTC [15332][client backend] [[unknown]][33/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/temporal-range-integrity
2025-01-09 14:06:14.703 UTC [15333][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:14.704 UTC [15333][client backend] [[unknown]][34/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:14.704 UTC [15333][client backend] [[unknown]][34/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/temporal-range-integrity
2025-01-09 14:06:14.738 UTC [15337][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:14.741 UTC [15337][client backend] [[unknown]][35/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:14.741 UTC [15337][client backend] [[unknown]][35/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/temporal-range-integrity
2025-01-09 14:06:14.837 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/4:1663] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:14.837 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/4:1663] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:14.837 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/4:1663] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:14.837 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/4:1663] STATEMENT:  DELETE FROM statute WHERE statute_cite = '123.45(1)a' AND eff_date = DATE '2008-01-01';
2025-01-09 14:06:14.879 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/5:1667] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:14.879 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/5:1667] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:14.879 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/5:1667] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:14.879 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/5:1667] STATEMENT:  COMMIT;
2025-01-09 14:06:14.921 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/6:1670] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:14.921 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/6:1670] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:14.921 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/6:1670] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:14.921 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/6:1670] STATEMENT:  COMMIT;
2025-01-09 14:06:14.948 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/7:1675] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:14.948 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/7:1675] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:14.948 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/7:1675] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:14.948 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/7:1675] STATEMENT:  DELETE FROM statute WHERE statute_cite = '123.45(1)a' AND eff_date = DATE '2008-01-01';
2025-01-09 14:06:14.999 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/8:1679] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:14.999 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/8:1679] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:14.999 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/8:1679] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:14.999 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/8:1679] STATEMENT:  COMMIT;
2025-01-09 14:06:15.041 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/9:1682] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.041 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/9:1682] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.041 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/9:1682] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.041 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/9:1682] STATEMENT:  COMMIT;
2025-01-09 14:06:15.071 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/10:1686] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.071 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/10:1686] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.071 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/10:1686] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.071 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/10:1686] STATEMENT:  COMMIT;
2025-01-09 14:06:15.096 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/11:1691] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.096 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/11:1691] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.096 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/11:1691] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.096 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/11:1691] STATEMENT:  COMMIT;
2025-01-09 14:06:15.135 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/12:1695] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.135 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/12:1695] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:15.135 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/12:1695] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.135 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/12:1695] STATEMENT:  INSERT INTO offense VALUES (1, '123.45(1)a', DATE '2009-05-15');
2025-01-09 14:06:15.182 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/13:1699] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.182 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/13:1699] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:15.182 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/13:1699] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.182 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/13:1699] STATEMENT:  DELETE FROM statute WHERE statute_cite = '123.45(1)a' AND eff_date = DATE '2008-01-01';
2025-01-09 14:06:15.206 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/14:1703] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.206 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/14:1703] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.206 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/14:1703] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.206 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/14:1703] STATEMENT:  COMMIT;
2025-01-09 14:06:15.245 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/15:1706] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.245 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/15:1706] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.245 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/15:1706] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.245 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/15:1706] STATEMENT:  COMMIT;
2025-01-09 14:06:15.287 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/16:1710] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.287 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/16:1710] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.287 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/16:1710] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.287 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/16:1710] STATEMENT:  COMMIT;
2025-01-09 14:06:15.339 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/17:1715] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.339 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/17:1715] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.339 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/17:1715] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.339 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/17:1715] STATEMENT:  COMMIT;
2025-01-09 14:06:15.368 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/18:1719] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.368 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/18:1719] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:15.368 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/18:1719] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.368 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/18:1719] STATEMENT:  INSERT INTO offense VALUES (1, '123.45(1)a', DATE '2009-05-15');
2025-01-09 14:06:15.411 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/19:1722] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.411 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/19:1722] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.411 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/19:1722] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.411 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][35/19:1722] STATEMENT:  COMMIT;
2025-01-09 14:06:15.435 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/20:1727] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.435 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/20:1727] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.435 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/20:1727] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.435 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/20:1727] STATEMENT:  COMMIT;
2025-01-09 14:06:15.466 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/21:1731] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.466 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/21:1731] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:15.466 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/21:1731] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.466 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][34/21:1731] STATEMENT:  INSERT INTO offense VALUES (1, '123.45(1)a', DATE '2009-05-15');
2025-01-09 14:06:15.516 UTC [15333][client backend] [isolation/temporal-range-integrity/s1][:0] LOG:  disconnection: session time: 0:00:00.814 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:15.518 UTC [15332][client backend] [isolation/temporal-range-integrity/control connection][:0] LOG:  disconnection: session time: 0:00:00.845 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:15.519 UTC [15337][client backend] [isolation/temporal-range-integrity/s2][:0] LOG:  disconnection: session time: 0:00:00.781 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:15.601 UTC [15434][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:15.602 UTC [15434][client backend] [[unknown]][36/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:15.603 UTC [15434][client backend] [[unknown]][36/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/project-manager
2025-01-09 14:06:15.647 UTC [15451][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:15.649 UTC [15451][client backend] [[unknown]][37/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:15.649 UTC [15451][client backend] [[unknown]][37/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/project-manager
2025-01-09 14:06:15.658 UTC [15457][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:15.664 UTC [15457][client backend] [[unknown]][38/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:15.664 UTC [15457][client backend] [[unknown]][38/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/project-manager
2025-01-09 14:06:15.785 UTC [15457][client backend] [isolation/project-manager/s2][38/4:1743] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.785 UTC [15457][client backend] [isolation/project-manager/s2][38/4:1743] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:15.785 UTC [15457][client backend] [isolation/project-manager/s2][38/4:1743] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.785 UTC [15457][client backend] [isolation/project-manager/s2][38/4:1743] STATEMENT:  UPDATE person SET is_project_manager = false WHERE person_id = 1;
2025-01-09 14:06:15.839 UTC [15457][client backend] [isolation/project-manager/s2][38/5:1747] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.839 UTC [15457][client backend] [isolation/project-manager/s2][38/5:1747] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.839 UTC [15457][client backend] [isolation/project-manager/s2][38/5:1747] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.839 UTC [15457][client backend] [isolation/project-manager/s2][38/5:1747] STATEMENT:  COMMIT;
2025-01-09 14:06:15.875 UTC [15451][client backend] [isolation/project-manager/s1][37/6:1750] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.875 UTC [15451][client backend] [isolation/project-manager/s1][37/6:1750] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:15.875 UTC [15451][client backend] [isolation/project-manager/s1][37/6:1750] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.875 UTC [15451][client backend] [isolation/project-manager/s1][37/6:1750] STATEMENT:  COMMIT;
2025-01-09 14:06:15.940 UTC [15457][client backend] [isolation/project-manager/s2][38/7:1755] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:15.940 UTC [15457][client backend] [isolation/project-manager/s2][38/7:1755] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:15.940 UTC [15457][client backend] [isolation/project-manager/s2][38/7:1755] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:15.940 UTC [15457][client backend] [isolation/project-manager/s2][38/7:1755] STATEMENT:  UPDATE person SET is_project_manager = false WHERE person_id = 1;
2025-01-09 14:06:16.007 UTC [15457][client backend] [isolation/project-manager/s2][38/8:1759] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.007 UTC [15457][client backend] [isolation/project-manager/s2][38/8:1759] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.007 UTC [15457][client backend] [isolation/project-manager/s2][38/8:1759] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.007 UTC [15457][client backend] [isolation/project-manager/s2][38/8:1759] STATEMENT:  COMMIT;
2025-01-09 14:06:16.075 UTC [15451][client backend] [isolation/project-manager/s1][37/9:1762] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.075 UTC [15451][client backend] [isolation/project-manager/s1][37/9:1762] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.075 UTC [15451][client backend] [isolation/project-manager/s1][37/9:1762] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.075 UTC [15451][client backend] [isolation/project-manager/s1][37/9:1762] STATEMENT:  COMMIT;
2025-01-09 14:06:16.134 UTC [15457][client backend] [isolation/project-manager/s2][38/10:1766] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.134 UTC [15457][client backend] [isolation/project-manager/s2][38/10:1766] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.134 UTC [15457][client backend] [isolation/project-manager/s2][38/10:1766] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.134 UTC [15457][client backend] [isolation/project-manager/s2][38/10:1766] STATEMENT:  COMMIT;
2025-01-09 14:06:16.201 UTC [15451][client backend] [isolation/project-manager/s1][37/11:1771] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.201 UTC [15451][client backend] [isolation/project-manager/s1][37/11:1771] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.201 UTC [15451][client backend] [isolation/project-manager/s1][37/11:1771] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.201 UTC [15451][client backend] [isolation/project-manager/s1][37/11:1771] STATEMENT:  COMMIT;
2025-01-09 14:06:16.251 UTC [15451][client backend] [isolation/project-manager/s1][37/12:1775] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.251 UTC [15451][client backend] [isolation/project-manager/s1][37/12:1775] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:16.251 UTC [15451][client backend] [isolation/project-manager/s1][37/12:1775] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.251 UTC [15451][client backend] [isolation/project-manager/s1][37/12:1775] STATEMENT:  INSERT INTO project VALUES (101, 'Build Great Wall', 1);
2025-01-09 14:06:16.307 UTC [15457][client backend] [isolation/project-manager/s2][38/13:1779] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.307 UTC [15457][client backend] [isolation/project-manager/s2][38/13:1779] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:16.307 UTC [15457][client backend] [isolation/project-manager/s2][38/13:1779] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.307 UTC [15457][client backend] [isolation/project-manager/s2][38/13:1779] STATEMENT:  UPDATE person SET is_project_manager = false WHERE person_id = 1;
2025-01-09 14:06:16.347 UTC [15457][client backend] [isolation/project-manager/s2][38/14:1783] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.347 UTC [15457][client backend] [isolation/project-manager/s2][38/14:1783] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.347 UTC [15457][client backend] [isolation/project-manager/s2][38/14:1783] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.347 UTC [15457][client backend] [isolation/project-manager/s2][38/14:1783] STATEMENT:  COMMIT;
2025-01-09 14:06:16.392 UTC [15451][client backend] [isolation/project-manager/s1][37/15:1786] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.392 UTC [15451][client backend] [isolation/project-manager/s1][37/15:1786] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.392 UTC [15451][client backend] [isolation/project-manager/s1][37/15:1786] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.392 UTC [15451][client backend] [isolation/project-manager/s1][37/15:1786] STATEMENT:  COMMIT;
2025-01-09 14:06:16.443 UTC [15457][client backend] [isolation/project-manager/s2][38/16:1790] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.443 UTC [15457][client backend] [isolation/project-manager/s2][38/16:1790] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.443 UTC [15457][client backend] [isolation/project-manager/s2][38/16:1790] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.443 UTC [15457][client backend] [isolation/project-manager/s2][38/16:1790] STATEMENT:  COMMIT;
2025-01-09 14:06:16.479 UTC [15451][client backend] [isolation/project-manager/s1][37/17:1795] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.479 UTC [15451][client backend] [isolation/project-manager/s1][37/17:1795] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.479 UTC [15451][client backend] [isolation/project-manager/s1][37/17:1795] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.479 UTC [15451][client backend] [isolation/project-manager/s1][37/17:1795] STATEMENT:  COMMIT;
2025-01-09 14:06:16.516 UTC [15451][client backend] [isolation/project-manager/s1][37/18:1799] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.516 UTC [15451][client backend] [isolation/project-manager/s1][37/18:1799] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:16.516 UTC [15451][client backend] [isolation/project-manager/s1][37/18:1799] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.516 UTC [15451][client backend] [isolation/project-manager/s1][37/18:1799] STATEMENT:  INSERT INTO project VALUES (101, 'Build Great Wall', 1);
2025-01-09 14:06:16.566 UTC [15457][client backend] [isolation/project-manager/s2][38/19:1802] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.566 UTC [15457][client backend] [isolation/project-manager/s2][38/19:1802] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.566 UTC [15457][client backend] [isolation/project-manager/s2][38/19:1802] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.566 UTC [15457][client backend] [isolation/project-manager/s2][38/19:1802] STATEMENT:  COMMIT;
2025-01-09 14:06:16.618 UTC [15451][client backend] [isolation/project-manager/s1][37/20:1807] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.618 UTC [15451][client backend] [isolation/project-manager/s1][37/20:1807] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:16.618 UTC [15451][client backend] [isolation/project-manager/s1][37/20:1807] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.618 UTC [15451][client backend] [isolation/project-manager/s1][37/20:1807] STATEMENT:  COMMIT;
2025-01-09 14:06:16.657 UTC [15451][client backend] [isolation/project-manager/s1][37/21:1811] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.657 UTC [15451][client backend] [isolation/project-manager/s1][37/21:1811] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:16.657 UTC [15451][client backend] [isolation/project-manager/s1][37/21:1811] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.657 UTC [15451][client backend] [isolation/project-manager/s1][37/21:1811] STATEMENT:  INSERT INTO project VALUES (101, 'Build Great Wall', 1);
2025-01-09 14:06:16.739 UTC [15457][client backend] [isolation/project-manager/s2][:0] LOG:  disconnection: session time: 0:00:01.080 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:16.740 UTC [15451][client backend] [isolation/project-manager/s1][:0] LOG:  disconnection: session time: 0:00:01.092 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:16.751 UTC [15434][client backend] [isolation/project-manager/control connection][:0] LOG:  disconnection: session time: 0:00:01.151 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:16.849 UTC [15518][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:16.850 UTC [15518][client backend] [[unknown]][39/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:16.850 UTC [15518][client backend] [[unknown]][39/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/classroom-scheduling
2025-01-09 14:06:16.888 UTC [15520][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:16.889 UTC [15520][client backend] [[unknown]][40/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:16.889 UTC [15520][client backend] [[unknown]][40/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/classroom-scheduling
2025-01-09 14:06:16.916 UTC [15525][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:16.917 UTC [15525][client backend] [[unknown]][41/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:16.917 UTC [15525][client backend] [[unknown]][41/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/classroom-scheduling
2025-01-09 14:06:16.994 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/4:1823] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:16.994 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/4:1823] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:16.994 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/4:1823] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:16.994 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/4:1823] STATEMENT:  UPDATE room_reservation SET start_time = TIMESTAMP WITH TIME ZONE '2010-04-01 13:30', end_time = TIMESTAMP WITH TIME ZONE '2010-04-01 14:30' WHERE room_id = '101' AND start_time = TIMESTAMP WITH TIME ZONE '2010-04-01 10:00';
2025-01-09 14:06:17.019 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/5:1827] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.019 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/5:1827] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.019 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/5:1827] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.019 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/5:1827] STATEMENT:  COMMIT;
2025-01-09 14:06:17.042 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/6:1830] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.042 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/6:1830] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.042 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/6:1830] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.042 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/6:1830] STATEMENT:  COMMIT;
2025-01-09 14:06:17.066 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/7:1835] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.066 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/7:1835] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:17.066 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/7:1835] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.066 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/7:1835] STATEMENT:  UPDATE room_reservation SET start_time = TIMESTAMP WITH TIME ZONE '2010-04-01 13:30', end_time = TIMESTAMP WITH TIME ZONE '2010-04-01 14:30' WHERE room_id = '101' AND start_time = TIMESTAMP WITH TIME ZONE '2010-04-01 10:00';
2025-01-09 14:06:17.094 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/8:1839] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.094 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/8:1839] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.094 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/8:1839] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.094 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/8:1839] STATEMENT:  COMMIT;
2025-01-09 14:06:17.118 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/9:1842] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.118 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/9:1842] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.118 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/9:1842] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.118 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/9:1842] STATEMENT:  COMMIT;
2025-01-09 14:06:17.147 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/10:1846] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.147 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/10:1846] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.147 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/10:1846] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.147 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/10:1846] STATEMENT:  COMMIT;
2025-01-09 14:06:17.170 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/11:1851] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.170 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/11:1851] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.170 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/11:1851] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.170 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/11:1851] STATEMENT:  COMMIT;
2025-01-09 14:06:17.194 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/12:1855] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.194 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/12:1855] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:17.194 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/12:1855] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.194 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/12:1855] STATEMENT:  INSERT INTO room_reservation VALUES ('101', TIMESTAMP WITH TIME ZONE '2010-04-01 13:00', TIMESTAMP WITH TIME ZONE '2010-04-01 14:00', 'Carol');
2025-01-09 14:06:17.233 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/13:1859] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.233 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/13:1859] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:17.233 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/13:1859] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.233 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/13:1859] STATEMENT:  UPDATE room_reservation SET start_time = TIMESTAMP WITH TIME ZONE '2010-04-01 13:30', end_time = TIMESTAMP WITH TIME ZONE '2010-04-01 14:30' WHERE room_id = '101' AND start_time = TIMESTAMP WITH TIME ZONE '2010-04-01 10:00';
2025-01-09 14:06:17.273 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/14:1863] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.273 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/14:1863] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.273 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/14:1863] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.273 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/14:1863] STATEMENT:  COMMIT;
2025-01-09 14:06:17.295 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/15:1866] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.295 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/15:1866] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.295 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/15:1866] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.295 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/15:1866] STATEMENT:  COMMIT;
2025-01-09 14:06:17.333 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/16:1870] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.333 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/16:1870] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.333 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/16:1870] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.333 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/16:1870] STATEMENT:  COMMIT;
2025-01-09 14:06:17.363 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/17:1875] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.363 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/17:1875] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.363 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/17:1875] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.363 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/17:1875] STATEMENT:  COMMIT;
2025-01-09 14:06:17.405 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/18:1879] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.405 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/18:1879] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:17.405 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/18:1879] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.405 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/18:1879] STATEMENT:  INSERT INTO room_reservation VALUES ('101', TIMESTAMP WITH TIME ZONE '2010-04-01 13:00', TIMESTAMP WITH TIME ZONE '2010-04-01 14:00', 'Carol');
2025-01-09 14:06:17.445 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/19:1882] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.445 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/19:1882] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.445 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/19:1882] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.445 UTC [15525][client backend] [isolation/classroom-scheduling/s2][41/19:1882] STATEMENT:  COMMIT;
2025-01-09 14:06:17.478 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/20:1887] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.478 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/20:1887] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.478 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/20:1887] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.478 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/20:1887] STATEMENT:  COMMIT;
2025-01-09 14:06:17.531 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/21:1891] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.531 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/21:1891] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:17.531 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/21:1891] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.531 UTC [15520][client backend] [isolation/classroom-scheduling/s1][40/21:1891] STATEMENT:  INSERT INTO room_reservation VALUES ('101', TIMESTAMP WITH TIME ZONE '2010-04-01 13:00', TIMESTAMP WITH TIME ZONE '2010-04-01 14:00', 'Carol');
2025-01-09 14:06:17.580 UTC [15525][client backend] [isolation/classroom-scheduling/s2][:0] LOG:  disconnection: session time: 0:00:00.665 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:17.584 UTC [15520][client backend] [isolation/classroom-scheduling/s1][:0] LOG:  disconnection: session time: 0:00:00.699 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:17.584 UTC [15518][client backend] [isolation/classroom-scheduling/control connection][:0] LOG:  disconnection: session time: 0:00:00.736 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:17.668 UTC [15577][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:17.669 UTC [15577][client backend] [[unknown]][42/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:17.669 UTC [15577][client backend] [[unknown]][42/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/total-cash
2025-01-09 14:06:17.716 UTC [15579][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:17.717 UTC [15579][client backend] [[unknown]][43/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:17.717 UTC [15579][client backend] [[unknown]][43/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/total-cash
2025-01-09 14:06:17.755 UTC [15585][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:17.756 UTC [15585][client backend] [[unknown]][44/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:17.756 UTC [15585][client backend] [[unknown]][44/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/total-cash
2025-01-09 14:06:17.849 UTC [15585][client backend] [isolation/total-cash/s2][44/4:1903] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.849 UTC [15585][client backend] [isolation/total-cash/s2][44/4:1903] DETAIL:  Reason code: Canceled on conflict out to pivot 1902, during read.
2025-01-09 14:06:17.849 UTC [15585][client backend] [isolation/total-cash/s2][44/4:1903] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.849 UTC [15585][client backend] [isolation/total-cash/s2][44/4:1903] STATEMENT:  SELECT SUM(balance) FROM accounts;
2025-01-09 14:06:17.877 UTC [15585][client backend] [isolation/total-cash/s2][44/5:1907] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.877 UTC [15585][client backend] [isolation/total-cash/s2][44/5:1907] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.877 UTC [15585][client backend] [isolation/total-cash/s2][44/5:1907] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.877 UTC [15585][client backend] [isolation/total-cash/s2][44/5:1907] STATEMENT:  COMMIT;
2025-01-09 14:06:17.898 UTC [15579][client backend] [isolation/total-cash/s1][43/6:1910] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.898 UTC [15579][client backend] [isolation/total-cash/s1][43/6:1910] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.898 UTC [15579][client backend] [isolation/total-cash/s1][43/6:1910] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.898 UTC [15579][client backend] [isolation/total-cash/s1][43/6:1910] STATEMENT:  COMMIT;
2025-01-09 14:06:17.911 UTC [15585][client backend] [isolation/total-cash/s2][44/7:1915] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.911 UTC [15585][client backend] [isolation/total-cash/s2][44/7:1915] DETAIL:  Reason code: Canceled on conflict out to pivot 1914, during read.
2025-01-09 14:06:17.911 UTC [15585][client backend] [isolation/total-cash/s2][44/7:1915] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.911 UTC [15585][client backend] [isolation/total-cash/s2][44/7:1915] STATEMENT:  SELECT SUM(balance) FROM accounts;
2025-01-09 14:06:17.963 UTC [15585][client backend] [isolation/total-cash/s2][44/8:1919] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.963 UTC [15585][client backend] [isolation/total-cash/s2][44/8:1919] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.963 UTC [15585][client backend] [isolation/total-cash/s2][44/8:1919] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.963 UTC [15585][client backend] [isolation/total-cash/s2][44/8:1919] STATEMENT:  COMMIT;
2025-01-09 14:06:17.977 UTC [15579][client backend] [isolation/total-cash/s1][43/9:1922] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:17.977 UTC [15579][client backend] [isolation/total-cash/s1][43/9:1922] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:17.977 UTC [15579][client backend] [isolation/total-cash/s1][43/9:1922] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:17.977 UTC [15579][client backend] [isolation/total-cash/s1][43/9:1922] STATEMENT:  COMMIT;
2025-01-09 14:06:18.003 UTC [15585][client backend] [isolation/total-cash/s2][44/10:1927] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.003 UTC [15585][client backend] [isolation/total-cash/s2][44/10:1927] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.003 UTC [15585][client backend] [isolation/total-cash/s2][44/10:1927] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.003 UTC [15585][client backend] [isolation/total-cash/s2][44/10:1927] STATEMENT:  COMMIT;
2025-01-09 14:06:18.042 UTC [15579][client backend] [isolation/total-cash/s1][43/11:1930] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.042 UTC [15579][client backend] [isolation/total-cash/s1][43/11:1930] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.042 UTC [15579][client backend] [isolation/total-cash/s1][43/11:1930] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.042 UTC [15579][client backend] [isolation/total-cash/s1][43/11:1930] STATEMENT:  COMMIT;
2025-01-09 14:06:18.078 UTC [15579][client backend] [isolation/total-cash/s1][43/12:1934] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.078 UTC [15579][client backend] [isolation/total-cash/s1][43/12:1934] DETAIL:  Reason code: Canceled on conflict out to pivot 1935, during read.
2025-01-09 14:06:18.078 UTC [15579][client backend] [isolation/total-cash/s1][43/12:1934] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.078 UTC [15579][client backend] [isolation/total-cash/s1][43/12:1934] STATEMENT:  SELECT SUM(balance) FROM accounts;
2025-01-09 14:06:18.092 UTC [15585][client backend] [isolation/total-cash/s2][44/13:1938] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.092 UTC [15585][client backend] [isolation/total-cash/s2][44/13:1938] DETAIL:  Reason code: Canceled on conflict out to pivot 1939, during read.
2025-01-09 14:06:18.092 UTC [15585][client backend] [isolation/total-cash/s2][44/13:1938] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.092 UTC [15585][client backend] [isolation/total-cash/s2][44/13:1938] STATEMENT:  SELECT SUM(balance) FROM accounts;
2025-01-09 14:06:18.122 UTC [15585][client backend] [isolation/total-cash/s2][44/14:1942] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.122 UTC [15585][client backend] [isolation/total-cash/s2][44/14:1942] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.122 UTC [15585][client backend] [isolation/total-cash/s2][44/14:1942] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.122 UTC [15585][client backend] [isolation/total-cash/s2][44/14:1942] STATEMENT:  COMMIT;
2025-01-09 14:06:18.154 UTC [15579][client backend] [isolation/total-cash/s1][43/15:1947] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.154 UTC [15579][client backend] [isolation/total-cash/s1][43/15:1947] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.154 UTC [15579][client backend] [isolation/total-cash/s1][43/15:1947] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.154 UTC [15579][client backend] [isolation/total-cash/s1][43/15:1947] STATEMENT:  COMMIT;
2025-01-09 14:06:18.198 UTC [15585][client backend] [isolation/total-cash/s2][44/16:1950] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.198 UTC [15585][client backend] [isolation/total-cash/s2][44/16:1950] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.198 UTC [15585][client backend] [isolation/total-cash/s2][44/16:1950] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.198 UTC [15585][client backend] [isolation/total-cash/s2][44/16:1950] STATEMENT:  COMMIT;
2025-01-09 14:06:18.223 UTC [15579][client backend] [isolation/total-cash/s1][43/17:1955] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.223 UTC [15579][client backend] [isolation/total-cash/s1][43/17:1955] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.223 UTC [15579][client backend] [isolation/total-cash/s1][43/17:1955] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.223 UTC [15579][client backend] [isolation/total-cash/s1][43/17:1955] STATEMENT:  COMMIT;
2025-01-09 14:06:18.249 UTC [15579][client backend] [isolation/total-cash/s1][43/18:1959] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.249 UTC [15579][client backend] [isolation/total-cash/s1][43/18:1959] DETAIL:  Reason code: Canceled on conflict out to pivot 1958, during read.
2025-01-09 14:06:18.249 UTC [15579][client backend] [isolation/total-cash/s1][43/18:1959] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.249 UTC [15579][client backend] [isolation/total-cash/s1][43/18:1959] STATEMENT:  SELECT SUM(balance) FROM accounts;
2025-01-09 14:06:18.290 UTC [15585][client backend] [isolation/total-cash/s2][44/19:1962] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.290 UTC [15585][client backend] [isolation/total-cash/s2][44/19:1962] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.290 UTC [15585][client backend] [isolation/total-cash/s2][44/19:1962] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.290 UTC [15585][client backend] [isolation/total-cash/s2][44/19:1962] STATEMENT:  COMMIT;
2025-01-09 14:06:18.339 UTC [15579][client backend] [isolation/total-cash/s1][43/20:1967] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.339 UTC [15579][client backend] [isolation/total-cash/s1][43/20:1967] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.339 UTC [15579][client backend] [isolation/total-cash/s1][43/20:1967] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.339 UTC [15579][client backend] [isolation/total-cash/s1][43/20:1967] STATEMENT:  COMMIT;
2025-01-09 14:06:18.361 UTC [15579][client backend] [isolation/total-cash/s1][43/21:1971] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.361 UTC [15579][client backend] [isolation/total-cash/s1][43/21:1971] DETAIL:  Reason code: Canceled on conflict out to pivot 1970, during read.
2025-01-09 14:06:18.361 UTC [15579][client backend] [isolation/total-cash/s1][43/21:1971] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.361 UTC [15579][client backend] [isolation/total-cash/s1][43/21:1971] STATEMENT:  SELECT SUM(balance) FROM accounts;
2025-01-09 14:06:18.402 UTC [15579][client backend] [isolation/total-cash/s1][:0] LOG:  disconnection: session time: 0:00:00.693 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:18.402 UTC [15585][client backend] [isolation/total-cash/s2][:0] LOG:  disconnection: session time: 0:00:00.654 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:18.412 UTC [15577][client backend] [isolation/total-cash/control connection][:0] LOG:  disconnection: session time: 0:00:00.748 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:18.504 UTC [15628][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:18.506 UTC [15628][client backend] [[unknown]][45/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:18.506 UTC [15628][client backend] [[unknown]][45/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/referential-integrity
2025-01-09 14:06:18.548 UTC [15633][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:18.549 UTC [15633][client backend] [[unknown]][46/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:18.549 UTC [15633][client backend] [[unknown]][46/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/referential-integrity
2025-01-09 14:06:18.570 UTC [15634][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:18.571 UTC [15634][client backend] [[unknown]][47/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:18.571 UTC [15634][client backend] [[unknown]][47/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/referential-integrity
2025-01-09 14:06:18.635 UTC [15634][client backend] [isolation/referential-integrity/s2][47/4:1983] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.635 UTC [15634][client backend] [isolation/referential-integrity/s2][47/4:1983] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:18.635 UTC [15634][client backend] [isolation/referential-integrity/s2][47/4:1983] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.635 UTC [15634][client backend] [isolation/referential-integrity/s2][47/4:1983] STATEMENT:  DELETE FROM a WHERE i = 1;
2025-01-09 14:06:18.647 UTC [15634][client backend] [isolation/referential-integrity/s2][47/5:1987] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.647 UTC [15634][client backend] [isolation/referential-integrity/s2][47/5:1987] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:18.647 UTC [15634][client backend] [isolation/referential-integrity/s2][47/5:1987] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.647 UTC [15634][client backend] [isolation/referential-integrity/s2][47/5:1987] STATEMENT:  DELETE FROM a WHERE i = 1;
2025-01-09 14:06:18.664 UTC [15634][client backend] [isolation/referential-integrity/s2][47/6:1991] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.664 UTC [15634][client backend] [isolation/referential-integrity/s2][47/6:1991] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.664 UTC [15634][client backend] [isolation/referential-integrity/s2][47/6:1991] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.664 UTC [15634][client backend] [isolation/referential-integrity/s2][47/6:1991] STATEMENT:  COMMIT;
2025-01-09 14:06:18.677 UTC [15633][client backend] [isolation/referential-integrity/s1][46/7:1994] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.677 UTC [15633][client backend] [isolation/referential-integrity/s1][46/7:1994] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.677 UTC [15633][client backend] [isolation/referential-integrity/s1][46/7:1994] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.677 UTC [15633][client backend] [isolation/referential-integrity/s1][46/7:1994] STATEMENT:  COMMIT;
2025-01-09 14:06:18.699 UTC [15634][client backend] [isolation/referential-integrity/s2][47/8:1999] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.699 UTC [15634][client backend] [isolation/referential-integrity/s2][47/8:1999] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:18.699 UTC [15634][client backend] [isolation/referential-integrity/s2][47/8:1999] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.699 UTC [15634][client backend] [isolation/referential-integrity/s2][47/8:1999] STATEMENT:  DELETE FROM a WHERE i = 1;
2025-01-09 14:06:18.712 UTC [15634][client backend] [isolation/referential-integrity/s2][47/9:2003] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.712 UTC [15634][client backend] [isolation/referential-integrity/s2][47/9:2003] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:18.712 UTC [15634][client backend] [isolation/referential-integrity/s2][47/9:2003] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.712 UTC [15634][client backend] [isolation/referential-integrity/s2][47/9:2003] STATEMENT:  DELETE FROM a WHERE i = 1;
2025-01-09 14:06:18.727 UTC [15634][client backend] [isolation/referential-integrity/s2][47/10:2007] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.727 UTC [15634][client backend] [isolation/referential-integrity/s2][47/10:2007] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.727 UTC [15634][client backend] [isolation/referential-integrity/s2][47/10:2007] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.727 UTC [15634][client backend] [isolation/referential-integrity/s2][47/10:2007] STATEMENT:  COMMIT;
2025-01-09 14:06:18.739 UTC [15633][client backend] [isolation/referential-integrity/s1][46/11:2010] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.739 UTC [15633][client backend] [isolation/referential-integrity/s1][46/11:2010] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.739 UTC [15633][client backend] [isolation/referential-integrity/s1][46/11:2010] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.739 UTC [15633][client backend] [isolation/referential-integrity/s1][46/11:2010] STATEMENT:  COMMIT;
2025-01-09 14:06:18.755 UTC [15634][client backend] [isolation/referential-integrity/s2][47/12:2015] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.755 UTC [15634][client backend] [isolation/referential-integrity/s2][47/12:2015] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:18.755 UTC [15634][client backend] [isolation/referential-integrity/s2][47/12:2015] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.755 UTC [15634][client backend] [isolation/referential-integrity/s2][47/12:2015] STATEMENT:  DELETE FROM a WHERE i = 1;
2025-01-09 14:06:18.771 UTC [15634][client backend] [isolation/referential-integrity/s2][47/13:2019] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.771 UTC [15634][client backend] [isolation/referential-integrity/s2][47/13:2019] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.771 UTC [15634][client backend] [isolation/referential-integrity/s2][47/13:2019] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.771 UTC [15634][client backend] [isolation/referential-integrity/s2][47/13:2019] STATEMENT:  COMMIT;
2025-01-09 14:06:18.793 UTC [15633][client backend] [isolation/referential-integrity/s1][46/14:2022] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.793 UTC [15633][client backend] [isolation/referential-integrity/s1][46/14:2022] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.793 UTC [15633][client backend] [isolation/referential-integrity/s1][46/14:2022] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.793 UTC [15633][client backend] [isolation/referential-integrity/s1][46/14:2022] STATEMENT:  COMMIT;
2025-01-09 14:06:18.812 UTC [15634][client backend] [isolation/referential-integrity/s2][47/15:2026] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.812 UTC [15634][client backend] [isolation/referential-integrity/s2][47/15:2026] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.812 UTC [15634][client backend] [isolation/referential-integrity/s2][47/15:2026] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.812 UTC [15634][client backend] [isolation/referential-integrity/s2][47/15:2026] STATEMENT:  COMMIT;
2025-01-09 14:06:18.837 UTC [15633][client backend] [isolation/referential-integrity/s1][46/16:2031] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.837 UTC [15633][client backend] [isolation/referential-integrity/s1][46/16:2031] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.837 UTC [15633][client backend] [isolation/referential-integrity/s1][46/16:2031] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.837 UTC [15633][client backend] [isolation/referential-integrity/s1][46/16:2031] STATEMENT:  COMMIT;
2025-01-09 14:06:18.849 UTC [15633][client backend] [isolation/referential-integrity/s1][46/17:2035] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.849 UTC [15633][client backend] [isolation/referential-integrity/s1][46/17:2035] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:18.849 UTC [15633][client backend] [isolation/referential-integrity/s1][46/17:2035] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.849 UTC [15633][client backend] [isolation/referential-integrity/s1][46/17:2035] STATEMENT:  INSERT INTO b VALUES (1);
2025-01-09 14:06:18.867 UTC [15634][client backend] [isolation/referential-integrity/s2][47/18:2039] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.867 UTC [15634][client backend] [isolation/referential-integrity/s2][47/18:2039] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:18.867 UTC [15634][client backend] [isolation/referential-integrity/s2][47/18:2039] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.867 UTC [15634][client backend] [isolation/referential-integrity/s2][47/18:2039] STATEMENT:  DELETE FROM a WHERE i = 1;
2025-01-09 14:06:18.882 UTC [15634][client backend] [isolation/referential-integrity/s2][47/19:2043] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.882 UTC [15634][client backend] [isolation/referential-integrity/s2][47/19:2043] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:18.882 UTC [15634][client backend] [isolation/referential-integrity/s2][47/19:2043] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.882 UTC [15634][client backend] [isolation/referential-integrity/s2][47/19:2043] STATEMENT:  DELETE FROM a WHERE i = 1;
2025-01-09 14:06:18.908 UTC [15634][client backend] [isolation/referential-integrity/s2][47/20:2047] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.908 UTC [15634][client backend] [isolation/referential-integrity/s2][47/20:2047] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.908 UTC [15634][client backend] [isolation/referential-integrity/s2][47/20:2047] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.908 UTC [15634][client backend] [isolation/referential-integrity/s2][47/20:2047] STATEMENT:  COMMIT;
2025-01-09 14:06:18.940 UTC [15633][client backend] [isolation/referential-integrity/s1][46/21:2050] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.940 UTC [15633][client backend] [isolation/referential-integrity/s1][46/21:2050] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.940 UTC [15633][client backend] [isolation/referential-integrity/s1][46/21:2050] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.940 UTC [15633][client backend] [isolation/referential-integrity/s1][46/21:2050] STATEMENT:  COMMIT;
2025-01-09 14:06:18.956 UTC [15634][client backend] [isolation/referential-integrity/s2][47/22:2055] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.956 UTC [15634][client backend] [isolation/referential-integrity/s2][47/22:2055] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:18.956 UTC [15634][client backend] [isolation/referential-integrity/s2][47/22:2055] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.956 UTC [15634][client backend] [isolation/referential-integrity/s2][47/22:2055] STATEMENT:  DELETE FROM a WHERE i = 1;
2025-01-09 14:06:18.981 UTC [15634][client backend] [isolation/referential-integrity/s2][47/23:2059] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.981 UTC [15634][client backend] [isolation/referential-integrity/s2][47/23:2059] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.981 UTC [15634][client backend] [isolation/referential-integrity/s2][47/23:2059] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.981 UTC [15634][client backend] [isolation/referential-integrity/s2][47/23:2059] STATEMENT:  COMMIT;
2025-01-09 14:06:18.993 UTC [15633][client backend] [isolation/referential-integrity/s1][46/24:2062] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:18.993 UTC [15633][client backend] [isolation/referential-integrity/s1][46/24:2062] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:18.993 UTC [15633][client backend] [isolation/referential-integrity/s1][46/24:2062] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:18.993 UTC [15633][client backend] [isolation/referential-integrity/s1][46/24:2062] STATEMENT:  COMMIT;
2025-01-09 14:06:19.009 UTC [15634][client backend] [isolation/referential-integrity/s2][47/25:2066] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.009 UTC [15634][client backend] [isolation/referential-integrity/s2][47/25:2066] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.009 UTC [15634][client backend] [isolation/referential-integrity/s2][47/25:2066] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.009 UTC [15634][client backend] [isolation/referential-integrity/s2][47/25:2066] STATEMENT:  COMMIT;
2025-01-09 14:06:19.032 UTC [15633][client backend] [isolation/referential-integrity/s1][46/26:2071] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.032 UTC [15633][client backend] [isolation/referential-integrity/s1][46/26:2071] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.032 UTC [15633][client backend] [isolation/referential-integrity/s1][46/26:2071] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.032 UTC [15633][client backend] [isolation/referential-integrity/s1][46/26:2071] STATEMENT:  COMMIT;
2025-01-09 14:06:19.046 UTC [15633][client backend] [isolation/referential-integrity/s1][46/27:2075] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.046 UTC [15633][client backend] [isolation/referential-integrity/s1][46/27:2075] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:19.046 UTC [15633][client backend] [isolation/referential-integrity/s1][46/27:2075] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.046 UTC [15633][client backend] [isolation/referential-integrity/s1][46/27:2075] STATEMENT:  INSERT INTO b VALUES (1);
2025-01-09 14:06:19.059 UTC [15634][client backend] [isolation/referential-integrity/s2][47/28:2079] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.059 UTC [15634][client backend] [isolation/referential-integrity/s2][47/28:2079] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:19.059 UTC [15634][client backend] [isolation/referential-integrity/s2][47/28:2079] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.059 UTC [15634][client backend] [isolation/referential-integrity/s2][47/28:2079] STATEMENT:  DELETE FROM a WHERE i = 1;
2025-01-09 14:06:19.071 UTC [15634][client backend] [isolation/referential-integrity/s2][47/29:2083] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.071 UTC [15634][client backend] [isolation/referential-integrity/s2][47/29:2083] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.071 UTC [15634][client backend] [isolation/referential-integrity/s2][47/29:2083] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.071 UTC [15634][client backend] [isolation/referential-integrity/s2][47/29:2083] STATEMENT:  COMMIT;
2025-01-09 14:06:19.090 UTC [15633][client backend] [isolation/referential-integrity/s1][46/30:2086] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.090 UTC [15633][client backend] [isolation/referential-integrity/s1][46/30:2086] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.090 UTC [15633][client backend] [isolation/referential-integrity/s1][46/30:2086] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.090 UTC [15633][client backend] [isolation/referential-integrity/s1][46/30:2086] STATEMENT:  COMMIT;
2025-01-09 14:06:19.104 UTC [15634][client backend] [isolation/referential-integrity/s2][47/31:2090] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.104 UTC [15634][client backend] [isolation/referential-integrity/s2][47/31:2090] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.104 UTC [15634][client backend] [isolation/referential-integrity/s2][47/31:2090] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.104 UTC [15634][client backend] [isolation/referential-integrity/s2][47/31:2090] STATEMENT:  COMMIT;
2025-01-09 14:06:19.138 UTC [15633][client backend] [isolation/referential-integrity/s1][46/32:2095] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.138 UTC [15633][client backend] [isolation/referential-integrity/s1][46/32:2095] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.138 UTC [15633][client backend] [isolation/referential-integrity/s1][46/32:2095] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.138 UTC [15633][client backend] [isolation/referential-integrity/s1][46/32:2095] STATEMENT:  COMMIT;
2025-01-09 14:06:19.149 UTC [15633][client backend] [isolation/referential-integrity/s1][46/33:2099] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.149 UTC [15633][client backend] [isolation/referential-integrity/s1][46/33:2099] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:19.149 UTC [15633][client backend] [isolation/referential-integrity/s1][46/33:2099] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.149 UTC [15633][client backend] [isolation/referential-integrity/s1][46/33:2099] STATEMENT:  INSERT INTO b VALUES (1);
2025-01-09 14:06:19.173 UTC [15634][client backend] [isolation/referential-integrity/s2][47/34:2102] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.173 UTC [15634][client backend] [isolation/referential-integrity/s2][47/34:2102] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.173 UTC [15634][client backend] [isolation/referential-integrity/s2][47/34:2102] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.173 UTC [15634][client backend] [isolation/referential-integrity/s2][47/34:2102] STATEMENT:  COMMIT;
2025-01-09 14:06:19.185 UTC [15633][client backend] [isolation/referential-integrity/s1][46/35:2107] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.185 UTC [15633][client backend] [isolation/referential-integrity/s1][46/35:2107] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.185 UTC [15633][client backend] [isolation/referential-integrity/s1][46/35:2107] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.185 UTC [15633][client backend] [isolation/referential-integrity/s1][46/35:2107] STATEMENT:  COMMIT;
2025-01-09 14:06:19.207 UTC [15633][client backend] [isolation/referential-integrity/s1][46/36:2111] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.207 UTC [15633][client backend] [isolation/referential-integrity/s1][46/36:2111] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:19.207 UTC [15633][client backend] [isolation/referential-integrity/s1][46/36:2111] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.207 UTC [15633][client backend] [isolation/referential-integrity/s1][46/36:2111] STATEMENT:  INSERT INTO b VALUES (1);
2025-01-09 14:06:19.252 UTC [15633][client backend] [isolation/referential-integrity/s1][:0] LOG:  disconnection: session time: 0:00:00.716 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:19.255 UTC [15634][client backend] [isolation/referential-integrity/s2][:0] LOG:  disconnection: session time: 0:00:00.687 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:19.268 UTC [15628][client backend] [isolation/referential-integrity/control connection][:0] LOG:  disconnection: session time: 0:00:00.768 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:19.343 UTC [15694][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:19.344 UTC [15694][client backend] [[unknown]][48/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:19.344 UTC [15694][client backend] [[unknown]][48/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/ri-trigger
2025-01-09 14:06:19.365 UTC [15697][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:19.366 UTC [15697][client backend] [[unknown]][49/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:19.366 UTC [15697][client backend] [[unknown]][49/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/ri-trigger
2025-01-09 14:06:19.388 UTC [15700][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:19.389 UTC [15700][client backend] [[unknown]][50/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:19.389 UTC [15700][client backend] [[unknown]][50/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/ri-trigger
2025-01-09 14:06:19.435 UTC [15700][client backend] [isolation/ri-trigger/s2][50/3:2119] ERROR:  child row exists
2025-01-09 14:06:19.435 UTC [15700][client backend] [isolation/ri-trigger/s2][50/3:2119] CONTEXT:  PL/pgSQL function ri_parent() line 5 at RAISE
2025-01-09 14:06:19.435 UTC [15700][client backend] [isolation/ri-trigger/s2][50/3:2119] STATEMENT:  DELETE FROM parent WHERE parent_id = 0;
2025-01-09 14:06:19.482 UTC [15700][client backend] [isolation/ri-trigger/s2][50/4:2123] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.482 UTC [15700][client backend] [isolation/ri-trigger/s2][50/4:2123] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:19.482 UTC [15700][client backend] [isolation/ri-trigger/s2][50/4:2123] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.482 UTC [15700][client backend] [isolation/ri-trigger/s2][50/4:2123] STATEMENT:  DELETE FROM parent WHERE parent_id = 0;
2025-01-09 14:06:19.527 UTC [15700][client backend] [isolation/ri-trigger/s2][50/5:2127] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.527 UTC [15700][client backend] [isolation/ri-trigger/s2][50/5:2127] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.527 UTC [15700][client backend] [isolation/ri-trigger/s2][50/5:2127] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.527 UTC [15700][client backend] [isolation/ri-trigger/s2][50/5:2127] STATEMENT:  COMMIT;
2025-01-09 14:06:19.577 UTC [15697][client backend] [isolation/ri-trigger/s1][49/6:2130] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.577 UTC [15697][client backend] [isolation/ri-trigger/s1][49/6:2130] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.577 UTC [15697][client backend] [isolation/ri-trigger/s1][49/6:2130] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.577 UTC [15697][client backend] [isolation/ri-trigger/s1][49/6:2130] STATEMENT:  COMMIT;
2025-01-09 14:06:19.617 UTC [15700][client backend] [isolation/ri-trigger/s2][50/7:2135] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.617 UTC [15700][client backend] [isolation/ri-trigger/s2][50/7:2135] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:19.617 UTC [15700][client backend] [isolation/ri-trigger/s2][50/7:2135] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.617 UTC [15700][client backend] [isolation/ri-trigger/s2][50/7:2135] STATEMENT:  DELETE FROM parent WHERE parent_id = 0;
2025-01-09 14:06:19.665 UTC [15700][client backend] [isolation/ri-trigger/s2][50/8:2139] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.665 UTC [15700][client backend] [isolation/ri-trigger/s2][50/8:2139] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.665 UTC [15700][client backend] [isolation/ri-trigger/s2][50/8:2139] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.665 UTC [15700][client backend] [isolation/ri-trigger/s2][50/8:2139] STATEMENT:  COMMIT;
2025-01-09 14:06:19.704 UTC [15697][client backend] [isolation/ri-trigger/s1][49/9:2142] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.704 UTC [15697][client backend] [isolation/ri-trigger/s1][49/9:2142] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.704 UTC [15697][client backend] [isolation/ri-trigger/s1][49/9:2142] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.704 UTC [15697][client backend] [isolation/ri-trigger/s1][49/9:2142] STATEMENT:  COMMIT;
2025-01-09 14:06:19.768 UTC [15700][client backend] [isolation/ri-trigger/s2][50/10:2146] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.768 UTC [15700][client backend] [isolation/ri-trigger/s2][50/10:2146] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.768 UTC [15700][client backend] [isolation/ri-trigger/s2][50/10:2146] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.768 UTC [15700][client backend] [isolation/ri-trigger/s2][50/10:2146] STATEMENT:  COMMIT;
2025-01-09 14:06:19.804 UTC [15697][client backend] [isolation/ri-trigger/s1][49/11:2151] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:19.804 UTC [15697][client backend] [isolation/ri-trigger/s1][49/11:2151] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:19.804 UTC [15697][client backend] [isolation/ri-trigger/s1][49/11:2151] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:19.804 UTC [15697][client backend] [isolation/ri-trigger/s1][49/11:2151] STATEMENT:  COMMIT;
2025-01-09 14:06:19.844 UTC [15697][client backend] [isolation/ri-trigger/s1][49/12:2155] ERROR:  parent row missing
2025-01-09 14:06:19.844 UTC [15697][client backend] [isolation/ri-trigger/s1][49/12:2155] CONTEXT:  PL/pgSQL function ri_child() line 5 at RAISE
2025-01-09 14:06:19.844 UTC [15697][client backend] [isolation/ri-trigger/s1][49/12:2155] STATEMENT:  INSERT INTO child (parent_id) VALUES (0);
2025-01-09 14:06:19.854 UTC [15697][client backend] [isolation/ri-trigger/s1][:0] LOG:  disconnection: session time: 0:00:00.493 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:19.860 UTC [15700][client backend] [isolation/ri-trigger/s2][:0] LOG:  disconnection: session time: 0:00:00.475 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:19.864 UTC [15694][client backend] [isolation/ri-trigger/control connection][:0] LOG:  disconnection: session time: 0:00:00.527 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:19.928 UTC [15761][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:19.930 UTC [15761][client backend] [[unknown]][51/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:19.930 UTC [15761][client backend] [[unknown]][51/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/partial-index
2025-01-09 14:06:19.951 UTC [15764][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:19.952 UTC [15764][client backend] [[unknown]][52/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:19.952 UTC [15764][client backend] [[unknown]][52/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/partial-index
2025-01-09 14:06:19.972 UTC [15766][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:19.973 UTC [15766][client backend] [[unknown]][53/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:19.973 UTC [15766][client backend] [[unknown]][53/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/partial-index
2025-01-09 14:06:20.161 UTC [15766][client backend] [isolation/partial-index/s2][53/4:2163] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:20.161 UTC [15766][client backend] [isolation/partial-index/s2][53/4:2163] DETAIL:  Reason code: Canceled on conflict out to pivot 2162, during read.
2025-01-09 14:06:20.161 UTC [15766][client backend] [isolation/partial-index/s2][53/4:2163] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:20.161 UTC [15766][client backend] [isolation/partial-index/s2][53/4:2163] STATEMENT:  select * from test_t where val2 = 1;
2025-01-09 14:06:20.208 UTC [15766][client backend] [isolation/partial-index/s2][53/5:2167] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:20.208 UTC [15766][client backend] [isolation/partial-index/s2][53/5:2167] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:20.208 UTC [15766][client backend] [isolation/partial-index/s2][53/5:2167] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:20.208 UTC [15766][client backend] [isolation/partial-index/s2][53/5:2167] STATEMENT:  COMMIT;
2025-01-09 14:06:20.276 UTC [15764][client backend] [isolation/partial-index/s1][52/6:2170] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:20.276 UTC [15764][client backend] [isolation/partial-index/s1][52/6:2170] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:20.276 UTC [15764][client backend] [isolation/partial-index/s1][52/6:2170] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:20.276 UTC [15764][client backend] [isolation/partial-index/s1][52/6:2170] STATEMENT:  COMMIT;
2025-01-09 14:06:20.391 UTC [15766][client backend] [isolation/partial-index/s2][53/7:2174] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:20.391 UTC [15766][client backend] [isolation/partial-index/s2][53/7:2174] DETAIL:  Reason code: Canceled on conflict out to pivot 2175, during read.
2025-01-09 14:06:20.391 UTC [15766][client backend] [isolation/partial-index/s2][53/7:2174] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:20.391 UTC [15766][client backend] [isolation/partial-index/s2][53/7:2174] STATEMENT:  select * from test_t where val2 = 1;
2025-01-09 14:06:20.457 UTC [15766][client backend] [isolation/partial-index/s2][53/8:2178] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:20.457 UTC [15766][client backend] [isolation/partial-index/s2][53/8:2178] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:20.457 UTC [15766][client backend] [isolation/partial-index/s2][53/8:2178] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:20.457 UTC [15766][client backend] [isolation/partial-index/s2][53/8:2178] STATEMENT:  COMMIT;
2025-01-09 14:06:20.644 UTC [15764][client backend] [isolation/partial-index/s1][52/9:2183] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:20.644 UTC [15764][client backend] [isolation/partial-index/s1][52/9:2183] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:20.644 UTC [15764][client backend] [isolation/partial-index/s1][52/9:2183] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:20.644 UTC [15764][client backend] [isolation/partial-index/s1][52/9:2183] STATEMENT:  COMMIT;
2025-01-09 14:06:20.884 UTC [15766][client backend] [isolation/partial-index/s2][53/10:2186] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:20.884 UTC [15766][client backend] [isolation/partial-index/s2][53/10:2186] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:20.884 UTC [15766][client backend] [isolation/partial-index/s2][53/10:2186] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:20.884 UTC [15766][client backend] [isolation/partial-index/s2][53/10:2186] STATEMENT:  COMMIT;
2025-01-09 14:06:21.050 UTC [15764][client backend] [isolation/partial-index/s1][52/11:2191] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:21.050 UTC [15764][client backend] [isolation/partial-index/s1][52/11:2191] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:21.050 UTC [15764][client backend] [isolation/partial-index/s1][52/11:2191] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:21.050 UTC [15764][client backend] [isolation/partial-index/s1][52/11:2191] STATEMENT:  COMMIT;
2025-01-09 14:06:21.199 UTC [15764][client backend] [isolation/partial-index/s1][52/12:2195] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:21.199 UTC [15764][client backend] [isolation/partial-index/s1][52/12:2195] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:21.199 UTC [15764][client backend] [isolation/partial-index/s1][52/12:2195] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:21.199 UTC [15764][client backend] [isolation/partial-index/s1][52/12:2195] STATEMENT:  update test_t set val2 = 2 where val2 = 1 and id = 10;
2025-01-09 14:06:21.298 UTC [15766][client backend] [isolation/partial-index/s2][53/13:2198] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:21.298 UTC [15766][client backend] [isolation/partial-index/s2][53/13:2198] DETAIL:  Reason code: Canceled on conflict out to pivot 2199, during read.
2025-01-09 14:06:21.298 UTC [15766][client backend] [isolation/partial-index/s2][53/13:2198] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:21.298 UTC [15766][client backend] [isolation/partial-index/s2][53/13:2198] STATEMENT:  select * from test_t where val2 = 1;
2025-01-09 14:06:21.435 UTC [15766][client backend] [isolation/partial-index/s2][53/14:2202] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:21.435 UTC [15766][client backend] [isolation/partial-index/s2][53/14:2202] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:21.435 UTC [15766][client backend] [isolation/partial-index/s2][53/14:2202] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:21.435 UTC [15766][client backend] [isolation/partial-index/s2][53/14:2202] STATEMENT:  COMMIT;
2025-01-09 14:06:21.582 UTC [15764][client backend] [isolation/partial-index/s1][52/15:2207] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:21.582 UTC [15764][client backend] [isolation/partial-index/s1][52/15:2207] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:21.582 UTC [15764][client backend] [isolation/partial-index/s1][52/15:2207] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:21.582 UTC [15764][client backend] [isolation/partial-index/s1][52/15:2207] STATEMENT:  COMMIT;
2025-01-09 14:06:21.828 UTC [15766][client backend] [isolation/partial-index/s2][53/16:2210] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:21.828 UTC [15766][client backend] [isolation/partial-index/s2][53/16:2210] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:21.828 UTC [15766][client backend] [isolation/partial-index/s2][53/16:2210] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:21.828 UTC [15766][client backend] [isolation/partial-index/s2][53/16:2210] STATEMENT:  COMMIT;
2025-01-09 14:06:21.934 UTC [15764][client backend] [isolation/partial-index/s1][52/17:2215] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:21.934 UTC [15764][client backend] [isolation/partial-index/s1][52/17:2215] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:21.934 UTC [15764][client backend] [isolation/partial-index/s1][52/17:2215] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:21.934 UTC [15764][client backend] [isolation/partial-index/s1][52/17:2215] STATEMENT:  COMMIT;
2025-01-09 14:06:22.064 UTC [15764][client backend] [isolation/partial-index/s1][52/18:2219] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:22.064 UTC [15764][client backend] [isolation/partial-index/s1][52/18:2219] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:22.064 UTC [15764][client backend] [isolation/partial-index/s1][52/18:2219] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:22.064 UTC [15764][client backend] [isolation/partial-index/s1][52/18:2219] STATEMENT:  update test_t set val2 = 2 where val2 = 1 and id = 10;
2025-01-09 14:06:22.165 UTC [15766][client backend] [isolation/partial-index/s2][53/19:2222] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:22.165 UTC [15766][client backend] [isolation/partial-index/s2][53/19:2222] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:22.165 UTC [15766][client backend] [isolation/partial-index/s2][53/19:2222] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:22.165 UTC [15766][client backend] [isolation/partial-index/s2][53/19:2222] STATEMENT:  COMMIT;
2025-01-09 14:06:22.290 UTC [15764][client backend] [isolation/partial-index/s1][52/20:2227] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:22.290 UTC [15764][client backend] [isolation/partial-index/s1][52/20:2227] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:22.290 UTC [15764][client backend] [isolation/partial-index/s1][52/20:2227] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:22.290 UTC [15764][client backend] [isolation/partial-index/s1][52/20:2227] STATEMENT:  COMMIT;
2025-01-09 14:06:22.433 UTC [15764][client backend] [isolation/partial-index/s1][52/21:2231] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:22.433 UTC [15764][client backend] [isolation/partial-index/s1][52/21:2231] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:22.433 UTC [15764][client backend] [isolation/partial-index/s1][52/21:2231] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:22.433 UTC [15764][client backend] [isolation/partial-index/s1][52/21:2231] STATEMENT:  update test_t set val2 = 2 where val2 = 1 and id = 10;
2025-01-09 14:06:22.591 UTC [15764][client backend] [isolation/partial-index/s1][:0] LOG:  disconnection: session time: 0:00:02.640 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:22.596 UTC [15766][client backend] [isolation/partial-index/s2][:0] LOG:  disconnection: session time: 0:00:02.625 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:22.616 UTC [15761][client backend] [isolation/partial-index/control connection][:0] LOG:  disconnection: session time: 0:00:02.691 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:22.704 UTC [15990][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:22.705 UTC [15990][client backend] [[unknown]][54/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:22.705 UTC [15990][client backend] [[unknown]][54/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/two-ids
2025-01-09 14:06:22.721 UTC [15993][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:22.733 UTC [15993][client backend] [[unknown]][55/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:22.734 UTC [15993][client backend] [[unknown]][55/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/two-ids
2025-01-09 14:06:22.759 UTC [15996][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:22.760 UTC [15996][client backend] [[unknown]][56/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:22.760 UTC [15996][client backend] [[unknown]][56/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/two-ids
2025-01-09 14:06:22.779 UTC [15997][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:22.788 UTC [15997][client backend] [[unknown]][57/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:22.793 UTC [15997][client backend] [[unknown]][57/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/two-ids
2025-01-09 14:06:23.029 UTC [15996][client backend] [isolation/two-ids/s2][56/10:2267] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.029 UTC [15996][client backend] [isolation/two-ids/s2][56/10:2267] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.029 UTC [15996][client backend] [isolation/two-ids/s2][56/10:2267] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.029 UTC [15996][client backend] [isolation/two-ids/s2][56/10:2267] STATEMENT:  COMMIT;
2025-01-09 14:06:23.062 UTC [15996][client backend] [isolation/two-ids/s2][56/11:2271] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.062 UTC [15996][client backend] [isolation/two-ids/s2][56/11:2271] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.062 UTC [15996][client backend] [isolation/two-ids/s2][56/11:2271] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.062 UTC [15996][client backend] [isolation/two-ids/s2][56/11:2271] STATEMENT:  COMMIT;
2025-01-09 14:06:23.148 UTC [15996][client backend] [isolation/two-ids/s2][56/15:2287] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.148 UTC [15996][client backend] [isolation/two-ids/s2][56/15:2287] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.148 UTC [15996][client backend] [isolation/two-ids/s2][56/15:2287] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.148 UTC [15996][client backend] [isolation/two-ids/s2][56/15:2287] STATEMENT:  COMMIT;
2025-01-09 14:06:23.192 UTC [15996][client backend] [isolation/two-ids/s2][56/16:2291] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.192 UTC [15996][client backend] [isolation/two-ids/s2][56/16:2291] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.192 UTC [15996][client backend] [isolation/two-ids/s2][56/16:2291] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.192 UTC [15996][client backend] [isolation/two-ids/s2][56/16:2291] STATEMENT:  COMMIT;
2025-01-09 14:06:23.368 UTC [15996][client backend] [isolation/two-ids/s2][56/24:2323] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.368 UTC [15996][client backend] [isolation/two-ids/s2][56/24:2323] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.368 UTC [15996][client backend] [isolation/two-ids/s2][56/24:2323] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.368 UTC [15996][client backend] [isolation/two-ids/s2][56/24:2323] STATEMENT:  COMMIT;
2025-01-09 14:06:23.390 UTC [15996][client backend] [isolation/two-ids/s2][56/25:2327] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.390 UTC [15996][client backend] [isolation/two-ids/s2][56/25:2327] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.390 UTC [15996][client backend] [isolation/two-ids/s2][56/25:2327] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.390 UTC [15996][client backend] [isolation/two-ids/s2][56/25:2327] STATEMENT:  COMMIT;
2025-01-09 14:06:23.594 UTC [15996][client backend] [isolation/two-ids/s2][56/34:2362] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.594 UTC [15996][client backend] [isolation/two-ids/s2][56/34:2362] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.594 UTC [15996][client backend] [isolation/two-ids/s2][56/34:2362] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.594 UTC [15996][client backend] [isolation/two-ids/s2][56/34:2362] STATEMENT:  COMMIT;
2025-01-09 14:06:23.617 UTC [15996][client backend] [isolation/two-ids/s2][56/35:2366] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.617 UTC [15996][client backend] [isolation/two-ids/s2][56/35:2366] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.617 UTC [15996][client backend] [isolation/two-ids/s2][56/35:2366] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.617 UTC [15996][client backend] [isolation/two-ids/s2][56/35:2366] STATEMENT:  COMMIT;
2025-01-09 14:06:23.690 UTC [15996][client backend] [isolation/two-ids/s2][56/39:2382] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.690 UTC [15996][client backend] [isolation/two-ids/s2][56/39:2382] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.690 UTC [15996][client backend] [isolation/two-ids/s2][56/39:2382] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.690 UTC [15996][client backend] [isolation/two-ids/s2][56/39:2382] STATEMENT:  COMMIT;
2025-01-09 14:06:23.717 UTC [15996][client backend] [isolation/two-ids/s2][56/40:2386] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.717 UTC [15996][client backend] [isolation/two-ids/s2][56/40:2386] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.717 UTC [15996][client backend] [isolation/two-ids/s2][56/40:2386] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.717 UTC [15996][client backend] [isolation/two-ids/s2][56/40:2386] STATEMENT:  COMMIT;
2025-01-09 14:06:23.909 UTC [15996][client backend] [isolation/two-ids/s2][56/51:2430] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.909 UTC [15996][client backend] [isolation/two-ids/s2][56/51:2430] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.909 UTC [15996][client backend] [isolation/two-ids/s2][56/51:2430] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.909 UTC [15996][client backend] [isolation/two-ids/s2][56/51:2430] STATEMENT:  COMMIT;
2025-01-09 14:06:23.928 UTC [15996][client backend] [isolation/two-ids/s2][56/52:2434] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:23.928 UTC [15996][client backend] [isolation/two-ids/s2][56/52:2434] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:23.928 UTC [15996][client backend] [isolation/two-ids/s2][56/52:2434] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:23.928 UTC [15996][client backend] [isolation/two-ids/s2][56/52:2434] STATEMENT:  COMMIT;
2025-01-09 14:06:24.208 UTC [15996][client backend] [isolation/two-ids/s2][56/66:2491] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:24.208 UTC [15996][client backend] [isolation/two-ids/s2][56/66:2491] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:24.208 UTC [15996][client backend] [isolation/two-ids/s2][56/66:2491] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:24.208 UTC [15996][client backend] [isolation/two-ids/s2][56/66:2491] STATEMENT:  COMMIT;
2025-01-09 14:06:24.233 UTC [15996][client backend] [isolation/two-ids/s2][56/67:2495] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:24.233 UTC [15996][client backend] [isolation/two-ids/s2][56/67:2495] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:24.233 UTC [15996][client backend] [isolation/two-ids/s2][56/67:2495] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:24.233 UTC [15996][client backend] [isolation/two-ids/s2][56/67:2495] STATEMENT:  COMMIT;
2025-01-09 14:06:24.379 UTC [15996][client backend] [isolation/two-ids/s2][56/75:2526] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:24.379 UTC [15996][client backend] [isolation/two-ids/s2][56/75:2526] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:24.379 UTC [15996][client backend] [isolation/two-ids/s2][56/75:2526] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:24.379 UTC [15996][client backend] [isolation/two-ids/s2][56/75:2526] STATEMENT:  COMMIT;
2025-01-09 14:06:24.400 UTC [15996][client backend] [isolation/two-ids/s2][56/76:2530] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:24.400 UTC [15996][client backend] [isolation/two-ids/s2][56/76:2530] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:24.400 UTC [15996][client backend] [isolation/two-ids/s2][56/76:2530] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:24.400 UTC [15996][client backend] [isolation/two-ids/s2][56/76:2530] STATEMENT:  COMMIT;
2025-01-09 14:06:24.808 UTC [15993][client backend] [isolation/two-ids/s1][:0] LOG:  disconnection: session time: 0:00:02.087 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:24.808 UTC [15997][client backend] [isolation/two-ids/s3][:0] LOG:  disconnection: session time: 0:00:02.029 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:24.812 UTC [15996][client backend] [isolation/two-ids/s2][:0] LOG:  disconnection: session time: 0:00:02.053 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:24.819 UTC [15990][client backend] [isolation/two-ids/control connection][:0] LOG:  disconnection: session time: 0:00:02.131 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:24.885 UTC [16196][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:24.887 UTC [16196][client backend] [[unknown]][58/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:24.887 UTC [16196][client backend] [[unknown]][58/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/multiple-row-versions
2025-01-09 14:06:24.908 UTC [16199][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:24.909 UTC [16199][client backend] [[unknown]][59/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:24.909 UTC [16199][client backend] [[unknown]][59/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/multiple-row-versions
2025-01-09 14:06:24.953 UTC [16203][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:24.954 UTC [16203][client backend] [[unknown]][60/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:24.954 UTC [16203][client backend] [[unknown]][60/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/multiple-row-versions
2025-01-09 14:06:25.009 UTC [16209][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:25.010 UTC [16209][client backend] [[unknown]][61/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:25.010 UTC [16209][client backend] [[unknown]][61/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/multiple-row-versions
2025-01-09 14:06:25.040 UTC [16212][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:25.041 UTC [16212][client backend] [[unknown]][62/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:25.041 UTC [16212][client backend] [[unknown]][62/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/multiple-row-versions
2025-01-09 14:06:32.161 UTC [16196][client backend] [isolation/multiple-row-versions/control connection][58/4:2597] LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp16196.0", size 14000000
2025-01-09 14:06:32.161 UTC [16196][client backend] [isolation/multiple-row-versions/control connection][58/4:2597] STATEMENT:  
	 CREATE TABLE t (id int NOT NULL, txt text) WITH (fillfactor=50);
	 INSERT INTO t (id)
	   SELECT x FROM (SELECT * FROM generate_series(1, 1000000)) a(x);
	 ALTER TABLE t ADD PRIMARY KEY (id);
	
2025-01-09 14:06:34.894 UTC [16196][client backend] [isolation/multiple-row-versions/control connection][58/4:2597] LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp16196.0.fileset/0.0", size 10510336
2025-01-09 14:06:34.894 UTC [16196][client backend] [isolation/multiple-row-versions/control connection][58/4:2597] STATEMENT:  
	 CREATE TABLE t (id int NOT NULL, txt text) WITH (fillfactor=50);
	 INSERT INTO t (id)
	   SELECT x FROM (SELECT * FROM generate_series(1, 1000000)) a(x);
	 ALTER TABLE t ADD PRIMARY KEY (id);
	
2025-01-09 14:06:34.897 UTC [16196][client backend] [isolation/multiple-row-versions/control connection][58/4:2597] LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp16196.0.fileset/1.0", size 9535488
2025-01-09 14:06:34.897 UTC [16196][client backend] [isolation/multiple-row-versions/control connection][58/4:2597] STATEMENT:  
	 CREATE TABLE t (id int NOT NULL, txt text) WITH (fillfactor=50);
	 INSERT INTO t (id)
	   SELECT x FROM (SELECT * FROM generate_series(1, 1000000)) a(x);
	 ALTER TABLE t ADD PRIMARY KEY (id);
	
2025-01-09 14:06:35.045 UTC [16199][client backend] [isolation/multiple-row-versions/s1][59/3:2601] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:35.045 UTC [16199][client backend] [isolation/multiple-row-versions/s1][59/3:2601] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
2025-01-09 14:06:35.045 UTC [16199][client backend] [isolation/multiple-row-versions/s1][59/3:2601] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:35.045 UTC [16199][client backend] [isolation/multiple-row-versions/s1][59/3:2601] STATEMENT:  UPDATE t SET txt = 'a' WHERE id = 1;
2025-01-09 14:06:35.300 UTC [16212][client backend] [isolation/multiple-row-versions/s4][:0] LOG:  disconnection: session time: 0:00:10.260 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:35.302 UTC [16196][client backend] [isolation/multiple-row-versions/control connection][:0] LOG:  disconnection: session time: 0:00:10.425 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:35.304 UTC [16209][client backend] [isolation/multiple-row-versions/s3][:0] LOG:  disconnection: session time: 0:00:10.296 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:35.308 UTC [16203][client backend] [isolation/multiple-row-versions/s2][:0] LOG:  disconnection: session time: 0:00:10.358 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:35.312 UTC [16199][client backend] [isolation/multiple-row-versions/s1][:0] LOG:  disconnection: session time: 0:00:10.409 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:35.401 UTC [17312][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:35.403 UTC [17312][client backend] [[unknown]][63/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:35.403 UTC [17312][client backend] [[unknown]][63/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/index-only-scan
2025-01-09 14:06:35.423 UTC [17316][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:35.425 UTC [17316][client backend] [[unknown]][64/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:35.425 UTC [17316][client backend] [[unknown]][64/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/index-only-scan
2025-01-09 14:06:35.468 UTC [17319][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:35.469 UTC [17319][client backend] [[unknown]][65/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:35.469 UTC [17319][client backend] [[unknown]][65/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/index-only-scan
2025-01-09 14:06:35.977 UTC [17319][client backend] [isolation/index-only-scan/s2][65/4:2613] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:35.977 UTC [17319][client backend] [isolation/index-only-scan/s2][65/4:2613] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:35.977 UTC [17319][client backend] [isolation/index-only-scan/s2][65/4:2613] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:35.977 UTC [17319][client backend] [isolation/index-only-scan/s2][65/4:2613] STATEMENT:  COMMIT;
2025-01-09 14:06:36.201 UTC [17316][client backend] [isolation/index-only-scan/s1][64/5:2618] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:36.201 UTC [17316][client backend] [isolation/index-only-scan/s1][64/5:2618] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:36.201 UTC [17316][client backend] [isolation/index-only-scan/s1][64/5:2618] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:36.201 UTC [17316][client backend] [isolation/index-only-scan/s1][64/5:2618] STATEMENT:  COMMIT;
2025-01-09 14:06:36.424 UTC [17319][client backend] [isolation/index-only-scan/s2][65/6:2624] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:36.424 UTC [17319][client backend] [isolation/index-only-scan/s2][65/6:2624] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:36.424 UTC [17319][client backend] [isolation/index-only-scan/s2][65/6:2624] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:36.424 UTC [17319][client backend] [isolation/index-only-scan/s2][65/6:2624] STATEMENT:  COMMIT;
2025-01-09 14:06:36.630 UTC [17316][client backend] [isolation/index-only-scan/s1][64/7:2631] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:36.630 UTC [17316][client backend] [isolation/index-only-scan/s1][64/7:2631] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:36.630 UTC [17316][client backend] [isolation/index-only-scan/s1][64/7:2631] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:36.630 UTC [17316][client backend] [isolation/index-only-scan/s1][64/7:2631] STATEMENT:  COMMIT;
2025-01-09 14:06:36.956 UTC [17316][client backend] [isolation/index-only-scan/s1][:0] LOG:  disconnection: session time: 0:00:01.533 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:36.960 UTC [17319][client backend] [isolation/index-only-scan/s2][:0] LOG:  disconnection: session time: 0:00:01.498 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:36.984 UTC [17312][client backend] [isolation/index-only-scan/control connection][:0] LOG:  disconnection: session time: 0:00:01.587 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.057 UTC [17490][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.058 UTC [17490][client backend] [[unknown]][66/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.058 UTC [17490][client backend] [[unknown]][66/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/predicate-lock-hot-tuple
2025-01-09 14:06:37.087 UTC [17496][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.088 UTC [17496][client backend] [[unknown]][67/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.088 UTC [17496][client backend] [[unknown]][67/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/predicate-lock-hot-tuple
2025-01-09 14:06:37.106 UTC [17498][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.108 UTC [17498][client backend] [[unknown]][68/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.108 UTC [17498][client backend] [[unknown]][68/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/predicate-lock-hot-tuple
2025-01-09 14:06:37.145 UTC [17498][client backend] [isolation/predicate-lock-hot-tuple/s2][68/3:2641] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:37.145 UTC [17498][client backend] [isolation/predicate-lock-hot-tuple/s2][68/3:2641] DETAIL:  Reason code: Canceled on identification as a pivot, during commit attempt.
2025-01-09 14:06:37.145 UTC [17498][client backend] [isolation/predicate-lock-hot-tuple/s2][68/3:2641] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:37.145 UTC [17498][client backend] [isolation/predicate-lock-hot-tuple/s2][68/3:2641] STATEMENT:  COMMIT;
2025-01-09 14:06:37.152 UTC [17496][client backend] [isolation/predicate-lock-hot-tuple/s1][:0] LOG:  disconnection: session time: 0:00:00.068 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.154 UTC [17490][client backend] [isolation/predicate-lock-hot-tuple/control connection][:0] LOG:  disconnection: session time: 0:00:00.098 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.160 UTC [17498][client backend] [isolation/predicate-lock-hot-tuple/s2][:0] LOG:  disconnection: session time: 0:00:00.055 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.269 UTC [17518][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.271 UTC [17518][client backend] [[unknown]][69/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.271 UTC [17518][client backend] [[unknown]][69/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/update-conflict-out
2025-01-09 14:06:37.324 UTC [17527][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.325 UTC [17527][client backend] [[unknown]][70/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.325 UTC [17527][client backend] [[unknown]][70/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/update-conflict-out
2025-01-09 14:06:37.376 UTC [17546][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.377 UTC [17546][client backend] [[unknown]][71/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.377 UTC [17546][client backend] [[unknown]][71/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/update-conflict-out
2025-01-09 14:06:37.390 UTC [17550][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.392 UTC [17550][client backend] [[unknown]][72/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.392 UTC [17550][client backend] [[unknown]][72/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/update-conflict-out
2025-01-09 14:06:37.443 UTC [17546][client backend] [isolation/update-conflict-out/bar][71/3:2644] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:37.443 UTC [17546][client backend] [isolation/update-conflict-out/bar][71/3:2644] DETAIL:  Reason code: Canceled on conflict out to pivot 2645, during read.
2025-01-09 14:06:37.443 UTC [17546][client backend] [isolation/update-conflict-out/bar][71/3:2644] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:37.443 UTC [17546][client backend] [isolation/update-conflict-out/bar][71/3:2644] STATEMENT:  SELECT * FROM txn1 WHERE id = 7;
2025-01-09 14:06:37.521 UTC [17546][client backend] [isolation/update-conflict-out/bar][71/4:2649] ERROR:  could not serialize access due to read/write dependencies among transactions
2025-01-09 14:06:37.521 UTC [17546][client backend] [isolation/update-conflict-out/bar][71/4:2649] DETAIL:  Reason code: Canceled on conflict out to pivot 2650, during read.
2025-01-09 14:06:37.521 UTC [17546][client backend] [isolation/update-conflict-out/bar][71/4:2649] HINT:  The transaction might succeed if retried.
2025-01-09 14:06:37.521 UTC [17546][client backend] [isolation/update-conflict-out/bar][71/4:2649] STATEMENT:  SELECT * FROM txn1 WHERE id = 7;
2025-01-09 14:06:37.547 UTC [17550][client backend] [isolation/update-conflict-out/trouble][:0] LOG:  disconnection: session time: 0:00:00.157 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.548 UTC [17518][client backend] [isolation/update-conflict-out/control connection][:0] LOG:  disconnection: session time: 0:00:00.279 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.550 UTC [17527][client backend] [isolation/update-conflict-out/foo][:0] LOG:  disconnection: session time: 0:00:00.250 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.556 UTC [17546][client backend] [isolation/update-conflict-out/bar][:0] LOG:  disconnection: session time: 0:00:00.187 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.648 UTC [17580][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.650 UTC [17580][client backend] [[unknown]][73/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.650 UTC [17580][client backend] [[unknown]][73/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-simple
2025-01-09 14:06:37.684 UTC [17588][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.685 UTC [17588][client backend] [[unknown]][74/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.685 UTC [17588][client backend] [[unknown]][74/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-simple
2025-01-09 14:06:37.732 UTC [17594][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.733 UTC [17594][client backend] [[unknown]][75/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.733 UTC [17594][client backend] [[unknown]][75/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-simple
2025-01-09 14:06:37.754 UTC [17594][client backend] [isolation/deadlock-simple/s2][75/3:2655] ERROR:  deadlock detected
2025-01-09 14:06:37.754 UTC [17594][client backend] [isolation/deadlock-simple/s2][75/3:2655] DETAIL:  Process 17594 waits for AccessExclusiveLock on relation 22547 of database 16384; blocked by process 17588.
	Process 17588 waits for AccessExclusiveLock on relation 22547 of database 16384; blocked by process 17594.
	Process 17594: LOCK TABLE a1 IN ACCESS EXCLUSIVE MODE;
	Process 17588: LOCK TABLE a1 IN ACCESS EXCLUSIVE MODE;
2025-01-09 14:06:37.754 UTC [17594][client backend] [isolation/deadlock-simple/s2][75/3:2655] HINT:  See server log for query details.
2025-01-09 14:06:37.754 UTC [17594][client backend] [isolation/deadlock-simple/s2][75/3:2655] STATEMENT:  LOCK TABLE a1 IN ACCESS EXCLUSIVE MODE;
2025-01-09 14:06:37.758 UTC [17588][client backend] [isolation/deadlock-simple/s1][:0] LOG:  disconnection: session time: 0:00:00.076 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.758 UTC [17594][client backend] [isolation/deadlock-simple/s2][:0] LOG:  disconnection: session time: 0:00:00.034 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.761 UTC [17580][client backend] [isolation/deadlock-simple/control connection][:0] LOG:  disconnection: session time: 0:00:00.116 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:37.854 UTC [17610][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.856 UTC [17610][client backend] [[unknown]][76/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.856 UTC [17610][client backend] [[unknown]][76/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-hard
2025-01-09 14:06:37.872 UTC [17617][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.873 UTC [17617][client backend] [[unknown]][77/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.873 UTC [17617][client backend] [[unknown]][77/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-hard
2025-01-09 14:06:37.896 UTC [17624][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.897 UTC [17624][client backend] [[unknown]][78/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.897 UTC [17624][client backend] [[unknown]][78/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-hard
2025-01-09 14:06:37.922 UTC [17626][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.923 UTC [17626][client backend] [[unknown]][79/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.923 UTC [17626][client backend] [[unknown]][79/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-hard
2025-01-09 14:06:37.952 UTC [17632][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.954 UTC [17632][client backend] [[unknown]][80/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.954 UTC [17632][client backend] [[unknown]][80/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-hard
2025-01-09 14:06:37.968 UTC [17638][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:37.969 UTC [17638][client backend] [[unknown]][81/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:37.969 UTC [17638][client backend] [[unknown]][81/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-hard
2025-01-09 14:06:38.000 UTC [17642][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:38.001 UTC [17642][client backend] [[unknown]][82/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:38.001 UTC [17642][client backend] [[unknown]][82/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-hard
2025-01-09 14:06:38.012 UTC [17645][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:38.014 UTC [17645][client backend] [[unknown]][83/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:38.014 UTC [17645][client backend] [[unknown]][83/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-hard
2025-01-09 14:06:38.041 UTC [17648][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:38.042 UTC [17648][client backend] [[unknown]][84/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:38.042 UTC [17648][client backend] [[unknown]][84/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-hard
2025-01-09 14:06:38.371 UTC [17648][client backend] [isolation/deadlock-hard/s8][84/3:2665] LOG:  process 17648 detected deadlock while waiting for AccessExclusiveLock on relation 22550 of database 16384 after 10.073 ms
2025-01-09 14:06:38.371 UTC [17648][client backend] [isolation/deadlock-hard/s8][84/3:2665] DETAIL:  Process holding the lock: 17617. Wait queue: .
2025-01-09 14:06:38.371 UTC [17648][client backend] [isolation/deadlock-hard/s8][84/3:2665] STATEMENT:  LOCK TABLE a1;
2025-01-09 14:06:38.372 UTC [17648][client backend] [isolation/deadlock-hard/s8][84/3:2665] ERROR:  deadlock detected
2025-01-09 14:06:38.372 UTC [17648][client backend] [isolation/deadlock-hard/s8][84/3:2665] DETAIL:  Process 17648 waits for AccessExclusiveLock on relation 22550 of database 16384; blocked by process 17617.
	Process 17617 waits for AccessExclusiveLock on relation 22553 of database 16384; blocked by process 17624.
	Process 17624 waits for AccessExclusiveLock on relation 22556 of database 16384; blocked by process 17626.
	Process 17626 waits for AccessExclusiveLock on relation 22559 of database 16384; blocked by process 17632.
	Process 17632 waits for AccessExclusiveLock on relation 22562 of database 16384; blocked by process 17638.
	Process 17638 waits for AccessExclusiveLock on relation 22565 of database 16384; blocked by process 17642.
	Process 17642 waits for AccessExclusiveLock on relation 22568 of database 16384; blocked by process 17645.
	Process 17645 waits for AccessExclusiveLock on relation 22571 of database 16384; blocked by process 17648.
	Process 17648: LOCK TABLE a1;
	Process 17617: LOCK TABLE a2;
	Process 17624: LOCK TABLE a3;
	Process 17626: LOCK TABLE a4;
	Process 17632: LOCK TABLE a5;
	Process 17638: LOCK TABLE a6;
	Process 17642: LOCK TABLE a7;
	Process 17645: LOCK TABLE a8;
2025-01-09 14:06:38.372 UTC [17648][client backend] [isolation/deadlock-hard/s8][84/3:2665] HINT:  See server log for query details.
2025-01-09 14:06:38.372 UTC [17648][client backend] [isolation/deadlock-hard/s8][84/3:2665] STATEMENT:  LOCK TABLE a1;
2025-01-09 14:06:38.733 UTC [17638][client backend] [isolation/deadlock-hard/s5][:0] LOG:  disconnection: session time: 0:00:00.765 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:38.736 UTC [17617][client backend] [isolation/deadlock-hard/s1][:0] LOG:  disconnection: session time: 0:00:00.864 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:38.736 UTC [17610][client backend] [isolation/deadlock-hard/control connection][:0] LOG:  disconnection: session time: 0:00:00.883 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:38.740 UTC [17624][client backend] [isolation/deadlock-hard/s2][:0] LOG:  disconnection: session time: 0:00:00.846 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:38.744 UTC [17626][client backend] [isolation/deadlock-hard/s3][:0] LOG:  disconnection: session time: 0:00:00.822 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:38.748 UTC [17632][client backend] [isolation/deadlock-hard/s4][:0] LOG:  disconnection: session time: 0:00:00.799 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:38.752 UTC [17642][client backend] [isolation/deadlock-hard/s6][:0] LOG:  disconnection: session time: 0:00:00.759 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:38.756 UTC [17645][client backend] [isolation/deadlock-hard/s7][:0] LOG:  disconnection: session time: 0:00:00.743 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:38.760 UTC [17648][client backend] [isolation/deadlock-hard/s8][:0] LOG:  disconnection: session time: 0:00:00.721 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:38.778 UTC [17770][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:38.779 UTC [17770][client backend] [[unknown]][85/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:38.779 UTC [17770][client backend] [[unknown]][85/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft
2025-01-09 14:06:38.790 UTC [17773][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:38.791 UTC [17773][client backend] [[unknown]][86/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:38.791 UTC [17773][client backend] [[unknown]][86/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft
2025-01-09 14:06:38.812 UTC [17779][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:38.813 UTC [17779][client backend] [[unknown]][87/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:38.813 UTC [17779][client backend] [[unknown]][87/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft
2025-01-09 14:06:38.844 UTC [17781][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:38.845 UTC [17781][client backend] [[unknown]][88/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:38.845 UTC [17781][client backend] [[unknown]][88/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft
2025-01-09 14:06:38.876 UTC [17789][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:38.878 UTC [17789][client backend] [[unknown]][89/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:38.878 UTC [17789][client backend] [[unknown]][89/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft
2025-01-09 14:06:38.975 UTC [17779][client backend] [isolation/deadlock-soft/d2][87/3:0] LOG:  process 17779 avoided deadlock for AccessShareLock on relation 22574 of database 16384 by rearranging queue order after 10.072 ms
2025-01-09 14:06:38.975 UTC [17779][client backend] [isolation/deadlock-soft/d2][87/3:0] DETAIL:  Process holding the lock: 17773. Wait queue: 17781, 17779.
2025-01-09 14:06:38.975 UTC [17779][client backend] [isolation/deadlock-soft/d2][87/3:0] STATEMENT:  LOCK TABLE a1 IN ACCESS SHARE MODE;
2025-01-09 14:06:38.975 UTC [17779][client backend] [isolation/deadlock-soft/d2][87/3:0] LOG:  process 17779 still waiting for AccessShareLock on relation 22574 of database 16384 after 10.072 ms
2025-01-09 14:06:38.975 UTC [17779][client backend] [isolation/deadlock-soft/d2][87/3:0] DETAIL:  Process holding the lock: 17773. Wait queue: 17781, 17779.
2025-01-09 14:06:38.975 UTC [17779][client backend] [isolation/deadlock-soft/d2][87/3:0] STATEMENT:  LOCK TABLE a1 IN ACCESS SHARE MODE;
2025-01-09 14:06:39.019 UTC [17779][client backend] [isolation/deadlock-soft/d2][87/3:0] LOG:  process 17779 acquired AccessShareLock on relation 22574 of database 16384 after 53.387 ms
2025-01-09 14:06:39.019 UTC [17779][client backend] [isolation/deadlock-soft/d2][87/3:0] STATEMENT:  LOCK TABLE a1 IN ACCESS SHARE MODE;
2025-01-09 14:06:39.035 UTC [17770][client backend] [isolation/deadlock-soft/control connection][:0] LOG:  disconnection: session time: 0:00:00.257 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.037 UTC [17773][client backend] [isolation/deadlock-soft/d1][:0] LOG:  disconnection: session time: 0:00:00.249 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.040 UTC [17779][client backend] [isolation/deadlock-soft/d2][:0] LOG:  disconnection: session time: 0:00:00.231 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.044 UTC [17781][client backend] [isolation/deadlock-soft/e1][:0] LOG:  disconnection: session time: 0:00:00.203 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.048 UTC [17789][client backend] [isolation/deadlock-soft/e2][:0] LOG:  disconnection: session time: 0:00:00.174 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.235 UTC [17854][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.237 UTC [17854][client backend] [[unknown]][90/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.237 UTC [17854][client backend] [[unknown]][90/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft-2
2025-01-09 14:06:39.274 UTC [17856][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.276 UTC [17856][client backend] [[unknown]][91/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.276 UTC [17856][client backend] [[unknown]][91/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft-2
2025-01-09 14:06:39.315 UTC [17859][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.317 UTC [17859][client backend] [[unknown]][92/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.317 UTC [17859][client backend] [[unknown]][92/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft-2
2025-01-09 14:06:39.372 UTC [17864][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.373 UTC [17864][client backend] [[unknown]][93/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.373 UTC [17864][client backend] [[unknown]][93/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft-2
2025-01-09 14:06:39.424 UTC [17867][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.425 UTC [17867][client backend] [[unknown]][94/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.425 UTC [17867][client backend] [[unknown]][94/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-soft-2
2025-01-09 14:06:39.529 UTC [17856][client backend] [isolation/deadlock-soft-2/s1][91/3:0] LOG:  process 17856 avoided deadlock for ShareUpdateExclusiveLock on relation 22583 of database 16384 by rearranging queue order after 10.203 ms
2025-01-09 14:06:39.529 UTC [17856][client backend] [isolation/deadlock-soft-2/s1][91/3:0] DETAIL:  Processes holding the lock: 17859, 17856. Wait queue: 17864, 17867.
2025-01-09 14:06:39.529 UTC [17856][client backend] [isolation/deadlock-soft-2/s1][91/3:0] STATEMENT:  LOCK TABLE a2 IN SHARE UPDATE EXCLUSIVE MODE;
2025-01-09 14:06:39.529 UTC [17856][client backend] [isolation/deadlock-soft-2/s1][91/3:0] LOG:  process 17856 acquired ShareUpdateExclusiveLock on relation 22583 of database 16384 after 10.203 ms
2025-01-09 14:06:39.529 UTC [17856][client backend] [isolation/deadlock-soft-2/s1][91/3:0] STATEMENT:  LOCK TABLE a2 IN SHARE UPDATE EXCLUSIVE MODE;
2025-01-09 14:06:39.624 UTC [17856][client backend] [isolation/deadlock-soft-2/s1][:0] LOG:  disconnection: session time: 0:00:00.353 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.628 UTC [17859][client backend] [isolation/deadlock-soft-2/s2][:0] LOG:  disconnection: session time: 0:00:00.316 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.632 UTC [17864][client backend] [isolation/deadlock-soft-2/s3][:0] LOG:  disconnection: session time: 0:00:00.264 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.636 UTC [17867][client backend] [isolation/deadlock-soft-2/s4][:0] LOG:  disconnection: session time: 0:00:00.219 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.642 UTC [17854][client backend] [isolation/deadlock-soft-2/control connection][:0] LOG:  disconnection: session time: 0:00:00.410 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:39.772 UTC [17886][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.773 UTC [17886][client backend] [[unknown]][95/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.773 UTC [17886][client backend] [[unknown]][95/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-parallel
2025-01-09 14:06:39.810 UTC [17887][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.811 UTC [17887][client backend] [[unknown]][96/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.811 UTC [17887][client backend] [[unknown]][96/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-parallel
2025-01-09 14:06:39.858 UTC [17890][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.860 UTC [17890][client backend] [[unknown]][97/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.860 UTC [17890][client backend] [[unknown]][97/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-parallel
2025-01-09 14:06:39.911 UTC [17892][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.912 UTC [17892][client backend] [[unknown]][98/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.912 UTC [17892][client backend] [[unknown]][98/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-parallel
2025-01-09 14:06:39.950 UTC [17896][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:39.952 UTC [17896][client backend] [[unknown]][99/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:39.952 UTC [17896][client backend] [[unknown]][99/1:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/deadlock-parallel
2025-01-09 14:06:40.520 UTC [17923][parallel worker] LOG:  process 17923 avoided deadlock for ShareLock on advisory lock [16384,0,1,1] by rearranging queue order after 13.069 ms
2025-01-09 14:06:40.520 UTC [17923][parallel worker] DETAIL:  Process holding the lock: 17887. Wait queue: 17902, 17923, 17922.
2025-01-09 14:06:40.520 UTC [17923][parallel worker] CONTEXT:  SQL function "lock_share" statement 1
2025-01-09 14:06:40.520 UTC [17923][parallel worker] STATEMENT:  SET debug_parallel_query = on;
				  SET parallel_setup_cost = 0;
				  SET parallel_tuple_cost = 0;
				  SET min_parallel_table_scan_size = 0;
				  SET parallel_leader_participation = off;
				  SET max_parallel_workers_per_gather = 3;
				  SELECT sum(lock_share(1,x)) FROM bigt;
				  SET debug_parallel_query = off;
				  RESET parallel_setup_cost;
				  RESET parallel_tuple_cost;
				  SELECT lock_share(3,x) FROM bigt LIMIT 1;
2025-01-09 14:06:40.520 UTC [17923][parallel worker] LOG:  process 17923 still waiting for ShareLock on advisory lock [16384,0,1,1] after 13.069 ms
2025-01-09 14:06:40.520 UTC [17923][parallel worker] DETAIL:  Process holding the lock: 17887. Wait queue: 17902, 17923, 17922.
2025-01-09 14:06:40.520 UTC [17923][parallel worker] CONTEXT:  SQL function "lock_share" statement 1
2025-01-09 14:06:40.520 UTC [17923][parallel worker] STATEMENT:  SET debug_parallel_query = on;
				  SET parallel_setup_cost = 0;
				  SET parallel_tuple_cost = 0;
				  SET min_parallel_table_scan_size = 0;
				  SET parallel_leader_participation = off;
				  SET max_parallel_workers_per_gather = 3;
				  SELECT sum(lock_share(1,x)) FROM bigt;
				  SET debug_parallel_query = off;
				  RESET parallel_setup_cost;
				  RESET parallel_tuple_cost;
				  SELECT lock_share(3,x) FROM bigt LIMIT 1;
2025-01-09 14:06:40.522 UTC [17922][parallel worker] LOG:  process 17922 still waiting for ShareLock on advisory lock [16384,0,1,1] after 12.239 ms
2025-01-09 14:06:40.522 UTC [17922][parallel worker] DETAIL:  Process holding the lock: 17887. Wait queue: 17902, 17923, 17922.
2025-01-09 14:06:40.522 UTC [17922][parallel worker] CONTEXT:  SQL function "lock_share" statement 1
2025-01-09 14:06:40.522 UTC [17922][parallel worker] STATEMENT:  SET debug_parallel_query = on;
				  SET parallel_setup_cost = 0;
				  SET parallel_tuple_cost = 0;
				  SET min_parallel_table_scan_size = 0;
				  SET parallel_leader_participation = off;
				  SET max_parallel_workers_per_gather = 3;
				  SELECT sum(lock_share(1,x)) FROM bigt;
				  SET debug_parallel_query = off;
				  RESET parallel_setup_cost;
				  RESET parallel_tuple_cost;
				  SELECT lock_share(3,x) FROM bigt LIMIT 1;
2025-01-09 14:06:40.711 UTC [17923][parallel worker] LOG:  process 17923 acquired ShareLock on advisory lock [16384,0,1,1] after 204.276 ms
2025-01-09 14:06:40.711 UTC [17923][parallel worker] CONTEXT:  SQL function "lock_share" statement 1
2025-01-09 14:06:40.711 UTC [17923][parallel worker] STATEMENT:  SET debug_parallel_query = on;
				  SET parallel_setup_cost = 0;
				  SET parallel_tuple_cost = 0;
				  SET min_parallel_table_scan_size = 0;
				  SET parallel_leader_participation = off;
				  SET max_parallel_workers_per_gather = 3;
				  SELECT sum(lock_share(1,x)) FROM bigt;
				  SET debug_parallel_query = off;
				  RESET parallel_setup_cost;
				  RESET parallel_tuple_cost;
				  SELECT lock_share(3,x) FROM bigt LIMIT 1;
2025-01-09 14:06:40.716 UTC [17922][parallel worker] LOG:  process 17922 acquired ShareLock on advisory lock [16384,0,1,1] after 206.030 ms
2025-01-09 14:06:40.716 UTC [17922][parallel worker] CONTEXT:  SQL function "lock_share" statement 1
2025-01-09 14:06:40.716 UTC [17922][parallel worker] STATEMENT:  SET debug_parallel_query = on;
				  SET parallel_setup_cost = 0;
				  SET parallel_tuple_cost = 0;
				  SET min_parallel_table_scan_size = 0;
				  SET parallel_leader_participation = off;
				  SET max_parallel_workers_per_gather = 3;
				  SELECT sum(lock_share(1,x)) FROM bigt;
				  SET debug_parallel_query = off;
				  RESET parallel_setup_cost;
				  RESET parallel_tuple_cost;
				  SELECT lock_share(3,x) FROM bigt LIMIT 1;
2025-01-09 14:06:40.944 UTC [17887][client backend] [isolation/deadlock-parallel/d1][:0] LOG:  disconnection: session time: 0:00:01.135 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:40.948 UTC [17892][client backend] [isolation/deadlock-parallel/e1][:0] LOG:  disconnection: session time: 0:00:01.043 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:40.952 UTC [17890][client backend] [isolation/deadlock-parallel/d2][:0] LOG:  disconnection: session time: 0:00:01.099 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:40.956 UTC [17896][client backend] [isolation/deadlock-parallel/e2][:0] LOG:  disconnection: session time: 0:00:01.007 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:40.968 UTC [17886][client backend] [isolation/deadlock-parallel/control connection][:0] LOG:  disconnection: session time: 0:00:01.203 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:41.060 UTC [17963][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:41.069 UTC [17963][client backend] [[unknown]][0/2:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:41.069 UTC [17963][client backend] [[unknown]][0/2:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-1
2025-01-09 14:06:41.109 UTC [17968][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:41.111 UTC [17968][client backend] [[unknown]][1/4:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:41.111 UTC [17968][client backend] [[unknown]][1/4:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-1
2025-01-09 14:06:41.148 UTC [17970][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:41.150 UTC [17970][client backend] [[unknown]][3/4:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:41.150 UTC [17970][client backend] [[unknown]][3/4:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-1
2025-01-09 14:06:41.182 UTC [17973][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:41.183 UTC [17973][client backend] [[unknown]][4/4:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:41.183 UTC [17973][client backend] [[unknown]][4/4:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-1
2025-01-09 14:06:41.633 UTC [17973][client backend] [isolation/detach-partition-concurrently-1/s3][4/9:0] ERROR:  no partition of relation "d_listp" found for row
2025-01-09 14:06:41.633 UTC [17973][client backend] [isolation/detach-partition-concurrently-1/s3][4/9:0] DETAIL:  Partition key of the failing row contains (a) = (2).
2025-01-09 14:06:41.633 UTC [17973][client backend] [isolation/detach-partition-concurrently-1/s3][4/9:0] STATEMENT:  INSERT INTO d_listp VALUES (2);
2025-01-09 14:06:42.018 UTC [17973][client backend] [isolation/detach-partition-concurrently-1/s3][:0] LOG:  disconnection: session time: 0:00:00.842 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:42.021 UTC [17968][client backend] [isolation/detach-partition-concurrently-1/s1][:0] LOG:  disconnection: session time: 0:00:00.912 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:42.024 UTC [17970][client backend] [isolation/detach-partition-concurrently-1/s2][:0] LOG:  disconnection: session time: 0:00:00.879 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:42.030 UTC [17963][client backend] [isolation/detach-partition-concurrently-1/control connection][:0] LOG:  disconnection: session time: 0:00:00.977 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:42.195 UTC [18044][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:42.197 UTC [18044][client backend] [[unknown]][5/4:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:42.197 UTC [18044][client backend] [[unknown]][5/4:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-2
2025-01-09 14:06:42.244 UTC [18046][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:42.245 UTC [18046][client backend] [[unknown]][2/7:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:42.245 UTC [18046][client backend] [[unknown]][2/7:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-2
2025-01-09 14:06:42.288 UTC [18051][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:42.289 UTC [18051][client backend] [[unknown]][7/5:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:42.289 UTC [18051][client backend] [[unknown]][7/5:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-2
2025-01-09 14:06:42.317 UTC [18056][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:42.319 UTC [18056][client backend] [[unknown]][8/5:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:42.319 UTC [18056][client backend] [[unknown]][8/5:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-2
2025-01-09 14:06:42.419 UTC [18056][client backend] [isolation/detach-partition-concurrently-2/s3][8/7:2742] ERROR:  insert or update on table "d_lp_fk_r" violates foreign key constraint "d_lp_fk_r_a_fkey"
2025-01-09 14:06:42.419 UTC [18056][client backend] [isolation/detach-partition-concurrently-2/s3][8/7:2742] DETAIL:  Key (a)=(1) is not present in table "d_lp_fk".
2025-01-09 14:06:42.419 UTC [18056][client backend] [isolation/detach-partition-concurrently-2/s3][8/7:2742] STATEMENT:  INSERT INTO d_lp_fk_r VALUES (1);
2025-01-09 14:06:42.773 UTC [18051][client backend] [isolation/detach-partition-concurrently-2/s2][7/11:2753] ERROR:  removing partition "d_lp_fk_1" violates foreign key constraint "d_lp_fk_r_a_fkey1"
2025-01-09 14:06:42.773 UTC [18051][client backend] [isolation/detach-partition-concurrently-2/s2][7/11:2753] DETAIL:  Key (a)=(1) is still referenced from table "d_lp_fk_r".
2025-01-09 14:06:42.773 UTC [18051][client backend] [isolation/detach-partition-concurrently-2/s2][7/11:2753] STATEMENT:  ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY;
2025-01-09 14:06:43.101 UTC [18056][client backend] [isolation/detach-partition-concurrently-2/s3][8/12:2762] ERROR:  insert or update on table "d_lp_fk_r" violates foreign key constraint "d_lp_fk_r_a_fkey"
2025-01-09 14:06:43.101 UTC [18056][client backend] [isolation/detach-partition-concurrently-2/s3][8/12:2762] DETAIL:  Key (a)=(1) is not present in table "d_lp_fk".
2025-01-09 14:06:43.101 UTC [18056][client backend] [isolation/detach-partition-concurrently-2/s3][8/12:2762] STATEMENT:  INSERT INTO d_lp_fk_r VALUES (1);
2025-01-09 14:06:43.171 UTC [18046][client backend] [isolation/detach-partition-concurrently-2/s1][:0] LOG:  disconnection: session time: 0:00:00.928 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:43.176 UTC [18051][client backend] [isolation/detach-partition-concurrently-2/s2][:0] LOG:  disconnection: session time: 0:00:00.892 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:43.180 UTC [18056][client backend] [isolation/detach-partition-concurrently-2/s3][:0] LOG:  disconnection: session time: 0:00:00.862 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:43.200 UTC [18044][client backend] [isolation/detach-partition-concurrently-2/control connection][:0] LOG:  disconnection: session time: 0:00:01.008 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:43.291 UTC [18134][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:43.293 UTC [18134][client backend] [[unknown]][9/5:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:43.293 UTC [18134][client backend] [[unknown]][9/5:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-3
2025-01-09 14:06:43.325 UTC [18138][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:43.326 UTC [18138][client backend] [[unknown]][6/8:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:43.326 UTC [18138][client backend] [[unknown]][6/8:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-3
2025-01-09 14:06:43.377 UTC [18145][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:43.378 UTC [18145][client backend] [[unknown]][10/8:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:43.378 UTC [18145][client backend] [[unknown]][10/8:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-3
2025-01-09 14:06:43.426 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/12:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.426 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/12:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:43.429 UTC [18138][client backend] [isolation/detach-partition-concurrently-3/s1][6/12:2768] ERROR:  cannot alter partition "d3_listp1" with an incomplete detach
2025-01-09 14:06:43.429 UTC [18138][client backend] [isolation/detach-partition-concurrently-3/s1][6/12:2768] HINT:  Use ALTER TABLE ... DETACH PARTITION ... FINALIZE to complete the pending detach operation.
2025-01-09 14:06:43.429 UTC [18138][client backend] [isolation/detach-partition-concurrently-3/s1][6/12:2768] STATEMENT:  ALTER TABLE d3_listp1 ALTER a DROP NOT NULL;
2025-01-09 14:06:43.473 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/15:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.473 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/15:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:43.473 UTC [18138][client backend] [isolation/detach-partition-concurrently-3/s1][6/13:0] ERROR:  no partition of relation "d3_listp" found for row
2025-01-09 14:06:43.473 UTC [18138][client backend] [isolation/detach-partition-concurrently-3/s1][6/13:0] DETAIL:  Partition key of the failing row contains (a) = (1).
2025-01-09 14:06:43.473 UTC [18138][client backend] [isolation/detach-partition-concurrently-3/s1][6/13:0] STATEMENT:  INSERT INTO d3_listp VALUES (1);
2025-01-09 14:06:43.514 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/18:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.514 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/18:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:43.568 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/21:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.568 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/21:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:43.621 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/24:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.621 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/24:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp2 CONCURRENTLY;
2025-01-09 14:06:43.683 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/27:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.683 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/27:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp2 CONCURRENTLY;
2025-01-09 14:06:43.747 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/30:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.747 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/30:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:43.792 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/33:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.792 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/33:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:43.856 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/36:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.856 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/36:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:43.857 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/37:0] ERROR:  partition "d3_listp1" already pending detach in partitioned table "public.d3_listp"
2025-01-09 14:06:43.857 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/37:0] HINT:  Use ALTER TABLE ... DETACH PARTITION ... FINALIZE to complete the pending detach operation.
2025-01-09 14:06:43.857 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/37:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp2 CONCURRENTLY;
2025-01-09 14:06:43.917 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/40:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.917 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/40:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:43.997 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/46:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:43.997 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/46:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:44.054 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/51:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:44.054 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/51:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:44.112 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/55:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:44.112 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/55:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:44.181 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/59:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:44.181 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/59:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:44.257 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/63:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:44.257 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/63:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:44.297 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/67:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:44.297 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/67:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:44.361 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/71:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:44.361 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/71:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:44.426 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/75:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:44.426 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][10/75:0] STATEMENT:  ALTER TABLE d3_listp DETACH PARTITION d3_listp1 CONCURRENTLY;
2025-01-09 14:06:44.452 UTC [18138][client backend] [isolation/detach-partition-concurrently-3/s1][:0] LOG:  disconnection: session time: 0:00:01.133 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:44.456 UTC [18145][client backend] [isolation/detach-partition-concurrently-3/s2][:0] LOG:  disconnection: session time: 0:00:01.080 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:44.480 UTC [18134][client backend] [isolation/detach-partition-concurrently-3/control connection][:0] LOG:  disconnection: session time: 0:00:01.195 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:44.536 UTC [18238][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:44.537 UTC [18238][client backend] [[unknown]][12/4:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:44.537 UTC [18238][client backend] [[unknown]][12/4:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-4
2025-01-09 14:06:44.557 UTC [18243][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:44.558 UTC [18243][client backend] [[unknown]][11/4:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:44.558 UTC [18243][client backend] [[unknown]][11/4:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-4
2025-01-09 14:06:44.584 UTC [18248][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:44.585 UTC [18248][client backend] [[unknown]][13/4:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:44.585 UTC [18248][client backend] [[unknown]][13/4:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-4
2025-01-09 14:06:44.616 UTC [18252][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:44.617 UTC [18252][client backend] [[unknown]][16/5:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:44.617 UTC [18252][client backend] [[unknown]][16/5:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/detach-partition-concurrently-4
2025-01-09 14:06:44.680 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/8:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:44.680 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/8:0] STATEMENT:  alter table d4_primary detach partition d4_primary1 concurrently;
2025-01-09 14:06:44.682 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/6:2861] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:44.682 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/6:2861] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:44.682 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/6:2861] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:44.784 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/7:2865] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:44.784 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/7:2865] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:44.784 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/7:2865] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:44.885 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/14:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:44.885 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/14:0] STATEMENT:  alter table d4_primary detach partition d4_primary1 concurrently;
2025-01-09 14:06:44.886 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/8:2870] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:44.886 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/8:2870] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:44.886 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/8:2870] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:45.009 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/9:2874] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:45.009 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/9:2874] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:45.009 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/9:2874] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:45.119 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/20:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:45.119 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/20:0] STATEMENT:  alter table d4_primary detach partition d4_primary1 concurrently;
2025-01-09 14:06:45.120 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/10:2879] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:45.120 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/10:2879] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:45.120 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/10:2879] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:45.254 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/11:2883] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:45.254 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/11:2883] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:45.254 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/11:2883] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:45.365 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/26:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:45.365 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/26:0] STATEMENT:  alter table d4_primary detach partition d4_primary1 concurrently;
2025-01-09 14:06:45.366 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/12:2888] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:45.366 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/12:2888] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:45.366 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/12:2888] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:45.535 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/13:2893] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:45.535 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/13:2893] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:45.535 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/13:2893] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:45.659 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/14:2900] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:45.659 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/14:2900] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:45.659 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/14:2900] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:45.817 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/15:2905] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:45.817 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/15:2905] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:45.817 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/15:2905] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:45.890 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/16:2910] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:45.890 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/16:2910] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:45.890 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/16:2910] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:45.986 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/17:2916] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:45.986 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/17:2916] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:45.986 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/17:2916] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:46.072 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/44:2921] ERROR:  canceling statement due to user request
2025-01-09 14:06:46.072 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/44:2921] STATEMENT:  alter table d4_primary detach partition d4_primary1 concurrently;
2025-01-09 14:06:46.073 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/18:2922] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:46.073 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/18:2922] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:46.073 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/18:2922] STATEMENT:  update d4_fk set a = 1 where current of f;
2025-01-09 14:06:46.170 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/19:2927] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:46.170 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/19:2927] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:46.170 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/19:2927] STATEMENT:  update d4_fk set a = 1 where current of f;
2025-01-09 14:06:46.245 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/49:2931] ERROR:  removing partition "d4_primary1" violates foreign key constraint "d4_fk_a_fkey1"
2025-01-09 14:06:46.245 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/49:2931] DETAIL:  Key (a)=(1) is still referenced from table "d4_fk".
2025-01-09 14:06:46.245 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/49:2931] STATEMENT:  alter table d4_primary detach partition d4_primary1 concurrently;
2025-01-09 14:06:46.310 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][16/10:2935] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:46.310 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][16/10:2935] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:46.310 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][16/10:2935] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:46.370 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][16/11:2940] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:46.370 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][16/11:2940] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:46.370 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][16/11:2940] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:46.392 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/55:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:46.392 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/55:0] STATEMENT:  alter table d4_primary detach partition d4_primary1 concurrently;
2025-01-09 14:06:46.439 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][16/12:2944] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:46.439 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][16/12:2944] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:46.439 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][16/12:2944] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:46.504 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/61:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:46.504 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/61:0] STATEMENT:  alter table d4_primary detach partition d4_primary1 concurrently;
2025-01-09 14:06:46.508 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/24:2949] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:46.508 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/24:2949] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:46.508 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/24:2949] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:46.570 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/64:0] ERROR:  canceling statement due to user request
2025-01-09 14:06:46.570 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][13/64:0] STATEMENT:  alter table d4_primary detach partition d4_primary1 concurrently;
2025-01-09 14:06:46.573 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/25:2953] ERROR:  insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey"
2025-01-09 14:06:46.573 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/25:2953] DETAIL:  Key (a)=(1) is not present in table "d4_primary".
2025-01-09 14:06:46.573 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][11/25:2953] STATEMENT:  insert into d4_fk values (1);
2025-01-09 14:06:46.577 UTC [18248][client backend] [isolation/detach-partition-concurrently-4/s2][:0] LOG:  disconnection: session time: 0:00:01.996 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:46.585 UTC [18238][client backend] [isolation/detach-partition-concurrently-4/control connection][:0] LOG:  disconnection: session time: 0:00:02.057 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:46.592 UTC [18252][client backend] [isolation/detach-partition-concurrently-4/s3][:0] LOG:  disconnection: session time: 0:00:01.983 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:46.596 UTC [18243][client backend] [isolation/detach-partition-concurrently-4/s1][:0] LOG:  disconnection: session time: 0:00:02.039 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:46.716 UTC [18475][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:46.718 UTC [18475][client backend] [[unknown]][15/5:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:46.718 UTC [18475][client backend] [[unknown]][15/5:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-contention
2025-01-09 14:06:46.732 UTC [18483][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:46.733 UTC [18483][client backend] [[unknown]][14/10:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:46.733 UTC [18483][client backend] [[unknown]][14/10:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-contention
2025-01-09 14:06:46.752 UTC [18484][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:46.754 UTC [18484][client backend] [[unknown]][18/5:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:46.754 UTC [18484][client backend] [[unknown]][18/5:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-contention
2025-01-09 14:06:46.927 UTC [18483][client backend] [isolation/fk-contention/s1][:0] LOG:  disconnection: session time: 0:00:00.196 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:46.928 UTC [18484][client backend] [isolation/fk-contention/s2][:0] LOG:  disconnection: session time: 0:00:00.179 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:46.946 UTC [18475][client backend] [isolation/fk-contention/control connection][:0] LOG:  disconnection: session time: 0:00:00.234 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:47.004 UTC [18522][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:47.005 UTC [18522][client backend] [[unknown]][19/5:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:47.005 UTC [18522][client backend] [[unknown]][19/5:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-deadlock
2025-01-09 14:06:47.036 UTC [18530][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:47.038 UTC [18530][client backend] [[unknown]][17/9:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:47.038 UTC [18530][client backend] [[unknown]][17/9:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-deadlock
2025-01-09 14:06:47.064 UTC [18534][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:47.066 UTC [18534][client backend] [[unknown]][21/4:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:47.066 UTC [18534][client backend] [[unknown]][21/4:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-deadlock
2025-01-09 14:06:47.854 UTC [18530][client backend] [isolation/fk-deadlock/s1][:0] LOG:  disconnection: session time: 0:00:00.822 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:47.860 UTC [18534][client backend] [isolation/fk-deadlock/s2][:0] LOG:  disconnection: session time: 0:00:00.796 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:47.880 UTC [18522][client backend] [isolation/fk-deadlock/control connection][:0] LOG:  disconnection: session time: 0:00:00.886 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:47.964 UTC [18624][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:47.965 UTC [18624][client backend] [[unknown]][22/4:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:47.965 UTC [18624][client backend] [[unknown]][22/4:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-deadlock2
2025-01-09 14:06:48.004 UTC [18627][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:48.005 UTC [18627][client backend] [[unknown]][20/7:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:48.005 UTC [18627][client backend] [[unknown]][20/7:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-deadlock2
2025-01-09 14:06:48.026 UTC [18633][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:48.027 UTC [18633][client backend] [[unknown]][24/6:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:48.027 UTC [18633][client backend] [[unknown]][24/6:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-deadlock2
2025-01-09 14:06:48.566 UTC [18627][client backend] [isolation/fk-deadlock2/s1][:0] LOG:  disconnection: session time: 0:00:00.570 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:48.568 UTC [18633][client backend] [isolation/fk-deadlock2/s2][:0] LOG:  disconnection: session time: 0:00:00.546 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:48.606 UTC [18624][client backend] [isolation/fk-deadlock2/control connection][:0] LOG:  disconnection: session time: 0:00:00.646 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:48.664 UTC [18729][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:48.665 UTC [18729][client backend] [[unknown]][25/6:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:48.665 UTC [18729][client backend] [[unknown]][25/6:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-partitioned-1
2025-01-09 14:06:48.696 UTC [18737][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:48.715 UTC [18737][client backend] [[unknown]][23/13:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:48.715 UTC [18737][client backend] [[unknown]][23/13:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-partitioned-1
2025-01-09 14:06:48.764 UTC [18750][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:48.765 UTC [18750][client backend] [[unknown]][27/9:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:48.765 UTC [18750][client backend] [[unknown]][27/9:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-partitioned-1
2025-01-09 14:06:48.831 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/11:3068] ERROR:  insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey"
2025-01-09 14:06:48.831 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/11:3068] DETAIL:  Key (a)=(1) is not present in table "ppk".
2025-01-09 14:06:48.831 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/11:3068] STATEMENT:  alter table pfk attach partition pfk1 for values in (1);
2025-01-09 14:06:48.889 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/13:3072] ERROR:  insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey"
2025-01-09 14:06:48.889 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/13:3072] DETAIL:  Key (a)=(1) is not present in table "ppk".
2025-01-09 14:06:48.889 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/13:3072] STATEMENT:  alter table pfk attach partition pfk1 for values in (1);
2025-01-09 14:06:48.950 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/15:3076] ERROR:  insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey"
2025-01-09 14:06:48.950 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/15:3076] DETAIL:  Key (a)=(1) is not present in table "ppk".
2025-01-09 14:06:48.950 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/15:3076] STATEMENT:  alter table pfk attach partition pfk1 for values in (1);
2025-01-09 14:06:48.992 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/17:3080] ERROR:  insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey"
2025-01-09 14:06:48.992 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/17:3080] DETAIL:  Key (a)=(1) is not present in table "ppk".
2025-01-09 14:06:48.992 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/17:3080] STATEMENT:  alter table pfk attach partition pfk1 for values in (1);
2025-01-09 14:06:49.032 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/19:3084] ERROR:  insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey"
2025-01-09 14:06:49.032 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/19:3084] DETAIL:  Key (a)=(1) is not present in table "ppk".
2025-01-09 14:06:49.032 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/19:3084] STATEMENT:  alter table pfk attach partition pfk1 for values in (1);
2025-01-09 14:06:49.086 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/20:3088] ERROR:  update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey1" on table "pfk"
2025-01-09 14:06:49.086 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/20:3088] DETAIL:  Key (a)=(1) is still referenced from table "pfk".
2025-01-09 14:06:49.086 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/20:3088] STATEMENT:  delete from ppk1 where a = 1;
2025-01-09 14:06:49.134 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/21:3092] ERROR:  update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey1" on table "pfk"
2025-01-09 14:06:49.134 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/21:3092] DETAIL:  Key (a)=(1) is still referenced from table "pfk".
2025-01-09 14:06:49.134 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/21:3092] STATEMENT:  delete from ppk1 where a = 1;
2025-01-09 14:06:49.172 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/25:3096] ERROR:  insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey"
2025-01-09 14:06:49.172 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/25:3096] DETAIL:  Key (a)=(1) is not present in table "ppk".
2025-01-09 14:06:49.172 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/25:3096] STATEMENT:  alter table pfk attach partition pfk1 for values in (1);
2025-01-09 14:06:49.210 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/27:3100] ERROR:  insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey"
2025-01-09 14:06:49.210 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/27:3100] DETAIL:  Key (a)=(1) is not present in table "ppk".
2025-01-09 14:06:49.210 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][27/27:3100] STATEMENT:  alter table pfk attach partition pfk1 for values in (1);
2025-01-09 14:06:49.289 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/24:3104] ERROR:  update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey1" on table "pfk"
2025-01-09 14:06:49.289 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/24:3104] DETAIL:  Key (a)=(1) is still referenced from table "pfk".
2025-01-09 14:06:49.289 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/24:3104] STATEMENT:  delete from ppk1 where a = 1;
2025-01-09 14:06:49.328 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/25:3108] ERROR:  update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey1" on table "pfk"
2025-01-09 14:06:49.328 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/25:3108] DETAIL:  Key (a)=(1) is still referenced from table "pfk".
2025-01-09 14:06:49.328 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/25:3108] STATEMENT:  delete from ppk1 where a = 1;
2025-01-09 14:06:49.394 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/26:3112] ERROR:  update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey1" on table "pfk"
2025-01-09 14:06:49.394 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/26:3112] DETAIL:  Key (a)=(1) is still referenced from table "pfk".
2025-01-09 14:06:49.394 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/26:3112] STATEMENT:  delete from ppk1 where a = 1;
2025-01-09 14:06:49.454 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/27:3116] ERROR:  update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey1" on table "pfk"
2025-01-09 14:06:49.454 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/27:3116] DETAIL:  Key (a)=(1) is still referenced from table "pfk".
2025-01-09 14:06:49.454 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/27:3116] STATEMENT:  delete from ppk1 where a = 1;
2025-01-09 14:06:49.507 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/28:3120] ERROR:  update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey1" on table "pfk"
2025-01-09 14:06:49.507 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/28:3120] DETAIL:  Key (a)=(1) is still referenced from table "pfk".
2025-01-09 14:06:49.507 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][23/28:3120] STATEMENT:  delete from ppk1 where a = 1;
2025-01-09 14:06:49.540 UTC [18729][client backend] [isolation/fk-partitioned-1/control connection][:0] LOG:  disconnection: session time: 0:00:00.880 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:49.544 UTC [18737][client backend] [isolation/fk-partitioned-1/s1][:0] LOG:  disconnection: session time: 0:00:00.848 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:49.574 UTC [18750][client backend] [isolation/fk-partitioned-1/s2][:0] LOG:  disconnection: session time: 0:00:00.818 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:49.620 UTC [18842][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:49.622 UTC [18842][client backend] [[unknown]][28/9:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:49.622 UTC [18842][client backend] [[unknown]][28/9:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-partitioned-2
2025-01-09 14:06:49.648 UTC [18849][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:49.649 UTC [18849][client backend] [[unknown]][26/16:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:49.649 UTC [18849][client backend] [[unknown]][26/16:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-partitioned-2
2025-01-09 14:06:49.677 UTC [18853][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:49.678 UTC [18853][client backend] [[unknown]][30/213:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:49.678 UTC [18853][client backend] [[unknown]][30/213:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-partitioned-2
2025-01-09 14:06:49.737 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/215:3124] ERROR:  insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey"
2025-01-09 14:06:49.737 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/215:3124] DETAIL:  Key (a)=(1) is not present in table "ppk".
2025-01-09 14:06:49.737 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/215:3124] STATEMENT:  insert into pfk values (1);
2025-01-09 14:06:49.808 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/217:3128] ERROR:  could not serialize access due to concurrent update
2025-01-09 14:06:49.808 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/217:3128] CONTEXT:  SQL statement "SELECT 1 FROM "public"."ppk" x WHERE "a" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"
2025-01-09 14:06:49.808 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/217:3128] STATEMENT:  insert into pfk values (1);
2025-01-09 14:06:49.865 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/219:3132] ERROR:  insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey"
2025-01-09 14:06:49.865 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/219:3132] DETAIL:  Key (a)=(1) is not present in table "ppk".
2025-01-09 14:06:49.865 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/219:3132] STATEMENT:  insert into pfk values (1);
2025-01-09 14:06:49.917 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/221:3136] ERROR:  could not serialize access due to concurrent update
2025-01-09 14:06:49.917 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/221:3136] CONTEXT:  SQL statement "SELECT 1 FROM "public"."ppk" x WHERE "a" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"
2025-01-09 14:06:49.917 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][30/221:3136] STATEMENT:  insert into pfk values (1);
2025-01-09 14:06:49.960 UTC [18849][client backend] [isolation/fk-partitioned-2/s1][26/22:3140] ERROR:  update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey1" on table "pfk"
2025-01-09 14:06:49.960 UTC [18849][client backend] [isolation/fk-partitioned-2/s1][26/22:3140] DETAIL:  Key (a)=(1) is still referenced from table "pfk".
2025-01-09 14:06:49.960 UTC [18849][client backend] [isolation/fk-partitioned-2/s1][26/22:3140] STATEMENT:  delete from ppk where a = 1;
2025-01-09 14:06:50.005 UTC [18849][client backend] [isolation/fk-partitioned-2/s1][26/23:3144] ERROR:  update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey1" on table "pfk"
2025-01-09 14:06:50.005 UTC [18849][client backend] [isolation/fk-partitioned-2/s1][26/23:3144] DETAIL:  Key (a)=(1) is still referenced from table "pfk".
2025-01-09 14:06:50.005 UTC [18849][client backend] [isolation/fk-partitioned-2/s1][26/23:3144] STATEMENT:  delete from ppk where a = 1;
2025-01-09 14:06:50.031 UTC [18842][client backend] [isolation/fk-partitioned-2/control connection][:0] LOG:  disconnection: session time: 0:00:00.411 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:50.032 UTC [18849][client backend] [isolation/fk-partitioned-2/s1][:0] LOG:  disconnection: session time: 0:00:00.387 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:50.045 UTC [18853][client backend] [isolation/fk-partitioned-2/s2][:0] LOG:  disconnection: session time: 0:00:00.377 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:50.134 UTC [18913][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:50.140 UTC [18913][client backend] [[unknown]][31/213:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:50.140 UTC [18913][client backend] [[unknown]][31/213:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-snapshot
2025-01-09 14:06:50.165 UTC [18920][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:50.167 UTC [18920][client backend] [[unknown]][29/424:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:50.167 UTC [18920][client backend] [[unknown]][29/424:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-snapshot
2025-01-09 14:06:50.176 UTC [18925][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:50.178 UTC [18925][client backend] [[unknown]][32/213:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:50.178 UTC [18925][client backend] [[unknown]][32/213:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/fk-snapshot
2025-01-09 14:06:50.226 UTC [18920][client backend] [isolation/fk-snapshot/s1][29/426:3148] ERROR:  insert or update on table "fk_parted_pk_2" violates foreign key constraint "fk_parted_pk_a_fkey"
2025-01-09 14:06:50.226 UTC [18920][client backend] [isolation/fk-snapshot/s1][29/426:3148] DETAIL:  Key (a)=(2) is not present in table "pk_noparted".
2025-01-09 14:06:50.226 UTC [18920][client backend] [isolation/fk-snapshot/s1][29/426:3148] STATEMENT:  INSERT INTO fk_parted_pk VALUES (2);
2025-01-09 14:06:50.748 UTC [18925][client backend] [isolation/fk-snapshot/s2][32/223:3169] ERROR:  could not serialize access due to concurrent update
2025-01-09 14:06:50.748 UTC [18925][client backend] [isolation/fk-snapshot/s2][32/223:3169] CONTEXT:  SQL statement "DELETE FROM "public"."fk_parted_pk" WHERE $1 OPERATOR(pg_catalog.=) "a""
2025-01-09 14:06:50.748 UTC [18925][client backend] [isolation/fk-snapshot/s2][32/223:3169] STATEMENT:  DELETE FROM pk_noparted WHERE a = 2;
2025-01-09 14:06:50.855 UTC [18925][client backend] [isolation/fk-snapshot/s2][32/225:3174] ERROR:  could not serialize access due to concurrent update
2025-01-09 14:06:50.855 UTC [18925][client backend] [isolation/fk-snapshot/s2][32/225:3174] CONTEXT:  SQL statement "UPDATE ONLY "public"."fk_noparted_sn" SET "a" = NULL WHERE $1 OPERATOR(pg_catalog.=) "a""
2025-01-09 14:06:50.855 UTC [18925][client backend] [isolation/fk-snapshot/s2][32/225:3174] STATEMENT:  DELETE FROM pk_noparted WHERE a = 2;
2025-01-09 14:06:50.905 UTC [18920][client backend] [isolation/fk-snapshot/s1][:0] LOG:  disconnection: session time: 0:00:00.748 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:50.908 UTC [18925][client backend] [isolation/fk-snapshot/s2][:0] LOG:  disconnection: session time: 0:00:00.731 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:50.925 UTC [18913][client backend] [isolation/fk-snapshot/control connection][:0] LOG:  disconnection: session time: 0:00:00.792 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:51.007 UTC [19040][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:51.009 UTC [19040][client backend] [[unknown]][34/23:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:51.009 UTC [19040][client backend] [[unknown]][34/23:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/subxid-overflow
2025-01-09 14:06:51.027 UTC [19047][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:51.028 UTC [19047][client backend] [[unknown]][33/44:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:51.028 UTC [19047][client backend] [[unknown]][33/44:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/subxid-overflow
2025-01-09 14:06:51.042 UTC [19051][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:51.045 UTC [19051][client backend] [[unknown]][35/23:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:51.045 UTC [19051][client backend] [[unknown]][35/23:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/subxid-overflow
2025-01-09 14:06:51.069 UTC [19056][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:51.070 UTC [19056][client backend] [[unknown]][38/23:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:51.070 UTC [19056][client backend] [[unknown]][38/23:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/subxid-overflow
2025-01-09 14:06:51.264 UTC [19056][client backend] [isolation/subxid-overflow/s3][:0] LOG:  disconnection: session time: 0:00:00.200 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:51.267 UTC [19051][client backend] [isolation/subxid-overflow/s2][:0] LOG:  disconnection: session time: 0:00:00.226 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:51.272 UTC [19047][client backend] [isolation/subxid-overflow/s1][:0] LOG:  disconnection: session time: 0:00:00.251 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:51.276 UTC [19040][client backend] [isolation/subxid-overflow/control connection][:0] LOG:  disconnection: session time: 0:00:00.272 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:51.367 UTC [19109][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:51.369 UTC [19109][client backend] [[unknown]][37/23:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:51.369 UTC [19109][client backend] [[unknown]][37/23:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/eval-plan-qual
2025-01-09 14:06:51.428 UTC [19116][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:51.429 UTC [19116][client backend] [[unknown]][36/44:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:51.429 UTC [19116][client backend] [[unknown]][36/44:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/eval-plan-qual
2025-01-09 14:06:51.468 UTC [19135][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:51.469 UTC [19135][client backend] [[unknown]][41/23:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:51.469 UTC [19135][client backend] [[unknown]][41/23:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/eval-plan-qual
2025-01-09 14:06:51.497 UTC [19140][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:51.499 UTC [19140][client backend] [[unknown]][40/23:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:51.499 UTC [19140][client backend] [[unknown]][40/23:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/eval-plan-qual
TRAP: failed Assert("false"), File: "../../../src/include/executor/execScan.h", Line: 115, PID: 19135
/lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7fdecc051f31]
postgres: postgres isolation_regression [local] UPDATE(ExceptionalCondition+0xe6)[0x5630d47f3390]
postgres: postgres isolation_regression [local] UPDATE(ExecScan+0x649)[0x5630d3ff5714]
postgres: postgres isolation_regression [local] UPDATE(+0x9c6ff0)[0x5630d4078ff0]
postgres: postgres isolation_regression [local] UPDATE(+0x93ad63)[0x5630d3fecd63]
postgres: postgres isolation_regression [local] UPDATE(+0x9a1a20)[0x5630d4053a20]
postgres: postgres isolation_regression [local] UPDATE(+0x9a1cc0)[0x5630d4053cc0]
postgres: postgres isolation_regression [local] UPDATE(+0x93ad63)[0x5630d3fecd63]
postgres: postgres isolation_regression [local] UPDATE(+0x9cbd4a)[0x5630d407dd4a]
postgres: postgres isolation_regression [local] UPDATE(+0x9cdf6d)[0x5630d407ff6d]
postgres: postgres isolation_regression [local] UPDATE(ExecSubPlan+0x2d3)[0x5630d4080f20]
postgres: postgres isolation_regression [local] UPDATE(ExecEvalSubPlan+0x62)[0x5630d3fc4ada]
postgres: postgres isolation_regression [local] UPDATE(+0x919d81)[0x5630d3fcbd81]
postgres: postgres isolation_regression [local] UPDATE(ExecInterpExprStillValid+0x4d)[0x5630d3fba918]
postgres: postgres isolation_regression [local] UPDATE(+0x942fb5)[0x5630d3ff4fb5]
postgres: postgres isolation_regression [local] UPDATE(ExecScan+0x181)[0x5630d3ff524c]
postgres: postgres isolation_regression [local] UPDATE(+0x9c6ff0)[0x5630d4078ff0]
postgres: postgres isolation_regression [local] UPDATE(+0x93ad63)[0x5630d3fecd63]
postgres: postgres isolation_regression [local] UPDATE(+0x924474)[0x5630d3fd6474]
postgres: postgres isolation_regression [local] UPDATE(EvalPlanQualNext+0x7d)[0x5630d3fded55]
postgres: postgres isolation_regression [local] UPDATE(EvalPlanQual+0xd1)[0x5630d3fdf246]
postgres: postgres isolation_regression [local] UPDATE(+0x9b6774)[0x5630d4068774]
postgres: postgres isolation_regression [local] UPDATE(+0x9bd34a)[0x5630d406f34a]
postgres: postgres isolation_regression [local] UPDATE(+0x93ad63)[0x5630d3fecd63]
postgres: postgres isolation_regression [local] UPDATE(+0x924474)[0x5630d3fd6474]
postgres: postgres isolation_regression [local] UPDATE(+0x92465d)[0x5630d3fd665d]
postgres: postgres isolation_regression [local] UPDATE(standard_ExecutorRun+0x3e6)[0x5630d3fd846a]
postgres: postgres isolation_regression [local] UPDATE(ExecutorRun+0x1c)[0x5630d3fd84ca]
postgres: postgres isolation_regression [local] UPDATE(+0xe2edc6)[0x5630d44e0dc6]
postgres: postgres isolation_regression [local] UPDATE(+0xe30dbf)[0x5630d44e2dbf]
postgres: postgres isolation_regression [local] UPDATE(PortalRun+0x3bd)[0x5630d44e39a6]
postgres: postgres isolation_regression [local] UPDATE(+0xe290a6)[0x5630d44db0a6]
postgres: postgres isolation_regression [local] UPDATE(PostgresMain+0xe3d)[0x5630d44deeaf]
postgres: postgres isolation_regression [local] UPDATE(BackendMain+0x123)[0x5630d44d13b8]
postgres: postgres isolation_regression [local] UPDATE(postmaster_child_launch+0x1f1)[0x5630d4330410]
postgres: postgres isolation_regression [local] UPDATE(+0xc83e04)[0x5630d4335e04]
postgres: postgres isolation_regression [local] UPDATE(+0xc862af)[0x5630d43382af]
postgres: postgres isolation_regression [local] UPDATE(PostmasterMain+0x1c3c)[0x5630d433a415]
postgres: postgres isolation_regression [local] UPDATE(main+0x2a2)[0x5630d40dfe25]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7fdecaf7824a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7fdecaf78305]
postgres: postgres isolation_regression [local] UPDATE(_start+0x21)[0x5630d3aca391]
2025-01-09 14:06:54.249 UTC [19116][client backend] [isolation/eval-plan-qual/s1][:0] LOG:  disconnection: session time: 0:00:02.825 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.252 UTC [19109][client backend] [isolation/eval-plan-qual/control connection][:0] LOG:  disconnection: session time: 0:00:02.888 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.260 UTC [19140][client backend] [isolation/eval-plan-qual/s3][:0] LOG:  disconnection: session time: 0:00:02.767 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.416 UTC [19566][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:54.417 UTC [19566][client backend] [[unknown]][39/45:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:54.417 UTC [19566][client backend] [[unknown]][39/45:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/eval-plan-qual-trigger
2025-01-09 14:06:54.444 UTC [19570][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:54.445 UTC [19570][client backend] [[unknown]][43/23:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:54.445 UTC [19570][client backend] [[unknown]][43/23:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/eval-plan-qual-trigger
2025-01-09 14:06:54.460 UTC [19573][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:54.461 UTC [19573][client backend] [[unknown]][44/23:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:54.461 UTC [19573][client backend] [[unknown]][44/23:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/eval-plan-qual-trigger
2025-01-09 14:06:54.500 UTC [19577][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:54.501 UTC [19577][client backend] [[unknown]][42/44:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:54.501 UTC [19577][client backend] [[unknown]][42/44:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/eval-plan-qual-trigger
2025-01-09 14:06:54.524 UTC [19580][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:54.525 UTC [19580][client backend] [[unknown]][46/38:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:54.525 UTC [19580][client backend] [[unknown]][46/38:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/eval-plan-qual-trigger
2025-01-09 14:06:54.545 UTC [19566][client backend] [isolation/eval-plan-qual-trigger/control connection][39/48:3667] ERROR:  function "noisy_oper" already exists with same argument types
2025-01-09 14:06:54.545 UTC [19566][client backend] [isolation/eval-plan-qual-trigger/control connection][39/48:3667] STATEMENT:  
	    CREATE TABLE trigtest(key text primary key, data text);
	
	    CREATE FUNCTION noisy_oper(p_comment text, p_a anynonarray, p_op text, p_b anynonarray)
	    RETURNS bool LANGUAGE plpgsql AS $body$
	        DECLARE
	            r bool;
	        BEGIN
	            EXECUTE format('SELECT $1 %s $2', p_op) INTO r USING p_a, p_b;
	            RAISE NOTICE '%: % % % % %: %', p_comment, pg_typeof(p_a), p_a, p_op, pg_typeof(p_b), p_b, r;
	        RETURN r;
	    END;$body$;
	
	    CREATE FUNCTION trig_report() RETURNS TRIGGER LANGUAGE plpgsql AS $body$
	    DECLARE
		r_new text;
		r_old text;
		r_ret record;
	    BEGIN
		-- In older releases it wasn't allowed to reference OLD/NEW
	        -- when not applicable for TG_WHEN
		IF TG_OP = 'INSERT' THEN
		    r_old = NULL;
		    r_new = NEW;
		    r_ret = NEW;
		ELSIF TG_OP = 'DELETE' THEN
		    r_old = OLD;
		    r_new = NULL;
		    r_ret = OLD;
		ELSIF TG_OP = 'UPDATE' THEN
		    r_old = OLD;
		    r_new = NEW;
		    r_ret = NEW;
		END IF;
	
		IF TG_WHEN = 'AFTER' THEN
		   r_ret = NULL;
		END IF;
	
	        RAISE NOTICE 'trigger: name %; when: %; lev: %s; op: %; old: % new: %',
	            TG_NAME, TG_WHEN, TG_LEVEL, TG_OP, r_old, r_new;
	
		RETURN r_ret;
	    END;
	    $body$;
	
2025-01-09 14:06:54.545 UTC [19570][client backend] [isolation/eval-plan-qual-trigger/s0][:0] LOG:  disconnection: session time: 0:00:00.112 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.548 UTC [19573][client backend] [isolation/eval-plan-qual-trigger/s1][:0] LOG:  disconnection: session time: 0:00:00.090 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.548 UTC [19580][client backend] [isolation/eval-plan-qual-trigger/s3][:0] LOG:  disconnection: session time: 0:00:00.028 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.552 UTC [19566][client backend] [isolation/eval-plan-qual-trigger/control connection][:0] LOG:  disconnection: session time: 0:00:00.139 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.552 UTC [19577][client backend] [isolation/eval-plan-qual-trigger/s2][:0] LOG:  disconnection: session time: 0:00:00.064 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.644 UTC [19602][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:54.645 UTC [19602][client backend] [[unknown]][47/38:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:54.645 UTC [19602][client backend] [[unknown]][47/38:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/inplace-inval
2025-01-09 14:06:54.665 UTC [19622][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:54.666 UTC [19622][client backend] [[unknown]][45/74:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:54.666 UTC [19622][client backend] [[unknown]][45/74:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/inplace-inval
2025-01-09 14:06:54.708 UTC [19626][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:54.709 UTC [19626][client backend] [[unknown]][49/13:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:54.709 UTC [19626][client backend] [[unknown]][49/13:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/inplace-inval
2025-01-09 14:06:54.736 UTC [19633][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-09 14:06:54.737 UTC [19633][client backend] [[unknown]][50/13:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/isolation/tmp_check_iso/data/pg_hba.conf:117)
2025-01-09 14:06:54.737 UTC [19633][client backend] [[unknown]][50/13:0] LOG:  connection authorized: user=postgres database=isolation_regression application_name=isolation/inplace-inval
2025-01-09 14:06:54.799 UTC [19633][client backend] [isolation/inplace-inval/s3][:0] LOG:  disconnection: session time: 0:00:00.064 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.801 UTC [19626][client backend] [isolation/inplace-inval/s2][:0] LOG:  disconnection: session time: 0:00:00.101 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.808 UTC [19602][client backend] [isolation/inplace-inval/control connection][:0] LOG:  disconnection: session time: 0:00:00.173 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.812 UTC [19622][client backend] [isolation/inplace-inval/s1][:0] LOG:  disconnection: session time: 0:00:00.148 user=postgres database=isolation_regression host=[local]
2025-01-09 14:06:54.883 UTC [14426][postmaster] LOG:  client backend (PID 19135) was terminated by signal 6: Aborted
2025-01-09 14:06:54.883 UTC [14426][postmaster] DETAIL:  Failed process was running: 
	    UPDATE accounts SET balance = balance - 1200
	    WHERE noisy_oper('upid', accountid, '=', 'checking')
	    AND noisy_oper('up', balance, '>', 200.0)
	    AND EXISTS (
	        SELECT accountid
	        FROM accounts_ext ae
	        WHERE noisy_oper('lock_id', ae.accountid, '=', accounts.accountid)
	            AND noisy_oper('lock_bal', ae.balance, '>', 200.0)
	        FOR UPDATE
	    );
	
2025-01-09 14:06:54.883 UTC [14426][postmaster] LOG:  terminating any other active server processes
2025-01-09 14:06:54.909 UTC [14426][postmaster] LOG:  shutting down because "restart_after_crash" is off
2025-01-09 14:06:55.008 UTC [14426][postmaster] LOG:  database system is shut down