[jira] [Closed] (ASTERIXDB-1956) An edit-distance-check query generates "Unable to find free page in buffer cache after 1000 cycles (buffer cache undersized?)" Exception

2018-02-23 Thread Taewoo Kim (JIRA) 

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Taewoo Kim closed ASTERIXDB-1956.
-
Resolution: Fixed

> An edit-distance-check query generates "Unable to find free page in buffer 
> cache after 1000 cycles (buffer cache undersized?)" Exception
> 
>
> Key: ASTERIXDB-1956
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1956
> Project: Apache AsterixDB
>  Issue Type: Bug
>Reporter: Taewoo Kim
>Assignee: Taewoo Kim
>Priority: Major
>
> Setting: 
> 1 node (CC+NC), 20GB dataset, NC: max memory 4GB, Buffer-cache size: default 
> (682.75 MB), a keyword index on the field.
> Query:
> {code}
> use dataverse exp;
> count(
> for $o in dataset
> "AmazonReviewNoDup"
> where edit-distance-check($o.reviewerName,
> "Jacob Libin"
> ,
> int64("2")
> )[0]
> return {"oid":$o.id}
> );
> {code}
> Result from API call:
> {code}
> {
>   "requestID": "0a36c521-879f-429c-af29-7a2670150585",
>   "signature": "*",
>   "errors": [{
>   "code": "1",
>   "msg": "Unable to find free page in buffer cache after 1000 cycles 
> (buffer cache undersized?)"
>   }],
>   "status": "fatal",
>   "metrics": {
>   "elapsedTime": "52.433274939s",
>   "executionTime": "52.431912415s",
>   "resultCount": 0,
>   "resultSize": 0
>   }
> }
> No success - status code: fatal
> {
>   "requestID": "0a36c521-879f-429c-af29-7a2670150585",
>   "signature": "*",
>   "errors": [{
>   "code": "1",
>   "msg": "Unable to find free page in buffer cache after 1000 cycles 
> (buffer cache undersized?)"
>   }],
>   "status": "fatal",
>   "metrics": {
>   "elapsedTime": "52.433274939s",
>   "executionTime": "52.431912415s",
>   "resultCount": 0,
>   "resultSize": 0
>   }
> }
> {code}
> Exception in the nc.log
> {code}
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: Unable to 
> find free page in buffer cache after 1000 cycles (buffer cache undersized?)
>   at 
> org.apache.hyracks.storage.common.buffercache.BufferCache.getPageLoop(BufferCache.java:1261)
>   at 
> org.apache.hyracks.storage.common.buffercache.BufferCache.findPage(BufferCache.java:228)
>   at 
> org.apache.hyracks.storage.common.buffercache.BufferCache.pin(BufferCache.java:195)
>   at 
> org.apache.hyracks.storage.am.lsm.invertedindex.ondisk.FixedSizeElementInvertedListCursor.pinPages(FixedSizeElementInvertedListCursor.java:98)
>   at 
> org.apache.hyracks.storage.am.lsm.invertedindex.search.PartitionedTOccurrenceSearcher.search(PartitionedTOccurrenceSearcher.java:150)
>   at 
> org.apache.hyracks.storage.am.lsm.invertedindex.ondisk.OnDiskInvertedIndex$OnDiskInvertedIndexAccessor.search(OnDiskInvertedIndex.java:505)
>   at 
> org.apache.hyracks.storage.am.lsm.invertedindex.impls.LSMInvertedIndexSearchCursor.hasNext(LSMInvertedIndexSearchCursor.java:153)
>   at 
> org.apache.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.writeSearchResults(IndexSearchOperatorNodePushable.java:183)
>   at 
> org.apache.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.nextFrame(IndexSearchOperatorNodePushable.java:236)
>   ... 12 more
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Closed] (ASTERIXDB-1956) An edit-distance-check query generates "Unable to find free page in buffer cache after 1000 cycles (buffer cache undersized?)" Exception

2017-06-27 Thread Taewoo Kim (JIRA) 

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Taewoo Kim closed ASTERIXDB-1956.
-
Resolution: Not A Problem

The issue was simple - not enough buffer cache memory to handle this request.

> An edit-distance-check query generates "Unable to find free page in buffer 
> cache after 1000 cycles (buffer cache undersized?)" Exception
> 
>
> Key: ASTERIXDB-1956
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1956
> Project: Apache AsterixDB
>  Issue Type: Bug
>Reporter: Taewoo Kim
>
> Setting: 
> 1 node (CC+NC), 20GB dataset, NC: max memory 4GB, Buffer-cache size: default 
> (682.75 MB), a keyword index on the field.
> Query:
> {code}
> use dataverse exp;
> count(
> for $o in dataset
> "AmazonReviewNoDup"
> where edit-distance-check($o.reviewerName,
> "Jacob Libin"
> ,
> int64("2")
> )[0]
> return {"oid":$o.id}
> );
> {code}
> Result from API call:
> {code}
> {
>   "requestID": "0a36c521-879f-429c-af29-7a2670150585",
>   "signature": "*",
>   "errors": [{
>   "code": "1",
>   "msg": "Unable to find free page in buffer cache after 1000 cycles 
> (buffer cache undersized?)"
>   }],
>   "status": "fatal",
>   "metrics": {
>   "elapsedTime": "52.433274939s",
>   "executionTime": "52.431912415s",
>   "resultCount": 0,
>   "resultSize": 0
>   }
> }
> No success - status code: fatal
> {
>   "requestID": "0a36c521-879f-429c-af29-7a2670150585",
>   "signature": "*",
>   "errors": [{
>   "code": "1",
>   "msg": "Unable to find free page in buffer cache after 1000 cycles 
> (buffer cache undersized?)"
>   }],
>   "status": "fatal",
>   "metrics": {
>   "elapsedTime": "52.433274939s",
>   "executionTime": "52.431912415s",
>   "resultCount": 0,
>   "resultSize": 0
>   }
> }
> {code}
> Exception in the nc.log
> {code}
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: Unable to 
> find free page in buffer cache after 1000 cycles (buffer cache undersized?)
>   at 
> org.apache.hyracks.storage.common.buffercache.BufferCache.getPageLoop(BufferCache.java:1261)
>   at 
> org.apache.hyracks.storage.common.buffercache.BufferCache.findPage(BufferCache.java:228)
>   at 
> org.apache.hyracks.storage.common.buffercache.BufferCache.pin(BufferCache.java:195)
>   at 
> org.apache.hyracks.storage.am.lsm.invertedindex.ondisk.FixedSizeElementInvertedListCursor.pinPages(FixedSizeElementInvertedListCursor.java:98)
>   at 
> org.apache.hyracks.storage.am.lsm.invertedindex.search.PartitionedTOccurrenceSearcher.search(PartitionedTOccurrenceSearcher.java:150)
>   at 
> org.apache.hyracks.storage.am.lsm.invertedindex.ondisk.OnDiskInvertedIndex$OnDiskInvertedIndexAccessor.search(OnDiskInvertedIndex.java:505)
>   at 
> org.apache.hyracks.storage.am.lsm.invertedindex.impls.LSMInvertedIndexSearchCursor.hasNext(LSMInvertedIndexSearchCursor.java:153)
>   at 
> org.apache.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.writeSearchResults(IndexSearchOperatorNodePushable.java:183)
>   at 
> org.apache.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.nextFrame(IndexSearchOperatorNodePushable.java:236)
>   ... 12 more
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)