[
https://issues.apache.org/jira/browse/PHOENIX-453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-453.
----------------------------------
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.
> Memory allocation exception on order by with limit
> --------------------------------------------------
>
> Key: PHOENIX-453
> URL: https://issues.apache.org/jira/browse/PHOENIX-453
> Project: Phoenix
> Issue Type: Task
> Reporter: mujtaba
> Assignee: Maryann Xue
> Labels: bug
>
> Getting the following exception with 1M row table on order by limit query:
> select * from performance_1000000 order by db limit 1000. Order by query
> without limit works fine. Data was created by running performance script
> bin/performance.sh [zookeeper] 1000000
> Requested memory of 74444634 bytes is larger than global pool of 73703424
> bytes.
> at com.salesforce.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:83)
> at
> com.salesforce.phoenix.coprocessor.ScanRegionObserver.getTopNScanner(ScanRegionObserver.java:160)
> at
> com.salesforce.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:136)
> at
> com.salesforce.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:59)
> at
> org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1313)
> at
> org.apache.hadoop.hbase.regionserver.HRegionServer.openScanner(HRegionServer.java:2509)
> at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320)
> at org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1426)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
