Couchbase built in reduce function in production view doesn't work

Hello,

How big is your data set?

Have you tried to build the index in development mode? (see the option "Full Cluster Data Set" in the "Show Results" section of the page)

Any error in the log?

You can look at the "Troubleshooting Views" available here:
http://www.couchbase.com/docs/couchbase-manual-2.0/couchbase-views-troub...

Regards
Tug

how many documents do you have, carl? also, what kind of instance / machine are you running on?

Hi,Tug
The document size is about 110MB. It works in development Time Subset.But it doesn't work in Full Cluster Data Set as well.
I checked Couchbase error log,I got something like "reason: Builtin _sum function requires map values to be numbers".It seems that the map values are not number,But I'm sure map values are all numbers.

Regards
Carl

Hi,
I have about 42000 documents,the couchbase running instance is:
instance 1:
CPU : Dual Core AMD Opteron(tm) Processor 275
Memory : 16G

instance 2:
CPU : Six-Core AMD Opteron(tm) Processor 2431
Memory : 4G

Thanks
Carl

Maybe you can try to create another design document, with same map function but without the reduce, and check that every value is indeed a number?

Just query the new (map-only) view, without any limit/pagination, and paste it here (unless you sensitive data).

Thanks everyone.It works now.Not sure if it's due to I'm using Couchbase Server 2.0 which I installed Today.