Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

OSRMDistanceDbOperator dá deadlock no SQL Server #81

Closed
augusto-herrmann opened this issue Jun 28, 2022 · 0 comments · Fixed by #82
Closed

OSRMDistanceDbOperator dá deadlock no SQL Server #81

augusto-herrmann opened this issue Jun 28, 2022 · 0 comments · Fixed by #82
Assignees
@augusto-herrmann
Labels
bug Something isn't working

Comments

@augusto-herrmann
Copy link
Member

Ao usar o OSRMDistanceDbOperator com o banco de dados Microsoft SQL Server, a primeira query UPDATE fica travada esperando algo em deadlock, por causa da query SELECT que vem antes.

Segundo o @lucasbenevides, se usarmos WITH (NOLOCK) na query SELECT podemos evitar o problema.
@augusto-herrmann augusto-herrmann self-assigned this Jun 28, 2022
@augusto-herrmann augusto-herrmann added the bug Something isn't working label Jun 28, 2022
augusto-herrmann added a commit that referenced this issue Jun 28, 2022
@augusto-herrmann
Adds nolock condition for SQL server
200d40b 
to avoid deadlock and fix #81
@augusto-herrmann augusto-herrmann mentioned this issue Jun 28, 2022
Merged
augusto-herrmann added a commit that referenced this issue Jun 28, 2022
@augusto-herrmann
Adds nolock condition for SQL server
7bb0a53 
to avoid deadlock and fix #81
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@augusto-herrmann augusto-herrmann

Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Adds nolock condition for SQL server gestaogovbr/FastETL
1 participant
@augusto-herrmann