> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1900-to-1999/e1931.md).

# Error 1931: Query execution was interrupted. The query exceeded. The query result may be incomplete

**MariaDB starting with** [**10.5.22**](/docs/release-notes/community-server/old-releases/10.5/10.5.22.md)

> \= [MariaDB 11.1.2](/docs/release-notes/community-server/old-releases/11.1/11.1.2.md), [MariaDB 10.11.5](/docs/release-notes/community-server/10.11/10.11.5.md), [MariaDB 10.6.15](/docs/release-notes/community-server/10.6/10.6.15.md), [MariaDB 10.5.22](/docs/release-notes/community-server/old-releases/10.5/10.5.22.md):

| Error Code | SQLSTATE | Error                         | Description                                                                                     |
| ---------- | -------- | ----------------------------- | ----------------------------------------------------------------------------------------------- |
| 1931       |          | ER\_QUERY\_RESULT\_INCOMPLETE | Query execution was interrupted. The query exceeded %s %llu. The query result may be incomplete |

**MariaDB until** [**10.6.14**](/docs/release-notes/community-server/10.6/10.6.14.md)

<= [MariaDB 11.1.1](/docs/release-notes/community-server/old-releases/11.1/11.1.1.md), [MariaDB 10.11.4](/docs/release-notes/community-server/10.11/10.11.4.md), [MariaDB 10.6.14](/docs/release-notes/community-server/10.6/10.6.14.md), [MariaDB 10.5.21](/docs/release-notes/community-server/old-releases/10.5/10.5.21.md):

| Error Code | SQLSTATE | Error                                      | Description                                                                                                                                           |
| ---------- | -------- | ------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------- |
| 1931       |          | ER\_QUERY\_EXCEEDED\_ROWS\_EXAMINED\_LIMIT | Query execution was interrupted. The query examined at least %llu rows, which exceeds LIMIT ROWS EXAMINED (%llu). The query result may be incomplete. |

## Possible Causes and Solutions

{% hint style="success" %}
This article doesn't currently contain any content. [You can help!](/docs/general-resources/about/readme/contributing-documentation.md)
{% endhint %}

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}