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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Saturday, September 23, 2006 1:41 PM
To: Ray Stell
Cc: theman; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] COPY FROM command v8.1.4

Ray Stell <stellr(at)cns(dot)vt(dot)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