Stack Overflow
Stack Overflow

Questions tagged [read-uncommitted]

49 questions
1
vote
1 answer

Postgres - killing uncommitted transaction

I have read of a few ways to do this (namely, querying the pg_stat_activity table to get the pid to kill), but I have no data coming back in those queries. In other DBMSs like MSSQL, I could at least see the uncommitted data and/or use profiler to…
djsoteric
  • 188
  • 1
  • 10
1
vote
0 answers

Getting Uncommitted Transactions Sqlite With System.Data.Sqlite

I am trying to get a count of uncommitted records in a SQLite database using the System.Data.Sqlite library. My research thus far has pointed towards using the PRAGMA read_committed, but I always get a count of 0 until records are committed. Any…
user163757
  • 6,795
  • 9
  • 32
  • 47
1
vote
1 answer

Read uncommited rows created by postgresql function?

I wrote a function that creates a row in the table mytable accordingly to the parameters and returns the id of the created row. Unfortunately, if I use the following statement, the SELECT returns no row, as if the transaction of the function was…
poussma
  • 7,033
  • 3
  • 43
  • 68
1
vote
0 answers

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED on insert record

Consider the following SQL statement: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED BEGIN TRANSACTION insert into Customer(name) values('CustomerName') COMMIT Am I right in saying this Isolation Level is not needed since we are doing a simple…
dstewart101
  • 1,084
  • 1
  • 16
  • 38
1
vote
0 answers

Uncommitted Transaction Isolation Level

I am trying to understand how Transactions work in c# using the TransactionScope object. I have an understanding about them in SQL server but I don't know how to verify this in c#. For example I want to check if I set the IsolationLevel to…
Huma Ali
  • 1,759
  • 7
  • 40
  • 66
1
vote
2 answers

SQL Server long running transaction

I am wondering how resource expensive is to perform a begin transaction on a connection and imediatelly update/insert a row into a database and letting this transaction hanging for several hours. Basically I just want to perform a "series number"…
George Lica
  • 1,798
  • 1
  • 12
  • 23
1
vote
2 answers

How don't submit in a database but select the modified data

I have a database with multiple tables and the user can change the data in the table. my problems is that I wont that nothing changes in the database until the user click the button "save", and even when he do - it submit only the table he decide to…
chmouel kalifa
  • 129
  • 2
  • 11
1
vote
0 answers

NOLOCK at query level

I've a query to run a SQL server table, in which, I am not concerned with the exact count. So, I want to specify NOLOCK for that query. But, query itself consists of multiple subqueries and multiple joins; so, it's quite dirty to put NOLOCK all…
ptntialunrlsd
  • 794
  • 8
  • 23
1
vote
3 answers

Could an query with READ UNCOMMITTED isolation level cause locks on the tables it access?

My app needs to batch process 10M rows, the result of a complex SQL query that join tables. I'll plan to be iterating a resultset, reading a hundred per iteration. To run this on a busy OLTP production DB and avoid locks, I figured I'll query with a…
Gili Nachum
  • 5,288
  • 4
  • 31
  • 33
1
vote
2 answers

Read uncomitted data from HasMany-relationship with NHibernate

I have an NHibernate map which defines a HasMany-relationship on a type, i.e. a class has a list of another class. I would like NHibernate to be able to read uncommitted data including the list resulting from the HasMany-relationship. I have…
hlintrup
  • 169
  • 1
  • 13
1
vote
4 answers

uncommitted reads?

I was looking at potential concurrency issues in DB so i went to read up. I found http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/c0005267.htm and it mentions access to uncommitted data. Access to…
user34537
0
votes
0 answers

Transaction isolation READ_UNCOMMITED doesn't work

I have written an application using Springboot 2.0 to store books catalog in MySQL 8 database. Book information is being read from the file. Book object has a list of authors as there can be more than one author to the book. At the same time, author…
Gary Greenberg
  • 468
  • 1
  • 9
  • 22
0
votes
0 answers

Forgot WITH (READUNCOMMITTED) in SQL

At my company I was advised to always run SQL queries as follows: SELECT col1, col2 FROM table WITH (READUNCOMMITTED) WHERE table.id = my_id; It is a production database which is used by other applications and I only have read access. However I…
Ohumeronen
  • 1,769
  • 2
  • 14
  • 28
0
votes
0 answers

Spring Data JPA isolationlevel does not affect on SQLServer queries

I have a @Service layer class with several methods, which have @Transactional(isolation = Isolation.READ_UNCOMMITTED) annotated queries and @Transactional annotated write transactions. Sometime deadlock appears on transactions and I can see in…
István Scheer
  • 21
  • 3
0
votes
0 answers

Predicate CONTAINS doesn't return records with NOLOCK

I am writing integration tests and I use TransactionScope(TransactionScopeAsyncFlowOption.Enabled) for this purpose. I add some data to DB (MS SQL Server) and then check the result, compare it etc. When the test is passed, new data will not be saved…
Spiderman5
  • 23
  • 5
1
2
3 4