cockroachdb / cockroachdb/cockroach

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

Open
#175,555 1 comment 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/84483de1-b344-4bb7-a487-42863798b484?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/1/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/1/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/1/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.09s)
```

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 pkg/sql/tablemetadatacache/table_metadata_updater_test.go and the update_table_metadata testdata referenced in the failure. Run TestDataDrivenTableMetadataCacheUpdater and compare the expected and actual table_metadata results, especially the replication_size_bytes count of 81 versus 74. Done means the failure is understood and the test passes reliably.

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
Needs clarification
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.