Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted April 14, 2024Apr 14 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, 2024Apr 14 by kazad63
April 14, 2024Apr 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! 🙂
April 14, 2024Apr 14 Author 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.
April 14, 2024Apr 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.
April 14, 2024Apr 14 Author 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.