1,563 questions
0
votes
0
answers
36
views
Transactions not rolled back in FrankenPHP worker mode cause data loss after deployment — has anyone experienced this?
I’m running an application using FrankenPHP in worker mode. In one script, I use BEGIN TRANSACTION → SELECT → INSERT → COMMIT if certain conditions are met. But I forgot to call ROLLBACK when the ...
- 1
2
votes
1
answer
77
views
How do I perform a rollback in multiple models?
I have this class in rails
class ServiceClass < ApplicationService
attr_reader :resource
def initialize(resource)
@resource = resource
end
def call
ActiveRecord::Base.transaction ...
2
votes
1
answer
103
views
Roll back a commit?
Note: This question focuses on web apps utilising MySQL's transactions - commit and rollback. Even though the code samples below use Python, the problem itself is not limited to the choice of ...
- 1,344
1
vote
0
answers
24
views
How do you use hg commit --amend to replicate the functionality of the deprecated hg rollback
I have Mercurial Distributed SCM (version 6.1.1). I enabled and used the "uncommit" extension to solve the particular problem below, but I still want to know how I was supposed to do it with ...
- 1,651
0
votes
0
answers
62
views
System.Data.Entity.Infrastructure.CommitFailedException
System.Data.Entity.Infrastructure.CommitFailedException: An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the ...
1
vote
1
answer
97
views
Using multiple rest calls in angular in an atomic way
I'm learning Angular, Spring Boot and Hibernate at the moment and I found a good tutorial on that. But I have a problem where I can't find the answer. There are occasions where I have multiple REST ...
- 1,279
2
votes
1
answer
559
views
Why I am unable to rollback my transaction to particular savepoint in plpgsql stored procedure
I am getting error while executing stored procedure on pgadmin at "To" in "Rollback to Savepoint".
CREATE OR REPLACE PROCEDURE demo8()
AS $$
BEGIN
INSERT INTO statefis VALUES(83,...
0
votes
1
answer
764
views
ORA-01002: Fetch out of Sequence caused by for loop and update statement
I had a procedure which currently look like this in Oracle Database 19C
Declare
i integer;
BEGIN
Delete from t_invent;
-- If I add commit here or remove the delete statement here then the error ...
- 53
1
vote
1
answer
78
views
Identify error in multiple Insert statements and rollback
I have a scenario where I have to insert into 10 tables. The code looks like this:
create or replace procedure insert_into_tbls
as
begin
savepoint s1;
insert into tab1;
insert into tab2;
...
- 43
0
votes
1
answer
79
views
ROLLBACK in ORACLE fails
SELECT * FROM BOOKS; -- 100 ROWS returned.
DELETE FROM BOOKS; -- 100 rows deleted
SELECT * FROM BOOKS; -- no rows returned.
ROLLBACK; --Rollback complete.
SELECT * FROM BOOKS; -- no rows ...
- 5
0
votes
1
answer
189
views
Transactions inside functions in SurrealDB
Is there a way to commit data inside a function in SurrealDB? It throws a syntax error if I place BEGIN TRANSACTION within the { and } blocks:
There was a problem with the database: Parse error: ...
- 3,988
0
votes
1
answer
42
views
JPA @Transactioanl REQUIRES_NEW AND Catch RuntimeException But rollback
@Service
@RequiredArgsConstructor
@Transactional
public class UserService {
public void createUser(CreateUserRequest request) {
Users users = firebaseUsersRepository.findUsersByFirebaseUid(...
1
vote
1
answer
162
views
Laravel - Rollback specific eloquent transaction after many other transactions committed
I will try as much as I can to explain my question,
let's say that I have a shipping system that many admins using,
one of the shipping steps is to put a selected packages in a container,
the problem: ...
- 19
0
votes
1
answer
46
views
how to rollback changes in git not on commit but on logs
how to rollback in git to yesterday or to the log I need, the problem is that I didn't do the commit, it is there but it is too old changes. I have a main branch on a remote repository main: develop ...
0
votes
1
answer
46
views
Data rolled back after 5-7 minutes of running the update on table successfully
I ran an update on the SQL table using the below code, and it updated the table correctly. But after 5-7 minutes, the data rolls back. Why does this happen? I don't see any logs or errors in the SQL ...
