Help Center > > Developer Guide> SQL Reference> SQL Syntax> COMMIT PREPARED

COMMIT PREPARED

Updated at: Mar 13, 2020 GMT+08:00

Function

COMMIT PREPARED commits a prepared two-phase transaction.

Precautions

  • The function is only available in maintenance mode (when GUC parameter xc_maintenance_mode is on). Exercise caution when enabling the mode. It is used by maintenance engineers for troubleshooting. Common users should not use the mode.
  • Only the transaction creators or system administrators can run the COMMIT command. The creation and commit operations must be in different sessions.
  • The transaction function is maintained automatically by the database, and should be not visible to users.

Syntax

1
2
COMMIT PREPARED transaction_id ;
COMMIT PREPARED transaction_id WITH CSN;

Parameter Description

  • transaction_id

    Specifies the identifier of the transaction to be submitted. The identifier must be different from those for current prepared transactions.

  • CSN(commit sequence number)

    Specifies the sequence number of the transaction to be committed. It is a 64-bit, incremental, unsigned number.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel