Questions tagged [locking]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
27 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 ...
0
votes
1answer
347 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
0answers
99 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
2k 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
338 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
325 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
51 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
464 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
248 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
110 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
666 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
45 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 ...
2
votes
0answers
445 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
223 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 ...
4
votes
2answers
7k 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
246 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
464 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 ...
7
votes
2answers
18k 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
34 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
563 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
320 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
367 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
982 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
271 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
177 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
206 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
646 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
749 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
2k 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
36k 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
222 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
7k 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 ...