Disk Full Error

erich

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

Code:
    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

Code:
    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

Well-known member
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

Active member
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.
 
Top