gaoxingliang commented on issue #8828:
URL: https://github.com/apache/apisix/issues/8828#issuecomment-1577809672
Hi @An-DJ I tried with apisix 3.2.0, it shows an error like :
```
2023/06/06 02:35:00 [error] 53#53: *71652544 [lua] batch-processor.lua:95:
Batch Processor[clickhouse-logger] failed to process entries: server returned
status code[400] host[clickhouse-clickhouse-cluster.devops] port[8123]
body[Code: 26, e.displayText() = DB::ParsingException: Cannot parse JSON
string: expected opening quote: (at row 1)
: (while reading the value of key response) (version 21.1.3.32)
], context: ngx.timer, client: 10.233.107.0, server: 0.0.0.0:9080
```
The table is:
```
create table api_log4 on cluster "all-nodes" ( \
upstream String, \
start_time DateTime64(3, 'Asia/Shanghai'),\
client_ip String,\
service_id String,\
route_id String,\
request JSON,\
response String DEFAULT '{}',\
server JSON,\
latency Float64,\
upstream_latency Float64,\
apisix_latency Float64\
)\
ENGINE =
ReplicatedMergeTree('/clickhouse/tables/{shard}/{database}/{table}',
'{replica}')\
PARTITION BY toYYYYMM(start_time)\
ORDER BY (start_time, route_id);
```
and the conf is same as above except the table.
I changed the `response` field from JSON to String. the error is same. I
don't what the raw body (of logger) is.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
