bytebase/bytebase · error

failed to commit execute transaction

Error message

failed to commit execute transaction

What it means

When Execute runs statements inside an explicit transaction, tx.Commit() must succeed to persist the work. If the driver returns an error on commit (connection dropped, deadlock/timeout, server shutdown), the error is wrapped as 'failed to commit execute transaction' and surfaced to the caller; nothing from the transaction is persisted.

Source

Thrown at backend/plugin/db/mysql/mysql.go:450

				return err
			}

			allRowsAffected := sqlResult.(mysql.Result).AllRowsAffected()
			var rowsAffected int64
			var allRowsAffectedInt64 []int64
			for _, a := range allRowsAffected {
				rowsAffected += a
				allRowsAffectedInt64 = append(allRowsAffectedInt64, a)
			}
			totalRowsAffected += rowsAffected

			opts.LogCommandResponse(rowsAffected, allRowsAffectedInt64, "")
		}

		if err := tx.Commit(); err != nil {
			opts.LogTransactionControl(storepb.TaskRunLog_TransactionControl_COMMIT, err.Error())
			return errors.Wrapf(err, "failed to commit execute transaction")
		} else {
			opts.LogTransactionControl(storepb.TaskRunLog_TransactionControl_COMMIT, "")
			committed = true
		}
		return nil
	}); err != nil {
		return 0, err
	}

	return totalRowsAffected, nil
}

// executeInAutoCommitMode executes statements sequentially in auto-commit mode
func (d *Driver) executeInAutoCommitMode(ctx context.Context, conn *sql.Conn, commands []base.Statement, opts db.ExecuteOptions, connectionID string) (int64, error) {
	var totalRowsAffected int64

	if err := conn.Raw(func(driverConn any) error {
		//nolint

View on GitHub (pinned to 1870550677)

Solutions

1. Re-run the task; if the transaction failed nothing was committed, so a retry is safe
2. Check server logs for the underlying commit error (deadlock, lock wait timeout, connection killed)
3. Increase lock_wait_timeout / innodb_lock_wait_timeout or reduce contention
4. Check network stability and idle timeouts (wait_timeout) between client and MySQL

Example fix

// before
if err := tx.Commit(); err != nil {
  return errors.Wrapf(err, "failed to commit execute transaction")
}
// after
if err := tx.Commit(); err != nil {
  if mysqlErr, ok := errors.Unwrap(err).(*mysqldriver.MySQLError); ok && isRetryable(mysqlErr) {
    return retryable(err) // let the task runner retry the whole transaction
  }
  return errors.Wrapf(err, "failed to commit execute transaction")
}

err := executeTransaction(ctx, stmts)
if err != nil && strings.Contains(err.Error(), "failed to commit execute transaction") {
  // transaction rolled back on commit failure; safe to retry whole unit
  return retryWithBackoff(executeTransaction, ctx, stmts)
}

When it happens

Trigger: tx.Commit() fails during Execute's transactional path — typically because the MySQL connection was lost mid-transaction, the server killed the transaction (lock wait timeout, deadlock), or the session was terminated.

Common situations: Long-running migrations exceeding wait_timeout; network blips between app and database; lock contention with other writers causing implicit rollback before commit; admin killing the connection.

Related errors

• failed to commit batch
• invalid isolation level for MySQL: %s. Supported levels: REA
• failed to commit transaction
• failed to commit transaction
• failed to commit execute transaction

AI-assisted analysis of bytebase/bytebase@1870550677 (2026-09-06). Data as JSON: /api/errors/f65af523d43ec932. Report an issue: GitHub.