Decoupling internal and external tasks in a database environment
Systems, methods, and devices for retrying a query. A method includes receiving, by a first database query manager, a query directed to database data from a client account. The method includes assigning an original execution of the query to one or more execution nodes of an execution platform. The method includes determining the original execution of the query was unsuccessful. The method includes transferring the query to a second database query manager configured to manage internal tasks for improving operation of a database platform that are not received from client accounts. The method includes assigning, by the second database query manager, a retry execution of the query to one or more execution nodes of an execution platform.
1. A method comprising:
receiving, by a first database query manager of a database platform, a query directed to database data, the first database query manager using a first version of database platform software;
assigning, by the first database query manager of the database platform, execution of the query to one or more execution nodes of an execution platform;
determining that the execution of the query results in a failed execution, and that the first version of the database platform software is a recent version of the database platform software;
based on determining that the failed execution of the query was conducted on the recent version of the database platform software:
assigning, by the first database query manager, a first retry execution of the query on the first version of the database platform software;
identifying a second database query manager of the database platform using a second version of the database platform software that was released prior to the first version of the database platform software;
reassigning the query to the second database query manager of the database platform to be retried; and
assigning, by the second database query manager, a second retry execution of the query to one or more execution nodes of the execution platform; and
in response to determining, at least in part on results of the first retry and the second retry of the execution of the query, that a potential regression exists in the first version of the database platform software, generating a report indicating the potential regression.
2. The method of claim 1 , wherein the reassigning of the query to the second database query manager is also based on determining that the execution of the query was unsuccessful due to an internal error of the database platform.
3. The method of claim 2 , further comprising generating an error message for an account that requested the query, the error message indicating that the failed execution is due to an internal error of the database platform.
4. The method of claim 1 , wherein the database platform comprises multiple database query managers collectively running two or more versions of the database platform software at one time.
5. The method of claim 1 , wherein the execution of the query and the second retry of the execution of the query are assigned to a same set of one or more execution nodes.
6. The method of claim 1 , wherein the execution of the query and the second retry of the execution of the query are assigned to different sets of one or more execution nodes.
7. A database platform comprising:
one or more computer processors; and
one or more computer-readable mediums storing instructions that, when executed by the one or more computer processors, cause the database platform to perform operations comprising:
receiving, by a first database query manager of the database platform, a query directed to database data, the first database query manager using a first version of database platform software;
assigning, by the first database query manager of the database platform, execution of the query to one or more execution nodes of an execution platform;
determining that the execution of the query results in a failed execution, and that the first version of the database platform software is a recent version of the database platform software;
based on determining that the failed execution of the query was conducted on the recent version of the database platform software:
assigning, by the first database query manager, a first retry execution of the query on the first version of the database platform software;
identifying a second database query manager of the database platform using a second version of the database platform software that was released prior to the first version of the database platform software;
reassigning the query to the second database query manager of the database platform to be retried; and
assigning, by the second database query manager, a second retry execution of the query to one or more execution nodes of the execution platform; and
in response to determining, at least in part on results of the first retry and the second retry of the execution of the query, that a potential regression exists in the first version of the database platform software, generating a report indicating the potential regression.
8. The database platform of claim 7 , wherein the reassigning of the query to the second database query manager is also based on determining that the execution of the query was unsuccessful due to an internal error of the database platform.
9. The database platform of claim 8 , the operations further comprising:
generating an error message for an account that requested the query, the error message indicating that the failed execution is due to an internal error of the database platform.
10. The database platform of claim 7 , wherein the database platform comprises multiple database query managers collectively running two or more versions of the database platform software at one time.
11. The database platform of claim 7 , wherein the execution of the query and the second retry of the execution of the query are assigned to a same set of one or more execution nodes.
12. The database platform of claim 7 , wherein the execution of the query and the second retry of the execution of the query are assigned to different sets of one or more execution nodes.
13. A non-transitory computer-readable medium storing instructions that, when executed by one or more computer processors of a database platform, cause the database platform to perform operations comprising:
receiving, by a first database query manager of the database platform, a query directed to database data, the first database query manager using a first version of database platform software;
assigning, by the first database query manager of the database platform, execution of the query to one or more execution nodes of an execution platform;
determining that the execution of the query results in a failed execution, and that the first version of the database platform software is a recent version of the database platform software;
based on determining that the failed execution of the query was conducted on the recent version of the database platform software:
assigning, by the first database query manager, a first retry execution of the query on the first version of the database platform software;
identifying a second database query manager of the database platform using a second version of the database platform software that was released prior to the first version of the database platform software;
reassigning the query to the second database query manager of the database platform to be retried; and
assigning, by the second database query manager, a second retry execution of the query to one or more execution nodes of the execution platform; and
in response to determining, at least in part on results of the first retry and the second retry of the execution of the query, that a potential regression exists in the first version of the database platform software, generating a report indicating the potential regression.
14. The non-transitory computer-readable medium of claim 13 , wherein the reassigning of the query to the second database query manager is also based on determining that the execution of the query was unsuccessful due to an internal error of the database platform.
15. The non-transitory computer-readable medium of claim 14 , the operations further comprising:
generating an error message for an account that requested the query, the error message indicating that the failed execution is due to an internal error of the database platform.
16. The non-transitory computer-readable medium of claim 13 , wherein the database platform comprises multiple database query managers collectively running two or more versions of the database platform software at one time.
17. The non-transitory computer-readable medium of claim 13 , wherein the execution of the query and the second retry of the execution of the query are assigned to a same set of one or more execution nodes.
18. The non-transitory computer-readable medium of claim 13 , wherein the execution of the query and the second retry of the execution of the query are assigned to different sets of one or more execution nodes.