A situation caused by two or more processes being unable to proceed (and thus release their locks) because they are blocked by locks on resources held by the other process.

learn more… | top users | synonyms

-1
votes
0answers
25 views

Deadlock for huge task when accessed simultaneously [closed]

I have a procedure, which process multiple documents and finance postings. So when i execute it will take 1 mins to complete.All the queries in procedure have proper index and well tuned.My problem is ...
-1
votes
0answers
34 views

Query Deadlock on Select Query [closed]

I have 2 queries deadlocking on each other. The first query is Select Top 1 NULL From [Table1] with (HOLDLOCK, TABLOCKX) Second Query is an insert query that only reads from [Table2] to put data ...
-1
votes
0answers
131 views

Postgres database locked up [closed]

I was running a process to update a bunch of rows in postgres database and it locked up. Now I can't select anything out of it. None of my processes are "idle in transaction" when I execute ps ...
-2
votes
2answers
4k views

SQL Server - How many type of timeout can happen, and how?

When working with SQL Server, there can be multiple application host accessing it, and each application can have one or many connection. Each connection can potentially have multiple transaction ...