Stack Overflow
Stack Overflow

Questions tagged [dirtyread]

40 questions
0
votes
1 answer

Bulk loading in Cassandra, issue of dirty reads, and its effect in cluster

Our use case is load bulk data into our live production Cassandra cluster. We have to load bulk data in Cassandra on daily basis. We came across sstableloader. We have few queries around same: 1: When we are loading bulk data into our live…
Saurabh Kumar
  • 1
0
votes
1 answer

Reading data object in one transaction after comitting data object in another transaction - dirty read?

By definition, a dirty read is a read of uncommitted data. My question is: If you have several writes from different transactions in the same story happening right after each other (lets say transaction 1, 2 and 3), then at the end of the writes,…
per
  • 11
  • 3
0
votes
0 answers

Does Transaction Isolation Level Have to be Reset After Read

I am trying to dirty check a SQL Server table, but I am not sure whether or not the settings are saved to the table and will effect other reads, or automatically reset after the read. I would like the uncommitted flag to only be used each time the…
Matthew
  • 1,461
  • 3
  • 23
  • 49
0
votes
1 answer

start two independent transactions with mysql

I want to recreate a dirty read anomaly with two independent transactions. I've started the terminal twice and connected both with my database. I've started the transaction with the command start transaction; in both. Then I updated one information…
iamrobin.
  • 1,554
  • 3
  • 19
  • 31
0
votes
0 answers

observation about false sharing

I have an observation about false sharing, please look this code: struct foo { int x; int y; }; static struct foo f; /* The two following functions are running concurrently: */ int sum_a(void) { int s = 0; int i; for (i = 0;…
Giovanni Far
  • 1,623
  • 6
  • 23
  • 37
0
votes
0 answers

Best way to avoid dirty read in SQL server

I found by other posts that in SQL server a read can't be locked by another read. So I do as following BEGIN TRAN -- I used this update to lock specific row UPDATE TBL_BALANCE SET TBL_BALANCE.DUMMYCOLUMN = 1 SET WHERE TBL_BALANCE.ACCOUNT =…
Esty
  • 1,882
  • 3
  • 17
  • 36
0
votes
2 answers

Spring batch JdbcPagingItemReader missing un commit records

Batch has 4 steps 1. Do some basic task 2. pull records from input table -> process -> out table 3. validate error count, check count for records in input and output tables. 4. pull records from out table and update status is business tables. I…
saddy dj
  • 147
  • 1
  • 3
  • 13
0
votes
1 answer

How to avoid db lock

I am working on the backend of a game. Players first purchase their tickets, which are stored into the database, then they play and can win certain prizes. Each player can buy a max of 60 tickets. A new requirement appeared, setting an upper bound…
user998692
  • 5,172
  • 7
  • 40
  • 63
0
votes
2 answers

Is is possible in ruby to set a specific active record call to read dirty

I am looking at a rather large database.. Lets say I have an exported flag on the product records. If I want an estimate of how many products I have with the flag set to false, I can do a call something like this Product.where(:exported =>…
baash05
  • 4,394
  • 11
  • 59
  • 97
0
votes
3 answers

In Yii, can my Model read from a database view whilst creates, updates and deletes still go to the base table?

In Yii, can my Model read from a database view whilst creates, updates and deletes still go to the base table? Basically, any SELECT statements I want to be directed to a specific database view (maybe with some additional aggregate columns, or to…
Turgs
  • 1,729
  • 1
  • 20
  • 49
1 2
3