267 questions
-4
votes
0
answers
24
views
I am getting this error Unknown system variable 'transaction_isolation' [duplicate]
spring.datasource.url=jdbc:mysql://localhost:3306/db_name?sessionVariables=transaction_isolation=TRANSACTION-REPEATABLE-READ&autoReconnect=true
spring.datasource.username=username
spring....
2
votes
1
answer
84
views
PostgreSQL doesn't allow two non-conflicting serializable transactions to pass
I'm using PostgreSQL 14. Create the following table:
create table users
(
id serial primary key,
first_name varchar(255) not null,
last_name varchar(255) not null
);
insert into ...
- 4,423
3
votes
2
answers
254
views
Spring 6 TransactionManager Isolation Level Support in IBM Liberty
We have an application running in Liberty 19.X using Spring 5 and Spring Boot 2 which is live in production and working properly. We are migrating that application to Liberty 24.X with Spring 6 and ...
- 41
0
votes
0
answers
13
views
Is lost update possible with serializable transaction isolation?
It is often stated serializable transactions prevents all read phenomena including lost update and phantoms. But is this the case when read committed transaction (A) and serializable transaction (B) ...
- 23.6k
0
votes
0
answers
42
views
Spring @Transactional isolation level
I want to clarify if I understood correctly how @Transactional works. I read about isolation levels in the postgreSQL documentation.
The database image that I used: postgres:16.4-alpine3.20
Spring ...
1
vote
0
answers
140
views
"original: error: tuple concurrently updated" postgres error while concurrently executing a plpgsql function -[ postgresSQL 14.5 ]
Hi stackoverflow community, this is my first ever question on stackoverflow, so I'd appreciate if you excuse my mistakes in presenting my question and really would appreciate any help.
I have written ...
0
votes
2
answers
109
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 ...
2
votes
1
answer
539
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
...
- 3,251
0
votes
0
answers
31
views
Concurrent triggers for denormalised table and transaction isolation
I have two main tables:
CREATE TABLE profiles(id int PRIMARY KEY, active bool);
CREATE TABLE memberships(scope VARCHAR(10), profile int);
And I have a denormalised table that combines data from the ...
- 47
2
votes
2
answers
170
views
Is it guaranteed that constraint violation is flagged at the end of transactional block?
I’m using Postgres and have a transactional method defined as follows:
@Entity
public class SomeEntity {
// …
}
@Transactional(isolation = READ_COMMITED)
public void persistUniqueAndSendEmail() {
...
- 9,580
0
votes
1
answer
41
views
problematic read commited behavior - what should i expect?
small simplified question regarding isolation levels using wildfly, hibernate jpa, jta with isolation level READ_COMMITED. assuming the following scenario:
Thread 1, on table SomeTable, using JPA ...
- 143
0
votes
1
answer
101
views
How can an old, committed transaction affect ongoing txns?
SQL gurus!
My postgres 15 database is running under the SERIALIZABLE isolation level and I'm occasionally seeing serialization_failure (40001) errors with an odd error message:
DETAIL: Reason code: ...
- 5,828
0
votes
1
answer
172
views
How can I verify that my query is causing no locks?
Suppose that I'm having a bad day and my confidence just isn't with me. Suppose also that I've written a query with set transaction isolation level read uncommitted. After it runs for a few minutes, I ...
- 1,642
0
votes
0
answers
398
views
pg_dump Transaction Isolation Level Error
I'm having a hard time finding a reason/solution for this error. I'm hoping someone else has seen this and has some direction. These commands have been successful in the past from this same host. I'...
- 1
0
votes
0
answers
77
views
What is the "contamination" parameter in the `isolation.forest` function in R?
What is the "contamination" parameter in the isolation.forest function of the isotree package in R?
https://www.rdocumentation.org/packages/isotree/versions/0.1.24/topics/isolation.forest
...
- 1,796