Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [locked-objects]

13 questions
12
votes
3 answers

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 Forms front end screen Developer 2 starts another…
Sathyajith Bhat
  • 1,534
  • 3
  • 19
  • 36
11
votes
2 answers

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 SET position = position + 1 WHERE (photo_album_id =…
mvbl fst
  • 211
  • 1
  • 6
10
votes
2 answers

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 lock; used to test ranges before inserting a new…
yrushka
  • 1,994
  • 1
  • 16
  • 22
8
votes
2 answers

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). Let's say I do the following: Create a function…
Wildcard
  • 587
  • 8
  • 18
6
votes
1 answer

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 remove the lock ? I'm using Oracle 10g
Sathyajith Bhat
  • 1,534
  • 3
  • 19
  • 36
6
votes
3 answers

How to write script to kill MS Office database locks in MSSQL

I've recently inherited a MSSQL database as our DBA has moved on to greener pastures. I'm not a DBA and have limited to moderate SQL knowledge but have had to absorb some of his duties and have an issue I am having some trouble navigating around. We…
user2631683
  • 61
  • 1
2
votes
1 answer

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. One particular set of records can't be saved or…
Michael
  • 21
  • 1
2
votes
0 answers

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 '300' end as 'Min Page Life Expectancy',…
user4659
1
vote
1 answer

INNODB real-time locks?

How can I view real-time locks in innodb when information_schema.innodb_locks is not available?
user20459
1
vote
0 answers

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 procedure to update a row, and it works fine most of the…
VansFannel
  • 1,873
  • 5
  • 23
  • 36
0
votes
1 answer

How to migrate a database from 2016 to 2014 if there are encrypted/locked objects(SPs) associated with it?

I am trying to migrate a database from 2016 to 2014 through Task-->Generate Scripts. There are some stored procedures that are locked and seems like they are encrypted as well. They are causing error while generating the script. I have tried both…
user2664231
  • 1
0
votes
2 answers

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 blocked by each other by INSERT statements to one…
Jakub P
  • 167
  • 1
  • 2
  • 10
0
votes
1 answer

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 WAITFOR completes and the transaction finishes? (I…
J.D.
  • 40,776
  • 12
  • 62
  • 141