[ https://issues.apache.org/jira/browse/PHOENIX-4171?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16156157#comment-16156157 ]
Hadoop QA commented on PHOENIX-4171: ------------------------------------ {color:red}-1 overall{color}. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12885671/PHOENIX-4171_wip2_master.patch against master branch at commit ad52201e07670d342ef33c5e8bd2ee595fe559cc. ATTACHMENT ID: 12885671 {color:green}+1 @author{color}. The patch does not contain any @author tags. {color:red}-1 tests included{color}. The patch doesn't appear to include any new or modified tests. Please justify why no new tests are needed for this patch. Also please list what manual steps were performed to verify this patch. {color:green}+1 javac{color}. The applied patch does not increase the total number of javac compiler warnings. {color:green}+1 release audit{color}. The applied patch does not increase the total number of release audit warnings. {color:green}+1 lineLengths{color}. The patch does not introduce lines longer than 100 {color:red}-1 core tests{color}. The patch failed these unit tests: ./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.rpc.PhoenixServerRpcIT Test results: https://builds.apache.org/job/PreCommit-PHOENIX-Build/1386//testReport/ Console output: https://builds.apache.org/job/PreCommit-PHOENIX-Build/1386//console This message is automatically generated. > Creating immutable index is timing out intermittently > ----------------------------------------------------- > > Key: PHOENIX-4171 > URL: https://issues.apache.org/jira/browse/PHOENIX-4171 > Project: Phoenix > Issue Type: Bug > Reporter: Samarth Jain > Attachments: PHOENIX-4171_wip3_master.patch > > > In PHOENIX-4151, I converted all the tests extending BaseQueryIT to not use > current_scn anymore when creating tables and indices. This was done with the > assumption that somehow current_scn is causing index creation to timeout. > However, even after that change, I am seeing that the tests are still > flapping. And they are failing because creating immutable indexes is timing > out. > Sample run: https://builds.apache.org/job/PreCommit-PHOENIX-Build/1379/ > Stacktrace: > {code} > 2017-09-06 02:44:13,297 ERROR [main] > org.apache.phoenix.end2end.BaseQueryIT(141): Exception while creating index: > CREATE INDEX T000205 ON T000204 (a_integer DESC) INCLUDE ( A_STRING, > B_STRING, A_DATE) KEEP_DELETED_CELLS=false > java.sql.SQLTimeoutException: Operation timed out. > at > org.apache.phoenix.exception.SQLExceptionCode$15.newException(SQLExceptionCode.java:399) > at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150) > at > org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:932) > at > org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:846) > at > org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50) > at > org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97) > at > org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117) > at > org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64) > at > org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39) > at > org.apache.phoenix.compile.UpsertCompiler$1.execute(UpsertCompiler.java:734) > at > org.apache.phoenix.compile.DelegateMutationPlan.execute(DelegateMutationPlan.java:31) > at > org.apache.phoenix.compile.PostIndexDDLCompiler$1.execute(PostIndexDDLCompiler.java:117) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:3359) > at > org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1282) > at > org.apache.phoenix.schema.MetaDataClient.buildIndexAtTimeStamp(MetaDataClient.java:1222) > at > org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1588) > at > org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:393) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:376) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:374) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:363) > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1707) > at org.apache.phoenix.end2end.BaseQueryIT.<init>(BaseQueryIT.java:139) > at org.apache.phoenix.end2end.NotQueryIT.<init>(NotQueryIT.java:56) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > {code} > {code} > 2017-09-06 02:57:28,819 ERROR [main] > org.apache.phoenix.end2end.BaseQueryIT(141): Exception while creating index: > CREATE INDEX T000350 ON T000349 (a_integer, a_string) INCLUDE ( B_STRING, > A_DATE) KEEP_DELETED_CELLS=false > java.sql.SQLTimeoutException: Operation timed out. > at > org.apache.phoenix.exception.SQLExceptionCode$15.newException(SQLExceptionCode.java:399) > at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150) > at > org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:932) > at > org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:846) > at > org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50) > at > org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97) > at > org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117) > at > org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64) > at > org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39) > at > org.apache.phoenix.compile.UpsertCompiler$1.execute(UpsertCompiler.java:734) > at > org.apache.phoenix.compile.DelegateMutationPlan.execute(DelegateMutationPlan.java:31) > at > org.apache.phoenix.compile.PostIndexDDLCompiler$1.execute(PostIndexDDLCompiler.java:117) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:3359) > at > org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1282) > at > org.apache.phoenix.schema.MetaDataClient.buildIndexAtTimeStamp(MetaDataClient.java:1222) > at > org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1588) > at > org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:393) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:376) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:374) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:363) > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1707) > at org.apache.phoenix.end2end.BaseQueryIT.<init>(BaseQueryIT.java:139) > at org.apache.phoenix.end2end.QueryIT.<init>(QueryIT.java:66) > at sun.reflect.GeneratedConstructorAccessor118.newInstance(Unknown > Source) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)