Re: [HACKERS] memory problems in copying large table to STDOUT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] memory problems in copying large table to STDOUT
Date: 1999-10-10 15:59:53
Message-ID: 2101.939571193@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu> writes:
> I am attaching the backtrace. This one simultaneously generated
> this kernel message from the md driver:

> raid0_map bug: hash->zone0==NULL for block 1132810879
> Bad md_map in ll_rw_block

> Definitely a problem but no longer sure if it's the same one . . .
> sigh.

Looks like it is not the same. As you can see, the error message that
elog is about to report is "cannot read <block#> of <file>", which isn't
too surprising given the kernel notice:

> #1 0x81160e9 in elog (lev=-1, fmt=0x8146a4b "cannot read block %d of %s")
> at elog.c:81

If this read failure is reproducible then you will need to get that
taken care of before we can make any progress on the original problem.
But it might be a transient failure --- why don't you just start the
copy over again to see?

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-10-10 16:55:11 Mention of FAQ in shared memory/ipc errors
Previous Message Martin Weinberg 1999-10-10 13:38:43 Re: [HACKERS] memory problems in copying large table to STDOUT