Jump to content

problem on the index of the page smooth view


Recommended Posts

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 : 

Could contain: Page, Text, File, Computer Hardware, Electronics, Hardware, Monitor, Screen

 

 

 

 

Edited by kazad63
Link to comment
Share on other sites

Thank you for the feedback. The site is on a dedicated server:

Could contain: Chart, Plot, Page, Text, Measurements

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:

Could contain: Page, Text, File

 

 

thanks again.

Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...