roachtest: tpcc/headroom failed during release qualification #97141
Description
master on
refs/tags/v23.1.0-alpha.2-263-g51ed100a46 (51ed100)
During release qualification for the 23.1.0-alpha.3 release, the tpcc/headroom roachtest failed because the tpcc workload got a foreign key violation error:
I230214 08:30:36.143577 14763 workload/pgx_helpers.go:79 [T1] 5 pgx logger [error]: Exec logParams=map[args:[] err:ERROR: insert on table "order_line" violates foreign key constraint "order_line_ol_w_id_ol_d_id_ol_o_id_fkey" (SQLSTATE 23503) pid:2240385 sql:
I230214 08:30:36.143577 14763 workload/pgx_helpers.go:79 [T1] 5 + INSERT INTO order_line(ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_dist_info)
I230214 08:30:36.143577 14763 workload/pgx_helpers.go:79 [T1] 5 + VALUES (3003,2,523,4,2034,523,2,24.380000,'wfQSg3WOWVPeORXlu0VKctRL'), (3003,2,523,10,8593,523,5,281.450000,'QSg3WOWVPeORXlu0VKctRL3s'), (3003,2,523,2,12238,523,5,408.100000,'aHcqcLFiQSMwfQSg3WOWVPeO'), (3003,2,523,14,16298,523,6,485.880000,'WVPeORXlu0VKctRL3s2E8MgR'), (3003,2,523,13,25091,523,5,401.600000,'OWVPeORXlu0VKctRL3s2E8Mg'), (3003,2,523,8,40079,523,1,74.700000,'VKctRL3s2E8MgRpOF5R6WnUU'), (3003,2,523,9,49171,523,8,527.920000,'aHcqcLFiQSMwfQSg3WOWVPeO'), (3003,2,523,1,61960,523,4,156.000000,'QSMwfQSg3WOWVPeORXlu0VKc'), (3003,2,523,6,63507,523,3,187.170000,'QSMwfQSg3WOWVPeORXlu0VKc'), (3003,2,523,5,72203,523,4,43.520000,'RXlu0VKctRL3s2E8MgRpOF5R'), (3003,2,523,12,73233,523,9,80.190000,'L3s2E8MgRpOF5R6WnUUjpog5'), (3003,2,523,3,80399,523,9,108.630000,'0VKctRL3s2E8MgRpOF5R6WnU'), (3003,2,523,7,88551,523,9,594.000000,'3WOWVPeORXlu0VKctRL3s2E8'), (3003,2,523,15,97935,523,6,57.960000,'RpOF5R6WnUUjpog5gf7mBUBg'), (3003,2,523,11,98787,523,7,565.110000,'RXlu0VKctRL3s2E8MgRpOF5R') time:1.310890667s]
A subsequent run of that test passed, so this failure is non-deterministic. However, the workload shouldn't be seeing these types of errors.
Jira issue: CRDB-24539