[PHOENIX-4119] Upsert uses timestamp of server holding table metadata

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 4.8.0
• Assignee: Unassigned
• Reporter: Mark Christiaens
• Created: 24/Aug/17 07:45
• Updated: 25/Aug/17 06:54
• Resolved: 24/Aug/17 18:12

Description

When doing an upsert, I noticed that the resulting put-command to HBase uses a timestamp obtained from the server managing the corresponding table's metadata (cfr. https://issues.apache.org/jira/browse/PHOENIX-1674?focusedCommentId=14349982&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14349982).

Now, if the row that is updated resides on a second server, that second server could have some clock skew. After the upsert, if you fetch that updated row without specifying an explicit query timestamp, then you might not see the effects of the upsert until the second server's clock has caught up with the first server's clock.

I think that the desired behavior is that the puts performed occur with a timestamp derived from the region server where their rows are stored. (Of course, that still leaves the problem of region migration from one server to the next but it's a step in the right direction).

Issue Links

• is related to: PHOENIX-1674 Snapshot isolation transaction support through Tephra