On Wed, Aug 30, 2006 at 10:18:46 +0200,
Filip Hrbek <[EMAIL PROTECTED]> wrote:
>
> It is possible that the corruption was caused by a HW problem at customer's
> server, and then this problem appeared also at our development environment
> because of the data already beeing corrupted. I will rec
<[EMAIL PROTECTED]>;
Sent: Wednesday, August 30, 2006 4:10 AM
Subject: Re: [BUGS] Partially corrupted table
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
The underlined word is a field length word that evidently should contain
8, but contains hex 8008. This causes the t
Hrbek
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Filip Hrbek" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, August 30, 2006 1:33 AM
Subject: Re: [BUGS] Partially corrupted table
Well, it's a corrupt-data problem all right. The tuple that&#
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> The underlined word is a field length word that evidently should contain
>> 8, but contains hex 8008. This causes the tuple-data decoder to step
>> way past the end of the tuple and off into never-never land.
> Hmm, perhaps we could
Tom Lane wrote:
> The underlined word is a field length word that evidently should contain
> 8, but contains hex 8008. This causes the tuple-data decoder to step
> way past the end of the tuple and off into never-never land. Since the
> results will depend on which shared buffer the page happens
Well, it's a corrupt-data problem all right. The tuple that's
causing the problem is on page 1208, item 27:
Item 27 -- Length: 240 Offset: 1400 (0x0578) Flags: USED
XMIN: 5213 CMIN: 140502 XMAX: 0 CMAX|XVAC: 0
Block Id: 1208 linp Index: 27 Attributes: 29 Size: 28
infomask: 0x09
"Filip Hrbek" <[EMAIL PROTECTED]> writes:
> No, I'm sure is it not a HW problem. I tested the same DB cluster on two
> different machines. The error is exactly the same.
Really?
> I can send you the cluster if you tell me how and where to send 30M file.
You can email it to me personally if you
t;[EMAIL PROTECTED]>
To: "Filip Hrbek" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, August 29, 2006 4:01 PM
Subject: Re: [BUGS] Partially corrupted table
"Filip Hrbek" <[EMAIL PROTECTED]> writes:
dwhdb=# create temp table t_fct as select * from dwhdata_salemc.fct
"Filip Hrbek" <[EMAIL PROTECTED]> writes:
> dwhdb=# create temp table t_fct as select * from dwhdata_salemc.fct;
> SELECT
> dwhdb=# create temp table t_fct as select * from dwhdata_salemc.fct;
> server closed the connection unexpectedly
> This probably means the server terminated abnormall
