Page 3 of 4
Re: SQL Error: Disk Full
Posted: Tue Oct 18, 2016 9:53 am
by venturegardengroup
Hello,
Holding on for your usual support.
Regards,
Re: SQL Error: Disk Full
Posted: Tue Oct 18, 2016 10:09 am
by 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.
Re: SQL Error: Disk Full
Posted: Wed Oct 19, 2016 3:54 am
by venturegardengroup
Thanks,
Find outputs attached.
Regards,
Re: SQL Error: Disk Full
Posted: Wed Oct 19, 2016 9:14 am
by 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.
Re: SQL Error: Disk Full
Posted: Wed Oct 19, 2016 9:43 am
by 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
Re: SQL Error: Disk Full
Posted: Wed Oct 19, 2016 9:55 am
by 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.
Re: SQL Error: Disk Full
Posted: Thu Oct 20, 2016 9:42 am
by venturegardengroup
Thanks a lot,
Please see outputs in the attachement.
Re: SQL Error: Disk Full
Posted: Thu Oct 20, 2016 9:44 am
by venturegardengroup
Thanks a lot,
Please see outputs in the attachement.
Re: SQL Error: Disk Full
Posted: Thu Oct 20, 2016 9:46 am
by venturegardengroup
....
Re: SQL Error: Disk Full
Posted: Thu Oct 20, 2016 10:50 am
by avandemore
Enter the commands as exactly follows:
Code: Select all
# lvresize /dev/mapper/centos-root /dev/sda2
# lvdisplay
Please post the output again.
Thanks,