How to find the transaction reference?

[patrykcieszkowski]

We have noticed some of our transactions are stuck and never commited or rolledback. Is it possible to reference the transaction somehow, and roll it back manually?