From: | Wim <wdh(at)belbone(dot)be> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Still big problems with pg_dump! |
Date: | 2002-09-17 15:04:23 |
Message-ID: | 3D874477.3020104@belbone.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-hackers pgsql-novice |
Tom Lane wrote:
>Andrew Sullivan <andrew(at)libertyrms(dot)info> writes:
>
>
>>On Tue, Sep 17, 2002 at 04:25:45PM +0200, Wim wrote:
>>
>>
>>>ERROR: AllocSetFree: cannot find block containing chunk 4c5ad0
>>>
>>>Postgres is running on solaris 8...
>>>
>>>
>
>
>
>>Someone else suggested that this would not be the error when you have
>>written bad data to the disk (I thought you could have this if the
>>controller was flakey and wrote bad data in the past. Maybe I'm
>>wrong. Probably).
>>
>>
>
>Actually, what it looks like to me is a memory clobber; I don't think
>bad data on disk would be likely to lead to this particular type of
>failure. But writing one byte too many into a string, and thereby
>zeroing the high-order byte of an adjacent pointer, could lead to
>exactly this message when we later try to pfree() the pointer.
>
>I am wondering if Wim is running into that same Solaris snprintf() bug
>that we discovered awhile back --- it was not clear if the bug still
>exists in Solaris 8, but the symptoms sure match. See
>http://archives.postgresql.org/pgsql-bugs/2002-07/msg00059.php
>
>It would be useful to see a stack traceback from the point of the error,
>if possible.
>
> regards, tom lane
>
I Would like to send a stack traceback, but I need some halp on this
(never done this before).
some add. info:
SELECT relname FROM pg_class WHERE relname like 'pg_%' AND relkind = 'r';
gives:
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.
SELECT relname FROM pg_class;
works well...
SELECT relname, relkind from pg_class WHERE relkind='r';
works also...
SELECT relname, relkind from pg_class WHERE relname like 'pg_%';
produces the same error as above...
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>
>
Cheers!
Wim
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-17 15:08:46 | Re: [GENERAL] Still big problems with pg_dump! |
Previous Message | Andrew Sullivan | 2002-09-17 14:58:01 | Re: [GENERAL] Still big problems with pg_dump! |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-17 15:08:46 | Re: [GENERAL] Still big problems with pg_dump! |
Previous Message | Andrew Sullivan | 2002-09-17 14:58:01 | Re: [GENERAL] Still big problems with pg_dump! |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-17 15:08:46 | Re: [GENERAL] Still big problems with pg_dump! |
Previous Message | Andrew Sullivan | 2002-09-17 14:58:01 | Re: [GENERAL] Still big problems with pg_dump! |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-17 15:08:46 | Re: [GENERAL] Still big problems with pg_dump! |
Previous Message | Andrew Sullivan | 2002-09-17 14:58:01 | Re: [GENERAL] Still big problems with pg_dump! |