Questions tagged [locking]
The locking tag has no usage guidance.
47
questions
1
vote
1
answer
3k
views
Unlock SATA SSD locked with Dell's HDD password option in BIOS
Latest problem is a locked SATA disk. It is a Samsung 870 QVO SSD. It has been locked a long time ago with the Dell BIOS password utility. But because an admin password was set, the system never ...
1
vote
1
answer
4k
views
nfs: enabling file locking (flock)
I'm having trouble finding really any information at all on how to make file locking work for NFS mounts, to resolve client errors like ENOLCK (No locks available).
I understand that in NFSv3 file ...
0
votes
2
answers
2k
views
How to control start and stop of libvirtd and virtlockd in pacemaker cluster?
Using indirect locks of virtlockd (which is used by libvirtd) requires to use a cluster-wide shared filesystem like OCFS2.
In turn this means that virtlockd must be started after the shared filesystem ...
0
votes
0
answers
245
views
SQL Server: Are shared locks used for foreign key constraint enforcement, and how long are they kept?
Main question is in the subject.
In more detail: Let's say we have a table T with a FK constraint to table U (for simplicity, to its PK, and both table use clustered indices on their PKs). Now, we ...
2
votes
1
answer
4k
views
flock fails on shared NFS for exclusive blocking locks from 2 different maschines
I use PHP flock() (which uses the system flock) on systems with shared file system via NFS.
The flock() fails when I use EXCLUSIVE, BLOCKING lock to access the same (shared) file on 2 servers. Of ...
1
vote
0
answers
321
views
Εxponentially growing Innodb_row_lock_time on "master" node of MariaDB 10.3 Galera cluster
I've been trying to investigate issues with an application failing, and I have reason to believe that the culprit lies somewhere in the database backend. To this end, I started collecting metrics from ...
1
vote
1
answer
3k
views
NFS clients fail to get lock on files
I am running FreeBSD 12-RELEASE on our local NFS server. Previously it was working fine, but as of a few days ago some of our tools that require file locking stopped working. Locking does work on our ...
1
vote
1
answer
342
views
invalid or unknown key object_lock_configuration
Trying to set Object Locking on an AWS bucket module (which is working fine without object locking configuration) I get the error :
invalid or unknown key: object_lock_configuration
The error ...
3
votes
1
answer
4k
views
Files locked for on user on Windows Server 2016
I am running a file server on Windows Server 2016 with ~15 users. One user has a lot of difficulty accessing files on the shared drive. The following occurs:
Many (sometimes all) files are locked and ...
0
votes
0
answers
855
views
NFS locking on Windows
I'm mapping a network drive on Windows and I would like to make sure that during a copy the files can be deleted / modified by the server.
From the Microsoft documentation it seems that we need to ...
2
votes
0
answers
1k
views
(How) should I lock a Maildir mailbox managed by Dovecot before creating a backup via rsync?
I maintain an IMAP server running Dovecot which uses Maildir as the storage format for the user mailboxes. Every night, an rsync process runs to create a backup of the mailboxes. Recently, I noticed ...
1
vote
1
answer
65
views
Windows Account Locking policy different while editing scheduled task
When I connect (through RDP) on my Windows 2008 R2 server and editing a task from the "Task Scheduler" if I enter a wrong password, the account is immediately locked.
This happens with Domain user ...
3
votes
1
answer
973
views
ZFS over NFS concurrent write issues
I run a Proxmox cluster, and on this cluster, I have a few VMs on a private network, with a (Proxmox-managed) CEPH storage backend for the VM disks.
One (KVM) VM running "Ubuntu 16.04 server minimal ...
3
votes
0
answers
555
views
how to determine which process/thread holds the flock
When one or more processes/threads do an flock, how to determine who is currently holding the lock. 'fuser' on the file shows all the threads holding and waiting for the lock, not just the one who is ...
1
vote
1
answer
172
views
lockfile-touch terminating intermittently
I'm having some problems with a bit of script I'm using for making sure a script isn't running twice.
I've been using this for quite some time without much problems, but it is giving me trouble on a ...
0
votes
1
answer
1k
views
MySQL INSERTs on a database table block SELECTS in another database and in another table
I am using MySQL 5.1 on a Windows Server 2008 R2 Machine with 8GB RAM.
I am updating 2 databases weekly. Both databases consist of MyISAM tables, and I run a script which performs the necessary ...
6
votes
1
answer
2k
views
How can I test whether fcntl() locks work with my NFS setup?
From the SQLite FAQ:
Can multiple applications or multiple instances of the same application access a single database file at the same time?
…
SQLite uses reader/writer locks to ...
0
votes
1
answer
207
views
Trouble overwritting a locked EXE
Running into an issue that I've been banging my head against for a while now.
We use a shared executable located on a network share.
It's an in house system and we occasionally update it.
Recently we ...
0
votes
0
answers
3k
views
Lockfile creation failed
I got a plain-text logfile (not lock file) in /var/log what I cannot open with:
lockfile creation failed: exceeded maximum number of lock attempts
I wonder what causes this and how can I unlock it ...
3
votes
0
answers
672
views
Linux NFS server refuses blocking locks
So I have this problem. This horrible, awful problem.
I have a set of Linux NFS servers (in a NFS/CIFS cluster using CTDB) that refuse locks… only when the lock is blocking. If it's a non-blocking ...
0
votes
0
answers
229
views
Excel file on Windows client, is it possible to allow another user read-only if the file is already open?
I have a spreadsheet on a Windows 2003 R2 server. The clients are all Windows 7 using Excel 2010. If a remote user opens the spreadsheet first then any other "local" user gets access denied if they ...
4
votes
2
answers
2k
views
How to detect exceptionally long file locks in linux?
I have a point of contention on my linux server. One of a number of processes access a single file and lock the file at a random time for a considerable period (>60 seconds) which, in turn, causes ...
5
votes
2
answers
14k
views
MS Sql Server getting overloading with 'Suspended' queries, mostly reads. Any way to fix this?
I have a Microsoft Sql Server that handles a moderate amout of traffic for a company software suite made up of multiple clients in java and c#.
It is getting overloaded with 'Suspended' queries. They ...
0
votes
1
answer
373
views
Websphere shutdown not releasing database locks
Sometimes when shutting down Websphere there are database locks not released. As a result, when WAS is restarted nobody can work because of these locks, that must be removed manually by the DBA.
It's ...
0
votes
1
answer
2k
views
iSCSI and NFS file locking and concurrency
I've got a linux host that need to mount a data share located on a NAS. The choice is between NFS v3 (NAS limitation) and iSCSI. The initial idea was to have a NFS mount to the file server that ...
0
votes
1
answer
2k
views
file locking problems with recent Samba versions (from DOS/Clipper under XP)
we have several DOS applications (Clipper) which share dbase files on a file server. The applications run under XP. This has worked for about two decades with Netware and for years with Samba (member ...
1
vote
1
answer
1k
views
PostgreSQL Page-level locking
I'm fairly new to postgresql. I've checked out the documentation and I can't find anything about how to do page-level locking.
I understand that I can set a table into a locking mode like this:
LOCK ...
2
votes
1
answer
2k
views
Windows Server 08 R2 file share File locking, OSX clients
I've spent the last two weeks banging my head against this wall. I think I'm starting to understand the problem though. I manage a design company and they have 5 macs (OSX 10.5/.6/.7) connected over ...
8
votes
2
answers
26k
views
Avoid /usr/bin/xauth: error in locking authority file /home/user/.Xauthority
In batch scripts I often log in to the same system through ssh multiple times. E.g.
seq 1000 | parallel -j0 -S server echo
This triggers a race condition giving the error:
/usr/bin/xauth: error in ...
0
votes
3
answers
45
views
Apache / PHP Begins to Deny SQL Requests after about 2000
We have a web page on our server that we use to run administrative scripts. For example, we might run the script "unenrolStudents()" which runs 5,000 SQL SET commands one after another and sets 5000 ...
3
votes
2
answers
1k
views
Shared block device file system (cluster file system without networking)
Is there any file system that can be mounted multiple times and supports concurrent file access for Linux? Basically I want something like a cluster file system but without the need to have a running ...
2
votes
1
answer
357
views
Monitoring Innodb Lock Monitoring output?
I've found plenty of tools that will monitor the output of SHOW PROCESSLIST and SHOW INNODB STATUS but haven't really found much that indicates it will log, digest and summarize (optionally enabled) ...
0
votes
1
answer
397
views
Locking does not work with SVN (64 bit)
We are using Subversion to manage a big project.
Everyone normally has to lock a file before they can modify it.
There are several new new machines with Windows 7, SVN (64 bit) and this directive in ...
5
votes
1
answer
1k
views
Executing multiple commands with setlock
In a bash script I would like to execute multiple commands while keeping a file locked with setlock. Setlock however only supports the following usage:
setlock [-NnXx] [lock file] [command]
Is ...
0
votes
2
answers
524
views
Increase simultaneous connections with apache2
How can I increase the number of simultaneous connections in apache2? I'm using a javascript application that polls the server regularly and I'm trying to prevent clients from getting locked out. I ...
0
votes
1
answer
183
views
Can you recommend a reliable file copying program that deals with file locking?
I'm looking for a file copying utility (for Windows) that will take into account file locking in the destination folder.
The situation is we have multiple shares on multiple servers where our ...
1
vote
1
answer
390
views
Simple locking daemon with API for PHP (or just simple API)?
I am looking for a simple locking daemon which listens for clients over TCP and processes locking requests.
I need to synchronize parallel PHP processes at MULTIPLE machines. E.g. one machine may say ...
1
vote
2
answers
292
views
Software updates and locked EXEs/DLLs
I have a question on how to best deploy/update a software package on a Windows server that is used by several users across the network.
We are in charge of updating a software package on a regular ...
0
votes
1
answer
832
views
Column locking in innodb?
I know this sounds weird, but apparently one of my columns is locked.
select * from table where type_id = 1 and updated_at < '2010-03-14' limit 1;
select * from table where type_id = 3 and ...
0
votes
1
answer
78
views
How can i see what is locking up a table? [duplicate]
Possible Duplicate:
“Delete query” not able to be completed
I am trying to delete a single row from the db, but it is not completing,even in 20 minutes.There is no other queries ...
0
votes
1
answer
871
views
Mysql- “FLUSH TABLES WITH READ LOCK” started automatically
I would like to understand how this happened. I was running a query that would take a long time, but should not lock up any table. However, my dbs were practically down - it seems like it was being ...
1
vote
1
answer
3k
views
Lock timeout when creating index
I am attempting to create a new index on an existing table with 44,485 records in it.
I am using this query to create my new index
CREATE INDEX index_name ON table_name (field_name);
Whenever I run ...
1
vote
3
answers
5k
views
How do I FREEZE/stop/lock a MYSQL database? THen how do I enable the databse back to normal?
Basically, I need to stop it. (So that I can do backup without new data).
Everything "frozen".
THen, how do I enable it so that people can make changes to it again?
0
votes
1
answer
120
views
What privilege level is required on a Windows client workstation on an ActiveDomain to break file locks?
I'm not sure if I should be asking this here or on StackOverflow, but here goes:
I'm part of a team maintaining a document management application, and I'm trying to figure out Windows file locking ...
18
votes
4
answers
55k
views
File locks on an NFS?
My server uses NFS (Network File System), and I'm unable to use PHP's flock() -function. Is there a way to lock files on an NFS or is there a need to do so?
6
votes
3
answers
244
views
How do you know who or what is locking a removable disk?
I was reading that question How do you know who or what is locking a remote file? and I remember that question... even in Windows7, the Windows doesn't show that program is locking the removable disk, ...
9
votes
6
answers
10k
views
How do you know who or what is locking a remote file?
I can tell what process is holding a lock using Unlocker.
But the problem is that, when there is a lock on a file on a remote machine, Unlocker doesn't show who or what process is locking.
Is there ...