103 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
85
views
Magento2 database table locking error causing site to go offline several times a day
Several times a day a database insert query runs that seems to take a long time and locks up a table, and this in turn causes our site to go offline (error 503). It does not come back up until certain ...
0
votes
2
answers
535
views
How to acquire exclusive lock in replicated mysql and clustered servers?
I have this scenario:
My php web application is deployed in a clustered environment, it uses a replicated mariadb database with galera.
It has to acquire an exclusive lock on database row resource and ...
1
vote
0
answers
280
views
MS Access - Table locked by another person or process, after closing form
I am running a sub to 'snapshot' data from a pass-through query (which is slow) and store the results to a table. It is supposed to delete the table, then re-create it to be an updated snapshot of the ...
0
votes
1
answer
53
views
Doing FOR UPDATE and JOIN when using ROW SHARE lock?
According to PostgreSQL documentation, the ROW SHARE lock works like this:
The SELECT command acquires a lock of this mode on all tables on which
one of the FOR UPDATE FOR NO KEY UPDATE, FOR SHARE, ...
0
votes
0
answers
154
views
Lock escalation on update statement that uses a primary key
I inherited a database that seems to have a LOT of lock escalation going on. I ran a trace and it's full of escalation events.
Some of it is caused by things like BULK INSERTS. I can understand how ...
0
votes
0
answers
475
views
SQL Server table data deletion while insertion is in progress in another session
I have a table (TableA).
There is a probability that more than one process may try to delete data from TableA and at the same time more than one process may try to insert data into same table i.e. ...
0
votes
0
answers
134
views
Does stored procedure with select statement called from another stored procedure with transaction lock the table?
I have a stored procedure calling another stored procedure. The outer stored procedure got tran while the inner stored procedure has no tran just select statement. Does the table in the inner tran ...
0
votes
1
answer
2k
views
How to remove a lock from a table in a Synapse Dedicated Pool?
There has been a lock on 2 different tables since last night. What is the query to remove a lock from a table in a Synapse Dedicated Pool?
Thanks in advance
0
votes
1
answer
1k
views
Preventing/Reducing deadlocks within a django application
I've been having a few issues recently working with a large MySQL database within django, MySQL seems to be having issues with deadlocks.
I keep getting the error:
(1213, 'Deadlock found when trying ...
0
votes
0
answers
354
views
unlocking a table that someone else locked
Let's say a coworker does LOCK TABLES table_name and then leaves for the day without unlocking the table. Maybe their computer is locked so you can't just kill the process on their computer. Maybe you ...
1
vote
1
answer
1k
views
Difference between a row lock and a table lock in Oracle database
What is the difference between row locking and table locking in Oracle Database? Would a for loop with the UPDATE statement trigger a table lock?
0
votes
1
answer
629
views
Temporal Table and Table locks
I am thinking of using a temporal table solution for one of our application, and want to read historic data while new data is being written. Can this cause table locks? I have millions of rows to ...
0
votes
1
answer
488
views
Does InnoDB block on a SELECT that joins with a locked table?
Suppose, I run this query, which locks the entire table in InnoDB until it finishes:
Update UserDetails set balance = 0
Then I run this query:
Select * from User inner join UserDetails on (User.id = ...
0
votes
2
answers
3k
views
Does a general InnoDB UPDATE lock the entire table and block incoming specific UPDATEs?
Suppose I ran this statement:
UPDATE Employees set country='AU'
On an InnoDB table, Employees, with about 10 million rows.
This table is also actively being updated by other users through SQL queries ...
2
votes
1
answer
6k
views
Create index in huge MariaDB production database without table locking
I have a table with 202M records where I need to add a few indexes and I can't find it anywhere (or maybe I don't understand the lingo) if that is possible to do, without locking, in MariaDB 10.3.
I ...