Questions tagged [locked-objects]
The locked-objects tag has no usage guidance.
12
questions
0
votes
2answers
43 views
How to connect to specific session id & serial# ? Blocked sessions
I have blocked sessions and see which session is blocking them, having session_id and serial#. Is it possible to connect to such session? How?
Background: using V$SESSION_BLOCKERS I see sessions are ...
0
votes
0answers
15 views
How to check locked tables at specific time
I got error on my cron "(1205, 'Lock wait timeout exceeded; try restarting transaction')"
I want to check during that time (midnight), what query/process that locked my table.
I have general_log ...
0
votes
1answer
151 views
Do table locks get released after a query finishes when WAITFOR is used after that query within the same batch and transaction?
If I have a query that reads from a table, if that query is proceeded with the WAITFOR keyword (within the same batch and transaction) will the table lock of the preceding query be held until the ...
7
votes
2answers
200 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
212 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
106 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
134 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
183 views
INNODB real-time locks?
How can I view real-time locks in innodb when information_schema.innodb_locks is not available?
8
votes
3answers
3k 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
17k 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 ...
11
votes
2answers
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 ...