kazad63 Posted April 14 Share Posted April 14 (edited) Hello, I often encounter the problem 1 time per day on the index of the page which displays: [code]SELECT forums_topics.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `forums_topics` LEFT JOIN `forums_forums` ON forums_topics.forum_id=forums_forums.id LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT('forums;forums; ',forums_topics.tid)) LEFT JOIN `core_members` AS `author` ON author.member_id = forums_topics.starter_id LEFT JOIN `core_members` AS `last_commenter` ON last_commenter.member_id = forums_topics.last_poster_id WHERE forums_forums.club_id IS NULL AND forums_forums. min_posts_view<=39699 AND forums_topics.approved < 2 AND forums_topics.approved!=-2 AND forums_topics.approved!=-3 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id NOT IN (6,14 ,28,45,63,99,152,220,286,289,291,293,296,315,349,350,356,364,371) ORDER BY forums_topics.pinned DESC, forums_topics.last_post desc LIMIT 0.52 IPS\Db\Exception: Disk full (/tmp/#sql-temptable-70e-3aef8-cea.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (1021) #0 /home/nzbnewzfrance/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #1 [internal function]: IPS\Db\_Select->rewind() #2 [internal function]: IteratorIterator->rewind() #3 /home/.../public_html/system/Helpers/Table/Content.php(359): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator)) #4 /home/.../public_html/system/Helpers/Table/Table.php(504): IPS\Helpers\Table\_Content->getRows(Array) #5 /home/.../public_html/uploads/template_22_b9ece655dd44c92e77c425d3dea4cf8f_index.php(5411): IPS\Helpers\Table\_Table->__toString() #6 /home/.../public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_forums_front_index->simplifiedView(Object(IPS\Helpers\Table\Content)) #7 /home/.../public_html/applications/forums/modules/front/forums/index.php(204): IPS\Theme\_SandboxedTemplate->__call('simplifiedView', Array) #8 /home/.../public_html/system/Dispatcher/Controller.php(118): IPS\forums\modules\front\forums\_index->manage() #9 /home/.../public_html/applications/forums/modules/front/forums/index.php(52): IPS\Dispatcher\_Controller->execute() #10 /home/.../public_html/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_index->execute() #11 /home/.../public_html/index.php(13): IPS\_Dispatcher->run() #12 {hand} in "smooth view" since the last 2 updates, and the forum index is very slow to load. Error : EX1021 Can you help me.[/code] Invision Community v4.7.16 Skin 4.7.15 PHP : 8.1.27 SQL : MariaDB 10.6.17 InnoDButf8mb4_unicode_ci phpMyAdmin 5.2.1 In the System log : Edited April 14 by kazad63 Link to comment Share on other sites More sharing options...
DawPi Posted April 14 Share Posted April 14 18 minutes ago, kazad63 said: IPS\Db\Exception: Disk full (/tmp/#sql-temptable-70e-3aef8-cea.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (1021) Your hosting space is out! 🙂 wegorz23 1 Link to comment Share on other sites More sharing options...
kazad63 Posted April 14 Author Share Posted April 14 Thank you for the feedback. The site is on a dedicated server: It's true that when I have the problem, I restart and everything works perfectly. what would be the partition to enlarge? being on a WHM Cpanel server, I assigned no limitations to this site: thanks again. Link to comment Share on other sites More sharing options...
Randy Calvert Posted April 14 Share Posted April 14 You are looking at the wrong space. The error message tells you where is out of space: Disk full (/tmp/#sql-temptable-70e-3aef8-cea.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (1021) The /tmp/ partition is basically like a separate drive on a Linux server. It’s used for as you might expect from the name… TEMPORARY files. Restarting the server might temporarily clear some of those temp files but it does not necessarily solve why it’s filling up. This is a servet issue you would need to discuss with your hosting provider. Invision can’t help troubleshoot server/hosting issues. wegorz23 1 Link to comment Share on other sites More sharing options...
kazad63 Posted April 14 Author Share Posted April 14 Yes thank you temporary linux. I'm going to re-park on this side and even installed software in the background to delete the temporary ones. for example https://support.cpanel.net/hc/en-us/articles/360052677654-How-to-clean-your-tmp-directory-with-tmpwatch Thanks for your help. Link to comment Share on other sites More sharing options...
Recommended Posts