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

sql/tablemetadatacache.TestDataDrivenTableMetadataCacheUpdater [failed](https://mesolite.cluster.engflow.com/invocations/default/e97a94d3-9833-4a85-9ee3-760c3aa12029?testReportRun=2&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL3RhYmxlbWV0YWRhdGFjYWNoZTp0YWJsZW1ldGFkYXRhY2FjaGVfdGVzdA==) on basalt-26.3.2-rc-20260914 @ [d3eb08ebdd1dacc8d3dac0b107a7db5929e09969](https://github.com/cockroachdb/cockroach/commits/d3eb08ebdd1dacc8d3dac0b107a7db5929e09969):

```
/mnt/engflow/worker/work/3/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:104:
query
SELECT sum(replication_size_bytes) > 0 FROM system.table_metadata
----
true
table_metadata_updater_test.go:58:
/mnt/engflow/worker/work/3/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:109:
query
SELECT count(*) FROM system.table_metadata WHERE total_live_data_bytes > total_data_bytes
----
0
table_metadata_updater_test.go:58:
/mnt/engflow/worker/work/3/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:116:
query
SELECT count(*) FROM system.table_metadata
WHERE table_type IN ('TABLE', 'SEQUENCE', 'MATERIALIZED_VIEW')
AND (details->>'primary_index_id')::INT IS NULL
----
0
table_metadata_updater_test.go:58:
/mnt/engflow/worker/work/3/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:125:
query
SELECT count(*) FROM system.table_metadata
WHERE table_type IN ('TABLE', 'SEQUENCE', 'MATERIALIZED_VIEW')
AND details->'index_sizes'->>(details->>'primary_index_id') IS NULL
----
0
table_metadata_updater_test.go:58:
/mnt/engflow/worker/work/3/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:133:
query
SELECT details->'index_sizes' FROM system.table_metadata
WHERE table_name = 'myview'
----

table_metadata_updater_test.go:58:
/mnt/engflow/worker/work/3/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:143:
query
SELECT replication_size_bytes >= (
SELECT COALESCE(sum(value::INT), 0)
FROM jsonb_each_text(details->'index_sizes')
)
FROM system.table_metadata
WHERE table_name = 'mytable2'

expected:
true

found:
false
--- FAIL: TestDataDrivenTableMetadataCacheUpdater/update_table_metadata (34.48s)
```

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)

Same failure on other branches

- #175555 basalt-26.3.2-rc-20260908: sql/tablemetadatacache: TestDataDrivenTableMetadataCacheUpdater failed [C-test-failure O-robot T-observability branch-basalt-26.3.2-rc-20260908 release-blocker]
- #174995 basalt-26.3.2-rc-20260908: sql/tablemetadatacache: TestDataDrivenTableMetadataCacheUpdater failed [C-test-failure O-robot T-observability branch-basalt-26.3.2-rc-20260908 release-blocker]
- #174892 basalt-26.3.2-rc-20260908: sql/tablemetadatacache: TestDataDrivenTableMetadataCacheUpdater failed [C-test-failure O-robot T-observability branch-basalt-26.3.2-rc-20260908 release-blocker]

/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)

Start with pkg/sql/tablemetadatacache/table_metadata_updater_test.go and the data-driven case in pkg/sql/tablemetadatacache/testdata/update_table_metadata. Run TestDataDrivenTableMetadataCacheUpdater with the update_table_metadata case and investigate why the reported system.table_metadata assertions fail. Done means the test passes without the listed metadata inconsistencies.

Written by the indexing model from the issue text.