roachtest: ldr/kv0/workload=both/schema_change failed

[cockroach-teamcity]

roachtest.ldr/kv0/workload=both/schema_change failed with artifacts on master @ ea4644b040dd4503f2eb7292cfebc31a58fd16fb:

(sql_runner.go:94).ExecWithMessage: error executing query="DROP INDEX idx_right" args=[]: pq: index "idx_right" does not exist
test artifacts and logs in: /artifacts/ldr/kv0/workload=both/schema_change/cpu_arch=arm64/run_1

Parameters:

• ROACHTEST_arch=arm64
• ROACHTEST_cloud=aws
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=8
• ROACHTEST_encrypted=false
• ROACHTEST_fs=ext4
• ROACHTEST_localSSD=false
• ROACHTEST_runtimeAssertionsBuild=false
• ROACHTEST_ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

Grafana is not yet available for aws clusters

/cc @cockroachdb/disaster-recovery

This test on roachdash | Improve this report!

Jira issue: CRDB-44296

[cockroach-teamcity]

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.ldr/kv0/workload=both/schema_change failed with artifacts on master @ ea4644b040dd4503f2eb7292cfebc31a58fd16fb:

(sql_runner.go:94).ExecWithMessage: error executing query="DROP INDEX idx_left" args=[]: pq: index "idx_left" does not exist
test artifacts and logs in: /artifacts/ldr/kv0/workload=both/schema_change/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=azure
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=8
• ROACHTEST_encrypted=false
• ROACHTEST_fs=ext4
• ROACHTEST_localSSD=false
• ROACHTEST_runtimeAssertionsBuild=true
• ROACHTEST_ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

Grafana is not yet available for azure clusters

This test on roachdash | Improve this report!

[cockroach-teamcity]

roachtest.ldr/kv0/workload=both/schema_change failed with artifacts on master @ ea4644b040dd4503f2eb7292cfebc31a58fd16fb:

(sql_runner.go:94).ExecWithMessage: error executing query="DROP INDEX idx_right" args=[]: pq: index "idx_right" does not exist
test artifacts and logs in: /artifacts/ldr/kv0/workload=both/schema_change/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=8
• ROACHTEST_encrypted=false
• ROACHTEST_fs=ext4
• ROACHTEST_localSSD=false
• ROACHTEST_runtimeAssertionsBuild=false
• ROACHTEST_ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

[msbutler]

@rafiss this doesn't look like an LDR issue, but seems concerning. The DROP INDEX call does not observe the index after CREATE INDEX succeeded. Has there been a recent regression? This test has been quiet since you added it a couple months ago, but began flaking regularly in the past day or so. https://github.com/msbutler/cockroach/blob/butler-deflake-or-tests/pkg/cmd/roachtest/tests/logical_data_replication.go#L330-L332

[cockroach-teamcity]

roachtest.ldr/kv0/workload=both/schema_change failed with artifacts on master @ 39e43b85ec3b02bc760df10fce1c19d09419d6f2:

(sql_runner.go:94).ExecWithMessage: error executing query="DROP INDEX idx_right" args=[]: pq: index "idx_right" does not exist
test artifacts and logs in: /artifacts/ldr/kv0/workload=both/schema_change/cpu_arch=arm64/run_1

Parameters:

• arch=arm64
• cloud=aws
• coverageBuild=false
• cpu=8
• encrypted=false
• fs=ext4
• localSSD=false
• metamorphicLeases=default
• runtimeAssertionsBuild=false
• ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

Grafana is not yet available for aws clusters

This test on roachdash | Improve this report!

[cockroach-teamcity]

roachtest.ldr/kv0/workload=both/schema_change failed with artifacts on master @ 6610d705724a21c836f3521f75972e65d9e9e2d4:

(sql_runner.go:94).ExecWithMessage: error executing query="DROP INDEX idx_left" args=[]: pq: index "idx_left" does not exist
test artifacts and logs in: /artifacts/ldr/kv0/workload=both/schema_change/cpu_arch=arm64/run_1

Parameters:

• arch=arm64
• cloud=azure
• coverageBuild=false
• cpu=8
• encrypted=false
• fs=ext4
• localSSD=false
• metamorphicLeases=leader
• runtimeAssertionsBuild=false
• ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

Grafana is not yet available for azure clusters

Same failure on other branches

- #135152 roachtest: ldr/kv0/workload=both/schema_change failed [A-disaster-recovery C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.3 release-blocker]

This test on roachdash | Improve this report!

[cockroach-teamcity]

roachtest.ldr/kv0/workload=both/schema_change failed with artifacts on master @ a5ab06046e817627cd0b64390f4ede0c4a5d82ef:

(sql_runner.go:94).ExecWithMessage: error executing query="DROP INDEX idx_right" args=[]: pq: index "idx_right" does not exist
test artifacts and logs in: /artifacts/ldr/kv0/workload=both/schema_change/run_1

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=8
• encrypted=false
• metamorphicLeases=default
• runtimeAssertionsBuild=false
• ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #135152 roachtest: ldr/kv0/workload=both/schema_change failed [A-disaster-recovery C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.3 release-blocker]

This test on roachdash | Improve this report!