The row-lock tag has no wiki summary.
0
votes
1answer
50 views
Invalid rowid error
I'm trying to see, how UPDATE Lock helps to minimize error while dml (delete/update) operations.
declare
cursor update_lock is select empno from emp where deptno=&no for update of sal;
num ...
2
votes
1answer
732 views
Parallel inserts cause deadlock on DB2
The scenario is the following: The application attempts to insert into the same table from two parallel threads making 4000 insertions in each thread (separate transaction per thread). It causes the ...
2
votes
1answer
111 views
Optimising a query using hint locks
I have a stored procedure that is being called very frequently.
For some database servers it is as often as 20 times per second.
Unfortunately because different clients call this procedure, I can't ...
5
votes
2answers
8k views
How to troubleshoot enq: TX - row lock contention?
I have the following situation.
I have RAC. On both nodes there are the locks.
On the First Node
SID EVENT USERNAME BLOCKING_SESSION ROW_WAIT_OBJ# OBJECT_NAME ...
3
votes
2answers
3k views
InnoDB row locking - how to implement
I've been looking around now, reading the mysql site and I still can't see exactly how it works.
I want to select and row lock the result for writing, write the change and release the lock. ...
1
vote
2answers
380 views
How to lock a Row while I'm using it
I want to be able to Lock a row, select it, increment its value, and then release the lock. (without lockin the other rows, so that other connections can work with the rest of the table)
I've found ...
1
vote
2answers
1k views
Deadlock on Insert/Update
Using SQL Server 2008 R2:
I'm currently attempting to track down the cause of a deadlock issue we have. Not sure where to turn. Here's the setup.
TABLE Scores:
id INT IDENTITY(1,1),
first_name ...
1
vote
2answers
1k views
MS SQL Server - update row value to next row with row id
I have a table like below:
Newid1 a b c
1 null 40 50
2 null 45 55
3 null 46 56
4 null 47 57
5 null 48 58
Now I want to update value ...
6
votes
3answers
849 views
Postgres, MVCC, and Locking
I have a series of SQL statements that look like the following:
BEGIN;
SELECT counter FROM table WHERE id=X FOR UPDATE;
REALLY COMPLEX QUERY;
UPDATE table SET counter=Y WHERE id=X;
END;
I'd like to ...
7
votes
3answers
5k views
Tracing, debugging and fixing Row Lock Contentions
Off late, I've been facing a lot of row lock contentions. The table in contention seems to be a particular table.
This is generally what happens -
Developer 1 starts a transaction from Oracle ...
