Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 197B59FA666 for ; Sat, 23 Sep 2006 14:21:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 03289-01 for ; Sat, 23 Sep 2006 14:21:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id E40979FA5BF for ; Sat, 23 Sep 2006 14:21:00 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 20580118A1B; Sat, 23 Sep 2006 13:20:59 -0400 (EDT) Date: Sat, 23 Sep 2006 13:20:59 -0400 From: Ray Stell To: Tom Lane Cc: theman , pgsql-admin@postgresql.org Subject: Re: COPY FROM command v8.1.4 Message-ID: <20060923172059.GB4831@cns.vt.edu> References: <000b01c6de87$8d87db40$d3c016ac@omni.imsweb.com> <29595.1158962371@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <29595.1158962371@sss.pgh.pa.us> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.035 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200609/254 X-Sequence-Number: 23168 Curious how you get to an OS kernel bug from these writes? Aren't we missing the associated db reads in this trc data? Maybe there been other data provided off the list? Would love to see it. Thanks. On Fri, Sep 22, 2006 at 05:59:31PM -0400, Tom Lane wrote: > "theman" writes: > > lseek(10, 0, SEEK_END) = 913072128 > > write(10, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192 > > lseek(10, 0, SEEK_END) = 913080320 > > write(10, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192 > > lseek(10, 0, SEEK_END) = 913088512 > > write(10, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192 > > lseek(10, 0, SEEK_END) = 913088512 > > write(10, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192 > > lseek(10, 0, SEEK_END) = 913096704 > > write(10, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192 > > Boy, that looks like a smoking gun to me. We're dealing with a kernel > bug. > > What's the platform here, including the exact kernel version? What > filesystem are you storing the database on? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster