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.

Open
#101,508 2 comments 0 reactions 0 assignees View on GitHub
comp-system-table external question
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.