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