[DocDB] Observed Inconsistent sum of balance during bank workload with Parallel Queries

[archit-rastogi]

Jira Link: DB-14743

Description

Steps to reproduce:

1. Create universe and enable parallel query via gflags
2. Run sql bank sampe app workload with Read committed txn.
3. Periodically run analyze tables
4. Do random flush and compaction
5. Validate sum of balance with PQ

https://stress.dev.yugabyte.com/stress_test/ecc501da-1476-457b-8219-3562fc9c1e80

Downloads/archive/workload/172.151.19.81/workload-2a4c4a-SqlBankLargeValues.20241215123042.log
334283:java.lang.AssertionError: Expected 100000000 - actual 99998997, IndexScan,  WHERE id >= 0
334322:java.lang.AssertionError: Expected 100000000 - actual 99998997, SeqScan,  WHERE id >= 0
334374:java.lang.AssertionError: Expected 100000000 - actual 99998997, IndexOnlyScan,  WHERE id >= 0
334594:java.lang.AssertionError: Expected 100000000 - actual 99998997, SeqScan,  WHERE id >= 0
334683:java.lang.AssertionError: Expected 100000000 - actual 99998997, SeqScan, 
334688:java.lang.AssertionError: Expected 100000000 - actual 99998997, SeqScan,  WHERE id >= 0
334693:java.lang.AssertionError: Expected 100000000 - actual 99998997, SeqScan, 
334698:java.lang.AssertionError: Expected 100000000 - actual 99998997, SeqScan,  WHERE id >= 0
334724:java.lang.AssertionError: Expected 100000000 - actual 99998997, SeqScan, 
334771:java.lang.AssertionError: Expected 100000000 - actual 99998997, IndexOnlyScan,  WHERE id >= 0
334839:java.lang.AssertionError: Expected 100000000 - actual 99998997, IndexOnlyScan,  WHERE id >= 0
334866:java.lang.AssertionError: Expected 100000000 - actual 99998997, IndexOnlyScan,  WHERE id >= 0
334892:java.lang.AssertionError: Expected 100000000 - actual 99998997, SeqScan, 
334897:java.lang.AssertionError: Expected 100000000 - actual 99998997, IndexOnlyScan, 
334902:java.lang.AssertionError: Expected 100000000 - actual 99998997, IndexOnlyScan,  WHERE id >= 0
334907:java.lang.AssertionError: Expected 100000000 - actual 99998997, IndexOnlyScan,  WHERE id >= 0

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.

[archit-rastogi]

Investigating the logic in sample app used to run above test.

[archit-rastogi]

The issue was caused to logic error in sample app being used for testing. Hence closing the issue.
cc: @sushantrmishra @rthallamko3