Got error 28 from storage engine

plenty of space available though

[Doood]

MySQL 1030: Got error 28 from storage engine
This means "No space left on device" but there is lots of space available.

------------------------------------------------------
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
132G 20G 106G 16% /
/dev/sda1 99M 40M 55M 42% /boot
none 2.0G 0 2.0G 0% /dev/shm
/usr/tmpDSK 485M 142M 318M 31% /tmp
/tmp 485M 142M 318M 31% /var/tmp
------------------------------------------------------

The limit on a table is 4gb but the table I'm trying to rebuild should only be about 40mb with less than 150k records. The whole database is only 140mb total.

So my host changed the max rows for this table to 2.4 billion (yes billion) with an average row lenght of 50. This obviously didn't help cause I only need 150k rows for this table.

I can edit the sql query to create a table about half the size (20mb) and it works just fine, but the full query for 40mb gives the disk/partition full error.

Any ideas on a fix or workaround?

(They also increased the max_heap_table_size to 20mb for another error involving a temporary memory table reaching its limits. Haven't tested this one yet though.)