Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Subject: Re: Issue with Reduce - NOT SOLVED.
To: user@couchdb.apache.org
References: <7b1ecc57-b507-b34f-a85c-0aa04b9e8c3e@open-net.biz>
 <05d50a29-6be8-509a-5609-b5bf281bdf91@open-net.biz>
 <1403E181-E596-4AFA-B78D-2714D334D155@apache.org>
 <f57b0100-acb2-a519-00c5-66f714c1d940@open-net.biz>
 <DE252A4F-9AD3-483F-AF79-EFB46045A7C3@apache.org>
From: Kiril Stankov <kiril@open-net.biz>
Message-ID: <334716d1-7788-2bfc-4c2f-056fe5b3513b@open-net.biz>
Date: Wed, 28 Sep 2016 23:37:56 +0300
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101
 Thunderbird/45.3.0
MIME-Version: 1.0
In-Reply-To: <DE252A4F-9AD3-483F-AF79-EFB46045A7C3@apache.org>
Content-Type: multipart/alternative;
 boundary="------------271FBC24B53D7C7A1C5B215C"
archived-at: Wed, 28 Sep 2016 20:38:05 -0000

--------------271FBC24B53D7C7A1C5B215C
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

Well,

actually, it got from bad to worst.
Compact view doesn't fix the problem anymore.
Now I always get wrong output.
Modifying the reduce to return just vals.length returns always 2.

I found that the issue appears after each insertion of new doc to the DB.

Any help will be highly appreciated, this is a production environment... :(

------------------------------------------------------------------------
*With best regards,*
Kiril Stankov,

On 28.9.2016 г. 22:15, Jan Lehnardt wrote:
> Thanks!
>
> Do you have any more info on the type of operating system this runs on, the file system situation, etc?
>
> Best
> Jan
> --
>
>> On 28 Sep 2016, at 17:47, Kiril Stankov <kiril@open-net.biz> wrote:
>>
>> Sure. See below.
>>
>> The view filters documents from all docs, the reduce gives statistics
>> depending on values.
>> Very simple.
>>
>> An interesting thing is that when it breaks vals.length always equals 2.
>>
>> BTW - just happened again, second time today. Compact of the view always
>> fixes this.
>>
>> View:
>>
>> function(doc) {
>>    if(doc.status!='deleted' && (!doc.endUser || doc.forwarded) &&
>> !doc.pID) {
>>      emit(null, [(doc.status=='new'),(doc.status=='forwarded')]);
>>    }
>> }
>>
>> Reduce:
>>
>> function(keys, vals, rereduce) {
>>  // reduce function
>>
>>  var result = {'new':0, 'total':vals.length,forwarded:0};   
>>  for(var i = 0; i < vals.length; i++) {
>>    result.new += vals[i][0]?1:0;
>>    result.forwarded+= vals[i][1]?1:0;
>>  }
>>  return result;
>> }
>>
>> Thanks!
>>
>>
>> On 28.9.2016 г. 18:16, Jan Lehnardt wrote:
>>> Heya,
>>>
>>> Can you share the view code?
>>>
>>> Best
>>> Jan
>>> --
>>>
>>>> On 28 Sep 2016, at 15:38, Kiril Stankov <kiril@open-net.biz> wrote:
>>>>
>>>> Hi,
>>>>
>>>> I just saw this again.
>>>> Reduce didn't work until compacting the View.
>>>>
>>>> This starts to be a serious problem.
>>>> Any help or suggestion how to debug this will be appreciated.
>>>>
>>>> Thanks!
>>>>
>>>> ------------------------------------------------------------------------
>>>> *With best regards,*
>>>> Kiril Stankov,
>>>>
>>>> On 24.9.2016 г. 20:43, Kiril Stankov wrote:
>>>>> Hi all,
>>>>>
>>>>> I use CouchDb 1.6 and have a view with reduce (same on all databases),
>>>>> which returns some statistics.
>>>>>
>>>>> Suddenly, today, it started returning strange things, and I think that
>>>>> the problem was that vals.length was returning 0. There are only few
>>>>> dozens docs in this DB.
>>>>> I have a replication DB where everything worked fine, checked that the
>>>>> code is exactly the same.
>>>>>
>>>>> After compacting the views on the first DB, it also started showing the
>>>>> correct values.
>>>>>
>>>>> Any idea what could cause this? View corruption? There are plenty of
>>>>> resources (disk, memory) on the host machine.
>>>>>
>>


--------------271FBC24B53D7C7A1C5B215C--