Q&A BY TAG 'deadlock'

You must sign in to ask a question. If you do not have an account, you can register here

ERROR: Deadlock Detected - Does Denodo have any workarounds for error?
answered 14-08-2019 03:26:02 -0400

Hello, When we run views based on Greenplum/Postgresql we receive the ERROR: Deadlock Detected. In some cases we can resolve this issue by rearranging the logic/ordering of our views; however in many cases such an option is not feasible because the log...

Answers: 3

greenplum deadlock

VQL equivalent for T-SQL "WITH (NOLOCK)"
answered 13-06-2019 21:26:31 -0400

Our DBA claims that the Denodo view is causing DEADLOCKs on the SQL Server. They recommended us to pass the query to SQL Server with the "WITH (NOLOCK)" option. Is this possible with Denodo views? If yes, please provide specific example. Btw, the SQL...

Answers: 1

nolock sql server deadlock deadlock read uncommitted sql server