roachtest.schemachange/random-load <a href="https://teamcity.cockroachdb.com/buildConf

failure is <div class="snippet-clipboard-content notranslate position-relative ove

foreign keys are being disabled in <a class="issue-link js-issue-link" data-error-text

roachtest: schemachange/random-load failed [mismatched type in violatesFkConstraintsHelper query],about cockroachdb/cockroach

Comments (4)

rafiss commented on May 27, 2024 1

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)

from cockroach.

cockroach-teamcity commented on May 27, 2024

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

#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!}

from cockroach.

cockroach-teamcity commented on May 27, 2024

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!}

from cockroach.

rafiss commented on May 27, 2024

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.

from cockroach.

Recommend Projects