Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B71C97448 for ; Fri, 22 Jul 2011 11:39:50 +0000 (UTC) Received: (qmail 37067 invoked by uid 500); 22 Jul 2011 11:39:49 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 36784 invoked by uid 500); 22 Jul 2011 11:39:43 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 36693 invoked by uid 99); 22 Jul 2011 11:39:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Jul 2011 11:39:42 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ramkrishna.kulkarni@gmail.com designates 209.85.218.52 as permitted sender) Received: from [209.85.218.52] (HELO mail-yi0-f52.google.com) (209.85.218.52) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Jul 2011 11:39:34 +0000 Received: by yie19 with SMTP id 19so1819207yie.11 for ; Fri, 22 Jul 2011 04:39:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; bh=bIwHqGsVQECcQDw265jYCjBBWTsY/uAnxrDEcl2zbqQ=; b=krBLD7OaEhEeIYpm1lsFoia8aXsT7jkItNSj7412NI4h6ZeYK+MooqMUXkpJtQ0r3p eEJGYZidi6mVeJiElQlzu9DNIKrbXg2ROHVfZLrhWXNNEuwXNw8dXvNKS1bmkmWbdF8R h4gGm+VMwKTrl2ci6GLnA984tHyL39ITs5jnM= MIME-Version: 1.0 Received: by 10.231.83.20 with SMTP id d20mr1233990ibl.152.1311334753736; Fri, 22 Jul 2011 04:39:13 -0700 (PDT) Received: by 10.231.206.4 with HTTP; Fri, 22 Jul 2011 04:39:13 -0700 (PDT) Date: Fri, 22 Jul 2011 17:09:13 +0530 Message-ID: Subject: CouchDB filters: {"error":"changes_reader_died"} From: Ramkrishna Kulkarni To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=000e0cd56b442d99f104a8a6ea81 X-Virus-Checked: Checked by ClamAV on apache.org --000e0cd56b442d99f104a8a6ea81 Content-Type: text/plain; charset=ISO-8859-1 I have a DB with some 40K documents. I initiate around 40 replications at the same time with a filter. The filter is a simple string comparison on one of the fields. On an average, each replication copies 1K documents to the target DBs. This process takes several minutes (30 minutes sometimes). I have observed that around 90% of the time is spent in filtering the documents at source DB (I'm guessing this because CPU is fully loaded at source for most of the time and once the copying starts, it finishes pretty quickly). Situation is a little better if the number of simultaneously replications is less. This DB has 4 views (composite keys). Tried on 1.0.2 and 1.1.0. Server is a 2 core box running Ubuntu 10.10. I've seen message like "changes_timeout" and {"error":"changes_reader_** died"} Please let me know if there are things to keep in mind while using filters. Thanks, Ram --000e0cd56b442d99f104a8a6ea81--