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 C7A15C8A9 for ; Tue, 5 Jun 2012 03:08:19 +0000 (UTC) Received: (qmail 50153 invoked by uid 500); 5 Jun 2012 03:08:18 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 50110 invoked by uid 500); 5 Jun 2012 03:08:17 -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 50065 invoked by uid 99); 5 Jun 2012 03:08:15 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jun 2012 03:08:15 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FSL_RCVD_USER,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of tisdall@gmail.com designates 74.125.82.54 as permitted sender) Received: from [74.125.82.54] (HELO mail-wg0-f54.google.com) (74.125.82.54) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jun 2012 03:08:08 +0000 Received: by wgbfg15 with SMTP id fg15so4032849wgb.23 for ; Mon, 04 Jun 2012 20:07:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=2kP710c+o4BShNU/6c1iFIU1UH2Ih3FXeOUXiBNf9RY=; b=X7vArtS2flnB6C06VLGxulMxJgP3nOxQB+fVHDhAcGmqKPtr0Q5/BQJhFZoNzuCKS8 QCSNKGRRHtW6384j0thOBG1a4As0O+rpNkV4BimHtj/SwZmF5jS4TxRNKWUG1Qeqs7Dp UkMcjD9zcOXm2/hICrvcG+zVvRoy57rs88Owxui/YiwA75NSau1sfi19VH/pqawkvgdd yG8XTZjWels5zs2UTXywUmL+9jUGwEM+Iu3IQfTudWx38SvLtqqG8pK2uXsvVKaZvXOI ayrr3Q7h5Wkv3O8EEOltp1Tm1TudtYxZ3K1+FVwNvY8UjASI+tTuBfAo6dVf+aP1uPUu jLSQ== MIME-Version: 1.0 Received: by 10.216.227.154 with SMTP id d26mr13195276weq.9.1338865667297; Mon, 04 Jun 2012 20:07:47 -0700 (PDT) Received: by 10.216.90.77 with HTTP; Mon, 4 Jun 2012 20:07:47 -0700 (PDT) Date: Mon, 4 Jun 2012 23:07:47 -0400 Message-ID: Subject: limit on number of docs updated via _bulk_docs? From: Tim Tisdall To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 Hopefully someone can give me an idea on this problem because I think I've about exhausted ideas. I'm doing a series of document updates fairly rapidly. I was doing the updates via PUT and was having no problems except for the DB file size growing way too fast. I changed things to update the database in batches using _bulk_docs. Now I seem to have a problem with connections timing out to couchdb after about 11000 doc updates. I've tried different size batches from 5 to 500 docs but each time the program dies with a connection time out after about the same number of doc updates. I thought it may be a problem with my code (it's in PHP, and that's usually the problem ;) ), however I tried something that I think negates that possibility. I have the script running and stop it after about 5000 updates, then manually restart the script again right away. The second time the script dies after about 6000 updates. So, still around 11000 updates over 2 different processes. Any thoughts, guesses, things to try, or things to test? -Tim