Re: COPY FROM command v8.1.4

Thanks a million Tom!

SLES support helped upgrade our SLES 9, sp3, linux kernel from 2.6.5-7.244
to 2.6.5-7.282.  Since that we haven't had any blocks of rows beign
re-written or blanked out by the kernel.  The new kernel is handling the
wirtes much better.








-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Saturday, September 23, 2006 1:41 PM
To: Ray Stell
Cc: theman; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] COPY FROM command v8.1.4

Ray Stell <stellr@cns.vt.edu> writes:
> Curious how you get to an OS kernel bug from these writes?

Note the two successive lseek's returning the same result.  With a
write() in between that should have extended the file, that is clearly the
wrong answer.

Subsequent discussion reveals that Dan is running

> Linux pike 2.6.5-7.244-smp #1 SMP Mon Dec 12 18:32:25 UTC 2005 x86_64
> x86_64 x86_64 GNU/Linux SLES 9 suse linux enterprise 9 service pack 3

which is probably overdue for an update ...

            regards, tom lane