X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 85CBA9FA4E0 for ; Fri, 22 Sep 2006 18:59:38 -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 14182-03 for ; Fri, 22 Sep 2006 18:59:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id ADFF09F9F75 for ; Fri, 22 Sep 2006 18:59:33 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8MLxV68029596; Fri, 22 Sep 2006 17:59:31 -0400 (EDT) To: "theman" cc: pgsql-admin@postgresql.org Subject: Re: COPY FROM command v8.1.4 In-reply-to: <000b01c6de87$8d87db40$d3c016ac@omni.imsweb.com> References: <000b01c6de87$8d87db40$d3c016ac@omni.imsweb.com> Comments: In-reply-to "theman" message dated "Fri, 22 Sep 2006 16:42:00 -0400" Date: Fri, 22 Sep 2006 17:59:31 -0400 Message-ID: <29595.1158962371@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.099 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/251 X-Sequence-Number: 23165 "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