Questions tagged [locked-objects]
The locked-objects tag has no usage guidance.
10
questions
7
votes
2answers
188 views
Is a dropped (or altered) function still available inside already opened transactions?
I found
PostgreSQL - Are CREATE FUNCTION and DROP FUNCTION locking when used inside different transactions?
but there are no answers and isn't exactly the same as my question (though very similar).
...
1
vote
0answers
166 views
why an update doesn't update a row if the where clause exists?
I'm working with SQL Server 2012 SP2 and I have a problem with a stored procedure.
I have a table where we do a lot of things in a second: we insert and update rows very often.
I have a stored ...
2
votes
1answer
105 views
False positive error message in MS Access (concurrent users)
I have discovered a strange apparent bug in MS Access and would like to know if others know it already and hopefully how to get around it.
Trying to count records based on known column categories.
...
2
votes
0answers
132 views
os_buffer_descriptors blocking problem SQL Server 2008 R2
The following query :
select (buffer_descriptors.datacache) as 'Data Cache (MB)',
case
when buffer_descriptors.datacache > 4096 then (((buffer_descriptors.datacache)/4096)*300)
else '...
1
vote
1answer
157 views
INNODB real-time locks?
How can I view real-time locks in innodb when information_schema.innodb_locks is not available?
3
votes
1answer
1k views
Intent Exclusive (IX) Lock questions [closed]
I was experiencing a deadlock so I set up a trace flags as well as profile trace to capture a deadlock. During this exercise I found something interesting. In the profile trace I noticed that "sa" ...
6
votes
2answers
2k views
SQL Server - RangeX-X and RangeI-N locks
I came to a dead point in a deadlock analyze. According to msdn:
RangeX-X are Exclusive range, exclusive resource lock; used when updating a key in a range.
RangeI-N are Insert range, null resource ...
12
votes
3answers
16k 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 ...
10
votes
1answer
2k views
Unexplained InnoDB timeouts
I've been seeing some very basic updates timing out lately and have not been able to determine the cause. An example:
//# Query_time: 51 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
UPDATE photos ...
6
votes
1answer
12k views
How can I remove locks on an object?
One of my queries is running in to a Row Lock Contention. I've tracked down which table is causing that - so now what's the next step ? Which session is causing this table to get locked ? How do I ...
