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


Updated at:May 15, 2019 GMT+08:00


ROLLBACK PREPARED cancels a transaction ready for two-phase committing.


  • 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 user that initiates a transaction or the system administrator can roll back the transaction.
  • The transaction function is maintained automatically by the database, and should be not visible to users.


ROLLBACK PREPARED transaction_id ;

Parameter Description


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

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