Re: [GENERAL] Problem with data corruption and psql memory usage

2009-09-26 Thread Gerhard Wiesinger
Hello Tom, Late answer, but answer :-) : Finally, it was a very strange hardware problem, where a very small part of RAM was defect but kernel never crashed. I had also a very strange behavior when verifying rpm packages with rpm -V. First I had the harddisk under suspicion. But then I flushe

Re: [GENERAL] Problem with data corruption and psql memory usage

2007-05-09 Thread Scott Marlowe
On Wed, 2007-05-09 at 11:18, Gerhard Wiesinger wrote: > Hello Tom! > > I don't think this is a hardware problem. Machine runs 24/7 for around 4 > years without any problems, daily backup with GBs of data to it, > uptimes to the next kernel security patch, etc. > > The only problem I could belie

Re: [GENERAL] Problem with data corruption and psql memory usage

2007-05-09 Thread Tom Lane
Gerhard Wiesinger <[EMAIL PROTECTED]> writes: > The only problem I could believe is: > I'm running the FC7 test packages of postgresql in FC6 and maybe there is > a slight glibc library conflict or any other incompatibility. Hmm, I'd be suspicious of that too. You'd be well advised to take the F

Re: [GENERAL] Problem with data corruption and psql memory usage

2007-05-09 Thread Gerhard Wiesinger
Hello Tom! I don't think this is a hardware problem. Machine runs 24/7 for around 4 years without any problems, daily backup with GBs of data to it, uptimes to the next kernel security patch, etc. The only problem I could believe is: I'm running the FC7 test packages of postgresql in FC6 and

Re: [GENERAL] Problem with data corruption and psql memory usage

2007-05-09 Thread Tom Lane
Gerhard Wiesinger <[EMAIL PROTECTED]> writes: > LOG: could not fsync segment 0 of relation 1663/16386/42726: Input/output > error [ raised eyebrow... ] I think your machine is flakier than you believe. This error is particularly damning, but the general pattern of weird failures all over the pl