Hello, 

this error started when I logged in to marketplace and tried to install the updates on plugins I have. 

how can I repair it  and why did it happen ? 

SELECT * FROM `forums_forums`  LEFT JOIN `core_permission_index` ON core_permission_index.app='forums' AND core_permission_index.perm_type='forum' AND core_permission_index.perm_type_id=forums_forums.id  LEFT JOIN `core_members` ON core_members.member_id=forums_forums.last_poster_id WHERE (sub_can_post=0 OR min_posts_view<=11300) AND (( FIND_IN_SET(70,perm_view) OR FIND_IN_SET(71,perm_view) OR FIND_IN_SET('m4',perm_view) ) OR perm_view='*' ) ORDER BY position
IPS\Db\Exception: Error writing file '/tmp/MYIEF3By' (Errcode: 28 "No space left on device") (3)
#0 /home/parentsorg/public_html/forum/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#1 /home/parentsorg/public_html/forum/system/Node/Model.php(449): IPS\Db\_Select->rewind()
#2 /home/parentsorg/public_html/forum/applications/forums/sources/Forum/Forum.php(749): IPS\Node\_Model::loadIntoMemory('view', Object(IPS\Member), Array)
#3 /home/parentsorg/public_html/forum/applications/forums/sources/Topic/Topic.php(197): IPS\forums\_Forum::loadIntoMemory()
#4 /home/parentsorg/public_html/forum/system/Http/Url/Internal.php(175): IPS\forums\_Topic::preCorrectUrlFromVerifyClass(Object(IPS\Http\Url\Friendly))
#5 /home/parentsorg/public_html/forum/system/Http/Url/Friendly.php(218): IPS\Http\Url\_Internal->correctUrlFromVerifyClass('\\IPS\\forums\\Top...')
#6 /home/parentsorg/public_html/forum/system/Dispatcher/Front.php(308): IPS\Http\Url\_Friendly->correctFriendlyUrl()
#7 /home/parentsorg/public_html/forum/init.php(927) : eval()'d code(21): IPS\Dispatcher\_Front->checkUrl()
#8 /home/parentsorg/public_html/forum/system/Dispatcher/Front.php(90): IPS\Dispatcher\convert_hook_FrontDispatcher->checkUrl()
#9 /home/parentsorg/public_html/forum/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init()
#10 /home/parentsorg/public_html/forum/index.php(13): IPS\_Dispatcher::i()
#11 {main}

Edited March 26, 20232 yr by MeMaBlue

 

but they say even if its a managed server , that a developer on my side has do to this database transfer from MyISAM to  innoDB,   not them. Should I insist on them doing it?

DIY but make sure you take a DB backup first 😉

 

 

hello, can someone who is experienced perhaps do this switch for me, I dont want to take the risk , could someone give me a quote on it, since it happened again now  ?.... 

Edited April 6, 20231 yr by MeMaBlue

 

These things vary a lot from server to server and based on the specific size of your community, but ideally you should not be having several gigabytes of temp tables stored on your disk. Ideally, you should also have more than a handful of gigabytes available in /tmp, but I don't see how much space you actually have configured for this mount point on your server in the screenshots above, just that it is completely full.

As noted above, if the tmp directory PHP uses to store uploads is not large enough, large file uploads can end up causing this to happen. But based purely off the screenshots we see here, it looks like MySQL may be more to blame. In order to confirm, we would need to know the total disk space available to /tmp and what files are actually taking up all of this space.

Again based on the screenshots above however, it looks like your server is also configured to use MyISAM instead of InnoDB. Generally, it's recommended you use InnoDB for your tables instead, as MyISAM has several performance and scalability pitfalls that InnoDB mitigates.

The best solution here would be to first make sure your server has enough memory to store your entire MySQL database, plus enough to run all existing services and an additional buffer window to spare for growth and disk caching, and then convert your databases to InnoDB with your MySQL configuration tuned accordingly for your servers specific needs.

All of this can be rather complicated and is unfortunately not something that can be easily guided through in a forum post. If you have a managed server, you could see if this is something your host can do for you.

Hello,

 I have not found a solution for that yet and the support from the hosting has done the following 

"Hello

since the /tmp  maxed out again, we have implemented a cronjob at the server so that it empties the tmp file when it sees that its use is more than 95%. [ as previously stated the temp file is many GB more than 3 i remember ].   

please notify us when you solve the issue so that we remove the cron job. "

 

So, @Makoto  can you perhaps tell me where you can see that:  "it looks like your server is also configured to use MyISAM instead of InnoDB."   

so that I perhaps ask the host / tell them that I need something changed from their side, and what needs to be changed. 

I will ask the host to tell me how many times this has happened now, so that I get a statistic. 

 

Can someone from the team perhaps look into my error logs 

 

These are from the 2 licences.  

Maybe something else can also be found ..  and maybe  I am at the wrong path?

hello, after contacting the hosts, they told me from monitoring the server that the cron job is running once an hour to empty the temp file which is 3,9 GB and is not emptying itself . 

2023-04-18 09:13:30 Disk used 4093313024
2023-04-18 08:13:30 Disk used 4093313024
2023-04-18 07:13:30 Disk used 4093313024
2023-04-18 10:13:30 Disk used 4093313024
2023-04-18 11:13:30 Disk used 4093313024
2023-04-18 12:13:30 Disk used 4093313024
 

Dear @Marc Stridgen or someone else from the invision team can please guide me to what is to be done,

because I am stuck into not knowing that I need to change so that the temp file is not failing to empty itself (?) as it should.  As far as I can understand, this is the issue here.

please guide me as to what changes need to be made for that not to happen..

Edited April 18, 20231 yr by MeMaBlue

 Hello, for future reference I am posting an update. The problem got solved. 

The tables were changed to  innodb.... but.... this did not resolve the problem when we checked again. 

 

Because no reason could be found,  I asked to see the server error logs myself - for 17 years I never had to read server error logs myself, it was something done by hosting, since I am not an IT person.

I was under the wrong impression that they had looked at the  whole server log file, not only on that black error message I had posted earlier. (It didnt occur to me) 

And what do I find. The above error table, the black image in this topic, does not show which software is causing the issue.   Since the forum threw the errors and didnt function, I automatically came here and inquired the issue. 

My wp homepage, was running ok after all and I was using it.  

But,  after all these weeks,... today I open the error logs,... and what is the issue seen there?  Its not even invision at fault, its my wp homepage .... !    The custom theme had an issue, right after the server change...but it did not show in the front end or in the usability! 

(on my server I have a wp homepage which is the face of the ngo company, and in the directory   homepage...../forum. there is the invision forum  , plus I have another domain with only a forum on it, all in the same server)...

So... just,... many weeks of stress because of ... 

So thank you everybody, you can make another case study of why its horrible to self host nowadays. 

But, to answer your question @Marc Stridgen  my whole  setup right now does not allow for a switch financially.  Ofcourse after all that time i lost  this year, I would do the switch with closed eyes If I could.  If I had more funding I definitely would like to benefit from all the cloud options you have made and ofcourse the endless live topic options. Maybe in a later time when the ngo is funded better / I get a hold of some subscription money etc . Thats a different discussion, but ! thank you!  @Daniel F you too 🙏🙂

Edited April 22, 20231 yr by MeMaBlue