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 72AE0DFE4 for ; Wed, 11 Jul 2012 00:15:54 +0000 (UTC) Received: (qmail 87309 invoked by uid 500); 11 Jul 2012 00:15:53 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 87272 invoked by uid 500); 11 Jul 2012 00:15:52 -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 87264 invoked by uid 99); 11 Jul 2012 00:15:52 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2012 00:15:52 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of joao.sigma@gmail.com designates 209.85.212.176 as permitted sender) Received: from [209.85.212.176] (HELO mail-wi0-f176.google.com) (209.85.212.176) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2012 00:15:47 +0000 Received: by wibhn17 with SMTP id hn17so3349782wib.5 for ; Tue, 10 Jul 2012 17:15:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=EFree5atfjREZpJdZALJ9o/auj5F2yXfqiFOJHexCZw=; b=TYhKSFqLi1oqKlH9H+yGncGGTfbDkEy2nkD/mxZarKafnX850t0K76XyxrSQ43hC8O 5qCVsKsUM7lFCw83pd4Wp49HVczGf51PBEVzNFVgwkyom484uUOZ674U4+LY3T9ZXO+G kmXWdGMUpINAtWuf7C5Oy4g0SI2sJB3ifqOwzs3pX1xFAKtnlwrH0xcCcneEyPNCV2aF GzcbqVKym9w4DB2TIxQbN68JpgTiJIPg0KUYUd/1J+64b1zQm2GWmLlib4C/Ro4zEJGa 53z6POC3ZJwDT/BqJH1v2H89SxgTZnfj2WHDXMGHXmEfU/4AG6C/O/CorhZ6rSIyuZxS J79g== MIME-Version: 1.0 Received: by 10.180.106.97 with SMTP id gt1mr42338036wib.5.1341965723914; Tue, 10 Jul 2012 17:15:23 -0700 (PDT) Received: by 10.194.26.232 with HTTP; Tue, 10 Jul 2012 17:15:23 -0700 (PDT) In-Reply-To: References: Date: Wed, 11 Jul 2012 01:15:23 +0100 Message-ID: Subject: Re: Error after creating hundred of views From: =?ISO-8859-1?Q?Jo=E3o_Ramos?= To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=f46d044280664651a804c482bec1 X-Virus-Checked: Checked by ClamAV on apache.org --f46d044280664651a804c482bec1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Something is still not right. I increased the filedescriptors to 4096 and the same thing keeps happening. I restarted Couchdb, and used _stats to check how many filedescriptors were open: about 10, so I proceeded in creating 1000 design docs and the filedescriptors count went up to about 1000. I inserted another 1000 three more times and the count went up as excepted at around 4056. Then I queried those views (each design docs has only one view) and everything was fine. The 4000 queries were fast. To make sure I did them again and still no problem. Then I tried to insert another 1000 designs docs and the error started showing up. I couldn't use the database for anything anymore. Then I decided to compact the database and the filedescriptors returned back to about 10. So far so good, so I started querying 1000 views and the count went up again. I managed to call up until 4000 different views until the error reappeared. Does Couchdb ever closes the filedescriptors? Does limit on the number of filedescriptors somehow influences the maximum number of design docs / views a database can have? On Mon, Jul 9, 2012 at 9:25 PM, Niels Boldt wrote: > Hi > > emfile means you run out of filedescriptors > > See http://wiki.apache.org/couchdb/Performance#Resource_Limits for > further > information in increasing this limit > > Best Regards > Niels > > On Mon, Jul 9, 2012 at 8:01 PM, Jo=E3o Ramos wrote= : > > > I have a script that creates several hundred of views. > > At about 700, I start getting several errors and I've attached the log > > output of them. > > > > Thanks in advance. > > > > > > -- > BinaryConstructors ApS > Vestergade 10a, 4th > 1456 Kbh K > Denmark > phone: +4529722259 > web: http://www.binaryconstructors.dk > mail: nb@binaryconstructors.dk > skype: nielsboldt > --f46d044280664651a804c482bec1--