After relatively high write load data I noticed that almost all views returning empty lists(while records itself available in database).
I also found couple of views which contain 11 entries while expected value are much more higher.
Which information I should provide to help troubleshooting?
I using version 2.5.1, CentOS 2.6.32-431.1.2.0.1.el6.x86_64
Here is sample of query:
curl -v 'login:password@localhost:8092/olx/_design/dev_default/_view/countries?stale=false&debug=true'
* About to connect() to localhost port 8092 (#0)
* Trying ::1... В соединении отказано
* Trying 127.0.0.1... connected
* Connected to localhost (127.0.0.1) port 8092 (#0)
* Server auth using Basic with user 'login'
> GET /olx/_design/dev_default/_view/countries?stale=false&debug=true HTTP/1.1
> Authorization: Basic YWRtaW46cXdlMTIzMzIx
> User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.0.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
> Host: localhost:8092
> Accept: */*
>
< HTTP/1.1 200 OK
< Transfer-Encoding: chunked
< Server: MochiWeb/1.0 (Any of you quaids got a smint?)
< Date: Wed, 26 Nov 2014 02:12:55 GMT
< Content-Type: text/plain;charset=utf-8
< Cache-Control: must-revalidate
<
{"total_rows":0,"rows":[
]
}
countries View code:
function (doc, meta) {
if(meta.type == "json" && meta.id.indexOf("country") == 0) {
emit(meta.id, doc.sport.id);
}
}
Documents(fetched by key ID, just couple of them):
//Key: country_1
{
"id": 1,
"name": "England"
}
//Key: country_152
{
"id": 152,
"name": "Serbia"
}
//Key: country_17
{
"id": 17,
"name": "Austria"
}
happy testing