Select... For Update Selecting Old Data After A Commit

Good day, This is an update to my old post at SQL Simultaneous transactions ignore each other's locks??? DEADLOCK [InnoDB, Python], as I realized later that the issue had nothing t

Solution 1:

After following Solarflare's advice on slicing apart the program bit by bit, I eventually found the problem leading to a remote part of the code, which was functioning without error, but completely differently after the move from T-SQL to SQL.

I thought at first that the issue with the SQL server, but it was just a nasty bug. I'm now getting horrible deadlocks for some reason, yet another pleasure to look into.

Thanks for the comment and the time you spent explaining what could be wrong, I'm sorry this turned out to be just a personal silly issue

Have a great day!