Table is full. why?

Anon

Hi all

I got an error which says that one of the table is full. I do not know why. The database is Mysql. There is no error when with the other tables. The exact error message is:

The table 'SQLa0f9_0' is full.

The error number is 1114. Why this is happening? There is nothing wrong with the script itself. It was ok few days ago and there was no error.

The surprising thing is that I don't have a table named SQLa0f9_0. what could this be???

Anon

Possibly the sysadmin has a max number of bytes for a table?

Anon

No. There are only about 150 rows in the table.

Anon

what is your system ? unix / nt / etc ?
are you storing huge binary data in ur tables ?

nilesh.

Anon

My system is Linux server with Mysql database. I am storing any images into the database. There are just numbers and short texts. I meant columns of CHAR types.

The data is not huge at all. There are just 150 rows.

Anon

Hi again

The surprising thing is that the other tables in the database are working ok. No error at all, But one particular table seems to be in a bad mood. I mean the error come up as soon as data is fetched from it. The script is very ok. It used to work ok before with this table. All of a sudden, it says table is full. Any idea??

Anon

Hopefully you have a backup you can restore this data from. Sounds like something got corrupted.

Good Luck.

Anon

now that your system is linux, talk to the
systems admin or the person installing mysql
that this is the problem.
may be the mysql tables are distributed across several disks and the particular disk on which ur table is present is full.
this does happen.
at the unix shell issue the follwing command

df

also try

df -i

see which of the disks are getting full..

solution
this is a long shot, but i did it once.
using phpmyadmin i downloaded all the table values and then dropped the table, create the table and feed the old values to the new table. it is messy but it worked for me.
also you can move the current table and contents to a new table with phpmyadmin.
maybe it will copy to another disk and then delete the old table. OBVIOUSLY this is not a good solution for a production database.
but hey, better than getting errors..

nilesh

Anon

Well, I will ask the admin guy to investigate that possiblity. He already checked the memory space for mySQL database and he says it should be enough. This application is already in large use, so we cannot move tables or rename or anything of that sort i guess. It seems bad luck at this point of time. Can you again speculate any other ideas as why I got the problem and how it could be solved. I would really be grateful of any help or suggestion.

Thanks