When the Microsoft SQL Server database is not correctly figured, you may encounter this error:
[FreeTDS][SQL Server]Transaction (Process ID xxx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Database is not correctly configured for Awingu.
It's highly recommended to adjust these database properties when using a Microsoft SQL database for the Awingu nodes:
Do so by running these SQL queries on your MS SQL Server (replace 'awingudb' with your own database name).
Important: this will kill active connections. However, the settings will be applied immediately so the impact should be minimal.
ALTER DATABASE awingudb SET allow_snapshot_isolation ON;
ALTER DATABASE awingudb SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE awingudb SET read_committed_snapshot ON;
ALTER DATABASE awingudb SET MULTI_USER;
Was this article helpful?
Tell us how we can improve it.