prestodb/presto · error · WebApplicationException

Parameter 'limit' for getAllQueryInfo must be positive. Got

Error message

Parameter 'limit' for getAllQueryInfo must be positive. Got %d.

What it means

getAllQueryInfo on the resource manager validates the 'limit' query parameter: a non-positive (<=0) limit was supplied, so the request is rejected with this BadRequestException before querying query state.

Source

Thrown at presto-main/src/main/java/com/facebook/presto/resourcemanager/DistributedQueryResource.java:84

    private final ResourceManagerProxy proxyHelper;

    @Inject
    public DistributedQueryResource(ResourceManagerClusterStateProvider clusterStateProvider, ResourceManagerProxy proxyHelper)
    {
        this.clusterStateProvider = requireNonNull(clusterStateProvider, "nodeStateManager is null");
        this.proxyHelper = requireNonNull(proxyHelper, "proxyHelper is null");
    }

    @GET
    public Response getAllQueryInfo(
            @QueryParam("state") String stateFilter,
            @QueryParam("limit") Integer limitFilter)
    {
        QueryState expectedState = stateFilter == null ? null : QueryState.valueOf(stateFilter.toUpperCase(Locale.ENGLISH));
        List<BasicQueryInfo> queries;
        int limit = firstNonNull(limitFilter, Integer.MAX_VALUE);
        if (limit <= 0) {
            throw new WebApplicationException(Response
                    .status(BAD_REQUEST)
                    .type(MediaType.TEXT_PLAIN)
                    .entity(format("Parameter 'limit' for getAllQueryInfo must be positive. Got %d.", limit))
                    .build());
        }
        if (stateFilter == null) {
            queries = clusterStateProvider.getClusterQueries();
        }
        else {
            ImmutableList.Builder<BasicQueryInfo> builder = ImmutableList.builder();
            for (BasicQueryInfo queryInfo : clusterStateProvider.getClusterQueries()) {
                if (queryInfo.getState() == expectedState) {
                    builder.add(queryInfo);
                }
            }
            queries = builder.build();
        }
        queries = new ArrayList<>(queries);

View on GitHub (pinned to 55bb57d202)

Solutions

1. Pass a positive integer for the limit query parameter, or omit it entirely

When it happens

Trigger: Thrown at presto-main/src/main/java/com/facebook/presto/resourcemanager/DistributedQueryResource.java:84 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of prestodb/presto@55bb57d202 (2026-09-04). Data as JSON: /api/errors/efb84504ce9151a7. Report an issue: GitHub.