| Subject | Insert SQL Deadlock Issue |
|---|---|
| Author | Vishal Tiwari |
| Post date | 2017-01-04T12:07:13Z |
Hi All,
At production department, we are receiving below errors, not for all times, but frequently. We tried looking into code and found that there is a very simple insert statement which might cause that issue. Because functionality executes that Insert statement.
Wondering how to resolve that issue, because as a developer we are not able to reproduce these error at least once.
We are using Delphi 6 and Firbird version is 2.5.2. I found that Transaction component in Delphi is not used while executing the SQL.
Error 1:
There was an error processing this cancellation on main
server.
lock conflict on no wait transaction
deadlock
update conflicts with concurrent update
requires both input and output filenames
Error 2:
There was an error RaiseFees.
Unable to complete network request to host
"<Our Server Name>".
Error writing data to the connection.
unknown Win32 error 10054
Error 3:
validation error for column VAT, value "*** null
***"
-sql_dialect set database dialect n
Please help in this regards, as it seems deadlock issue.
Trying hard to get the solution.
With Best Regards.
Vishal