locking Questions
3
I have an Access database (.accdb) file that must be replaced with a backup copy. Unfortunately, the file is locked with an (.laccdb) and I cannot rename or remove either file.
I don't exactly kno...
Swimmingly asked 16/9, 2015 at 20:6
7
Solved
I have a bunch of servers with multiple instances accessing a resource that has a hard limit on requests per second.
I need a mechanism to lock the access on this resource for all servers and inst...
Roadside asked 12/4, 2014 at 22:39
4
Solved
My use case is as follows: I have a program that enforces that only one instance of it can be running at any given time, so at startup it always tries to grab hold of a lock file in a standard loca...
4
Solved
As is known, there are two locking strategy: Optimistic vs. Pessimistic locking
Pessimistic Locking is when you lock the record for your exclusive use
until you have finished with it. It has mu...
Wager asked 14/8, 2016 at 21:32
6
Solved
I am trying to do some shared locking using with statements
def someMethod(self, hasLock = False):
with self.my_lock:
self.somethingElse(hasLock=True)
def somethingElse(self, hasLock = False):...
Saenz asked 3/3, 2011 at 19:34
5
Solved
We have had an issue with a block of code that responds poorly in the face of slow databases (It craps the bed on a query timeout). We have created a patch, and are in the process of running it thr...
Chimney asked 28/4, 2009 at 14:16
5
Solved
I canceled a running Gradle build and now I get the following message whenever I restart it:
Could not create service of type FileHasher using BuildSessionServices.createFileHasher().
> Cannot ...
5
Solved
3
Solved
While researching the use of Table Hints, I came across these two questions:
Which lock hints should I use (T-SQL)?
What effect does HOLDLOCK have on UPDLOCK?
Answers to both questions say that...
Starch asked 21/10, 2011 at 0:12
2
Solved
I'm late to the party, but I recently learned about SemaphoreSlim:
I used to use lock for synchronous locking, and a busy boolean for asynchronous locking. Now I just use SemaphoreSlim for everythi...
Imamate asked 21/11, 2022 at 17:39
9
Solved
I want to known who is locking a file on a network share.
Here is the problem : the network share is on a NAS, so I can't log on. I need a tool to find out remotely who is locking the file. It is ...
3
What are the different techniques for Unlocking an oracle table?
What I Tried.
Get the object ID of the locked table:
SELECT object_id FROM dba_objects WHERE object_name='YOUR TABLE NAME';
Get ...
2
I need to use table locking (write) and along with that update a few tables, so I need transactions at the same time, as the locking is not transaction-safe.
From mysql documentation I read the fo...
Practically asked 16/12, 2015 at 17:48
3
Solved
I have one table that is read at the same time by different threads.
Each thread must select 100 rows, execute some tasks on each row (unrelated to the database) then they must delete the selecte...
Dictionary asked 5/11, 2010 at 19:40
6
Solved
C# doesn't allow locking on a null value. I suppose I could check whether the value is null or not before I lock it, but because I haven't locked it another thread could come along and make the val...
Incompetence asked 29/8, 2011 at 4:58
7
Solved
What is the best way to prevent concurrent update of one record in a key-value set without locking the entire set? Semantically, I'm looking for some kind of locking by a key (ideally, Java impleme...
Potherb asked 20/6, 2012 at 17:2
6
Solved
I've written an API that will be used on the same box in (1) a windows service, (2) a web application, and (3) a windows forms application. They all need to share a very small set of common data (a...
Melson asked 3/9, 2010 at 19:52
2
According to mmap() manpage:
MAP_PRIVATE
Create a private copy-on-write mapping. Updates to the mapping are not visible to other processes mapping the same file, and are not carried through t...
Bullyrag asked 7/6, 2019 at 17:42
30
Solved
I've seen many of the other threads about this and they don't help.
I have a very simple repo - two JavaScript files. I have 100+ GB on Macbook. When I try to move the files into a subdirectory an...
6
Solved
I have a super class with a method that calls other methods that are only defined in its sub classes. That's why, when I create an instance of my super class and call its method, it cannot find the...
Fool asked 3/11, 2011 at 0:37
3
We had a transaction that updates 2000000 rows in a postgresql 10 database using flyway (v6).
It failed with Unable to acquire Flyway advisory lock .
2000000 records is not that big and it is 1 lo...
Valedictorian asked 1/11, 2019 at 20:2
25
Solved
Is there a Pythonic way to have only one instance of a program running?
The only reasonable solution I've come up with is trying to run it as a server on some port, then second program trying to ...
Ruse asked 19/12, 2008 at 12:42
1
I wanted to replace the pthread_spinlock_t example with my own spinlock implementation. However, my implementation's result is literally far lower than the pthread_spinlock_t performance. While the...
Pilcomayo asked 2/10, 2023 at 17:3
2
Solved
In PostgreSQL, the MVCC concurrency control mechanism says that:
MVCC locks acquired for querying (reading) data do not conflict with
locks acquired for writing data, and so reading never block...
Staunch asked 30/5, 2015 at 12:30
2
Solved
Note: This question concerns C++11. The answer to the same question in C++17 (or later revisions) may have changed. For details:
std::lock_guard or std::scoped_lock?
When we want to lock mult...
Nailhead asked 14/6, 2013 at 16:56
1 Next >
© 2022 - 2024 — McMap. All rights reserved.