Mohit, Be aware that key filters are just a thin layer on top of full-bucket key listings. You'd be better off storing the field you want to filter in a secondary index, which more efficiently supports range queries (note that only the LevelDB storage engine currently supports secondary indexes). Barring that, you could use the special "$key" index for a range query on the key.
On Tue, Apr 24, 2012 at 1:07 PM, Sati, Mohit <[email protected]> wrote: > Hello All, > > I'm getting the below error in my queries. I'm using riak 1.1.1 > > Riak Version: > ============ > $rpm -qa | grep riak > riak-1.1.1-1.el6.x86_64 > > Riak Error: > ======== > HTTP/1.1 100 Continue > HTTP/1.1 500 Internal Server Error > Server: MochiWeb/1.1 WebMachine/1.9.0 (someone had painted it blue) > Date: Tue, 24 Apr 2012 16:58:53 GMT > Content-Type: application/json > Content-Length: 625 > {"phase":0,"error":"[preflist_exhausted]" > > Query: > ========== > My query is doing a range scan. I can only get data for 1 day. For 2 or > more days it is throwing the error posted above. > > {"inputs":{ "bucket":"tagg_dsquery", > "key_filters":[["and", > [["starts_with", "dsquery-us_prm"]], > [["and", > [["tokenize", "-", 5], ["greater_than_eq", > "20120312"]], > [["tokenize", "-", 5], ["less_than_eq", "20120314"]] > ]] > ]]}, > ... > ... > > > app.config changes: > ============= > map_js_vm_count - increased to 32,64,128 and 256 but not helping > js_max_vm_mem - increased to 32,64,128,256,512 and 1024. > js_thread_stack - increased to 64,128,256,512,1024 and 2048 (cannot go > beyond) - riak would not start > > Can anyone help me to debug this issue. My queries cannot go beyond 1 day > > Thanks > Mohit > > _______________________________________________ > riak-users mailing list > [email protected] > http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com > > -- Sean Cribbs <[email protected]> Software Engineer Basho Technologies, Inc. http://basho.com/
_______________________________________________ riak-users mailing list [email protected] http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com
