Questions tagged as 'lock'

2
answers

What is a lock and what are its causes?

I often come across the term: Table x is with lock . What does it mean and what are its causes?     
asked by 19.04.2017 / 21:38
1
answer

Optimistic Lock; Why not throw an exception?

I tried to simulate an optimistic Lock situation where you try to update the same record twice, but the exception is not triggered. I think it's interesting that even after changing the value of the holder and giving a MERGE, the version valu...
asked by 28.02.2017 / 21:25
1
answer

What is the Multi-Version Concurrency Control technique in PostgreSQL?

What is Multi-Version Concurrency Control (MVCC) in PostgreSQL and how is it working?     
asked by 27.03.2017 / 15:42
1
answer

Put password in a python file

I'm doing a program in which you select the file you want to block using a password, by clicking a button that file is locked with a user-defined password. How can I make this file accessible only with the password?     
asked by 04.04.2017 / 20:07
0
answers

Concurrent programming

Hello, I'm having trouble finding the error in the code below. It is a problem in which ideally, having 5 available positions, any of the types of threads (server or trainee) can be to sit freely, but when they fill the vacancies, the next vacan...
asked by 03.11.2017 / 18:43
0
answers

DB2 database - competition problem

The client application 1 inserts from the DB2 database and creates a lock IX to the lock X table on the line. Client applications 2 and 3 attached to the same database attempt to make selects to the same table and the application blocks. In t...
asked by 28.03.2018 / 16:14
0
answers

Transaction with Laravel

DB::connection('gtsql')->beginTransaction(); $seriefat = DB::connection('gtsql')->table('se_seriefat') ->where('c_codserie', 'FO')->first(); echo $seriefat->c_numultdoc; sleep(15); DB::connecti...
asked by 28.11.2017 / 14:53