Automated query retry in a database system

A system comprising:

• at least one hardware processor of a database platform;
• and
• at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
• assigning a first execution of a query directed to database data to a first execution node of a plurality of execution nodes of an execution platform, the first execution node using a first set of configurations during the first execution;
• determining that the first execution of the query by the first execution node results in a failed execution;
• selecting a second set of configurations based on a configuration version of the first set of configurations;
• transferring the query to a second execution node of the plurality of execution nodes based on the first execution resulting in the failed execution;
• causing a second execution of the query at the second execution node, the second execution node using the second set of configurations during the second execution;
• and
• determining a cause of the failed execution at the first execution node based on a result of the second execution of the query at the second execution node.

A computer-storage medium comprising instructions that, when executed by one or more processors of a machine in a database platform, configure the machine to perform operations comprising:

• assigning a first execution of a query directed to database data to a first execution node of a plurality of execution nodes of an execution platform, the first execution node using a first set of configurations during the first execution;
• determining that the first execution of the query by the first execution node results in a failed execution;
• selecting a second set of configurations based on a configuration version of the first set of configurations;
• transferring the query to a second execution node of the plurality of execution nodes based on the first execution resulting in the failed execution;
• causing a second execution of the query at the second execution node, the second execution node using the second set of configurations during the second execution;
• and
• determining a cause of the failed execution at the first execution node based on a result of the second execution of the query at the second execution node.