Hello,
I get the a table handler error (ERROR 1030: Got error 28 from table
handler), when using mySQL to evaluate numerious queries in a loop (from
Java), after a certain number of successfully evaluated queries.
My impression is that it is caused by the appearance of large files in
/tmp
Hello.
shell> perror 28
Error code 28: No space left on device
in other words: to process the query, MySQL creates a temporary table
on disk and you are running out of disk space.
You may want to consider to change the location of the directory used
for temporary files.
Bye,
Benjami
On 29-May-01 Griff Hamlin wrote:
> Hello,
>
>
> I have tried the set SQL_BIG_TABLES flag set to 1, but that did not help
> and now I'm out of ideas. Any suggestions would be appreciated.
>
localhost.dread$ perror 28
Error code 28: No space left on device
put --tmpdir on a bigger disc.
Hello,
When trying to do a large select statement like the following this error
is returned:
select account.username,person.firstname,person.lastname,
person.company_name, person.street,person.city,person.state,
person.zip,person.franchise,
person.card_number,person.expires,account.date,tran
