These are chat archives for damianh/Cedar
One transaction creates events (event_id = 4,5,6) in data table but not finished yet. The second transaction starts (add new events with event_id = 7,8) and commits first. Projections thread reads events with optimized way (READPAST hint in MS SQL Server): 1,2,3,7,8 (4,5,6 are not committed yet) and stores the last sequence equals 8.
Then the first transaction commits.
Now, we have events from 1 to 8 but 4,5,6 are not processed by projections.