Spent a day battling #Azure SQL Server transaction deadlocks occurring in sharded and parallel #RobotFramework testing using #Pabot.
Was fun still I expect it's because:
- #pyodbc isn't very efficient deleting rows from multiple tables in one transaction.
- ODBC driver isn't really the latest and greatest so maybe updating it might have some positive effect.
#azure #robotframework #pabot #pyodbc