Re: Serious Crash last Friday - Mailing list pgsql-general

From Henrik Steffen
Subject Re: Serious Crash last Friday
Date
Msg-id 04b601c215f4$5367a4a0$7100a8c0@topconcepts.net
Whole thread Raw
In response to Serious Crash last Friday  ("Henrik Steffen" <steffen@city-map.de>)
Responses Re: Serious Crash last Friday  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
> so, "parsed data" <= "length" is good, though hopefully it's not too much
> less.

well,

parsed data ==                  825242056
length ==                       84

I fear, it's toooooo much less.

BTW: The count of rows printed by the pgfsck increases permanently.
In my last mail, there were only 814 rows, 2 hours ago, there were 1200
rows, now there are 1600 rows !!! What does this mean? In the table, there
are only 185 rows like before.

There is always about 800000000 parsed data, and about 100-150 of length.


Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Martijn van Oosterhout" <kleptog@svana.org>
To: "Henrik Steffen" <steffen@city-map.de>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, June 17, 2002 12:02 PM
Subject: Re: [GENERAL] Serious Crash last Friday


> On Mon, Jun 17, 2002 at 11:38:00AM +0200, Henrik Steffen wrote:
> > same employee table (but after initdb, and restored from fridays dump)
> >
> > how can i find out the correct length of the tuples?
>
> Tuple incorrect length (parsed data=xxxxxx, length=xxx)
>
> "parsed data" is what was processed
> "length" is the amount allocated in the tuple header
>
> so, "parsed data" <= "length" is good, though hopefully it's not too much
> less.
>
> HTH,
> --
> Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> > There are 10 kinds of people in the world, those that can do binary
> > arithmetic and those that can't.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly


pgsql-general by date:

Previous
From: Herbert Liechti
Date:
Subject: Re: TEXT and NULL...
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Serious Crash last Friday