Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group