I am examining CB as a replacement for MySql. I’m using CB 3.0.1 (CE) and java client 1.2.3.
I have a 3 node CB cluster with 4 buckets (all of type: couchbase).
One of the buckets has 4 views in 2 design documents (2 views each). This is a rapidly growing bucket (a lot of inserts and a lot of updates).
Sometimes (1% of the cases), results from the views are inconsistent with the actual data. I can’t reproduce this - I can only detect that after it happens. I see the problem since I insert the same data into MySql and CB and then get them from MySql and CB (using view) and compare them - the results are not the same. After some time (few days sometimes), the view does return the correct results. I’m using stale=false.
From reading about disk writes, it appears that they happen quickly (a few seconds) so it can’t be that data is not written to disk within days.
Moreover, since this is CB 3.0.1 stream-based views should be applied and so indexes should be updated even before it is written to disk.
So, I don’t know how it happens that my results in the views are so far from being up-to-date.
can anyone suggest an explanation?