You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/03/16 08:20:28 UTC
[jira] [Resolved] (PHOENIX-486) issue arised run performance test
for 10,000,000 several times
[ https://issues.apache.org/jira/browse/PHOENIX-486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gabriel Reid resolved PHOENIX-486.
----------------------------------
Resolution: Fixed
Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.
> issue arised run performance test for 10,000,000 several times
> --------------------------------------------------------------
>
> Key: PHOENIX-486
> URL: https://issues.apache.org/jira/browse/PHOENIX-486
> Project: Phoenix
> Issue Type: Task
> Reporter: fouriertyp
>
> I run performance.sh for 10,000,000 records for 2+ times, and got the following error when it's interting the recards in the midel (at about 2,780,000). Another issue is that if I created a table with one million recoards, and drop it, and create a same table and insert few lines of records, a simple select query will take 8 seconds, which is only less then 1 second in normal case. did I miss any steps?
> com.salesforce.phoenix.execute.CommitException: org.apache.hadoop.hbase.client.NoServerForRegionException: Unable to find region for PERFORMANCE_10000000,NAApple.com\x00Dashboard\x00\x00\x00\x01@\xD3\xC4\xB2P,99999999999999 after 10 tries.
> at com.salesforce.phoenix.execute.MutationState.commit(MutationState.java:236)
> at com.salesforce.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:244)
> at com.salesforce.phoenix.util.CSVLoader.upsert(CSVLoader.java:133)
> at com.salesforce.phoenix.util.CSVLoader.upsert(CSVLoader.java:76)
> at com.salesforce.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:179)
> Caused by: org.apache.hadoop.hbase.client.NoServerForRegionException: Unable to find region for PERFORMANCE_10000000,NAApple.com\x00Dashboard\x00\x00\x00\x01@\xD3\xC4\xB2P,99999999999999 after 10 tries.
> at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegionInMeta(HConnectionManager.java:991)
> at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:896)
> at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegionInMeta(HConnectionManager.java:998)
> at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:900)
> at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:857)
> at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.processBatchCallback(HConnectionManager.java:1565)
> at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.processBatch(HConnectionManager.java:1450)
> at org.apache.hadoop.hbase.client.HTable.batch(HTable.java:701)
> at com.salesforce.phoenix.execute.MutationState.commit(MutationState.java:229)
--
This message was sent by Atlassian JIRA
(v6.2#6252)