PromQL query_range returns 500 for min/max/avg/sum by (...) (time() - metric)

[tangyouzzz]

What type of bug is this?

Unexpected error

What subsystems are affected?

Frontend

Minimal reproduce step

upgrading from v1.0.0-rc.2 to v1.1.1.

min( time() -
  container_start_time_seconds{}
) by (namespace, project,app)

What did you expect to see?

The query should return a valid Prometheus matrix result instead of HTTP 500.

What did you see instead?

unexpected response with status code 500: {"status":"error","error":"Internal error: 1003","errorType":"Internal"}

This also fails with max, avg, and sum.

However:

• removing time() makes the query work
• removing the aggregation makes the query work

What operating system did you use?

linux

What version of GreptimeDB did you use?

v1.1.1

Relevant log output and stack trace

[killme2008]

Does this work in v1.0.0-rc.2? Could you share the database logs from when you run it?

Please take a look @waynexia

[tangyouzzz]

这个方法在v1.0.0-rc.2你的电脑上能用吗？能否分享一下运行时的数据库日志？

请看一下@waynexia

I only upgraded one cluster to v1.1.1, and it worked fine on the old cluster v1.0.0-rc.2

[tangyouzzz]

这个方法在v1.0.0-rc.2你的电脑上能用吗？能否分享一下运行时的数据库日志？
请看一下@waynexia

I only upgraded one cluster to v1.1.1, and it worked fine on the old cluster v1.0.0-rc.2

{"timestamp":"2026-07-02T02:28:04.305690Z","level":"DEBUG","fields":{"message":"started processing request"},"target":"tower_http::trace::on_request","span":{"method":"GET","uri":"/health","version":"HTTP/1.1","name":"request"},"spans":[{"method":"GET","uri":"/health","version":"HTTP/1.1","name":"request"}]}
{"timestamp":"2026-07-02T02:28:04.305776Z","level":"DEBUG","fields":{"message":"Setting read preference to LEADER"},"target":"servers::http::read_preference","span":{"method":"GET","uri":"/health","version":"HTTP/1.1","name":"request"},"spans":[{"method":"GET","uri":"/health","version":"HTTP/1.1","name":"request"}]}
{"timestamp":"2026-07-02T02:28:04.305818Z","level":"DEBUG","fields":{"message":"finished processing request","latency":"0 ms","status":200},"target":"tower_http::trace::on_response","span":{"method":"GET","uri":"/health","version":"HTTP/1.1","name":"request"},"spans":[{"method":"GET","uri":"/health","version":"HTTP/1.1","name":"request"}]}
{"timestamp":"2026-07-02T02:28:05.485887Z","level":"DEBUG","fields":{"message":"started processing request"},"target":"tower_http::trace::on_request","span":{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"}]}
{"timestamp":"2026-07-02T02:28:05.485976Z","level":"DEBUG","fields":{"message":"Setting read preference to LEADER"},"target":"servers::http::read_preference","span":{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"}]}
{"timestamp":"2026-07-02T02:28:05.488295Z","level":"DEBUG","fields":{"message":"Parsing sql 'dummy'...","log.target":"sqlparser::parser","log.module_path":"sqlparser::parser","log.file":"/root/.cargo/git/checkouts/sqlparser-rs-6d6510b5e3af714f-shallow/2aefa08/src/parser/mod.rs","log.line":475},"target":"sqlparser::parser","span":{"name":"plan_pql"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},{"protocol":"prometheus","request_type":"range_query","name":"range_query"},{"name":"do_query"},{"name":"plan"},{"name":"plan"},{"name":"plan_pql"}]}
{"timestamp":"2026-07-02T02:28:05.488379Z","level":"DEBUG","fields":{"message":"Parsing sql 'time'...","log.target":"sqlparser::parser","log.module_path":"sqlparser::parser","log.file":"/root/.cargo/git/checkouts/sqlparser-rs-6d6510b5e3af714f-shallow/2aefa08/src/parser/mod.rs","log.line":475},"target":"sqlparser::parser","span":{"name":"plan_pql"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},{"protocol":"prometheus","request_type":"range_query","name":"range_query"},{"name":"do_query"},{"name":"plan"},{"name":"plan"},{"name":"plan_pql"}]}
{"timestamp":"2026-07-02T02:28:05.488502Z","level":"DEBUG","fields":{"message":"Created PromQL function plan: Filter(Filter { predicate: IsNotNull(Column(Column { relation: None, name: "time / Float64(1000)" })), input: Projection(Projection { expr: [Column(Column { relation: Some(Bare { table: "" }), name: "time" }), Alias(Alias { expr: BinaryExpr(BinaryExpr { left: Cast(Cast { expr: Cast(Cast { expr: Column(Column { relation: Some(Bare { table: "" }), name: "time" }), data_type: Int64 }), data_type: Float64 }), op: Divide, right: Literal(Float64(1000), None) }), relation: None, name: "time / Float64(1000)", metadata: None })], input: Extension(Extension { node: EmptyMetric { start: 1782957480000, end: 1782959280000, interval: 15000, expr: None, time_index_schema: DFSchema { inner: Schema { fields: [Field { name: "time", data_type: Timestamp(Millisecond, None) }], metadata: {} }, field_qualifiers: [Some(Bare { table: "" })], functional_dependencies: FunctionalDependencies { deps: [] } }, result_schema: DFSchema { inner: Schema { fields: [Field { name: "time", data_type: Timestamp(Millisecond, None) }], metadata: {} }, field_qualifiers: [Some(Bare { table: "" })], functional_dependencies: FunctionalDependencies { deps: [] } }, dummy_input: TableScan(TableScan { table_name: Bare { table: "dummy" }, source: "...", projection: None, projected_schema: DFSchema { inner: Schema { fields: [Field { name: "time", data_type: Timestamp(Millisecond, None) }], metadata: {} }, field_qualifiers: [Some(Bare { table: "dummy" })], functional_dependencies: FunctionalDependencies { deps: [] } }, filters: [], fetch: None, .. }) } }), schema: DFSchema { inner: Schema { fields: [Field { name: "time", data_type: Timestamp(Millisecond, None) }, Field { name: "time / Float64(1000)", data_type: Float64 }], metadata: {} }, field_qualifiers: [Some(Bare { table: "" }), None], functional_dependencies: FunctionalDependencies { deps: [] } } }) }) for Call { func: Function { name: "time", arg_types: [], variadic: false, return_type: Scalar }, args: FunctionArgs { args: [] } }"},"target":"query::promql::planner","span":{"name":"plan_pql"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},{"protocol":"prometheus","request_type":"range_query","name":"range_query"},{"name":"do_query"},{"name":"plan"},{"name":"plan"},{"name":"plan_pql"}]}
{"timestamp":"2026-07-02T02:28:05.489245Z","level":"DEBUG","fields":{"message":"Parsing sql 'greptime_timestamp'...","log.target":"sqlparser::parser","log.module_path":"sqlparser::parser","log.file":"/root/.cargo/git/checkouts/sqlparser-rs-6d6510b5e3af714f-shallow/2aefa08/src/parser/mod.rs","log.line":475},"target":"sqlparser::parser","span":{"name":"plan_pql"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},{"protocol":"prometheus","request_type":"range_query","name":"range_query"},{"name":"do_query"},{"name":"plan"},{"name":"plan"},{"name":"plan_pql"}]}
{"timestamp":"2026-07-02T02:28:05.489305Z","level":"DEBUG","fields":{"message":"Parsing sql 'greptime_value'...","log.target":"sqlparser::parser","log.module_path":"sqlparser::parser","log.file":"/root/.cargo/git/checkouts/sqlparser-rs-6d6510b5e3af714f-shallow/2aefa08/src/parser/mod.rs","log.line":475},"target":"sqlparser::parser","span":{"name":"plan_pql"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},{"protocol":"prometheus","request_type":"range_query","name":"range_query"},{"name":"do_query"},{"name":"plan"},{"name":"plan"},{"name":"plan_pql"}]}
{"timestamp":"2026-07-02T02:28:05.489323Z","level":"DEBUG","fields":{"message":"Parsing sql 'greptime_timestamp'...","log.target":"sqlparser::parser","log.module_path":"sqlparser::parser","log.file":"/root/.cargo/git/checkouts/sqlparser-rs-6d6510b5e3af714f-shallow/2aefa08/src/parser/mod.rs","log.line":475},"target":"sqlparser::parser","span":{"name":"plan_pql"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},{"protocol":"prometheus","request_type":"range_query","name":"range_query"},{"name":"do_query"},{"name":"plan"},{"name":"plan"},{"name":"plan_pql"}]}
{"timestamp":"2026-07-02T02:28:05.489339Z","level":"DEBUG","fields":{"message":"Parsing sql '__tsid'...","log.target":"sqlparser::parser","log.module_path":"sqlparser::parser","log.file":"/root/.cargo/git/checkouts/sqlparser-rs-6d6510b5e3af714f-shallow/2aefa08/src/parser/mod.rs","log.line":475},"target":"sqlparser::parser","span":{"name":"plan_pql"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},{"protocol":"prometheus","request_type":"range_query","name":"range_query"},{"name":"do_query"},{"name":"plan"},{"name":"plan"},{"name":"plan_pql"}]}
{"timestamp":"2026-07-02T02:28:05.490662Z","level":"WARN","fields":{"message":"HTTP error response 500 Internal Server Error for POST /v1/prometheus/api/v1/query_range (matched: /v1/prometheus/api/v1/query_range) from client 10.132.32.1:34820"},"target":"servers::http::client_ip","span":{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"}]}
{"timestamp":"2026-07-02T02:28:05.490714Z","level":"DEBUG","fields":{"message":"finished processing request","latency":"4 ms","status":500},"target":"tower_http::trace::on_response","span":{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"}]}
{"timestamp":"2026-07-02T02:28:05.490762Z","level":"DEBUG","fields":{"message":"end of stream","stream_duration":"0 ms"},"target":"tower_http::trace::on_eos","span":{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"},"spans":[{"method":"POST","uri":"/v1/prometheus/api/v1/query_range","version":"HTTP/1.1","name":"request"}]}