whatness wrote:
I set my Ubuntu 8.04 LTS Disk Image to 24000MB, and then migrated the downgrade. Now MySQL won't start saying " /etc/init.d/mysql: ERROR: The partition with is too full!"
How full is your new LTS disk image? (E.g., what does a "df" in the running system show as free). It's possible that the new size does not have enough room for MySQL to create whatever working space it needs for its database.
Quote:
I tried to reduce the Ubuntu 8.04 LTS Disk Image size. It failed:
...resize failed
resize2fs: No space left on device while trying to resize /dev/vg1/***
Resizing the filesystem on /dev/vg1/*** to 5888000 (4k) blocks.
It sounds like the error is saying that the actual contents of the filesystem on the disk image is too large for the size you are trying to shrink it to, so it was picking a new size that was at least large enough to hold your current data. This would seem to jive with the MySQL error about the disk being pretty full. (Since MySQL already complained about free space, I'm not entirely sure why you were trying to resize
down).
I'm not positive if the 4k blocks and Linode Manager "MB" are in typical disk sizes (k=1000, MB=1000000) or memory (k=1024, MB=1048576), but either way it would seem to indicate that you're likely using 96-98% of the 24000MB you initially resized to, which is a pretty full filesystem. And even if you have free space, unless its on the partition where /var/lib/mysql resides (which by default will hold the databases) it might not be helpful for mysql's needs.
BTW, is that the exact mysql error message you get? I believe it ought to have a filesystem path (like /var/lib/mysql) in there somewhere, which should help point you at the partition where you have to be sure to have the available space.
Have you tried freeing up space within the filesystem itself (e.g., in the running system, as opposed to the Linode disk image)?
Quote:
I bought 4GB more storage. But it was the same. What should I do now?

Did you resize your disk disk image after obtaining more storage? What's the free space like in your filesystem now?
-- David