ClickHouse / ClickHouse/ClickHouse
How to resolve persistent error when querying `system.columns`: File store/../some_name.bin is not added to the file checker: While executing Columns.
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
### Company or project name
Project Description: Data transformation and staging of data for reporting and other business requirements.
### Question
I'm currently facing the following error in a production environment:
> SQL Error [22000]: Code: 49. DB::Exception: File store/7f2/7f2f5700-xxxx-xxxx-bffa-aef192826xxx/startdate.bin is not added to the file checker: While executing Columns. (LOGICAL_ERROR) (version 24.2.1.2248 (official build))
When running this query
`SELECT database, table, name
FROM system.columns
WHERE database IN ('SomeDatabaseName')`
This error might be part of [this](https://github.com/ClickHouse/ClickHouse/issues/89106#issuecomment-3480059097) bug that has been reported and patched.
However, I'm looking for a solution to resolve this problem as our development cycle does not allow for upgrading of production resources for at least the next few months.
Contributor guide
Assessment
This issue has not been assessed yet.