Stack Overflow
Stack Overflow

Questions tagged [database-locking]

129 questions
1
vote
2 answers

Locks not releasing in Sybase ASE

My App runs on EJB 1.1 on Jboss 2.4 and uses Sybase. Lately we are seeing an issue where there are indefinite locks on a particular table and that caused the succeeding queries to wait on the locks to get released and therefore whole app fails. The…
oortcloud_domicile
  • 840
  • 6
  • 21
  • 41
1
vote
0 answers

How performant is frequent addition to a set in Cassandra?

I am trying to add values to a set (A Cassandra collection) frequently. I have a schema design such as, frequent_access_data( type text, values set ); Now in my each store operation (which is at faster rate, say 10000 records per second), I am…
Chintan Barad
  • 53
  • 8
1
vote
1 answer

Database is locked SQLite dlls for C#

I have this code below: public Dictionary> CloneGroupMeasuredOutputs(ISimulation clonedSimulation, Dictionary crashDict, Dictionary outputDict, string variationIDs, ProgressInterface progressInterface) …
Ștefan Blaga
  • 404
  • 1
  • 5
  • 22
1
vote
2 answers

database is locked in windows phone 8.1 RT which uses SQLite as database

I am converting my wp8 app (uses a SQL Server CE database) to a wp8.1RT app (using SQLite database). I am getting an error "database is locked" in the below code. Sometimes I get the error when retrieving the customers table information, sometimes…
srinivas vadlamudi
  • 61
  • 1
  • 1
  • 7
1
vote
1 answer

How to obtain a row level lock in java when multiple JVMs accessing same data base?

I have three instances of same application running in different JVMs. I don't want a specific value in the data base to modified by different applications at the same time. How do I enforce this restriction in java?
Bhargav Kumar R
  • 2,190
  • 3
  • 22
  • 38
1
vote
2 answers

Prevent concurrent access to stored procedure in sql server

i have sequences table that consists of three columns: Number,Year,Type and for each new year a three new records gets created and updated all along this year. my stored procedure for generating the sequence is used inside other stored procedures,…
Mahmoud Saleh
  • 33,303
  • 119
  • 337
  • 498
1
vote
3 answers

Correct way to use database locking to randomly return single record not already in use

I have a table that acts somewhat of a queue except records are never removed from the table. What I am trying to attempt is have the stored procedure return a single record that is not currently being processed from a front end application. What we…
Marco
  • 2,453
  • 3
  • 25
  • 35
1
vote
1 answer

SQLite - Database is locked in Java

In a first method, I create the database, if not exists : Class.forName("org.sqlite.JDBC"); Connection connection = null; connection = DriverManager.getConnection("jdbc:sqlite:" + Gdx.files.internal("mjvsworld.db")); Statement…
ajdsj asdnkandm
  • 19
  • 3
1
vote
1 answer

How to achieve database locking based protection against duplicates

In a web application, using the InnoDB storage engine, I was unable to adequately utilise database locking in the following scenario. There are 3 tables, I will call them aa, ar and ai. aa holds the base records, let's say articles. ar holds…
marekful
  • 14,986
  • 6
  • 37
  • 59
1
vote
1 answer

Tables oracle locked

I´m not a dba but I´m having a problems with a database which it´s been locking tables and creating a big chaos as a result. I get some information from the oracle dba, if someone could help me to found the key of the problem or point me what I…
Gustavo
  • 785
  • 1
  • 12
  • 31
1
vote
2 answers

Android: SQLiteOpenHelper.getDatabaseLocked

I can not figure out what is locking my database. This App is brand new in production and I can not even do the very first operation which is to add a user to the database. I have one single DatabaseHandler the does all DB ops. My Activity is…
user3705399
1
vote
0 answers

Android: Database locked, although I have closed it

I have an Activity which creates and runs a task, inside this task a database connection is created. Then I start a transaction and do some operations on the database. I want that when an orientation change appears the task gets canceled and…
Solidus0815
  • 129
  • 1
  • 1
  • 6
1
vote
3 answers

Delphi Xe5 firedac Database locked error with SQLite database

I am trying to create a simple object to handle all my database related functions. I have a functions to return a dataset or to execute a command. Now when i call this from my program I am able to fetch records using Execute_Dataset and it works…
Razal K.A
  • 49
  • 1
  • 3
1
vote
1 answer

Deadlock between INSERT and SELECT SPs

I am having trouble with an application where I get a deadlock that I thought could never happen. I have two stored procedures. One of them just reads parts of the table and one of them adds a row to the table or updates an existing row if there is…
www.jensolsson.se
  • 3,023
  • 2
  • 35
  • 65
1
vote
1 answer

Sql Server 2005 - cannot obtain a LOCK resource

The observed problem and error message is: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users.Ask the database administrator to check the lock and memory…
Sqluser
  • 21
  • 4
1 2 3
…
8 9