problem on the index of the page smooth view

[kazad63]

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

[DawPi]

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! 🙂

[kazad63]

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.

[Randy Calvert]

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. 

[kazad63]

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.