No space left on device error on select query

Aster
Enthusiast

No space left on device error on select query

Hi,

I'm getting below error message on create and select statments.

ERROR:  could not extend relation base/16495/1249: No space left on device

Checked the disk space its not full.

aster -queen > df -h

Filesystem      Size  Used Avail Use% Mounted on

/dev/sda2       7.0G  4.4G  2.2G  67% /

devtmpfs        432M  172K  432M   1% /dev

tmpfs           432M     0  432M   0% /dev/shm

IOInterceptor   7.0G  4.4G  2.2G  67% /primary/iointerceptor/mountdir

Please help in resolving the issue.

Pradi

1 REPLY
Teradata Employee

Re: No space left on device error on select query

It means that the space which was assigned to the aster machine is completly used.

There is still space available on the queen, but there probably is no space left available for the worker.