Stack Overflow
Stack Overflow

Questions tagged [transaction-isolation]

Transaction isolation relates to the visibility and impact of changes made in one transaction on concurrent transactions.

256 questions
0
votes
1 answer

What is the default transaction row level in Postgres and/or LOCK used by default in Sequelize.js

What is the default row-level lock mode used in PostgreSQL? And because the question is related to Sequelize ORM, so, it would be nice to know which mode is used by default to avoid or modify my queries.
ncardez
  • 139
  • 2
  • 11
0
votes
0 answers

TransactionScope with ReadUncommitted Isolation Level in a Recursive function locks table for first iteration and then releases table

I have a function that is being called recursively. In this function, a TransactionScope object with Isolation level ReadUncommitted is being used. The strange behaviour is that the first time, it hits Database, locks the table and after the…
Muhammad Qasim
  • 1,622
  • 14
  • 26
0
votes
1 answer

Lost update in snapshot vs all the rest isolation levels

Let's suppose we use create new table and enable snapshot isolation for our database: alter database database_name set allow_snapshot_isolation on create table marbles (id int primary key, color char(5)) insert marbles values(1, 'Black') insert…
Rocket128
  • 123
  • 3
  • 13
0
votes
2 answers

MySQL - need help in improving query performance

Original question was based on where best to set tx isolation to READ UNCOMMITTED but after some advise it would seem that my initial thoughts on that as a possible solution was incorrect. DDL CREATE TABLE `tblgpslog` ( `GPSLogID` BIGINT(20) NOT…
Jim Buckley Barret
  • 330
  • 6
  • 20
0
votes
1 answer

Transactions with different isolation levels for Ignite's SQL layer

Apache Ignite's documentation specifically mentions that weak isolation levels and ACID compliant transactions are only offered for cache operations but not for the SQL API. However, it is also mentioned that the functionality will be added in…
Kiarahmani
  • 47
  • 1
  • 8
0
votes
1 answer

Getting error Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT

I have a local development server where i have tested nearly all quartz functionality (scheduling/execution/e.t.c) where mysql setting log_bin = off When i deployed same script on my staging server(log_bin = on) i am getting following error.…
Kamran Shahid
  • 3,954
  • 5
  • 48
  • 93
0
votes
2 answers

Neo4j acquire/release the write lock - true/false vs remove

In Neo4j in order to simulate the SERIALIZABLE transaction isolation level I need to explicitly set a dummy property, for example: SET n._lock_ = true But how to properly release the lock, do I need to SET n._lock_ = false or to completely remove…
alexanoid
  • 24,051
  • 54
  • 210
  • 410
0
votes
1 answer

In Neo4j is the default isolation level always READ_COMMITTED or is it the case only when extending it with Java?

I am reading the documentation provided by Neo4j https://neo4j.com/docs/java-reference/current/transactions/, but as the link says, the rules provided in that explanation are valid when talking about the java-extension, what about Neo4j without any…
elena
  • 889
  • 2
  • 11
  • 19
0
votes
0 answers

Two max values of a same column are not equal in one select statement

OS: CentOS Linux release 7.4.1708 (Core) Kernel: 3.10.0-693.11.1.el7.x86_64 DB: MariaDB-server-10.2.12-1.el7.centos.x86_64 Create table and Insert initial data. create table customers ( company_id bigint not null, customer_id bigint not…
percy
  • 1
  • 1
0
votes
1 answer

InnoDB locking for INSERT/UPDATE concurrent transactions

I'm looking to ensure isolation when multiple transactions may execute a database insert or update, where the old value is required for the process. Here is a MVP in python-like pseudo code, the default isolation level is assumed: sql('BEGIN') rows…
M1L0U
  • 1,175
  • 12
  • 20
0
votes
1 answer

Spring @Transactional + Isolation.REPEATABLE_READ for Rate Limiting

We are trying a scenario of Rate Limiting the total no. of JSON records requested in a month to 10000 for an API. We are storing the total count of records in a table against client_id and a Timestamp(which is primary key). Per request we fetch…
Sreeram
  • 13
  • 5
0
votes
0 answers

SQL Server & Entity Framework how to deal with long running transactions

we have an application built with Entity Framework and SQL Server. The import data function is wrapped in a long running transaction. So all the actions in the "import data function" either succeeded or nothing is persisted into the database.…
Yang
  • 39
  • 3
0
votes
1 answer

What is the correct isolation level for Order header - Order lines transactions?

Lets say we have a usual situation with Order_Header and Order_LineItems tables. Also, lets say we have transactions for creating, updating and selecting Orders. Like: Create: BEGIN TRANSACTION INSERT INTO Order_Headers... SET @Id =…
dee zg
  • 13,793
  • 10
  • 42
  • 82
0
votes
1 answer

SSIS data flow task executing before previous task completes its SQL operation

In SSIS I have DataFlowTask1 which will insert the data into TABLE A. The following data flow task will pull the data from TABLE A. But unfortunately, DataFlowTask2 is getting fired before the DataFlowTask1 has completed inserting the data. Is…
shockwave
  • 3,074
  • 9
  • 35
  • 60
0
votes
2 answers

SQL Server Isolation Level issues

I looked at all the isolation types. But I could not find the mode I wanted. It can be read by other transaction during the transaction. But, it will not add update and delete data. For example (pseudo code): create table abc (id uniqueidentifier…
Nazlı
  • 3
  • 4
1 2 3
…
17 18