{"record":{"id":"e57e619cfbc434b6","repo":"SigNoz/signoz","slug":"error-in-clickhouse-queries","errorCode":null,"errorMessage":"error in clickhouse queries","messagePattern":"error in clickhouse queries","errorType":"validation","errorClass":null,"httpStatus":null,"severity":"error","filePath":"pkg/query-service/app/querier/querier.go","lineNumber":304,"sourceCode":"\tresults := make([]*v3.Result, 0)\n\terrQueriesByName := make(map[string]error)\n\tvar errs []error\n\n\tfor result := range channelResults {\n\t\tif result.Err != nil {\n\t\t\terrs = append(errs, result.Err)\n\t\t\terrQueriesByName[result.Name] = result.Err\n\t\t\tcontinue\n\t\t}\n\t\tresults = append(results, &v3.Result{\n\t\t\tQueryName: result.Name,\n\t\t\tSeries:    result.Series,\n\t\t})\n\t}\n\n\tvar err error\n\tif len(errs) > 0 {\n\t\terr = fmt.Errorf(\"error in clickhouse queries\")\n\t}\n\treturn results, errQueriesByName, err\n}\n\nfunc (q *querier) runWindowBasedListQuery(ctx context.Context, params *v3.QueryRangeParamsV3, tsRanges []utils.LogsListTsRange) ([]*v3.Result, map[string]error, error) {\n\tres := make([]*v3.Result, 0)\n\tqName := \"\"\n\tpageSize := uint64(0)\n\tlimit := uint64(0)\n\toffset := uint64(0)\n\n\t// Get query details and check order direction\n\tfor name, v := range params.CompositeQuery.BuilderQueries {\n\t\tqName = name\n\t\tpageSize = v.PageSize\n\t\tlimit = v.Limit\n\t\toffset = v.Offset\n","sourceCodeStart":286,"sourceCodeEnd":322,"githubUrl":"https://github.com/SigNoz/signoz/blob/5069bf80b08f1f00d7e014eccc09902f9871004f/pkg/query-service/app/querier/querier.go#L286-L322","documentation":"Aggregated error returned by runClickHouseQueries when one or more ClickHouse sub-queries of a composite query fail. Per-query errors are also returned in errQueriesByName keyed by query name, so callers can attribute the failure to a specific query.","triggerScenarios":"Calling QueryRange with a composite query of type v3.QueryBuilder/PromQLDirector where the generated ClickHouse SQL fails: syntax errors, missing tables/columns, ClickHouse connection issues, or execution timeouts.","commonSituations":"Schema mismatch after upgrade (missing columns in distributed tables), overly broad filters causing timeouts, wrong datasource type, ClickHouse cluster overload or OOM.","solutions":["Check errQueriesByName for the failing query name and the underlying ClickHouse error","Log/print the generated SQL (raise query-service log level) and run it against ClickHouse directly to see the real error","Verify ClickHouse connectivity, table schema, and TTL settings; ensure the signoz cluster is healthy","Narrow the time range or add filters to reduce query cost"],"exampleFix":null,"handlingStrategy":"try-catch","validationCode":null,"typeGuard":null,"tryCatchPattern":"results, errByName, err := querier.QueryRange(ctx, orgID, params)\nif err != nil && strings.Contains(err.Error(), \"error in clickhouse queries\") {\n    for name, qerr := range errByName { /* handle per-query */ }\n    return err\n}","preventionTips":["Keep ClickHouse schema and query-service versions in sync","Test generated SQL on large datasets before shipping dashboards","Set sane timeouts and retry on transient ClickHouse errors"],"tags":["clickhouse","query-range","sql","composite-query"],"backgroundTag":"backend-query-execution-failed","analyzedSha":"5069bf80b08f1f00d7e014eccc09902f9871004f","analyzedAt":"2026-08-28T06:22:12.824Z","schemaVersion":2},"datasetVersion":"2026-08-28T11:17:15.048Z"}