We are observing Intermittent empty results from I...
# questions-and-troubleshooting
a
We are observing Intermittent empty results from Iceberg table queries Environment: StarRocks 4.0.6, 5 FE nodes, REST Iceberg catalog Symptom: The same query against the same table intermittently returns 0 rows. Re-establishing the MySQL connection sometimes fixes it (presumably landing on a different FE). The table has not been updated — same snapshot is used in both cases. Root cause evidence from query profiles: - Both queries use snapshot 5731107429248102568 with identical predicates - Failing query: resultDataFiles=0, skippedDataFiles=414, totalFileSizeInBytes=0 - Working query: resultDataFiles=4, skippedDataFiles=9345, totalFileSizeInBytes=1.2GB - Both scanned 2 data manifests, skipped 1 — but the failing query only enumerated 414 files from those manifests vs 9,349 on the working query - ICEBERG.hasMoreOutput iterations: 120 (failing) vs 131 (working) - REFRESH EXTERNAL TABLE did not resolve the issue Is anyone else experiencing this on 4.0.6? Is it possible that the Iceberg manifest cache is incomplete/corrupt on one front-end? Anything we should look for specifically?