High CPU usage after a query then instance crashes

I updated my influxdb from 1.8 to 2.2 recently. This is the second time influxDb crashed my EC2 instance.
After I executed a query, then CPU get high, and then the whole instance crashes( can’t SSH to the instance)
This won’t happen when I using 1.8, even if I choose a much much long period.

Can you guys help to analysis what is wrong? and where can I find the error log, thanks

Hello @Yole_Yu,
I’m not sure.
Have you seen this documentation?

I believe it’s the same for 2.2

From the documentation, the default log location should be in /var/log/influxdb/influxd.log, but it is empty in /var/log/influxdb/ of my instance.

I am not familiar with the detail of InfluxDB, I just install it and analysis some of my quant data.

Anyway, I think InfluxDB2 will cause the whole system hang is a critical issue.