[jira] [Commented] (PHOENIX-3200) Error trying to remove Hash Cache
[
https://issues.apache.org/jira/browse/PHOENIX-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15691038#comment-15691038
]
Nithin commented on PHOENIX-3200:
-
Hi [~guoquan], Dont keep the connection alive till you complete all the
inserts. Create and destroy the connection for every record/row insertion.
> Error trying to remove Hash Cache
> -
>
> Key: PHOENIX-3200
> URL: https://issues.apache.org/jira/browse/PHOENIX-3200
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.7.0
> Environment: Amazon EMR 4.7.2
>Reporter: Nithin
>Priority: Critical
> Labels: Hbase, Phoenix
> Fix For: 4.7.0
>
>
> Data Set Consists of 500 Million Rows with each row consisting of 132 Columns
> (With various data types including Big-Int). Data Load was unsuccessful with
> the following error after loading 344 Million Rows. Please Note that 2 of the
> salted table's regions are split at this moment.
> 13:03:48.645 [pool-2-thread-2] ERROR
> org.apache.phoenix.cache.ServerCacheClient - Error trying to remove hash
> cache for region=EPOEVENT,,1471683321681.6d9e058365a24e63e5802ca783c09660.,
> hostname=ip-172-31-8-132.us-west-2.compute.internal,60020,1471683102656,
> seqNum=1935501 org.apache.hadoop.hbase.client.RetriesExhaustedException:
> Failed after attempts=35, exceptions:
> Tue Aug 23 12:54:36 UTC 2016,
> RpcRetryingCaller{globalStartTime=1471956876660, pause=100, retries=35},
> org.apache.hadoop.hbase.regionserver.RegionServerAbortedException:
> org.apache.hadoop.hbase.regionserver.RegionServerAbortedException: Server
> ip-172-31-8-129.us-west-2.compute.internal,60020,1471683105586 aborting
> at
> org.apache.hadoop.hbase.regionserver.RSRpcServices.checkOpen(RSRpcServices.java:1087)
> at
> org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1967)
> at
> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112)
> at
> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
> at java.lang.Thread.run(Thread.java:745)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (PHOENIX-3200) Error trying to remove Hash Cache
[
https://issues.apache.org/jira/browse/PHOENIX-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15689783#comment-15689783
]
guoquan commented on PHOENIX-3200:
--
Hi [~maryannxue], I have the same problem using Mybatis integration Phoenix
JDBC connection, I saw you said that it was caused by using Phoenix JDBC
connection as a persistent connection. Can you tell me how to solve it. THX
> Error trying to remove Hash Cache
> -
>
> Key: PHOENIX-3200
> URL: https://issues.apache.org/jira/browse/PHOENIX-3200
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.7.0
> Environment: Amazon EMR 4.7.2
>Reporter: Nithin
>Priority: Critical
> Labels: Hbase, Phoenix
> Fix For: 4.7.0
>
>
> Data Set Consists of 500 Million Rows with each row consisting of 132 Columns
> (With various data types including Big-Int). Data Load was unsuccessful with
> the following error after loading 344 Million Rows. Please Note that 2 of the
> salted table's regions are split at this moment.
> 13:03:48.645 [pool-2-thread-2] ERROR
> org.apache.phoenix.cache.ServerCacheClient - Error trying to remove hash
> cache for region=EPOEVENT,,1471683321681.6d9e058365a24e63e5802ca783c09660.,
> hostname=ip-172-31-8-132.us-west-2.compute.internal,60020,1471683102656,
> seqNum=1935501 org.apache.hadoop.hbase.client.RetriesExhaustedException:
> Failed after attempts=35, exceptions:
> Tue Aug 23 12:54:36 UTC 2016,
> RpcRetryingCaller{globalStartTime=1471956876660, pause=100, retries=35},
> org.apache.hadoop.hbase.regionserver.RegionServerAbortedException:
> org.apache.hadoop.hbase.regionserver.RegionServerAbortedException: Server
> ip-172-31-8-129.us-west-2.compute.internal,60020,1471683105586 aborting
> at
> org.apache.hadoop.hbase.regionserver.RSRpcServices.checkOpen(RSRpcServices.java:1087)
> at
> org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1967)
> at
> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112)
> at
> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
> at java.lang.Thread.run(Thread.java:745)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (PHOENIX-3200) Error trying to remove Hash Cache
[
https://issues.apache.org/jira/browse/PHOENIX-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15449729#comment-15449729
]
Maryann Xue commented on PHOENIX-3200:
--
Hi [~nvommi], thank you for reporting the issue. Could you please attach the
DDL and sample data here? and also for PHOENIX-3202?
> Error trying to remove Hash Cache
> -
>
> Key: PHOENIX-3200
> URL: https://issues.apache.org/jira/browse/PHOENIX-3200
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.7.0
> Environment: Amazon EMR 4.7.2
>Reporter: Nithin
>Priority: Critical
> Labels: Hbase, Phoenix
> Fix For: 4.7.0
>
>
> Data Set Consists of 500 Million Rows with each row consisting of 132 Columns
> (With various data types including Big-Int). Data Load was unsuccessful with
> the following error after loading 344 Million Rows. Please Note that 2 of the
> salted table's regions are split at this moment.
> 13:03:48.645 [pool-2-thread-2] ERROR
> org.apache.phoenix.cache.ServerCacheClient - Error trying to remove hash
> cache for region=EPOEVENT,,1471683321681.6d9e058365a24e63e5802ca783c09660.,
> hostname=ip-172-31-8-132.us-west-2.compute.internal,60020,1471683102656,
> seqNum=1935501 org.apache.hadoop.hbase.client.RetriesExhaustedException:
> Failed after attempts=35, exceptions:
> Tue Aug 23 12:54:36 UTC 2016,
> RpcRetryingCaller{globalStartTime=1471956876660, pause=100, retries=35},
> org.apache.hadoop.hbase.regionserver.RegionServerAbortedException:
> org.apache.hadoop.hbase.regionserver.RegionServerAbortedException: Server
> ip-172-31-8-129.us-west-2.compute.internal,60020,1471683105586 aborting
> at
> org.apache.hadoop.hbase.regionserver.RSRpcServices.checkOpen(RSRpcServices.java:1087)
> at
> org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1967)
> at
> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112)
> at
> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
> at java.lang.Thread.run(Thread.java:745)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
