Error
Error Code:
1104
MariaDB Error 1104: Query Exceeds Row Limit
Description
This error indicates that a `SELECT` statement would attempt to process more rows than permitted by the `MAX_JOIN_SIZE` system variable. MariaDB stops the query to prevent it from consuming excessive resources or running for an unacceptably long time, often due to an unoptimized query design.
Error Message
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
Known Causes
4 known causesInefficient WHERE Clause
A `SELECT` statement lacks a sufficient `WHERE` clause, causing it to scan or join an excessively large number of rows from tables.
Unoptimized Joins
Queries involving multiple `JOIN` operations without proper `ON` conditions or with conditions that result in a very large intermediate result set.
Low MAX_JOIN_SIZE Setting
The `MAX_JOIN_SIZE` system variable is configured to a value that is too low for legitimate, albeit large, queries required by the application.
Complex Query Design
A genuinely complex query involving many tables and conditions that naturally requires examining a large number of rows, exceeding the default safety limit.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service