Hi I m getting following error while going to service map pa

Question

Hi I m getting following error while going to service map page ```2023 03 02T16 21 17 197Z DEBUG clickhouseReader reader go 2006 WITH quantilesMergeState 0 5 0 75 0 9 0 95 0 99 duration quantiles state AS duration quantiles state finalizeAggregation duration quantiles state AS result SELECT src as parent dest as child result 1 AS p50 result 2 AS p75 result 3 AS p90 result 4 AS p95 result 5 AS p99 sum total count as callCount sum total count duration AS callRate sum error count sum total count 100 as errorRate FROM signoz traces distributed dependency graph minutes WHERE toUInt64 toDateTime timestamp gt = start AND toUInt64 toDateTime timestamp lt = end GROUP BY src dest start 1677773684 end 1677773984 duration 300 2023 03 02T16 21 17 250Z ERROR clickhouseReader reader go 2011 Error in processing sql query code 184 message Received from chi signoz clickhouse cluster 0 0 9000 DB Exception Aggregate function quantilesMergeState 0 5 0 75 0 9 0 95 0 99 duration quantiles state is found inside another aggregate function in query While processing quantilesMergeState 0 5 0 75 0 9 0 95 0 99 duration quantiles state Stack trace 0 DB Exception Exception std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt const amp int bool 0xa3fb75a in usr bin clickhouse 1 DB GetAggregatesMatcher visit DB ASTFunction const amp std 1 shared ptr lt DB IAST gt const amp DB GetAggregatesMatcher Data amp 0x149c2115 in usr bin clickhouse 2 DB InDepthNodeVisitor lt DB GetAggregatesMatcher true false std 1 shared ptr lt DB IAST gt const gt visit std 1 shared ptr lt DB IAST gt const amp 0x149b2dd2 in usr bin clickhouse 3 0x150d5ee7 in usr bin clickhouse 4 DB TreeRewriter analyzeSelect std 1 shared ptr lt DB IAST gt amp DB TreeRewriterResult amp amp DB SelectQueryOptions const amp std 1 vector lt DB TableWithColumnNamesAndTypes std 1 allocator lt DB TableWithColumnNamesAndTypes gt gt const amp std 1 vector lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt std 1 allocator lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt gt gt const amp std 1 shared ptr lt DB TableJoin gt const 0x150d2f3b in usr bin clickhouse 5 0x14e598e1 in usr bin clickhouse 6 DB InterpreterSelectQuery InterpreterSelectQuery std 1 shared ptr lt DB IAST gt const amp std 1 shared ptr lt DB Context gt const amp std 1 optional lt DB Pipe gt std 1 shared ptr lt DB IStorage gt const amp DB SelectQueryOptions const amp std 1 vector lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt std 1 allocator lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt gt gt const amp std 1 shared ptr lt DB StorageInMemoryMetadata const gt const amp std 1 shared ptr lt DB PreparedSets gt 0x14e56549 in usr bin clickhouse 7 DB InterpreterSelectQuery InterpreterSelectQuery std 1 shared ptr lt DB IAST gt const amp std 1 shared ptr lt DB Context const gt const amp std 1 optional lt DB Pipe gt std 1 shared ptr lt DB IStorage gt const amp DB SelectQueryOptions const amp std 1 vector lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt std 1 allocator lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt gt gt const amp std 1 shared ptr lt DB StorageInMemoryMetadata const gt const amp std 1 shared ptr lt DB PreparedSets gt 0x14e53a26 in usr bin clickhouse 8 DB InterpreterSelectQuery InterpreterSelectQuery std 1 shared ptr lt DB IAST gt const amp std 1 shared ptr lt DB Context const gt const amp DB SelectQueryOptions const amp std 1 shared ptr lt DB PreparedSets gt 0x14e58410 in usr bin clickhouse 9 DB MergeTreeData getQueryProcessingStageWithAggregateProjection std 1 shared ptr lt DB Context const gt std 1 shared ptr lt DB StorageSnapshot gt const amp DB SelectQueryInfo amp const 0x158c2a04 in usr bin clickhouse 10 DB MergeTreeData getQueryProcessingStage std 1 shared ptr lt DB Context const gt DB QueryProcessingStage Enum std 1 shared ptr lt DB StorageSnapshot gt const amp DB SelectQueryInfo amp const 0x158c72a5 in usr bin clickhouse 11 DB InterpreterSelectQuery getSampleBlockImpl 0x14e63916 in usr bin clickhouse 12 0x14e5b423 in usr bin clickhouse 13 DB InterpreterSelectQuery InterpreterSelectQuery std 1 shared ptr lt DB IAST gt const amp std 1 shared ptr lt DB Context gt const amp std 1 optional lt DB Pipe gt std 1 shared ptr lt DB IStorage gt const amp DB SelectQueryOptions const amp std 1 vector lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt std 1 allocator lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt gt gt const amp std 1 shared ptr lt DB StorageInMemoryMetadata const gt const amp std 1 shared ptr lt DB PreparedSets gt 0x14e56549 in usr bin clickhouse 14 DB InterpreterSelectWithUnionQuery buildCurrentChildInterpreter std 1 shared ptr lt DB IAST gt const amp std 1 vector lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt std 1 allocator lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt gt gt const amp 0x14ea2cac in usr bin clickhouse 15 DB InterpreterSelectWithUnionQuery InterpreterSelectWithUnionQuery std 1 shared ptr lt DB IAST gt const amp std 1 shared ptr lt DB Context gt DB SelectQueryOptions const amp std 1 vector lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt std 1 allocator lt std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt gt gt const amp 0x14ea09ac in usr bin clickhouse 16 DB InterpreterFactory get std 1 shared ptr lt DB IAST gt amp std 1 shared ptr lt DB Context gt DB SelectQueryOptions const amp 0x14e04a9e in usr bin clickhouse 17 0x15196e80 in usr bin clickhouse 18 DB executeQuery std 1 basic string lt char std 1 char traits lt char gt std 1 allocator lt char gt gt const amp std 1 shared ptr lt DB Context gt bool DB QueryProcessingStage Enum 0x15194957 in usr bin clickhouse 19 DB TCPHandler runImpl 0x15c8dd6c in usr bin clickhouse 20 DB TCPHandler run 0x15ca2379 in usr bin clickhouse 21 Poco Net TCPServerConnection start 0x18a16b73 in usr bin clickhouse 22 Poco Net TCPServerDispatcher run 0x18a17ecd in usr bin clickhouse 23 Poco PooledThread run 0x18bda829 in usr bin clickhouse 24 Poco ThreadImpl runnableEntry void 0x18bd80e2 in usr bin clickhouse 25 0x7fc72d53a609 in 26 clone 0x7fc72d45f133 in While executing Remote go src github com signoz signoz pkg query service app clickhouseReader reader go 2011 go src github com signoz signoz pkg query service app http handler go 1337 go src github com signoz signoz pkg query service app auth go 46 net http HandlerFunc ServeHTTP usr local go src net http server go 2047 go src github com signoz signoz ee query service app server go 256 net http HandlerFunc ServeHTTP usr local go src net http server go 2047 go src github com signoz signoz ee query service app server go 362 net http HandlerFunc ServeHTTP usr local go src net http server go 2047 go src github com signoz signoz ee query service app server go 390 net http HandlerFunc ServeHTTP usr local go src net http server go 2047 go pkg mod github com gorilla mux v1 8 0 mux go 210 go pkg mod github com rs cors v1 7 0 cors go 219 net http HandlerFunc ServeHTTP usr local go src net http server go 2047 go pkg mod github com gorilla handlers v1 5 1 compress go 141 net http HandlerFunc ServeHTTP usr local go src net http server go 2047 net http serverHandler ServeHTTP usr local go src net http server go 2879 net http conn serve usr local go src net http server go 1930 2023 03 02T16 21 17 250Z INFO app server go 257 api v1 dependency graph timeTaken 53 767308ms```

Srikanth Chekuri · Answer

Is this reproducible or happening occasionally

Muhammed Hussein Karimi · Answer

That s happening every time that I open this page

Srikanth Chekuri · Answer

What s the ClickHouse version

Muhammed Hussein Karimi · Answer

the version from chart

Muhammed Hussein Karimi · Answer

22 8

Srikanth Chekuri · Answer

Ok thanks there appears to be some bug in 22 8

Muhammed Hussein Karimi · Answer

I should bump up the version or I have to wait

Srikanth Chekuri · Answer

We haven t tested any new versions bumping version should be fine but we will also investigate and release some fix soon

Muhammed Hussein Karimi · Answer

Okay I m waiting for a fix