The section illustrates common query errors and how to resolve them on Appsmith.
Query/API response errors
Execution failed with status 5009
You could see the query/API execution fails and generates an error response.
[<QUERY_OR_API_NAME>] action returned an error response. Response size exceeded the maximum supported size of <SIZE_SPECIFIED_IN_FILE> MB. Please use LIMIT to reduce the amount of data fetched.
Response size exceeded the maximum supported size of <SIZE_SPECIFIED_IN_FILE> MB. Please use LIMIT to reduce the amount of data fetched.
The error response could be caused when the API/query response size exceeds the allowed maximum limit of 5 MB or the size setup.
You could resolve the error response by doing one of the following:
- To limit the data returned as part of query response by using limit in the query or enabling pagination for table.
- To limit the data for an API, you'll have to add a server-side pagination feature to it.
- To update the maximum allowed limit, you can modify the environment variable only for the self-hosted instance of Appsmith. For example, to modify the limit for docker-based installation, navigate to the
docker.envfile and modify the
APPSMITH_PLUGIN_MAX_RESPONSE_SIZE_MBenvironment variable to the desired response size(10 MB).