clickhouse 问题 Cannot read from file 1094, errno: 1, strerror: Operation not permitted:

问题描述

可以建表，删表，和插入数据，查询的时候报错，错误信息如下：

org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [74] [07000]: Code: 74. DB::ErrnoException: Cannot read from file 1094, errno: 1, strerror: Operation not permitted: (while reading column product_no): While executing MergeTreeInOrder. (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 22.7.1.2484 (official build))
, server ClickHouseNode(addr=http:10.193.222.5:8123, db=ads)@-1801368758

	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)

	at org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readData(JDBCTable.java:190)

	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118)

	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)

	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)

	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4945)

	at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)

	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

Caused by: java.sql.SQLException: Code: 74. DB::ErrnoException: Cannot read from file 1094, errno: 1, strerror: Operation not permitted: (while reading column product_no): While executing MergeTreeInOrder. (CANNOT_READ_FROM_FILE_DESCRIPTOR) (version 22.7.1.2484 (official build))
, server ClickHouseNode(addr=http:10.193.222.5:8123, db=ads)@-1801368758

	at com.clickhouse.jdbc.SqlExceptionUtils.handle(SqlExceptionUtils.java:54)

	at com.clickhouse.jdbc.SqlExceptionUtils.handle(SqlExceptionUtils.java:69)

	at com.clickhouse.jdbc.internal.ClickHouseStatementImpl.getLastResponse(ClickHouseStatementImpl.java:80)

	at com.clickhouse.jdbc.internal.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:257)

	at com.clickhouse.jdbc.internal.ClickHouseStatementImpl.execute(ClickHouseStatementImpl.java:409)

	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:329)

	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.lambda$0(JDBCStatementImpl.java:131)

	at org.jkiss.dbeaver.utils.SecurityManagerUtils.wrapDriverActions(SecurityManagerUtils.java:94)

	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)

	... 7 more

原部署命令

docker run -d --name clickhouse-server --restart=always --ulimit nofile=262144:262144 -p 8123:8123 -p 9001:9000 clickhouse/clickhouse-server

问题原因版本存在bug
当时 latest版本为 (version 22.7.1.2484 (official build))

解决方法换版本

docker run -d --name clickhouse-server --restart=always --ulimit nofile=262144:262144 -p 8123:8123 -p 9001:9000 clickhouse/clickhouse-server:21.9.2