16,334 questions
1
vote
1
answer
136
views
Massive performance overhead for @Transactional methods
using a Spring Boot (3.5) service and an Azure hosted MySQL 8 Database I found that we have quite a lot of performance loss when calling methods that are annotated as @org.springframework.transaction....
- 2,835
1
vote
1
answer
63
views
Stateless REST API to poll new records
I'm working on this application that records operations performed within the application as events. Each operation is recorded as a separate row in the table events. The row is written in the same ...
- 10k
1
vote
1
answer
43
views
“Restart read required” error during concurrent inserts and reads
We are experiencing transactional conflicts in a YugabyteDB (PostgreSQL API) setup involving two microservices:
Service A is performing high-throughput inserts (300+ TPS) into a shared table.
Service ...
- 1,158
0
votes
1
answer
25
views
Delete then create entity using Spring JPA with Hibernate and @Transactional violates unique key constraints
Setup: SpringBoot application using SpringJPA with Hibernate
I have two entities: A and B. Set is a child of A.
I want to remove a B and create another one in a characteristic which would hit a unique ...
- 52
0
votes
1
answer
87
views
SQLAlchemy, FastAPI, Dishka. Cannot use Connection.transaction() in a manually started transaction
The code is used in many projects and everything works. But in one service, sometimes an error occurs on the prod:
sqlalchemy.exc.InterfaceError: (sqlalchemy.dialects.postgresql.asyncpg.InterfaceError)...
0
votes
0
answers
30
views
Detecting token creations with Solana Program Library not working as it should be
Here's my current code:
const {Connection, PublicKey} = require("@solana/web3.js");
const bs58 = require('bs58');
// Program IDs for monitoring logs
const TOKEN_PROGRAM_ID = new PublicKey('...
- 1
2
votes
0
answers
71
views
IBM DB2 stored procedure transaction has a strange behavior
I have this code into an IBM DB2 stored procedure, when I send the @action = 'I', then the INSERT statement is executed successfully, but when I send @action = 'D', the DELETE statement remains in ...
- 39
0
votes
1
answer
20
views
Can a basic database be opened by a optimistictransactiondb or transactiondb in rocksdb?
I had created a base database with rocksdb::Open() and written some data to it.
Can I close it and open it with OptimisticTransactionDB::Open() for the transactional support? Will the existing data ...
- 461
3
votes
1
answer
57
views
"invalid transaction termination" when executing dynamic sql
I am trying to do some transaction management in calls invoked by dynamic sql (EXECUTE).
The following works:
CREATE or replace PROCEDURE transaction_test1()
LANGUAGE plpgsql
AS $$
DECLARE r RECORD;
...
- 363
1
vote
2
answers
66
views
How to retrieve AutoCAD SymbolTable Entries By Name using C#
After years of using vb.net I am trying to learn C# by converting many of my old custom AutoCAD libraries from vb.net to C#. I am having a hard time referencing symbol table objects (dimstyles, ...
0
votes
2
answers
75
views
How to lock database fields for all containers with Java
Concurrent Access to Database Records in Quarkus
I have a Quarkus application with two containers that are accessing the same database records on a schedule. The records have a field that is marked as ...
- 1,368
0
votes
1
answer
71
views
Sleeping Sessions with NULL sql_text and sql_command
I'm monitoring my SQL Server environments (local setup, various versions like SQL Server 2017, 2019, 2022) and frequently encounter sessions that appear as sleeping but have sql_text and sql_command ...
- 1
0
votes
1
answer
90
views
Spring Data JPA @Modifying DELETE query not working - old tokens remain in database
Problem Summary
I'm trying to delete old email verification tokens before creating new ones in my Spring Boot application. The SQL DELETE query works perfectly when executed directly in the database, ...
0
votes
0
answers
25
views
How should one prevent a DDB item being deleted unless there are no items left which reference it?
Let's say I have 2 types of item in my DDB table: Trains and Passengers. They look like this:
{
"type": "train",
"id": "OrientExpress" // partition key
}
{
...
- 1,017
0
votes
0
answers
28
views
How to properly use DataSource in Micronaut to avoid ‘No current connection present’ error?
I’m integrating with an ORM framework that requires a DataSource to execute SQL statements. In my Micronaut application, I’m trying to obtain the DataSource by calling
ApplicationContext.getBean(...
- 11