SET AUTORETRY

SET AUTORETRY

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

SET AUTORETRY

Specifies if implicit transactions are to be retried automatically if a deadlock or a time-out occurs.

Syntax

SET AUTORETRY ON|OFF

Comments

The AUTORETRY option is set OFF by default.

When AUTORETRY is ON, implicit transactions that fail because of deadlock or time-outs will be retried until they finally succeed or an internal maximum number of retries is reached (which can be set by the database configuration option “transaction retries”).

If these implicit transactions fail, then an error message is printed.

WARNING!

When running ZIM commands from the command prompt, there is no way to auto retry transactions even if this option is set to ON. Therefore, in this case, all deadlock conditions are IGNORED!

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish