当我尝试在clickhouse数据库中插入记录时,出现以下异常:
异常:
Code: 164, e.displayText() = DB::Exception: Cannot insert into table in readonly mode, e.what() = DB::Exception
节点包:
https://www.npmjs.com/package/clickhouse
连接代码:
const clickhouse = new ClickHouse({
url: 'http://localhost',
port: 8123,
debug: true,
database: 'mydb',
basicAuth: 'default',
username: '',
password: '',
isUseGzip: false,
config: {
session_timeout : 60,
output_format_json_quote_64bit_integers : 0,
enable_http_compression : 0
},
});
表架构:
CREATE TABLE logs_1 ( trid UInt64, date UInt32, email String) ENGINE = Log;
发布于 2019-03-12 04:43:05
可能的原因:
因此,请检查默认用户和配置文件的设置。它很可能包含只读标志。
https://stackoverflow.com/questions/55076759
复制相似问题