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.

    Autoscaling and throttling in an elastic cloud service

    公开(公告)号:US11347550B1

    公开(公告)日:2022-05-31

    申请号:US17463376

    申请日:2021-08-31

    Applicant: Snowflake Inc.

    Abstract: Techniques described herein can optimize usage of computing resources in a data system. Dynamic throttling can be performed locally on a computing resource in the foreground and autoscaling can be performed in a centralized fashion in the background. Dynamic throttling can lower the load without overshooting while minimizing oscillation and reducing the throttle quickly. Autoscaling may involve scaling in or out the number of computing resources in a cluster as well as scaling up or down the type of computing resources to handle different types of situations.

    Autoscaling and throttling in an elastic cloud service

    公开(公告)号:US12217088B2

    公开(公告)日:2025-02-04

    申请号:US18497260

    申请日:2023-10-30

    Applicant: Snowflake Inc.

    Abstract: Techniques described herein can optimize usage of computing resources in a data system. Dynamic throttling can be performed locally on a computing resource in the foreground and autoscaling can be performed in a centralized fashion in the background. Dynamic throttling can lower the load without overshooting while minimizing oscillation and reducing the throttle quickly. Autoscaling may involve scaling in or out the number of computing resources in a cluster as well as scaling up or down the type of computing resources to handle different types of situations.

    Automated query retry in a database system

    公开(公告)号:US11599440B2

    公开(公告)日:2023-03-07

    申请号:US17663253

    申请日:2022-05-13

    Applicant: Snowflake Inc.

    Abstract: Techniques for automated query retry in a database platform include assigning by at least one hardware processor 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 uses a first set of configurations during the first execution. The techniques further include determining that the first execution of the query by the first execution node results in a failed execution. The query is transferred to a second execution node of the plurality of execution nodes. A second execution of the query at the second execution node is caused. The second execution node uses a second set of configurations during the second execution. A cause of the failed execution at the first execution node is determined based on a result of the second execution of the query at the second execution node.

Patent Agency Ranking