Join the community today
Register Now

MariaDB no space for database!

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by amin, Nov 25, 2016.

  1. amin

    amin Member

    38
    6
    8
    Oct 11, 2014
    Ratings:
    +7
    Local Time:
    12:15 PM
    Katest
    Latest
    Hi,
    Wordpress login kept redirecting to reauth=1 so I enabled debug and found this:
    WordPress database error: [Can't change size of file (Errcode: 28 "No space left on device")]
    SHOW FULL COLUMNS FROM `11631_options`

    And


    WordPress database error: [Can't change size of file (Errcode: 28 "No space left on device")]
    SELECT t.*, tt.*, tr.object_id FROM 11631_terms AS t INNER JOIN 11631_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN 11631_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (30504, 30506, 30508, 30514, 30516, 30518, 30520, 30527, 30532, 30553) ORDER BY t.name ASC
     
  2. amin

    amin Member

    38
    6
    8
    Oct 11, 2014
    Ratings:
    +7
    Local Time:
    12:15 PM
    Katest
    Latest
  3. eva2000

    eva2000 Administrator Staff Member

    55,417
    12,256
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,837
    Local Time:
    6:45 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    /home is full for mysql default tmpdir defined in /etc/my.cnf

    temporarily you can uncomment tmpdir defined in /etc/my.cnf and restart mysql server and then work at expanding /home disk space or some disk cleaning
     
  4. amin

    amin Member

    38
    6
    8
    Oct 11, 2014
    Ratings:
    +7
    Local Time:
    12:15 PM
    Katest
    Latest
  5. eva2000

    eva2000 Administrator Staff Member

    55,417
    12,256
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,837
    Local Time:
    6:45 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    how large was /home/mysqltmp ?
    Code (Text):
    du -h --max-depth=1 /home
     
  6. amin

    amin Member

    38
    6
    8
    Oct 11, 2014
    Ratings:
    +7
    Local Time:
    12:15 PM
    Katest
    Latest
    4.0K /home/mysqltmp
    20G /home/nginx
    16K /home/lost+found
    8.0K /home/.ccache
    24G /home
     
  7. eva2000

    eva2000 Administrator Staff Member

    55,417
    12,256
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,837
    Local Time:
    6:45 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Oh so /home/nginx site data is 20GB so you need larger /home

    so full site backup and then wipe server, reload OS and resize partition for /home to be larger and then restore backups for files and mysql

    or if you have option upgrade to next vps plan and then ask web host about resizing /home options etc
     
  8. amin

    amin Member

    38
    6
    8
    Oct 11, 2014
    Ratings:
    +7
    Local Time:
    12:15 PM
    Katest
    Latest
    from 80 GB only 26 GB goes to home. What is the "root" for then? Is it for nginx? I can reinstall the VPS, but what partition do you recommend?

    [root@localhost ~]# df -h
    Filesystem Size Used Avail Use% Mounted on
    /dev/mapper/VolGroup-lv_root
    50G 6.7G 40G 15% /
    tmpfs 1.9G 0 1.9G 0% /dev/shm
    /dev/sda1 477M 52M 400M 12% /boot
    /dev/mapper/VolGroup-lv_home
    26G 24G 36M 100% /home
    /home/usertmp_donotdelete
    3.9G 13M 3.6G 1% /tmp
     
  9. eva2000

    eva2000 Administrator Staff Member

    55,417
    12,256
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,837
    Local Time:
    6:45 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    / covers both /usr and /var for you so mysql data is in /var/lib/mysql under root /

    so you need to figure out your current usage for /home and /var and /var/lib/mysql and adjust accordingly
     
  10. amin

    amin Member

    38
    6
    8
    Oct 11, 2014
    Ratings:
    +7
    Local Time:
    12:15 PM
    Katest
    Latest
    Thank you for the help, I extended the home partition, but still wonder why is it wasting the whole 50 GB!
     
  11. eva2000

    eva2000 Administrator Staff Member

    55,417
    12,256
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,837
    Local Time:
    6:45 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Depends on partition settings i guess but you'd need that space if you databases grows in /var/lib/mysql