asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Taewoo Kim (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ASTERIXDB-1956) An edit-distance-check query generates "Unable to find free page in buffer cache after 1000 cycles (buffer cache undersized?)" Exception
Date Tue, 27 Jun 2017 22:42:00 GMT

    [ https://issues.apache.org/jira/browse/ASTERIXDB-1956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16065618#comment-16065618
] 

Taewoo Kim commented on ASTERIXDB-1956:
---------------------------------------

I found that this query requires 2,050 pages to read the inverted lists from the index. The
capacity of buffer cache is 5,462 pages if we use the default size.  

> 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)

Mime
View raw message