Re: Partially corrupted table

From: "Filip Hrbek" <filip(dot)hrbek(at)plz(dot)comstar(dot)cz>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Partially corrupted table
Date: 2006-08-29 15:22:49
Message-ID: 008901c6cb7e$fd67bd70$1e03a8c0@fhrbek
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.
I can send you the cluster if you tell me how and where to send 30M file.

Thanks for reply
Filip Hrbek

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Filip Hrbek" <filip(dot)hrbek(at)plz(dot)comstar(dot)cz>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Tuesday, August 29, 2006 4:01 PM
Subject: Re: [BUGS] Partially corrupted table

> "Filip Hrbek" <filip(dot)hrbek(at)plz(dot)comstar(dot)cz> 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 abnormally
>> before or while processing the request.
>> The connection to the server was lost. Attempting reset: Failed.
>> !>
>
>> dwhdb=# create temp table t_fct as select * from dwhdata_salemc.fct;
>> ERROR: row is too big: size 119264, maximum size 8136
>
>> dwhdb=# create temp table t_fct as select * from dwhdata_salemc.fct;
>> ERROR: row is too big: size 38788, maximum size 8136
>
> I think you've got hardware problems. Getting different answers from
> successive scans of the same table is really hard to explain any other
> way. memtest86 and badblocks are commonly suggested for testing memory
> and disk respectively on Linux machines.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Anderson Nonato Santos 2006-08-29 15:23:43 BUG #2596: Invalid memory alloc request size
Previous Message Teodor Sigaev 2006-08-29 14:16:14 Re: BUG #2594: Gin Indexes cause server to crash on Windows