could not write block & xlog flush request 3FD/0 is not satisfied
Hi again pgsql-hackers,
my experimental index which I am developing still has some problems.
Perhaps the list has some advices or hints where this error might occur:
WARNING: could not write block 6 of base/459204/483963
DETAIL: Multiple failures --- write error might be permanent.
directly followed by an:
ERROR: xlog flush request 3FD/0 is not satisfied --- flushed only to
0/20E2DC4
CONTEXT: writing block 6 of relation base/459204/483963
So far my index worked for small relations, up to 1.000 tuples, now with
a relation of 1.000.000 tuples I am running into these problems. I think
I might be lacking some knowledge to really solve the problem. I am
happy about any suggestions or advices you can make.
Best wishes, Yves
Yves Weiï¿œig wrote:
my experimental index which I am developing still has some
problems. Perhaps the list has some advices or hints where this
error might occur:WARNING: could not write block 6 of base/459204/483963
DETAIL: Multiple failures --- write error might be permanent.directly followed by an:
ERROR: xlog flush request 3FD/0 is not satisfied --- flushed only
to 0/20E2DC4
CONTEXT: writing block 6 of relation base/459204/483963So far my index worked for small relations, up to 1.000 tuples, now
with a relation of 1.000.000 tuples I am running into these
problems.
Is there any chance you're running out of disk space?
If not, what OS is this? What sort of storage system do you have?
-Kevin
Import Notes
Resolved by subject fallback
Am 08.05.2011 17:38, schrieb Kevin Grittner:
Yves Weiï¿œig wrote:
my experimental index which I am developing still has some
problems. Perhaps the list has some advices or hints where this
error might occur:WARNING: could not write block 6 of base/459204/483963
DETAIL: Multiple failures --- write error might be permanent.directly followed by an:
ERROR: xlog flush request 3FD/0 is not satisfied --- flushed only
to 0/20E2DC4
CONTEXT: writing block 6 of relation base/459204/483963So far my index worked for small relations, up to 1.000 tuples, now
with a relation of 1.000.000 tuples I am running into these
problems.Is there any chance you're running out of disk space?
If not, what OS is this? What sort of storage system do you have?
-Kevin
Thanks for the reply.
I think disk space shouldn't be the problem:
postgres@farnsworth:/usr/local/pgsql/data/pg_log$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 7.5G 4.1G 3.1G 58% /
none 496M 228K 496M 1% /dev
none 501M 140K 501M 1% /dev/shm
none 501M 100K 501M 1% /var/run
none 501M 0 501M 0% /var/lock
It is an Ubuntu 10.10 running in a VirtualBox. The storage is located
locally on my HDD, no SAN or network access.
I'm afraid it is an error in my code...
Yves
On Sun, May 8, 2011 at 4:18 PM, Yves Weißig
<weissig@rbg.informatik.tu-darmstadt.de> wrote:
ERROR: xlog flush request 3FD/0 is not satisfied --- flushed only to
0/20E2DC4
That's a pretty big difference in log positions. It seems likely
you've overwritten the block header writing garbage to the LSN.
--
greg
All right, what would we be the best way to debug such a problem?
Yves
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Greg Stark
Sent: Sunday, May 08, 2011 6:36 PM
To: weissig@rbg.informatik.tu-darmstadt.de
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] could not write block & xlog flush request 3FD/0 is
not satisfied
On Sun, May 8, 2011 at 4:18 PM, Yves Weißig
<weissig@rbg.informatik.tu-darmstadt.de> wrote:
ERROR: xlog flush request 3FD/0 is not satisfied --- flushed only to
0/20E2DC4
That's a pretty big difference in log positions. It seems likely you've
overwritten the block header writing garbage to the LSN.
--
greg
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers