vitessio / vitess

Vitess is a database clustering system for horizontal scaling of MySQL.
http://vitess.io
Apache License 2.0
18.69k stars 2.1k forks source link

Feature Request: Distributed Transaction Actions on VTAdmin #16766

Closed harshit-gangal closed 1 week ago

harshit-gangal commented 2 months ago

Feature Description

VTAdmin should be able to display the list of open distributed transactions that are older than a certain time. The user should be able to perform the Conclude action on the list of Distributed Transactions displayed on the

Use Case(s)

This gives user the access to conclude open distributed transactions that are not getting resolved by the distributed transaction resolver logic.

harshit-gangal commented 2 months ago

Part of #16245

harshit-gangal commented 2 months ago

There are 2 vtctld grpc API to achieve it which are in https://github.com/vitessio/vitess/blob/main/go/vt/vtctl/grpcvtctldclient/client_gen.go GetUnresolvedTransactions: Listing of Distributed Transactions ConcludeTransaction: Conclude specific transaction

GuptaManan100 commented 1 week ago

All the work was done in these 3 PRs -