transactions Questions
2
Solved
In laravel 5.5 with MySQL I use \Illuminate\Support\Facades\DB to create transactions this way:
DB::transaction(function() {
...
});
What is the isolation level for such transaction and is ther...
Ursas asked 4/12, 2017 at 22:36
3
Solved
In PostgreSQL transaction access mode can be changed to READ ONLY (docs). In SQLAlchemy, isolation level can be changed for an engine, but no parameter is provided for read-only access mode (docs)....
Hyponitrite asked 18/9, 2014 at 4:7
5
Solved
The basic structure of my procedure is:
BEGIN
START TRANSACTION;
.. Query 1 ..
.. Query 2 ..
.. Query 3 ..
COMMIT;
END;
MySQL version: 5.1.61-0ubuntu0.11.10.1-log
Currently, if 'query 2' fa...
Favela asked 2/4, 2012 at 9:58
1
First, I set John to the user-defined variable @name as shown below:
SET @name = 'John';
Then, I set David to @name in a transaction, then rollbacked as shown below:
BEGIN;
SET @name = 'David';
RO...
Doordie asked 14/12, 2023 at 22:59
3
Solved
I've read this article (assumes I already know what a transaction boundary is) and this SO question (can't decipher meaning of transaction boundary from that question). In other words, there are no...
Calling asked 15/11, 2018 at 7:16
4
If a procedure fails in middle, are changes at that point from the beginning of SP rolled back implicitly or do we have to write any explicit code to make sure that SP runs in a transaction only?
Platonism asked 31/1, 2015 at 10:2
7
Is a PostgreSQL function such as the following automatically transactional?
CREATE OR REPLACE FUNCTION refresh_materialized_view(name)
RETURNS integer AS
$BODY$
DECLARE
_table_name ALIAS FOR $1...
Franconian asked 8/10, 2012 at 8:48
2
Solved
Recently I've read multiple times that two-phase commits are bad, but always as a side note. So there was never a good explanation with it.
For example in CQRS Journey Chapter 5:
Second, we're ...
Kvass asked 2/10, 2015 at 13:38
2
Solved
I have the following schema
ID (PK)| REF_ID | ACTIVE | STATUS
ID - Primary Key
I am using following query to select and update
BEGIN;
select * from table where ref_id = $1 and is_active i...
Formally asked 27/6, 2018 at 20:20
3
Solved
I'm a little bit confused reading about PostgreSQL deadlocks.
A typical deadlock example is:
-- Transaction 1
UPDATE customer SET ... WHERE id = 1
UPDATE customer SET ... WHERE id = 2
-- Transac...
Duala asked 20/4, 2012 at 11:41
6
Solved
I need to make sure many concurrent users be able to access the database. Although after each commit I close the session but sometimes my code runs into following error, but when I do the same oper...
Advance asked 9/7, 2013 at 7:11
11
Solved
I am getting the following error when I try to call a stored procedure that contains a SELECT Statement:
The operation is not valid for the state of the transaction
Here is the structure of my...
Coniine asked 10/10, 2008 at 21:49
4
Solved
I have this scenario:
fetch (read and delete) a record from IncomingMessage table
read record content
insert something to some tables
if an error (any exception) occurred in steps 1-3, insert an e...
Megathere asked 13/10, 2013 at 20:26
8
Solved
I'm having a similar issue to The current transaction cannot be committed and cannot support operations that write to the log file, but I have a follow-up question.
The answer there references Usi...
Chasseur asked 20/9, 2011 at 15:59
3
Solved
I'm using Spring Boot (1.4.4.REALEASE) with Spring Data in order to manage a MySql Database. I've got the following case:
We update one revision performed in one equipment using the RevisionServi...
Population asked 17/2, 2017 at 9:42
7
I am trying to insert some values in table throught the application and get issue ORA-00001: unique constraint violated.
I see that sequences are out of sync with the highest id of the table, but e...
Hindorff asked 13/3, 2012 at 17:55
2
Solved
From the docs Read isolation consistency - Sessions (emphasis mine)
To provide causal consistency, MongoDB 3.6 enables causal consistency in client sessions. A causally consistent session denote...
Staub asked 14/8, 2018 at 10:51
10
Solved
I have a long running TransactionScope in C#. I told the scope that it should have a long timespan, but still I get a timeout. What could cause this?
TransactionOptions transactionOptions = new Tr...
Arvonio asked 21/8, 2012 at 13:5
2
Solved
In PostgreSQL, the MVCC concurrency control mechanism says that:
MVCC locks acquired for querying (reading) data do not conflict with
locks acquired for writing data, and so reading never block...
Staunch asked 30/5, 2015 at 12:30
2
Found this line in an application I just took over, and it doesn't make much sense.
using (new TransactionScope(TransactionScopeOption.Suppress, new TimeSpan(1,0,0))) {
This occurs immediately in...
Draggletailed asked 15/4, 2013 at 18:23
6
Solved
We have client app that is running some SQL on a SQL Server 2005 such as the following:
BEGIN TRAN;
INSERT INTO myTable (myColumns ...) VALUES (myValues ...);
INSERT INTO myTable (myColumns ...) V...
Grammatical asked 17/11, 2009 at 15:38
5
Considering the common use case of a user creating a new account on a web application and the application sending a confirmation email to the user's address. From what I've seen, this is typically ...
Haggi asked 2/12, 2010 at 3:30
3
My program needs to add data to two lists in Redis as a transaction. Data should be consistent in both lists. If there is an exception or system failure and thus program only added data to one list...
Chaiken asked 20/9, 2016 at 4:50
10
Solved
What is the relationship between ACID and database transaction?
Does ACID give database transaction or is it the same thing?
Could someone enlighten this topic.
Conflux asked 18/9, 2010 at 3:35
3
Solved
We're using SQLAlchemy declarative base and I have a method that I want isolate the transaction level for. To explain, there are two processes concurrently writing to the database and I must have t...
Periwig asked 19/8, 2010 at 5:5
© 2022 - 2024 — McMap. All rights reserved.