Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 4C2EE1337BFA for ; Fri, 8 Apr 2011 00:36:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 79162-05 for ; Fri, 8 Apr 2011 03:36:32 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.netbsd.org (mail.netbsd.org [204.152.190.11]) by mail.postgresql.org (Postfix) with ESMTP id 848301337BE0 for ; Fri, 8 Apr 2011 00:36:32 -0300 (ADT) Received: by mail.netbsd.org (Postfix, from userid 1270) id F14CD19CF07; Fri, 8 Apr 2011 03:36:29 +0000 (UTC) To: Kevin.Grittner@wicourts.gov Cc: drkp@csail.mit.edu, heikki.linnakangas@enterprisedb.com, pgsql-hackers@postgresql.org Subject: Re: SSI bug? In-Reply-To: Your message of "Thu, 07 Apr 2011 10:21:21 -0500" <4D9D9021020000250003C4E2@gw.wicourts.gov> References: <4D9D9021020000250003C4E2@gw.wicourts.gov> X-Mailer: Cue version 0.8 (100217-1432/takashi) Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Message-Id: <20110408033629.F14CD19CF07@mail.netbsd.org> Date: Fri, 8 Apr 2011 03:36:29 +0000 (UTC) From: yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201104/451 X-Sequence-Number: 185654 hi, > YAMAMOTO Takashi wrote: > >> LOG: could not truncate directory "pg_serial": apparent >> wraparound > > Did you get a warning with this text?: > > memory for serializable conflict tracking is nearly exhausted there is not such a warning near the above "aparent wraparound" record. not sure if it was far before the record as i've lost the older log files. YAMAMOTO Takashi > > If not, there's some sort of cleanup bug to fix in the predicate > locking's use of SLRU. It may be benign, but we won't really know > until we find it. I'm investigating. > > -Kevin