lichenglin
lichenglin
> `MemoryResident = 3.3 GB` Try to compare with RES/RSS from Linux OS process (top/htop/ps ). > > ClickHouseMetrics_MemoryTracking shows incorrect values. I run the sql on node "cknode1" witch...
> Check https://kb.altinity.com/altinity-kb-setup-and-maintenance/altinity-kb-who-ate-my-memory/ > > Maybe you have inMemory parts enabled? (select type from system.parts) It seems we don't have inMemory parts  I have run the sql in the...
> Check this #33320 . Do you use "live views" ? > > What API/library do you use to query CH ? No, we use dict,materialize view and jdbc function....
JDBC-bridge uses http communicate with Clickhouse . I don't know if this is the possible reason. just like https://github.com/ClickHouse/ClickHouse/issues/33320
[log.zip](https://github.com/ClickHouse/ClickHouse/files/8518504/log.zip) I have checked the log in the attachement . Nothing suspicious. most memory is used for merge data pulling from kafka
What caught my attention is 'MemoryDataAndStack' and 'MemoryVirtual' seems higher than normal 
> > most memory is used for merge data pulling from kafka > > Can you try do detach Kafka table(s)? and check if the memory usage will be normalized?...
> > > most memory is used for merge data pulling from kafka > > > > > > Can you try do detach Kafka table(s)? and check if the...
Here is someting new I find ,I'm not sure if this is related to this bug We regularly see the following messages in the error log ` 2022.04.26 02:15:44.658695 [...
I think we can add new rules for "logback" ,"log4j","log4j2"