SQL Error: Disk Full

[venturegardengroup]

Hello,

Holding on for your usual support.

Regards,

[avandemore]

What is the output of

Code: Select all

cat /proc/mounts 
ls -laF /usr/local/mysqltmp
df -h

This has some issue with it, either readonly or another full file system. If you are posting a screenshot, please ensure the entirely of the output is captured.

[venturegardengroup]

Thanks,

Find outputs attached.

Regards,

[avandemore]

I'm assuming you followed only some of the advice of another forum member and added tmpdir=/usr/local/mysqltmp to /etc/my.cfg. This will not work unless you do other things, and this approach isn't necessarily for you. Please remove that line from the config, and try the earlier referenced document Resizing the VM Disk Size starting with pvresize /dev/mapper/centos-root. After you have finished the resizing process, you can then restart mysql. It may be easiest to do a full system reboot.

[venturegardengroup]

I have done that, and I think I got a headway with the PV resizing, but doesn't look so with the LV resizing:

[root@localhost /]# pvresize /dev/sda2
Physical volume "/dev/sda2" changed
1 physical volume(s) resized / 0 physical volume(s) not resized
[root@localhost /]# lvresize /dev/mapper/VolGroup-lv_root /dev/sda2
Volume group "VolGroup" not found
You have new mail in /var/spool/mail/root

[avandemore]

I should have said pvresize /dev/sda2 earlier, use that instead. You are running a non-standard setup so steps need to be altered.

What is the output from # vgdisplayand # lvdisplay now?

After the pv is resized do an lvresize /dev/mapper/centos-root. Then you can do a xfs_growfs /dev/mapper/centos-root and reboot. It should be working at that point.

[venturegardengroup]

Thanks a lot,

Please see outputs in the attachement.

[venturegardengroup]

Thanks a lot,

Please see outputs in the attachement.

[venturegardengroup]

....

[avandemore]

Enter the commands as exactly follows:

Code: Select all

# lvresize /dev/mapper/centos-root /dev/sda2
# lvdisplay

Please post the output again.

Thanks,