> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# ROLLBACK
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
The `ROLLBACK` statement aborts the current transaction and all of its nested transactions, discarding all transactional updates made by statements included in the transaction.
There are two ways to use `ROLLBACK`:
* The `ROLLBACK` statement [rolls back the entire transaction](#rollback-a-transaction).
* The `ROLLBACK TO SAVEPOINT` statement [rolls back and restarts the nested transaction](#rollback-a-nested-transaction) started at the corresponding `SAVEPOINT` statement, for working with standard savepoints. This is in addition to the existing support for working with client-side transaction retries. For examples of each usage, see:
* [Rollback a nested transaction](#rollback-a-nested-transaction)
* [Retry a transaction](#retry-a-transaction)
Rollbacks to savepoints over [DDL](https://en.wikipedia.org/wiki/Data_definition_language) statements are only supported if you're rolling back to a savepoint created at the beginning of the transaction.
## Synopsis
## Required privileges
No privileges are required to rollback a transaction. However, privileges are required for each statement within a transaction.
## Parameters
| Parameter | Description |
| --------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `TO SAVEPOINT cockroach\_restart` | If using advanced client-side transaction retries, retry the transaction. You should execute this statement when a transaction returns a `40001` / `retry transaction` error. |
| `TO SAVEPOINT ` | If using nested transactions, roll back and restart the nested transaction started at the corresponding `SAVEPOINT` statement. |
## Savepoints and row locks
CockroachDB supports exclusive row locks.
* In PostgreSQL, row locks are released/cancelled upon `ROLLBACK TO SAVEPOINT`.
* In CockroachDB, row locks are preserved upon `ROLLBACK TO SAVEPOINT`.
This is an architectural difference that may or may not be lifted in a later CockroachDB version.
The code of client applications that rely on row locks must be reviewed and possibly modified to account for this difference. In particular, if an application is relying on `ROLLBACK TO SAVEPOINT` to release row locks and allow a concurrent transaction touching the same rows to proceed, this behavior will not work with CockroachDB.
## Savepoints and high priority transactions
`ROLLBACK TO SAVEPOINT` (for either regular savepoints or "restart savepoints" defined with `cockroach_restart`) causes a "feature not supported" error after a DDL statement in a `HIGH PRIORITY` transaction, in order to avoid a transaction deadlock.
## Examples
### Rollback a transaction
Typically, an application conditionally executes rollbacks, but we can see their behavior by using `ROLLBACK` instead of `COMMIT` directly through SQL:
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM accounts;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
+----------+---------+
| name | balance |
+----------+---------+
| Marciela | 1000 |
+----------+---------+
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> BEGIN;
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> UPDATE accounts SET balance = 2500 WHERE name = 'Marciela';
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> ROLLBACK;
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM accounts;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
+----------+---------+
| name | balance |
+----------+---------+
| Marciela | 1000 |
+----------+---------+
```
### Rollback a nested transaction
The `ROLLBACK TO SAVEPOINT` statement rolls back and restarts the nested transaction started at the corresponding `SAVEPOINT` statement.
For examples showing how to use `ROLLBACK TO SAVEPOINT` to rollback a nested transaction, see the `SAVEPOINT` documentation on nested savepoints.
### Retry a transaction
When using advanced client-side transaction retries, use `ROLLBACK TO SAVEPOINT` to handle a transaction that needs to be retried (identified via the `40001` error code or `restart transaction` string in the error message), and then re-execute the statements you want the transaction to contain.
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> ROLLBACK TO SAVEPOINT cockroach_restart;
```
For examples of retrying transactions in an application, check out the transaction code samples in our Build an App with CockroachDB tutorials.
## See also
* `SAVEPOINT`
* Transactions
* `BEGIN`
* `COMMIT`
* `RELEASE SAVEPOINT`
* `SHOW SAVEPOINT STATUS`