(Illegal type DateTime64(3) [ while pushing to view default.DNS_PROTOCOL] Latest Version(v0.9.7) DNS-Monster Showing Error while send data to Click-House

[HesaMtiPu]

`dnsmonster[8323]: time="2023-01-24T12:38:07+05:30" level=warning msg="Error while executing batch: code: 43, message: Illegal type DateTime64(3) of argument for aggregate function sumWithOverflow: while pushing to view default.DNS_PROTOCOL (f20ac7c5-9b15-4d2f-935f-7fb13614c12f)"

Kindly look into it !!!
Thanks !!!

[mosajjal]

Hi there.

what's the version of ClickHouse and dnsmonster running

[HesaMtiPu]

ClickHouse server version 22.12.3
dnsmonster version: v0.9.7

[mosajjal]

if you've upgraded dnsmonster from an older version, it's required to re-create the tables on clickhouse based on the new table schema. That's an unfortunate limitation of Clickhouse that the primary key of the table can't have it's typed modified.

[HesaMtiPu]

i did not upgrade dnsmonster from older version , just installed fresh both in new VM .

[mosajjal]

did you use the autobuild.sh script or re-created the folders. Also, if you're using Linux, you can use the build artifact from the latest commit here

[mosajjal]

also have a look on 0.9.9.

[HesaMtiPu]

Okey buddy !!!
I will check and share Positive Result.

[HesaMtiPu]

we need to re-create DNS_LOG table and DNS_PROTOCOL after installation of 0.9.9. ????
because problem is still persist.

[mosajjal]

unfortunately yes. it's a limitation of ClickHouse :(