[PHOENIX-5084] Changes from Transactional Tables are not visible to query in different client

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 4.15.0, 4.14.1
• Fix Version/s: 4.15.0, 5.1.0, 4.14.2
• Assignee: Lars Hofhansl
• Reporter: Lars Hofhansl
• Created: 27/Dec/18 20:59
• Updated: 15/Jan/21 08:54
• Resolved: 02/Jan/19 09:01

Description

Scenario:

1. Upsert and commit some data into a transactional table. (Autocommit or following by explicit commit)
2. Query same table from another client

The first query on the other client will not see the newly upserted/committed data (regardless of how long one waits).
A second identical query will see the new data.

This happens with both Omid and Tephra.

I guess we can't write a test for this, since it requires multiple JVMs.

Issue Links

• relates to: PHOENIX-5082 Observations about the Phoenix-Omid integration