search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.97k stars 3.79k forks source link

roachtest: unoptimized-query-oracle/disable-rules=all/rand-multi-region failed #126444

Closed cockroach-teamcity closed 2 months ago

cockroach-teamcity commented 3 months ago

roachtest.unoptimized-query-oracle/disable-rules=all/rand-multi-region failed with artifacts on master @ 047a7ed79756eef53b8b9ab4c9dd9c5a463496c9:

(sqlsmith.go:400).func1: pq: verify-inverted-idx-count: column "c\\\\\\\\x60ol2_2" does not exist
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-multi-region/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-39918

cockroach-teamcity commented 3 months ago

roachtest.unoptimized-query-oracle/disable-rules=all/rand-multi-region failed with artifacts on master @ 7461a85f839c50edbdea502fe09794739a99632e:

(sqlsmith.go:400).func1: pq: verify-inverted-idx-count: column "col\\t3_15" does not exist
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-multi-region/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

cockroach-teamcity commented 3 months ago

roachtest.unoptimized-query-oracle/disable-rules=all/rand-multi-region failed with artifacts on master @ 8f72a01e81d4751c6615a9a864b8e32076565b09:

(sqlsmith.go:400).func1: pq: verify-inverted-idx-count: column "c\\\\rol3_1" does not exist
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-multi-region/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

cockroach-teamcity commented 3 months ago

roachtest.unoptimized-query-oracle/disable-rules=all/rand-multi-region failed with artifacts on master @ 485975b3a824c68c07340e6a336c7864c00d3c6d:

(sqlsmith.go:400).func1: pq: verify-inverted-idx-count: column "col\\\\\\\\x141_2" does not exist
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-multi-region/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

mgartner commented 2 months ago

A reproduction in a CCL logic test:

# LogicTest: multiregion-9node-3region-3azs !metamorphic-batch-sizes

statement ok
CREATE DATABASE multi_region_test_db PRIMARY REGION "ca-central-1" REGIONS "ap-southeast-2", "us-east-1" SURVIVE REGION FAILURE

statement ok
USE multi_region_test_db

statement ok
CREATE TABLE table_3 (
  a INT PRIMARY KEY,
  "b    c" STRING,
  INVERTED INDEX ("b    c" gin_trgm_ops)
)

statement ok
ALTER TABLE table_3 SET LOCALITY REGIONAL BY ROW
mgartner commented 2 months ago

Here's another repro that doesn't require a multi-region test:

statement ok
CREATE TABLE table_3 (
  a INT PRIMARY KEY,
  "b
c" STRING
)

statement ok
CREATE INVERTED INDEX ON table_3 ("b
c" gin_trgm_ops)

I'll have a fix up shortly.