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/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. > > 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
