Questions tagged [rollback]

0 votes
1 replies
Python3: Does a call to pymysql.rollback() require a commit?
I'm using python3.6 and pymysql 0.7.11. The call to rollback rolls a transaction back, according to the documentation. A call to commit finali...
asked 4 months ago
0 votes
0 replies
Rollback from scss to css version stays under scss
I registered in a commit my version under .css to try to transform it with under .scss. I first replaced all "css" words/parts of words of the a...
asked 4 months ago
0 votes
0 replies
Delete Trigger Not Activating Upon Met conditions
I have been asked to 'create a trigger to check: When someone is trying to recycle a PC (delete), a warning message ‘No, you cannot delete any PC...
asked 4 months ago
0 votes
0 replies
SQL Server unexpectedly rolling back transaction
Using SQL Server 2016+ and VB.Net I am currently seeing an issue where I have gaps in my logs. These logs are created by manually inserting inf...
asked 4 months ago
0 votes
0 replies
Data will be lost after running minitest completely
I setup minitest to test my code. But I realized that Data will be lost after running test. In some cases data will still alive in db_test. Wha...
1 votes
1 replies
Problems with mysqli_rollback() using PHP and InnoDB engine
I have problems with rollback inside my code, I'm using PHP and the engine of all my tables are InnoDB. Below is a part of my PHP code. mysqli_a...
asked 5 months ago
1 votes
0 replies
CondaRevisionError: Cannot revert to 3, since XX is not in repodata
I have an environment in conda, that has been screwed up after an install. When I try rolling it back to its previous state I get an error :...
asked 6 months ago
0 votes
0 replies
db data rollback best practices
I am wondering if its possible with database migration utilities like flyway or something else to do db migration rollback incase of a issue in p...
asked 5 months ago
1 votes
1 replies
Git rollback only a directory
This is the history of my last commits: (most recent) commit 349aee3, changes in /dir1 and /dir2 commit fe9a5ac, changes in /dir1 and /dir2 comm...
asked 5 months ago
0 votes
0 replies
How to get the real exception from a rollback transaction
I want to rollback a transaction when returning a checked exception. I am using @Transactional(rollbackOn = SomeCheckedException.class) and It wo...
0 votes
2 replies
In a Flask application that is using SQLAlchemy, is it ok to permanently put `session.rollback` at the beginning of the app?
I'm new to Flask and web development in general. I have a Flask web-application that is using SQLAlchemy, is it ok to put session.rollback at the...
asked 6 months ago
0 votes
1 replies
After execute the rollback instruction, my table data wont go back
After i type ROLLBACK; the data in the table departments_dup didnt rollback. CREATE TABLE departments_dup ( dept_no CHAR(4) NOT NULL, d...
asked 7 months ago
0 votes
0 replies
Rollback DB with real data when using pytest-django, pytest-splinter and pytest-bdd
For BDD of our Django project, we combine pytest-splinter with py-test django (and pytest-bdd). We run our test on real data. Therefore, we woul...
0 votes
1 replies
Will my query be required to “rollback” its changes if I cancel its execution
I've no idea about transactions in SQL Manager (SSMS) in general. We have a query that we didn't expect to run as long as it did and we're wonder...
0 votes
1 replies
Spring-tx: Rollback only if exception is uncaught by outmost method
By default, spring framework can rollback when unchecked exception is thrown across the boundary of a transactional method. But in case of transa...
asked 7 months ago
1 votes
1 replies
Rollback nested transaction and log error - in Trigger, Sql Server 2008
I have a trigger (that may modify a value on the insert) on insert statements to a table. If an error occurs in the trigger, I want to log it. An...
0 votes
0 replies
Set autocommit off using postgresql dblink [duplicate]
I am working in a Java application where I need to execute these the two queries (as Strings in java) at the same time and rollback the transacti...
0 votes
0 replies
Cloudformation rollback succeed when resource was deleted from outside
I am trying to understand rollback behavior in AWS Cloudformation. Assume I have successfully created AWS::WAFRegional::Rule. Then I deleted it m...
1 votes
0 replies
Error handling along with roll back and commit option with error message in MySQL
I have a stored procedure, which has handlers with flag for roll back, how do I get the error message from the handler. I have declared handlers...
0 votes
0 replies
What to do with a SqlAlchemy session only used for reads?
I have created a context manager to get a transactional session, following the instructions here: @contextmanager def session_scope(): """Pr...
asked 4 months ago
0 votes
0 replies
Quartz intergated to Spring with 'SchedulerFactoryBean' but no job and triggers records on database
I tried to run a quartz job while the application startup. The code is as follows: @Bean public SchedulerFactoryBean scheduler(DataSource dataSo...
asked 4 months ago
1 votes
1 replies
What happens if transaction.Rollback/Commit never called in before closing the connection?
What happens if transaction.Rollback/Commit never called in before closing the connection ? public DBStatus InsertUpdateUserProfile(Int64 UserID...
asked 4 months ago
1 votes
1 replies
TFS: How can i merge same changeset to target branch again/multiple time
I have two branch on TFS 1. SourceBranch 2. TargetBranch My Working copy is SourceBranch. Now there are 5 Changeset in my SourceBranch Chset01,...
asked 5 months ago
1 votes
1 replies
Can we use rollback(transactions) in Azure blob while uploading multiple files using SSIS package?
I am using ssis to upload multiple files to azure blob storage. Requirement is when any of the file upload fail we need to rollback transactions....
0 votes
1 replies
How to rollback my delete data in Postgres after delete operation?
I have not done anything. I just run this command DELETE FROM feed_republic. But I want to get my data again. What should I do? When I run rollb...