Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [locking]

46 questions
2
votes
1 answer

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) data from the InnoDB Lock Monitor. Is there such…
Zadan
  • 21
  • 1
2
votes
1 answer

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 course, only one process should be able to obtain…
Sybille Peters
  • 213
  • 2
  • 12
1
vote
0 answers

Ε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 the backend MariaDB Galera cluster (currently…
gedia
  • 11
  • 2
1
vote
1 answer

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 NFS clients for other servers. Here is some…
rocky
  • 51
  • 1
  • 7
1
vote
1 answer

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 message makes me think about a syntax error but can't…
SalutFred
  • 11
  • 2
1
vote
1 answer

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 this I get this timeout error: 1205 - Lock wait…
Neil Aitken
  • 93
  • 1
  • 8
1
vote
3 answers

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
  • 8,471
  • 26
  • 75
  • 99
1
vote
1 answer

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 and with local admin users. However when I am…
рüффп
  • 620
  • 1
  • 11
  • 25
1
vote
1 answer

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 server I just upgraded from Ubuntu 15.04 to Ubuntu…
DoppyNL
  • 111
  • 1
1
vote
1 answer

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 TABLE myTable IN LOCKMODE ROW EXCLUSIVE; How…
Lebowski156
  • 113
  • 5
1
vote
1 answer

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 "I lock the 'abcd' identifier from now and until…
Dmitry Koterov
  • 11
  • 1
1
vote
2 answers

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 basis. This package is installed in a shared folder…
hmn
  • 111
  • 3
1
vote
1 answer

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 locking was handled by separate services, and in…
fuzzyTew
  • 134
  • 2
  • 9
0
votes
0 answers

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 specify when we want to lock a file on the server,…
lachauj
  • 1
0
votes
1 answer

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 permissions. We use a utility somebody downloaded…
Mike Burton
  • 101
  • 1
1
2
3 4