Questions tagged [locking]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
Earl Hughes's user avatar
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 ...
fuzzyTew's user avatar
  • 134
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 ...
U. Windl's user avatar
  • 383
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 ...
H.M. Müller's user avatar
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 ...
Sybille Peters's user avatar
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 ...
gedia's user avatar
  • 11
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 ...
rocky's user avatar
  • 51
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 ...
SalutFred's user avatar
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 ...
Cliff's user avatar
  • 131
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 ...
lachauj's user avatar
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 ...
Frerich Raabe's user avatar
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 ...
рüффп's user avatar
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 ...
Eddy Buhler's user avatar
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 ...
Swami Jayaram's user avatar
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 ...
DoppyNL's user avatar
  • 111
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 ...
user3480610's user avatar
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 ...
200_success's user avatar
  • 4,790
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 ...
Nick's user avatar
  • 1
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 ...
tux553's user avatar
  • 1
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 ...
MikeyB's user avatar
  • 39.6k
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 ...
PowerApp101's user avatar
  • 2,624
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 ...
tudor -Reinstate Monica-'s user avatar
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 ...
AAA's user avatar
  • 247
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 ...
Lluis Martinez's user avatar
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 ...
Vinnie's user avatar
  • 105
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 ...
Hauke Laging's user avatar
  • 5,335
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 ...
Lebowski156's user avatar
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 ...
Keith Loughnane's user avatar
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 ...
Ole Tange's user avatar
  • 3,106
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 ...
Daniel Stern's user avatar
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 ...
fungs's user avatar
  • 61
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) ...
Zadan's user avatar
  • 21
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 ...
Tom's user avatar
  • 1
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 ...
John's user avatar
  • 53
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 ...
ensnare's user avatar
  • 2,232
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 ...
Rich's user avatar
  • 131
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 ...
Dmitry Koterov's user avatar
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 ...
hmn's user avatar
  • 111
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
Neil Aitken's user avatar
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?
Alex's user avatar
  • 8,591
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 ...
Mike Burton's user avatar
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?
rFactor's user avatar
  • 367
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, ...
Click Ok's user avatar
  • 956
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 ...
dance2die's user avatar
  • 2,031