cockroachdb / cockroachdb/cockroach

basalt-26.3.2-rc-20260908: sql/tablemetadatacache: TestDataDrivenTableMetadataCacheUpdater failed

Open
#174,995 5 comments 0 reactions 0 assignees View on GitHub
branch-basalt-26.3.2-rc-20260908 C-test-failure O-robot release-blocker T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

sql/tablemetadatacache.TestDataDrivenTableMetadataCacheUpdater [failed](https://mesolite.cluster.engflow.com/invocations/default/4e6b3e4b-4f3a-4ae0-ac38-acabe7fa7d66?testReportRun=2&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL3RhYmxlbWV0YWRhdGFjYWNoZTp0YWJsZW1ldGFkYXRhY2FjaGVfdGVzdA==) on basalt-26.3.2-rc-20260908 @ [807558e5e81666af257c811e925e4cae570abc28](https://github.com/cockroachdb/cockroach/commits/807558e5e81666af257c811e925e4cae570abc28):

```
----
updatedTables: 81, errors: 0, run #: 1, duration > 0: true
table_metadata_updater_test.go:58:
/mnt/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/sql/tablemetadatacache/tablemetadatacache_test_/tablemetadatacache_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/tablemetadatacache/testdata/update_table_metadata:57:
query
SELECT
table_name,
db_name,
schema_name,
db_id,
table_id,
total_columns,
total_indexes,
table_type,
details->'auto_stats_enabled',
store_ids,
total_ranges,
last_updated,
last_update_error
FROM system.table_metadata
WHERE db_name <> 'system' OR table_name IN ('comments', 'locations', 'descriptor_id_seq')
ORDER BY (db_name, table_name)
----
autostats_disabled defaultdb public 100 107 2 1 TABLE false {1} 1 2021-01-07 06:13:20 +0000 UTC
autostats_enabled defaultdb public 100 106 2 1 TABLE true {1} 1 2021-01-07 06:13:20 +0000 UTC
mymaterializedview defaultdb public 100 109 4 1 MATERIALIZED_VIEW null {1} 1 2021-01-07 06:13:20 +0000 UTC
myseq defaultdb public 100 110 1 1 SEQUENCE null {1} 1 2021-01-07 06:13:20 +0000 UTC
mytable defaultdb public 100 104 3 1 TABLE null {1} 1 2021-01-07 06:13:20 +0000 UTC
mytable2 defaultdb public 100 105 4 1 TABLE null {1} 1 2021-01-07 06:13:20 +0000 UTC
myview defaultdb public 100 108 3 1 VIEW null {1} 1 2021-01-07 06:13:20 +0000 UTC
comments system public 1 24 4 1 TABLE null {1} 1 2021-01-07 06:13:20 +0000 UTC
descriptor_id_seq system public 1 7 1 1 SEQUENCE null {1} 1 2021-01-07 06:13:20 +0000 UTC
locations system public 1 21 4 1 TABLE null {1} 1 2021-01-07 06:13:20 +0000 UTC
table_metadata_updater_test.go:58:
/mnt/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/sql/tablemetadatacache/tablemetadatacache_test_/tablemetadatacache_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/tablemetadatacache/testdata/update_table_metadata:87:
query
SELECT count(*) FROM system.table_metadata WHERE perc_live_data > 1
----
0
table_metadata_updater_test.go:58:
/mnt/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/sql/tablemetadatacache/tablemetadatacache_test_/tablemetadatacache_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/tablemetadatacache/testdata/update_table_metadata:92:
query
SELECT count(*) FROM system.table_metadata WHERE replication_size_bytes > 0

expected:
81

found:
74
--- FAIL: TestDataDrivenTableMetadataCacheUpdater/update_table_metadata (39.87s)
```

Parameters:
- attempt=1
- race=true
- run=2
- shard=1
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

/cc @cockroachlabs/obs-prs

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestDataDrivenTableMetadataCacheUpdater.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Contributor guide

Open the contributing guide

Research direction

Start with TestDataDrivenTableMetadataCacheUpdater in pkg/sql/tablemetadatacache and the testdata/update_table_metadata data file, then reproduce the failure with the reported race-enabled test configuration. Investigate why replication_size_bytes returns 74 instead of the expected 81; done means the test passes without weakening its expectations.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, testing-qa
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.