IDENTIFYING SOFTWARE REGRESSIONS BASED ON QUERY RETRY ATTEMPTS IN A DATABASE ENVIRONMENT

    公开(公告)号:US20240086397A1

    公开(公告)日:2024-03-14

    申请号:US18511204

    申请日:2023-11-16

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/2365 G06F16/2455

    Abstract: Systems, methods, and devices for retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of an execution platform, the one or more execution nodes configured to execute the query on a first version of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query to the one or more execution nodes of the execution platform and determining whether a regression or an intermittent fault caused the execution of the query to be unsuccessful based at least in part on whether the first retry execution of the query was successful or unsuccessful.

    Automated query retry execution in a database system

    公开(公告)号:US11640347B2

    公开(公告)日:2023-05-02

    申请号:US17809780

    申请日:2022-06-29

    Applicant: Snowflake Inc.

    Abstract: Techniques for automated query retry in a database platform include decoding, by at least one hardware processor, a query directed to database data from a client account of a database platform. The method further includes decoding, by the at least one hardware processor, an indication that execution of the query on at least one computing node of the database platform results in a failed execution. The method further includes configuring a processing loop with continuous retry executions of the query on the at least one computing node based on the indication. The method further includes exiting the processing loop based on detecting a retry execution of the continuous retry executions results in at least one successful execution of the query. The method includes logging each attempt to execute the query during the continuous retry executions in a query status log until the at least one successful execution of the query.

    Automated query retry execution using multiple computing nodes in a database system

    公开(公告)号:US12164405B2

    公开(公告)日:2024-12-10

    申请号:US18160720

    申请日:2023-01-27

    Applicant: Snowflake Inc.

    Abstract: Techniques for automated query retry in a database platform include decoding, by at least one hardware processor, a query directed to database data. The query is received by a first management node from a client account of a database system. The method further includes configuring an execution of the query by a first computing node associated with the first management node. The method includes detecting the execution of the query results in a failed execution. The query is transferred from the first management node to a second management node based on the failed execution. The second management node is configured to process tasks that are internal to the database system. A retry execution of the query by a second computing node is configured. The second computing node is associated with the second management node. A cause of the failed execution is determined based on a result of the retry execution.

    IDENTIFYING SOFTWARE REGRESSIONS BASED ON QUERY RETRY ATTEMPTS IN A DATABASE ENVIRONMENT

    公开(公告)号:US20230012433A1

    公开(公告)日:2023-01-12

    申请号:US17933082

    申请日:2022-09-17

    Applicant: Snowflake Inc.

    Abstract: Systems, methods, and devices for retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of an execution platform, the one or more execution nodes configured to execute the query on a first version of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query to the one or more execution nodes of the execution platform and determining whether a regression or an intermittent fault caused the execution of the query to be unsuccessful based at least in part on whether the first retry execution of the query was successful or unsuccessful.

    Decoupling internal and external tasks in a database environment

    公开(公告)号:US11409626B2

    公开(公告)日:2022-08-09

    申请号:US16555996

    申请日:2019-08-29

    Applicant: Snowflake Inc.

    Abstract: 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.

    DECOUPLING INTERNAL AND EXTERNAL TASKS IN A DATABASE ENVIRONMENT

    公开(公告)号:US20210064502A1

    公开(公告)日:2021-03-04

    申请号:US16555996

    申请日:2019-08-29

    Applicant: Snowflake Inc.

    Abstract: 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.

Patent Agency Ranking