Transaction Monitoring
The automatic rollback transaction can be monitored and its statement problems can be located by setting the transaction timeout warning. In addition, the statements with long execution time can also be monitored.
transaction_sync_naptime
Parameter description: For data consistency, when the local transaction's status differs from that in the snapshot of GTM, other transactions will be blocked. You need to wait for a few minutes until the transaction status of the local host is consistent with that of the GTM. The gs_clean tool is automatically triggered for cleansing when the waiting period on the CN exceeds that of transaction_sync_naptime. The tool will shorten the blocking time after it completes the cleansing.
Parameter type: integer.
Unit: second
Value range: 0 to 2147483

If the value of this parameter is set to 0, gs_clean will not be automatically called for the cleansing before the blocking arrives the duration. Instead, the gs_clean tool is called by gs_clean_timeout. The default value is 5 minutes.
Default value: 30
Setting method: This is a USERSET parameter. Set it based on instructions provided in Table 1.
Setting suggestion: Retain the default value.
Risks and impacts of improper settings: If the value is too large, the time for the CN to trigger clearing is prolonged, and the blocking time in the case of inconsistency is longer.
transaction_sync_timeout
Parameter description: For data consistency, when the local transaction's status differs from that in the snapshot of GTM, other transactions will be blocked. You need to wait for a few minutes until the transaction status of the local host is consistent with that of the GTM. An exception is reported when the waiting duration on the CN exceeds the value of transaction_sync_timeout. Roll back the transaction to avoid system blocking due to long time of thread response failures (for example, sync lock).
Parameter type: integer.
Unit: second
Value range: 0 to 2147483

- If the value is 0, no error is reported when the blocking times out or the transaction is rolled back.
- If the value is not 0, the value of this parameter must be greater than that of gs_clean_timeout. Otherwise, unnecessary transaction rollback will probably occur due to a block timeout caused by residual transactions that have not been deleted by gs_clean on the DN.
Default value: 600 (10 minutes)
Setting method: This is a USERSET parameter. Set it based on instructions provided in Table 1.
Setting suggestion: Retain the default value.
Risks and impacts of improper settings: Change the parameter value after fully understanding the parameter meaning and verifying it through testing.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot