Disk Full Error

[erich]

Recently I've noticed this error. I'm not sure what's causing it since my database isn't using a lot of space.

    XF\Db\Exception: MySQL query error [1021]: Disk full (/var/db/mysql-tmp/#sql_dfa57_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") src/XF/Db/AbstractStatement.php:228

    Generated by: Unknown account Jun 12, 2021 at 8:23 PM

    SELECT `xf_user_follow`.*, `xf_user_User_1`.*, `xf_user_profile_Profile_2`.*, `xf_user_option_Option_3`.*
            FROM `xf_user_follow`
            INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_follow`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_1`.`user_id`)
            WHERE (`xf_user_User_1`.`is_banned` = 0) AND (`xf_user_User_1`.`user_state` = 'valid') AND (`xf_user_follow`.`follow_user_id` = 18495)
            ORDER BY RAND() ASC
        
LIMIT 12
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1021, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1021, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Mvc/Entity/Finder.php(1379): XF\Db\AbstractAdapter->query('
            SELECT `xf_...')
#4 src/XF/Pub/Controller/Member.php(350): XF\Mvc\Entity\Finder->fetch(12)
#5 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Member->actionAbout(Object(XF\Mvc\ParameterBag))
#6 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Member', 'About', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Member), NULL)
#7 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Member), NULL)
#8 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#9 src/XF/App.php(2337): XF\Mvc\Dispatcher->run()
#10 src/XF.php(488): XF\App->run()
#11 index.php(20): XF::runApp('XF\\Pub\\App')
#12 {main}

 

[duderuud]

Looks like your /tmp partition is full. Clean up unused(!) files or extend the partition.

 

[erich]

Looks like your /tmp partition is full. Clean up unused(!) files or extend the partition.

Thanks. I'll have to check how to do this with Cpanel since I'm on a hosting plan.

 

[duderuud]

Be careful cleaning up. Some files may be in use. My advice is to shutdown as much services as possible (mysql/apache/elasticsearch/java/etc) before deleting. Best way is probable to move files or subdirectories to another partition and see if all comes back online without errors.

 

[erich]

Be careful cleaning up. Some files may be in use. My advice is to shutdown as much services as possible (mysql/apache/elasticsearch/java/etc) before deleting. Best way is probable to move files or subdirectories to another partition and see if all comes back online without errors.

Thanks for that information. I am on a shared hosting plan so I'm going to have to reach out to the provider to see why this is happening.