A rollback is reverting data to a previous state. Typically questions in this tag involve transactions in Relational Database Management Systems, where a ROLLBACK command is used to discard any changes to the data since a transaction started.
Questions tagged [rollback]
1545 questions
0
votes
1 answer
Will killing a large InnoDB rollback hurt my tables?
Using phpMyAdmin's "Copy Database" feature, I started copying one database with ~5M rows to another on the same server. About halfway through (2 hours or so) the server started crashing, and I had to kill the mysqld process.
MySQL is killing my…
Luke Shaheen
- 4,262
- 12
- 52
- 82
0
votes
4 answers
Rollback insert statement
I have inserted a significant quantity of records into a table. Unfortunately, these records should not have been inserted in this table. Deletion of the records in a one-by-one fashion is not feasible.
How can one rollback the aforementioned…
Waheed
- 10,086
- 20
- 53
- 66
0
votes
1 answer
How to stop rollback in TestNG?
I have a test like this:
@ContextConfiguration(locations = { "file:war/WEB-INF/application-context.xml" })
public class ServiceImplTest extends AbstractTestNGSpringContextTests
{
@Autowired
private Service service;
@Rollback(false)
…
Alex Luya
- 9,412
- 15
- 59
- 91
0
votes
0 answers
DataContext update and rollback
I'm having a problem with my DataContext. In the following code snippet, I first delete existing objects in my datacontext, and later in same code, adding new again. The problem is, since I'm using .DeleteOnSubmit() its still containing 2 entities…
grmihel
- 784
- 3
- 15
- 40
0
votes
2 answers
PHP/MySQLi What happens if a crash occurs during execution of a complex procedure?
I'm developing a php/MySQLi based site. I have a question about what might happen if the page for some reason crashes in the middle of executing a complex procedure.
Example:
if (get_message_call)
{
add something to table 1
add something…
Markus
- 616
- 1
- 9
- 24
0
votes
1 answer
Return JSON after PHP PDO Transaction Rollback
I have an AJAX call with jQuery that calls a PHP script, then returns some information in JSON format back to the success or error function like so:
$.ajax({
url: 'crud/clients.php',
dataType: 'json',
type: 'POST',
data: {
…
FastTrack
- 8,810
- 14
- 57
- 78
0
votes
2 answers
Transactions in SQL coming from pymssql rollback on their own
We have a developer connecting to SQL Server using pymssql which uses freetds. His script dynamically generates sql insert queries based on values in a MySQL DB.
The statements are parsed properly and have proper begin transaction/commits in them…
Ali Razeghi - AWS
- 722
- 1
- 6
- 19
0
votes
2 answers
MS SQL 2005- Rollback Update query
I'm using MS SQL Server 2005 enterprise edition. I executed an update query to get affect a record in a row and a column.
update HS_SM_USERACCOUNT
set ACCOUNTPOLICYTYPE=1
where EMP_NUMBER='000540' and USERID='03510410@'
Earlier the column…
0
votes
1 answer
iOS Coredata rollback is not working
In my app I'm following CoreDataBooks for implementing Core data. I have a list of items, when user selects any item, a detail screen comes up with edit option. The details screen is having instance of ManagedObjectContext which is child of…
Jitendra Singh
- 2,103
- 3
- 17
- 26
0
votes
1 answer
WIX: Uninstall is not happening properly
I'm using WIX Installer with Custom Action.
In one scenario I'm unable to uninsall the product properly.
scenario:
installed base version appliation
trying to upgrade it.
An exception occured, rollback is done to previous version
(we have…
Chakri
- 151
- 2
- 13
0
votes
1 answer
Java + Sql database data rollback is not working
In my application, I am writing data to a database.
This is the code for database writing.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class DatabaseRollback…
Pradeep Gamage
- 585
- 4
- 8
- 21
0
votes
0 answers
T SQL Sequence number column
Possible Duplicate:
Read and Increment int value in SQL Server
I am currently working on "Double Entry Accounting" in relational database.
According to the article, it quotes
"The primary key or part of the primary key of the 'POSTING' table…
PYSW
- 1
0
votes
1 answer
Transaction-per-session or transaction-per-query pattern in Hibernate?
We have a servlet to serve many concurrent requests and sometimes some request throw exceptions. I saw this warning from Hibernate guide:
"If the Session throws an exception, including any SQLException,
immediately rollback the database…
QuangHD
- 1
- 1
- 3
0
votes
1 answer
rollback PHP - CodeIgniter
I am new to CI and PHP too.
I have a form that which add a company and its contacts to the server including file upload .
i need all things on one button click.
so
function create_company()
{
$insert = $this->database->insert();
return…
Red
- 6,230
- 12
- 65
- 112
0
votes
4 answers
Who is right? - SQL Rollback Question
a few minutes ago I had a discussion with my boss and want now more meanings, if I am wrong or he is.
Following problem is given:
After a fast change from a colleague a stored procedure went wrong.
(I think for the theory here is no more information…
PassionateDeveloper
- 14,558
- 34
- 107
- 176