Hello everyone so i have been trying to delete transaction which is locking some of my tables, tried to restart the database but nothing changed (we are using 8.0.35 version MySQL) tried dropping modifying the table but nothing, everything is still the same this transaction is stuck its in running state but nothing is commiting or anything tried the XA command but XA cant identify the trx_id says that this ID doesnt exsists. Here is the Engine Status :