Questions tagged [locking]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
1k 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 ...
user avatar
  • 125
0 votes
2 answers
635 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 ...
user avatar
  • 262
0 votes
0 answers
148 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 ...
user avatar
2 votes
1 answer
2k 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 ...
user avatar
1 vote
0 answers
145 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 ...
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 ...
user avatar
  • 41
1 vote
1 answer
292 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 ...
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 ...
user avatar
  • 131
0 votes
0 answers
636 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 ...
user avatar
2 votes
0 answers
733 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 ...
user avatar
1 vote
1 answer
59 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 ...
user avatar
3 votes
1 answer
845 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 ...
user avatar
2 votes
0 answers
303 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 ...
user avatar
1 vote
1 answer
152 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 ...
user avatar
  • 111
0 votes
1 answer
992 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 ...
user avatar
5 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 ...
user avatar
  • 4,681
0 votes
1 answer
92 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 ...
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 ...
user avatar
  • 1
3 votes
0 answers
600 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 ...
user avatar
  • 38.5k
0 votes
0 answers
226 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 ...
user avatar
  • 2,594
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 ...
user avatar
5 votes
2 answers
12k 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 ...
user avatar
  • 247
0 votes
1 answer
301 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 ...
user avatar
0 votes
1 answer
1k 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 ...
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 ...
user avatar
  • 5,097
1 vote
1 answer
793 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 ...
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 ...
user avatar
8 votes
2 answers
24k 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 ...
user avatar
  • 2,736
0 votes
3 answers
38 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 ...
user avatar
3 votes
2 answers
999 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 ...
user avatar
  • 61
2 votes
1 answer
343 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) ...
user avatar
  • 21
0 votes
1 answer
390 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 ...
user avatar
  • 1
4 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 ...
user avatar
  • 43
0 votes
2 answers
398 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 ...
user avatar
  • 2,052
0 votes
1 answer
181 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 ...
user avatar
  • 131
1 vote
1 answer
385 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 ...
user avatar
1 vote
2 answers
240 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 ...
user avatar
  • 111
0 votes
1 answer
780 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
67 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
795 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 ...
user avatar
0 votes
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?
user avatar
  • 8,031
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 ...
user avatar
18 votes
4 answers
49k 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?
user avatar
  • 367
6 votes
3 answers
231 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, ...
user avatar
  • 946
9 votes
6 answers
9k 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 ...
user avatar
  • 1,961