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 3549F10772 for ; Mon, 15 Jul 2013 17:32:43 +0000 (UTC) Received: (qmail 54347 invoked by uid 500); 15 Jul 2013 17:32:41 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 54191 invoked by uid 500); 15 Jul 2013 17:32:41 -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 54182 invoked by uid 99); 15 Jul 2013 17:32:40 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 Jul 2013 17:32:40 +0000 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS,UNRESOLVED_TEMPLATE X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of Will.Perry@microsoft.com designates 207.46.163.152 as permitted sender) Received: from [207.46.163.152] (HELO na01-bn1-obe.outbound.protection.outlook.com) (207.46.163.152) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 Jul 2013 17:32:31 +0000 Received: from BL2FFO11FD015.protection.gbl (10.173.161.200) by BL2FFO11HUB007.protection.gbl (10.173.160.227) with Microsoft SMTP Server (TLS) id 15.0.717.3; Mon, 15 Jul 2013 17:32:09 +0000 Received: from TK5EX14HUBC102.redmond.corp.microsoft.com (131.107.125.37) by BL2FFO11FD015.mail.protection.outlook.com (10.173.160.223) with Microsoft SMTP Server (TLS) id 15.0.717.3 via Frontend Transport; Mon, 15 Jul 2013 17:32:09 +0000 Received: from ch1outboundpool.messaging.microsoft.com (157.54.51.81) by mail.microsoft.com (157.54.7.154) with Microsoft SMTP Server (TLS) id 14.3.136.1; Mon, 15 Jul 2013 17:31:56 +0000 Received: from mail134-ch1-R.bigfish.com (10.43.68.234) by CH1EHSOBE002.bigfish.com (10.43.70.52) with Microsoft SMTP Server id 14.1.225.22; Mon, 15 Jul 2013 17:29:54 +0000 Received: from mail134-ch1 (localhost [127.0.0.1]) by mail134-ch1-R.bigfish.com (Postfix) with ESMTP id B24C12401ED for ; Mon, 15 Jul 2013 17:29:54 +0000 (UTC) X-Forefront-Antispam-Report-Untrusted: CIP:157.56.240.21;KIP:(null);UIP:(null);(null);H:BL2PRD0310HT003.namprd03.prod.outlook.com;R:internal;EFV:INT X-SpamScore: -1 X-BigFish: PS-1(zz98dI9371I542I1432I1447Izz1f42h1ee6h1de0h1fdah2073h1202h1e76h1d1ah1d2ah1fc6hzz8275bh8275dhz31h2a8h668h839h944hd24hf0ah1220h1288h12a5h12a9h12bdh137ah13b6h1441h1504h1537h153bh162dh1631h1758h18e1h1946h19b5h1ad9h1b0ah1d07h1d0ch1d2eh1d3fh1de9h1dfeh1dffh1e1dh17ej9a9j1155h) Received-SPF: softfail (mail134-ch1: transitioning domain of microsoft.com does not designate 157.56.240.21 as permitted sender) client-ip=157.56.240.21; envelope-from=Will.Perry@microsoft.com; helo=BL2PRD0310HT003.namprd03.prod.outlook.com ;.outlook.com ; X-Forefront-Antispam-Report-Untrusted: SFV:NSPM;SFS:(189002)(199002)(51704005)(24454002)(377454003)(13464003)(51914003)(47976001)(51856001)(81342001)(50986001)(76576001)(74316001)(47736001)(54316002)(31966008)(74366001)(16406001)(53806001)(74706001)(74662001)(77096001)(56776001)(54356001)(74502001)(76482001)(81542001)(76796001)(80022001)(56816003)(63696002)(4396001)(33646001)(79102001)(69226001)(59766001)(46102001)(49866001)(77982001)(74876001)(65816001)(47446002)(83072001)(76786001)(24736002)(3826001);DIR:OUT;SFP:;SCL:1;SRVR:BLUPR03MB152;H:BLUPR03MB150.namprd03.prod.outlook.com;CLIP:2001:4898:80e0:ed43::cd;RD:InfoNoRecords;MX:1;A:1;LANG:en; Received: from mail134-ch1 (localhost.localdomain [127.0.0.1]) by mail134-ch1 (MessageSwitch) id 1373909393212857_3035; Mon, 15 Jul 2013 17:29:53 +0000 (UTC) Received: from CH1EHSMHS040.bigfish.com (snatpool1.int.messaging.microsoft.com [10.43.68.252]) by mail134-ch1.bigfish.com (Postfix) with ESMTP id 300EC4A004A for ; Mon, 15 Jul 2013 17:29:53 +0000 (UTC) Received: from BL2PRD0310HT003.namprd03.prod.outlook.com (157.56.240.21) by CH1EHSMHS040.bigfish.com (10.43.69.249) with Microsoft SMTP Server (TLS) id 14.16.227.3; Mon, 15 Jul 2013 17:29:52 +0000 Received: from BLUPR03MB152.namprd03.prod.outlook.com (10.255.212.28) by BL2PRD0310HT003.namprd03.prod.outlook.com (10.255.97.38) with Microsoft SMTP Server (TLS) id 14.16.329.3; Mon, 15 Jul 2013 17:29:48 +0000 Received: from BLUPR03MB150.namprd03.prod.outlook.com (10.255.212.18) by BLUPR03MB152.namprd03.prod.outlook.com (10.255.212.28) with Microsoft SMTP Server (TLS) id 15.0.731.16; Mon, 15 Jul 2013 17:29:47 +0000 Received: from BLUPR03MB150.namprd03.prod.outlook.com ([169.254.4.228]) by BLUPR03MB150.namprd03.prod.outlook.com ([169.254.4.228]) with mapi id 15.00.0731.000; Mon, 15 Jul 2013 17:29:47 +0000 From: Will Perry To: "user@couchdb.apache.org" Subject: RE: Understanding 'Source database out of sync' error Thread-Topic: Understanding 'Source database out of sync' error Thread-Index: Ac6BfX4/OGnS8WZPRHyF/9KURiAzSgAAi+4AAAA4xGA= Date: Mon, 15 Jul 2013 17:29:47 +0000 Message-ID: <44836ba5384b4951b1058c7e1134befb@BLUPR03MB150.namprd03.prod.outlook.com> References: <931d322264da4d14ab604a10ad2a4ac2@BLUPR03MB150.namprd03.prod.outlook.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [2001:4898:80e0:ed43::cd] x-forefront-prvs: 09086FB5C5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OrganizationHeadersPreserved: BLUPR03MB152.namprd03.prod.outlook.com X-FOPE-CONNECTOR: Id%0$Dn%*$RO%0$TLS%0$FQDN%$TlsDn% X-FOPE-CONNECTOR: Id%59$Dn%COUCHDB.APACHE.ORG$RO%2$TLS%6$FQDN%corpf5vips-237160.customer.frontbridge.com$TlsDn% X-CrossPremisesHeadersPromoted: TK5EX14HUBC102.redmond.corp.microsoft.com X-CrossPremisesHeadersFiltered: TK5EX14HUBC102.redmond.corp.microsoft.com X-Forefront-Antispam-Report: CIP:131.107.125.37;CTRY:US;IPV:CAL;IPV:NLI;EFV:NLI;SFV:NSPM;SFS:(189002)(199002)(51704005)(13464003)(377454003)(51914003)(24454002)(69226001)(44976005)(46406003)(76786001)(81342001)(4396001)(49866001)(47736001)(6806004)(56816003)(47776003)(83072001)(16676001)(47976001)(76576001)(77096001)(56776001)(74706001)(65816001)(50466002)(74876001)(77982001)(74662001)(53806001)(20776003)(23726002)(46102001)(54316002)(33646001)(74316001)(76796001)(31966008)(50986001)(76482001)(79102001)(81542001)(63696002)(74502001)(80022001)(74366001)(47446002)(51856001)(59766001)(54356001)(24736002)(3826001);DIR:OUT;SFP:;SCL:1;SRVR:BL2FFO11HUB007;H:TK5EX14HUBC102.redmond.corp.microsoft.com;CLIP:131.107.125.37;RD:InfoDomainNonexistent;MX:1;A:1;LANG:en; X-OriginatorOrg: microsoft.onmicrosoft.com X-O365ENT-EOP-Header: Message processed by - O365_ENT: Allow from ranges (Engineering ONLY) X-Forefront-PRVS: 09086FB5C5 X-Virus-Checked: Checked by ClamAV on apache.org Thanks for the speedy reply. When running the scenario, each node only has one user db (plus, of course = _replicator and _users) - there's a repl. Relationship setup for the existi= ng db, but I can't see how I'd get anywhere near 100 open dbs with this set= up. Might it help to 'warm up' these new dbs by running a few queries against t= hem before trying to replicate? Cheers, Will -----Original Message----- From: Robert Newson [mailto:rnewson@apache.org]=20 Sent: Monday, July 15, 2013 10:21 AM To: user@couchdb.apache.org Subject: Re: Understanding 'Source database out of sync' error The replicator checks the instance_start_time of both servers and restarts = the replication if they change. This is essential to ensure we replicate ev= erything. The reason it recommends increasing max_dbs_open is that instance= _start_time only changes if the database has previously closed, and this is= commonly because the LRU has done so. Does it sound plausible that you have more actively replicating databases a= t either end than your current max_dbs_open value? I believe the default va= lue is 100. B. On 15 July 2013 18:09, Will Perry wrote: > Hi Folks, > > I'm seeing the following error pop up when attempting to write a new docu= ment into the _replicator database referencing a newly created database: > > checkpoint_commit_failure,<<"Source database out of sync. Try to=20 > increase max_dbs_open at the source's server.">> > > The scenario I'm running is: > > 1. On 2 couch nodes A and B > > 2. Create a new database named 'Foo' on A, then on B > > 3. Create a replication relationship on A to pull changes from B > > 4. Create a replication relationship on B to pull changes from A > > This is failing at step 3 with a 400 (bad request) and Couch's logs are s= howing me the error above. Incidentally, the same code used to work (on 1.2= ) - is there a known issue or workaround? > > Cheers, > > Will