Questions tagged [locking]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
56 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
2answers
134 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
0answers
76 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
1answer
989 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
0answers
73 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
1answer
2k 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
1answer
228 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
1answer
3k 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
0answers
513 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
0answers
574 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
1answer
54 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
1answer
720 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 ...
2
votes
0answers
280 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
1answer
125 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
1answer
899 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 ...
5
votes
1answer
1k 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
1answer
50 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
0answers
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
0answers
556 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
0answers
224 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
2answers
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
2answers
10k 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
1answer
266 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
1answer
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 ...
0
votes
1answer
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
1answer
605 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
1answer
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
2answers
22k 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
3answers
35 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
2answers
873 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
1answer
340 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
1answer
387 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 ...
4
votes
1answer
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
2answers
359 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
1answer
179 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
1answer
382 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
2answers
209 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
1answer
748 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
1answer
66 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
1answer
784 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
1answer
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 ...
0
votes
3answers
4k 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
1answer
116 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 ...
17
votes
4answers
44k 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
3answers
225 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
6answers
8k 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 ...