The lock tag has no wiki summary.
6
votes
1answer
181 views
Deadlock graph with a lock on an index on a seemingly unrelated table
I have a deadlock graph from a deadlock where one process is doing a SELECT and one is doing an UPDATE. This seems like the classic case where the SELECT gets a NCI lock to perform a join and then a ...
2
votes
1answer
111 views
Database locked
I canceled a query which took too long time. After that, the SQL-Server database was locked. After I restarted SQL Server, the mode of my database was "in recovery". Now I can't access my database ...
2
votes
1answer
245 views
Sql server update query locking stages?
Looking at
update MyTable
set Status = 1
where Status = 0
of course- the where is calculated before the actual update.
but does this filtering (where Status = 0) is also inside the lock ?
I mean ...
1
vote
2answers
495 views
jdbc+mysql: “Deadlock found when trying to get lock; try restarting transaction”
After recovering from a disk-full problem, I started getting these errors in my logs:
java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
at ...
1
vote
1answer
65 views
SQL Server 2008 - get current LOCK_ESCALATION on particular table
Is there a way to find the current setting for LOCK_ESCALATION on particular table? Can it be found through system views?
0
votes
1answer
51 views
How do I stop a query from running if the row is locked?
I have a section of code that locks the database, updates it and then confirms.
This is all working fine, if another user attempts to update the same row they cannot and their changes are discarded.
...
0
votes
0answers
14 views
MySQL shared server regular lockup
I have a web/ database server with 5 websites on it, all of which execute fairly complex queries regularly.
Some of these queries appear in the slow log and take around 0.6-0.8 seconds. However I ...
