Large view query caused all my data to disappear
Hi guys -
I'm pretty new to Couchbase and CouchDB in general, I was messing around with making a map/reduce view. When I hit, "preview results" it was stuck at loading for a few minutes then came back with the following message
{"error":"case_clause","reason":"{error,no_stats}"}
I had around 16k documents, nothing production so it's okay. It was just the following, I had a bucket with 2GB dedicated. A little much but lol.
first, last, city, state
After the error occurred I see the following for my bucket
Bucket Name Nodes Item Count Ops/sec Disk Fetches/sec RAM Usage/Quota Disk Usage
default 1 0 0 0 0B / 2GB 20.4MB
If I hit the "documents" button I can see it but when using views I cannot see anything, even when hitting "Random Document"...it will say "Bucket is currently empty."
If I try to restart the service
/etc/init.d/couchbase-server restart
(it just hangs)
I killed the process manually and it started up, admin interface works but the bucket is still empty. Is there any diagnostic info I can get to you guys?
Edit: I generated a diagnostic report, it was like 150MB, how would you like me to get it to you if you need it.
Edit 2: I should have mentioned, my server has 4GB of RAM
Ricky
Hi Ricky,
Thanks for all of the info. If you could compress the diag report (it should be small after compressing) and post an issue at couchbase.com/issues that'd be great. Since you have a good description here, you can just post that into the summary of the issue. The project should be "Couchbase Server" and the component here is likely "capi" (short for Couch API).
Thanks!
Matt