[
https://issues.apache.org/jira/browse/PHOENIX-4151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16154482#comment-16154482
]
James Taylor commented on PHOENIX-4151:
---------------------------------------
Would this work?
# Get and remember current time (t1)
# Do DML without SCN
# Get new connection specifying current time of t1
# Execute query (this wouldn't see the changes from the DML done in step 2)
# Execute query at old connection, the one without an SCN. You should see the
changes from the DML.
> Tests extending BaseQueryIT are flapping
> ----------------------------------------
>
> Key: PHOENIX-4151
> URL: https://issues.apache.org/jira/browse/PHOENIX-4151
> Project: Phoenix
> Issue Type: Bug
> Reporter: Samarth Jain
> Assignee: Samarth Jain
> Attachments: PHOENIX-4151_wip_master.patch, PHOENIX-4151_wip.patch
>
>
> Sample failures:
> {code}
> ERROR]
> testNotInListOfFloat[NotQueryIT_1](org.apache.phoenix.end2end.NotQueryIT)
> Time elapsed: 0.001 s <<< ERROR!
> java.lang.RuntimeException: java.sql.SQLTimeoutException: Operation timed out.
> at org.apache.phoenix.end2end.NotQueryIT.<init>(NotQueryIT.java:56)
> Caused by: java.sql.SQLTimeoutException: Operation timed out.
> at org.apache.phoenix.end2end.NotQueryIT.<init>(NotQueryIT.java:56)
> {code}
> {code}
> [ERROR] testValidStringConcatExpression[indexDDL=CREATE INDEX %s ON %s
> (a_integer, a_string) INCLUDE ( B_STRING, A_DATE)
> %s,mutable=false,columnEncoded=false](org.apache.phoenix.end2end.QueryIT)
> Time elapsed: 0.014 s <<< ERROR!
> java.lang.RuntimeException: java.sql.SQLTimeoutException: Operation timed out.
> at org.apache.phoenix.end2end.QueryIT.<init>(QueryIT.java:66)
> Caused by: java.sql.SQLTimeoutException: Operation timed out.
> at org.apache.phoenix.end2end.QueryIT.<init>(QueryIT.java:66)
> {code}
> {code}
> [ERROR]
> testNullMultiCondCaseStatement[CaseStatementIT_1](org.apache.phoenix.end2end.CaseStatementIT)
> Time elapsed: 0.007 s <<< ERROR!
> java.lang.RuntimeException: java.sql.SQLTimeoutException: Operation timed out.
> at
> org.apache.phoenix.end2end.CaseStatementIT.<init>(CaseStatementIT.java:58)
> Caused by: java.sql.SQLTimeoutException: Operation timed out.
> at
> org.apache.phoenix.end2end.CaseStatementIT.<init>(CaseStatementIT.java:58)
> {code}
> My hunch is that timeouts are happening when creating tables or indices.
> Probably some sort of a timestamp/scn issue. [~jamestaylor] - any ideas?
> Would injecting our own clock in EnvironmentEdge help?
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
