https://signoz.io logo
#support
Title
# support
m

Muhammed Hussein Karimi

03/02/2023, 4:23 PM
Hi I'm getting following error while going to service map page
Copy code
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)) >= @start AND toUInt64(toDateTime(timestamp)) <= @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<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ 0xa3fb75a in /usr/bin/clickhouse
1. DB::GetAggregatesMatcher::visit(DB::ASTFunction const&, std::__1::shared_ptr<DB::IAST> const&, DB::GetAggregatesMatcher::Data&) @ 0x149c2115 in /usr/bin/clickhouse
2. DB::InDepthNodeVisitor<DB::GetAggregatesMatcher, true, false, std::__1::shared_ptr<DB::IAST> const>::visit(std::__1::shared_ptr<DB::IAST> const&) @ 0x149b2dd2 in /usr/bin/clickhouse
3. ? @ 0x150d5ee7 in /usr/bin/clickhouse
4. DB::TreeRewriter::analyzeSelect(std::__1::shared_ptr<DB::IAST>&, DB::TreeRewriterResult&&, DB::SelectQueryOptions const&, std::__1::vector<DB::TableWithColumnNamesAndTypes, std::__1::allocator<DB::TableWithColumnNamesAndTypes> > const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&, std::__1::shared_ptr<DB::TableJoin>) const @ 0x150d2f3b in /usr/bin/clickhouse
5. ? @ 0x14e598e1 in /usr/bin/clickhouse
6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::__1::shared_ptr<DB::PreparedSets>) @ 0x14e56549 in /usr/bin/clickhouse
7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context const> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::__1::shared_ptr<DB::PreparedSets>) @ 0x14e53a26 in /usr/bin/clickhouse
8. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context const> const&, DB::SelectQueryOptions const&, std::__1::shared_ptr<DB::PreparedSets>) @ 0x14e58410 in /usr/bin/clickhouse
9. DB::MergeTreeData::getQueryProcessingStageWithAggregateProjection(std::__1::shared_ptr<DB::Context const>, std::__1::shared_ptr<DB::StorageSnapshot> const&, DB::SelectQueryInfo&) const @ 0x158c2a04 in /usr/bin/clickhouse
10. DB::MergeTreeData::getQueryProcessingStage(std::__1::shared_ptr<DB::Context const>, DB::QueryProcessingStage::Enum, std::__1::shared_ptr<DB::StorageSnapshot> const&, DB::SelectQueryInfo&) 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<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::__1::shared_ptr<DB::PreparedSets>) @ 0x14e56549 in /usr/bin/clickhouse
14. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::__1::shared_ptr<DB::IAST> const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 0x14ea2cac in /usr/bin/clickhouse
15. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 0x14ea09ac in /usr/bin/clickhouse
16. DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x14e04a9e in /usr/bin/clickhouse
17. ? @ 0x15196e80 in /usr/bin/clickhouse
18. DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::Context>, 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
<http://go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetDependencyGraph|go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetDependencyGraph>
        /go/src/github.com/signoz/signoz/pkg/query-service/app/clickhouseReader/reader.go:2011
<http://go.signoz.io/signoz/pkg/query-service/app.(*APIHandler).dependencyGraph|go.signoz.io/signoz/pkg/query-service/app.(*APIHandler).dependencyGraph>
        /go/src/github.com/signoz/signoz/pkg/query-service/app/http_handler.go:1337
<http://go.signoz.io/signoz/pkg/query-service/app.(*AuthMiddleware).ViewAccess.func1|go.signoz.io/signoz/pkg/query-service/app.(*AuthMiddleware).ViewAccess.func1>
        /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
<http://go.signoz.io/signoz/ee/query-service/app.loggingMiddleware.func1|go.signoz.io/signoz/ee/query-service/app.loggingMiddleware.func1>
        /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
<http://go.signoz.io/signoz/ee/query-service/app.(*Server).analyticsMiddleware.func1|go.signoz.io/signoz/ee/query-service/app.(*Server).analyticsMiddleware.func1>
        /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
<http://go.signoz.io/signoz/ee/query-service/app.setTimeoutMiddleware.func1|go.signoz.io/signoz/ee/query-service/app.setTimeoutMiddleware.func1>
        /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
<http://github.com/gorilla/mux.(*Router).ServeHTTP|github.com/gorilla/mux.(*Router).ServeHTTP>
        /go/pkg/mod/github.com/gorilla/mux@v1.8.0/mux.go:210
<http://github.com/rs/cors.(*Cors).Handler.func1|github.com/rs/cors.(*Cors).Handler.func1>
        /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
<http://github.com/gorilla/handlers.CompressHandlerLevel.func1|github.com/gorilla/handlers.CompressHandlerLevel.func1>
        /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
s

Srikanth Chekuri

03/02/2023, 4:45 PM
Is this reproducible or happening occasionally?
m

Muhammed Hussein Karimi

03/04/2023, 1:31 PM
That's happening every time that I open this page
s

Srikanth Chekuri

03/04/2023, 2:06 PM
What’s the ClickHouse version?
m

Muhammed Hussein Karimi

03/04/2023, 2:07 PM
the version from chart
22.8
s

Srikanth Chekuri

03/04/2023, 2:14 PM
Ok, thanks, there appears to be some bug in 22.8,
m

Muhammed Hussein Karimi

03/04/2023, 2:15 PM
I should bump up the version? or I have to wait?
s

Srikanth Chekuri

03/04/2023, 2:15 PM
We haven’t tested any new versions, bumping version should be fine but we will also investigate and release some fix soon.
m

Muhammed Hussein Karimi

03/04/2023, 2:18 PM
Okay I'm waiting for a fix
4 Views