Clickhouse is taking column name as Data type

138 views
Skip to first unread message

Rajesh Roy

unread,
Jul 26, 2022, 7:44:35 AM7/26/22
to ClickHouse
Hello,
I was using clickhouse v19.16.14.65, from that I updated the version to 22.3.4.20.
In v22.3.4.20 I found memory leak, So I updated from v22.3.4.20 to v21.8.15.7.
I am using 2 shard 2 replica. So, after updated from v22.3.4.20 to v21.9.2.17 one node is continuously failing(docker container restarting) with error:
 <db_name>.<table_name>.DirectoryMonitor: Code: 50, e.displayText() = DB::Exception: Unknown data type family: date_time. Maybe you meant: ['DateTime','DateTime64']: While sending /var/lib/clickhouse/xxx/<UUID>/shard2_all_replicas/44354.bin

There is a column "date_time" of type DateTime in my table.
But error log is saying that it is taking "date_time" as type.
Can anyone please help me to know why this error is occurring?
Reply all
Reply to author
Forward
0 new messages