roachtest: schemachange/random-load failed [mismatched type in violatesFkConstraintsHelper query]

[cockroach-teamcity]

roachtest.schemachange/random-load failed with artifacts on master @ 791969fa98711e681289fa4f61f3d58c8fe44263:

(schemachange_random_load.go:123).runSchemaChangeRandomLoad: full command output in run_191020.334876794_n1_workload-run-schemac.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/random-load/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_fs=ext4
• ROACHTEST_localSSD=true
• ROACHTEST_metamorphicBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: schemachange/random-load failed [CRDB and test both hang when leases fail] #119352 roachtest: schemachange/random-load failed [CRDB and test both hang when leases fail] [C-test-failure O-roachtest O-robot P-1 T-sql-foundations branch-release-23.2 release-blocker]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-36346

[rafiss]

failure is

 "message": "***UNEXPECTED ERROR; Failed to generate a random operation: CollectOne: Query: \"\\n\\t    SELECT false = ANY (ARRAY ['24:00:00-15:59':::TIMETZ = '0/0':::PG_LSN,'14:27:45.548113+01:08':::TIMETZ = '0/0':::PG_LSN]) AND count(*) = 0 from schema_w16_84.table_w2_162\\n\\t    WHERE \\\"Col16 �2_w2_168\\\" = ('0/0':::PG_LSN)\\n\\t\" []: ERROR: unsupported comparison operator: false = ANY ARRAY['24:00:00-15:59':::TIMETZ = '0/0':::PG_LSN, '14:27:45.548113+01:08':::TIMETZ = '0/0':::PG_LSN]: unsupported comparison operator: \u003ctimetz\u003e = \u003cpg_lsn\u003e (SQLSTATE 22023)",

another occurrence of #119288 (cc @annrpom for awareness)

[cockroach-teamcity]

roachtest.schemachange/random-load failed with artifacts on master @ 660a3c8050a8ef7828b0151e44a86335639a8f9d:

(schemachange_random_load.go:123).runSchemaChangeRandomLoad: full command output in run_191728.048520153_n1_workload-run-schemac.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/random-load/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_fs=ext4
• ROACHTEST_localSSD=true
• ROACHTEST_metamorphicBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: schemachange/random-load failed [CRDB and test both hang when leases fail] #119352 roachtest: schemachange/random-load failed [CRDB and test both hang when leases fail] [C-test-failure O-roachtest O-robot P-1 T-sql-foundations branch-release-23.2 release-blocker]

This test on roachdash | Improve this report!

[cockroach-teamcity]

roachtest.schemachange/random-load failed with artifacts on master @ 431d56840cacdc86638ccb48e9f3bdc16897d341:

(schemachange_random_load.go:123).runSchemaChangeRandomLoad: full command output in run_173714.909454094_n1_workload-run-schemac.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/random-load/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_fs=ext4
• ROACHTEST_localSSD=true
• ROACHTEST_metamorphicBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

[rafiss]

foreign keys are being disabled in #120575 until they are fixed in the schemachange workload. keeping #119288 open as the tracking issue for the problem.