locks Questions
1
Solved
What I am trying to establish is whether there is any direct relation between Isolation Levels and Locks. So, let's say I started a transaction with a Serializable isolation level then will Oracle ...
Nicholle asked 10/10, 2022 at 6:34
5
Solved
According to wikipedia:
Shared locks are sometimes called "read locks" and exclusive locks are sometimes called "write locks".
Can you explain the reasoning behind the terms &...
Flavory asked 6/8, 2012 at 23:39
3
Basically I want to do this:
begin;
lock table a;
alter table a rename to b;
alter table a1 rename to a;
drop table b;
commit;
i.e. gain control and replace my old table while no one has access ...
Grinder asked 4/9, 2015 at 19:41
5
Solved
I'm new to concurrent programming.
I'd like to execute three tasks repeatedly. The first two should run all the time, the third should run every hour or so. The first two tasks can run in parallel...
Radiotherapy asked 12/11, 2011 at 10:24
2
I am reading through the OSTEP book by prof.Remzi
http://pages.cs.wisc.edu/~remzi/OSTEP/
I could only partially understand how the following code results in wakeup/waiting race condition.(The code...
Grouse asked 12/1, 2015 at 18:33
1
Solved
I am using python 3.6.7 with Ubuntu 18.04
After running the following script in which every process has its own shared lock :
from multiprocessing import Process, Manager
def foo(l1):
with l1:...
Illene asked 31/7, 2019 at 23:8
5
I need to lock two objects in a functionality and the current code looke like this;
Object obj1 = ...//get from somewhere
Object obj2 = ...//get from somewhere
synchronized(obj1){
...//blah
syn...
Alarum asked 1/3, 2011 at 6:33
3
Solved
When I try to drop a table, MySQL hangs. I don't have any other open sessions. How to resolve this? I have waited for 10 hours and the process has not terminated.
5
Solved
I have a LockManager that manages the locks of several threads. Sometimes the threads are bad boys, and I have to kill them and ask the LockManager to release all their locks. However, since I use ...
Karajan asked 10/5, 2013 at 21:50
5
In CopyOnWriteArrayList.java, in the method set(int index, E element)
below:
public E set(int index, E element) {
final ReentrantLock lock = this.lock;
lock.lock();
try {
Object[] elements = ge...
Trimerous asked 27/2, 2015 at 19:11
1
Solved
While debugging dump files, regularly I need to check for locks, for which I use the windbg extension command !locks. When everything goes well, this provides an output like the following:
CritSec...
Cartagena asked 19/12, 2018 at 9:48
2
Solved
I failed to find any definite answer on Google or even StackOverflow to answer this question.
From my understanding
Threads that use locks can break abstraction
Locks are not composable
But h...
Volution asked 11/11, 2017 at 6:13
1
Solved
I have the following statement in my PostgreSQL 10.5 database, which I execute in a repeatable read transaction:
delete from task
where task.task_id = (
select task.task_id
from task
order by ...
Gerfalcon asked 13/11, 2018 at 19:58
6
Solved
In my current scenario speed is essential I have a map that is only being read by multiple threads and this works fine. Now a requirement came up that may require writing to the static map once in ...
Injudicious asked 2/10, 2013 at 17:37
1
Solved
I believe that each SELECT statement in SQL Server will cause either a Shared or Key lock to be placed. But will it place that same type of lock when it is in a transaction? Will Shared or Key lock...
Burford asked 29/2, 2016 at 21:40
1
Solved
Can anyone explain intention shared and intention exclusive locks in mongodb by examples?
I read about their functionality but I can't figure out what are their actual usage in real db examples.
...
2
Solved
>>> import multiprocessing
>>> multiprocessing.Manager().Lock()
<thread.lock object at 0x7f64f7736290>
>>> type(multiprocessing.Lock())
<class 'multiprocessing.s...
Gallopade asked 19/11, 2015 at 9:42
1
Solved
I'm trying to understand the relationship between this concepts. Does the jpa locks is the way to provide/call transaction isolation level in DB from java? Or is it separated mechanisms, so what is...
Septal asked 28/7, 2015 at 11:20
2
I have a Mysql master-slave(s) replication with MyISAM tables. All updates are done on the master and selects are done on either the master or slaves.
It appears that we might need to manually loc...
Frustule asked 1/6, 2012 at 23:12
1
We want to have an alert when a lock is waiting longer than 60 seconds. The alert script below is performing as expected.
But we'd like to have more information like the locked Session ID, Lockin...
Packer asked 11/4, 2015 at 5:9
2
Solved
I'm aware that Python threads can only execute bytecode one at a time, so why would the threading library provide locks? I'm assuming race conditions can't occur if only one thread is executing at ...
Eastbound asked 11/11, 2014 at 20:4
2
I have question on lock on table in SQL Server while inserting data using multiple processes at a single time into same table.
Here are my questions on this,
Is it default behavior of SQL server...
Scolecite asked 10/7, 2014 at 15:53
3
MySQL Server version 5.1.41 with InnoDB plugin enabled. I have the following three tables for invoices: invoices, invoice_components and invoice_expenses. Table invoices has invoice_id primary key....
Scharf asked 14/7, 2011 at 8:31
1
Solved
I am aware of locking concepts with synchronization of static and non static methods to lock classes and instances respectively. What I am not able to understand is, how is class level lock achieve...
Agma asked 5/6, 2014 at 19:30
5
Solved
First, I'll describe what I want and then I'll elaborate on the possibilities I am considering. I don't know which is the best so I want some help.
I have a hash map on which I do read and write o...
Linea asked 1/8, 2013 at 16:55
1 Next >
© 2022 - 2024 — McMap. All rights reserved.