I couldn't even read one row. The session that locked it was gone. So I built a ghost hunter for Oracle

This is a submission for the Hacktoberfest Open-Source AI Challenge Week 4: Ghost in the Machine select amt from gh_ledger where id = 1; ORA-01591: lock held by in-doubt distributed transaction 5.30.71483 Not an update. A plain select. Oracle wouldn't even let me look at the row. Two minutes earlier, a transfer of 40 between two of my lab... Weiterlesen: I couldn't even read one row. The session that locked it was gone. So…