Help Center/ GaussDB/ Developer Guide(Centralized_3.x)/ Stored Procedure/ Retry Management
Updated on 2024-05-07 GMT+08:00
View PDF
Share

Retry Management

Retry is a process in which the database executes a SQL statement or stored procedure (including anonymous block) again in the case of execution failure, improving the execution success rate and user experience. The database checks the error code and retry configuration to determine whether to retry.

  • If the execution fails, the system rolls back the executed statements and executes the stored procedure again.

    Example:

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
    		 
    CREATE TABLE t1(a int);
CREATE TABLE

gaussdb=# CREATE OR REPLACE PROCEDURE retry_basic ( IN  x INT) 
AS  
BEGIN
   INSERT INTO t1 (a) VALUES (x);
   INSERT INTO t1 (a) VALUES (x+1);
END;
/
CREATE PROCEDURE

gaussdb=# CALL retry_basic(1); 
 retry_basic 
-------------

(1 row)
Parent topic: Stored Procedure