Stack Overflow
Stack Overflow

Questions tagged [database-locking]

129 questions
0
votes
1 answer

SQLite Locking Table from Read

Issue: Getting error from SQLite that the DB is locked Desired Outcome: Multiple applications can read from DB and if only one writes to it the table will not be locked. I have a C# application that reads and writes to a SQLite database. When…
B Minster
  • 331
  • 3
  • 16
0
votes
1 answer

C# - Sqlite - Error lock database

I need help please: I've two methods -one for insert data and one for update data- in my code and I call in first the "insert method" and in second time I call the "update method" but, in the second case, i recieve a "lock database error". Here the…
Berat Rahmani
  • 113
  • 1
  • 8
0
votes
2 answers

Stored procedures vs standard select update, avoid locks

In order to retrieve an ID, I first do a select and then an update, in two consequent queries. The problem is that I am having problems with locked rows. I've read that putting both this statements, Select and Update in one stored procedure it…
AM AM
  • 55
  • 1
  • 6
0
votes
1 answer

Issues in Storing array in SQLite3 using C#

I have a requirement wherein if a new object is found, I am adding its unique id to all the parent class inheriting this class. Eg if C:B and B:A (C extends B and B extends A), then if a new object is found for C, because of inheritance this object…
Nishant
  • 407
  • 2
  • 4
  • 12
0
votes
0 answers

Mysql full lock on big import

I've one MYSQL server with 5 databases. I was using phpmyadmin csv import to load a very big amount of data in one table of one database. I understand that all other operations in this machine may get slower due to the amount of processing take, but…
Rafael Lima
  • 3,079
  • 3
  • 41
  • 105
0
votes
1 answer

How to simulate a "lock timeout" error with Django on MySQL

What's the easiest way to simulate a "lock timeout" DatabaseError with Django using the MySQL backend? I have a piece of code, that operates over large querysets, and occasionally it throws the exception: DatabaseError: (1205, 'Lock wait timeout…
Cerin
  • 60,957
  • 96
  • 316
  • 522
0
votes
0 answers

lck_m_x Lock Locks Whole Database

We're running into a situation where the whole database becomes inaccessible. In looking at Activity Monitor and sorting by duration, I see a tons of backlogged queries, the following being oldest query (@0 nvarchar(max) ,@1 nvarchar(max) ,@2…
Jeff
  • 35,755
  • 15
  • 108
  • 220
0
votes
3 answers

Prevent database from locking with multiple ajax posts in django and django-rest-framework

I have the following models class Peri(models.Model): #fields class Task(models.Model): #fields peri = models.ForeignKey(Peri) I am creating a javascript client to create new Peri's and Tasks. I wanted to go easy on my self and when…
Apostolos
  • 7,763
  • 17
  • 80
  • 150
0
votes
1 answer

How to Lock a MongoDB Collection from all other Clients (write OR read)?

(The other questions on the side bar with similar titles do not address this issue.) I have a collection that I use like a historical sequence…
Matthew Moisen
  • 16,701
  • 27
  • 128
  • 231
0
votes
1 answer

How do I achieve database consistency when rewriting sections of a table?

I have a simple database relationship: one Item relates to many ItemDetails. ItemDetails are updated all at once: a message comes in via HTTP POST with the full set of ItemDetails to replace any old ItemDetails with. The logic I use is this: with…
Scott Stafford
  • 43,764
  • 28
  • 129
  • 177
0
votes
1 answer

Disable locking of Neo4j graph database?

My application is populating a Neo4j graph database at /tmp/import.db. In addition to my unit tests I like to use the Neo4j browser (AKA Neo4j Community) to do some digging in that same database. When the browser is running, my application crashes…
user1019830
0
votes
1 answer

MSSQL 2005 Request Mode is S and Request Type is Lock

My problem is with my database.I use mssql 2005 and management studio. I can see blocked processes by using activity monitor and there i see a list of blocked processes. I killed process that blocked by using its process_id but this time another…
husonos
  • 241
  • 3
  • 14
0
votes
1 answer

SQLite Database Locked in DialogFragment onClick event

People say that it may be caused when you don't close cursor or database. But I have something strange. I try to open database on OK button click in a dialogfragment window (resultClass) in MainActivity in the beginning of app. The method that…
anindis
  • 714
  • 2
  • 11
  • 20
0
votes
1 answer

sigleton instance for a database gives database locked exception in class but not in a method

I have a problem when I use a singleton database object inside class where I am getting database locked exception but when I use the same inside any method of the same class everything is fine, I am confused on the behavior. Below is the code:…
Siva
  • 9,043
  • 12
  • 40
  • 63
0
votes
0 answers

SQLite Database is locked; getDatabaseLocked()

The aim is to retrieve the car park names from the car park tables columns 'CPNAME' and put those rows of names in another class' arraylist which a spinner will display. To be honest Im not even sure if this way will even show the rows in the…
user3408604
  • 15
  • 1
  • 7
1 2 3
…
8
9