nikepan / clickhouse-bulk

Collects many small inserts to ClickHouse and send in big inserts
Apache License 2.0
474 stars 86 forks source link

ERROR: server error (400) Wrong server status 400 after updating to ClickHouse server version 21.4.4.30 (official build) #42

Closed ArthurMartiros closed 3 years ago

ArthurMartiros commented 3 years ago

Hi. The proxy can not execute queries an prints this log after the update but it has worked before the update

request: "INSERT INTO `display` (`uuid`,`user_id`,`app_uuid`,`uuid1`,`uuid2`,`created_at`) VALUES\n('7ecd41eb-58b6-44d2-ab59-01235bc32135',86,'00806453-89a0-4fd2-9f9f-2b012f45049e','0069f823-f901-48c6-b8bb-3d5a5d61d470','4264487b-fa40-47ae-939b-a492df46caaa','1618914155')"
2021/04/21 07:12:41.249482 INFO: sending 1 rows to http://192.168.88.1:8123 of INSERT INTO `display` (`uuid`,`user_id`,`app_uuid`,`uuid1`,`uuid1`,`created_at`) VALUES
2021/04/21 07:12:41.257645 INFO: sent 1 rows to http://192.168.88.1:8123 of INSERT INTO `display` (`uuid`,`user_id`,`app_uuid`,`uuid1`,`uuid1`,`created_at`) VALUES
2021/04/21 07:12:41.257817 ERROR: server error (400) Wrong server status 400:

Please take a look, it is very urgent for us. Best Regards Arthur

ArthurMartiros commented 3 years ago

Hey the problem is obvious: it is fixed in source code but still actual in docker image. The docker registry image is not up to date due to source code's latest release. Use source code instead of docker image to avoid such kind of problems with latest Clickhouse releases. Thanks :)

nikepan commented 3 years ago

sorry. docker image updated