Questions tagged [isolation-level]
Isolation level defines what data an SQL transaction can view or access while other transactions work with the same data.
isolation-level
743
questions
0
votes
1
answer
37
views
Where is Cassandra useful if it has no concept of Isolation Levels?
I read here that Cassandra has no concept of Isolation Levels and that you need to use External Locking(say Zookeeper) to enforce any kind of locking, which will magnify the latency manyfold.
I wonder,...
0
votes
1
answer
31
views
Does Cassandra offer any semantics similar to REPEATABLE READ?
Does Cassandra offer any semantics similar to REPEATABLE READ?
I believe you can do this within a "batched" LWT, but doesn't this incur significant network overhead due to PAXOS? REPEATABLE ...
0
votes
2
answers
56
views
Read query locking the insertion of a new record on a table with error - Lock wait timeout exceeded; try restarting transaction
I have a stored procedure that runs every one hour to generate a summary of the transactions that happened in the service. The stored procedure reads the data from a table called transaction_log and ...
0
votes
0
answers
24
views
DDIA doctor on-call example, Repeatable Read with lock VS Serializable
Background
You are writing an application for doctors to manage their on-call shifts at a hospital. The hospital usually tries to have several doctors on call at any one time, but it absolutely must ...
2
votes
1
answer
48
views
Postgresql REPEATABLE READ can see data committed after transaction begins(and do nothing before other transaction starts and commits)
Postgresql REPEATABLE READ can see data committed after transaction begins(and do nothing before other transaction starts and commits) even if its document says it cannot.
Start Transaction A with ...
2
votes
1
answer
106
views
Transaction isolation level for financial transactions
Let's assume we have an application that must transfer funds from account A to account B.
Let's assume that database is MySQL (though I'd appreciant an answer for Postgres too).
Account A balance: 20
...
0
votes
0
answers
28
views
Trouble Triggering Serialization Error with PostgreSQL Trigger Function
I'm encountering a puzzling issue with PostgreSQL's SERIALIZABLE isolation level and a trigger function's behavior. I have one table, and a trigger:
-- Definition of the events table
CREATE TABLE ...
0
votes
0
answers
6
views
Why doesn't Repeatable-read isolation level cause non-reaptable read problem?
I know that both write and read are long-term locks.
But even if it's all long-term, if transaction A reads the data with a read lock, and then transaction B changes and commits the data with a write ...
0
votes
0
answers
19
views
How to Identify Specific Transaction Anomalies in a Given Schedule?
I'm analyzing a schedule of database transactions to identify potential anomalies such as lost updates, non-repeatable reads, and dirty reads. Below is the schedule represented in a tabular format, ...
0
votes
1
answer
136
views
'TRANSACTION ISOLATION LEVEL is set to SNAPSHOT' error when using TransactionScope on Memory Optimised Table
In Memory disk setup on SQL Server with below up
snapshot_isolation_state
snapshot_isolation_state_desc
is_read_committed_snapshot_on
is_memory_optimized_elevate_to_snapshot_on
...
0
votes
0
answers
52
views
Why is serializable needed in ticket booking?
In this article
https://kkyr.io/blog/serializability-vs-linearizability/#:~:text=Banking%20example&text=The%20banking%20system%20uses%20a,and%20does%20not%20guarantee%20linearizability.
The author ...
0
votes
0
answers
22
views
MySQL Hibernate transactions with Repeatable Read isolation not working as expected
I am trying to fetch records from Matrix table and update one record based on some logic inside a transaction. This transaction is triggered concurrently 5-6 times.
So using isolation level ...
1
vote
1
answer
109
views
Unclear about how repeatable-read works in RDBMS [duplicate]
I'm uncertain about how repeatable-read operates in RDBMS. I initially thought it functions similarly to Git branching, where an exact copy of the current database is utilized. However, I'm puzzled by ...
1
vote
0
answers
77
views
Providing an isolation level to "DbConnection.BeginTransaction(isolationLevel)" has no effect on the SQL sent to the database
I've been doing some testing in the System.Data namespace using SQL Server Profiler, and noticed that whatever IsolationLevel you provide to DbConnection.BeginTransaction(isolationLevel) doesn't ...
0
votes
1
answer
40
views
Does Kafka Connect Sink with MySQL JDBC driver support setting isolation level?
I tried to find setting about DB transaction isolation level in Kafka Connect docs - nothing. Tried to find such connection url parameter for MySQL driver - it seems it doesn't exist. Also I didn't ...