Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted October 12, 2024Oct 12 My site has been unresponsive for much of the last 24 hours. The CPU keeps going up to 100% and all my has said is the following, can someone help asap? The issue appears to be coming from the database "foxes_forums" as it makes queries that get stuck and cannot execute further. You need to review the database and fix the query that does not go trough. We can provide you with all the processes, however you would need to review and determine which is the one that gets stuck and causes the load.
October 12, 2024Oct 12 Community Expert Without knowing more information about what is going on here, such as the query or process in place it would be impossible to determine what the issue is. I would say, you would want to start with disabling any third-party items and just run the core software.
October 12, 2024Oct 12 Community Expert Without knowing more information about what is going on here, such as the query or process in place it would be impossible to determine what the issue is. We would need to know the above, as mentioned.
October 12, 2024Oct 12 Author We would need to know the above, as mentioned. I don’t know do I, they’re not helping me How soon can I move to cloud?
October 12, 2024Oct 12 Community Expert I don’t know do I, they’re not helping me Your host would be the only ones who would be able to provide this and in your original message, they said they would so I would continue to pressure them. How soon can I move to cloud? Sorry, as it is the weekend, our sales team isn't around. Monday would be the first day that they are able to review and plan that out, but it would likely not be for a few days, depending on our queue.
October 12, 2024Oct 12 Author I have an attachment of the sessions and processes but where do I send it? If I upload to here then everyone sees it
October 12, 2024Oct 12 Community Expert I have an attachment of the sessions and processes but where do I send it? If I upload to here then everyone sees it You can post a link to it in your notes of the access details area in the Client Area or I can transfer this to a ticket.
October 12, 2024Oct 12 Community Expert Would ensure that you are fully disabling third party applications/plugins. I am seeing quite a few references to non-Invision Community tables in the report provided. Specifically, tables like: topicmetaimage_images dp44banfromtopic_topics
October 12, 2024Oct 12 Author Those have been turned off for a few hours and the problem has continued
October 12, 2024Oct 12 Community Expert The next issue is that query cache in MySQL is having issues. Your hosting provider would need to improve the performance of it or disable it. Those have been turned off for a few hours and the problem has continued If the recent logs provided are recent, they have not been fully disabled.
October 12, 2024Oct 12 Author So what do I ask? There's been not a single issue in years until the last 24 hours and I've not changed anything
October 12, 2024Oct 12 Community Expert So what do I ask? There's been not a single issue in years until the last 24 hours and I've not changed anything You would need to tell them to improve the performance of query cache or disable it. As it is locking up your database as it is not performing well. As mentioned, nothing has changed in 24 hours in the software so this would have been a server change.
October 12, 2024Oct 12 Author I've asked them but not heard back yet. It's not crashed as much since I uninstalled those two plugins but the cpu still goes up occasionally
October 12, 2024Oct 12 Author Its absolutely not improving nothing is loading I have no idea what I can do now Edited October 12, 2024Oct 12 by marklcfc
October 12, 2024Oct 12 Author No support from hosts and nothing to go off here either, apart from go back to hosts who send me back here so what do I do? I've even asked to join cloud and got nothing back Edited October 12, 2024Oct 12 by marklcfc
October 12, 2024Oct 12 Author I’m in that position where hosts say it’s a site issue and developers say it’s a host issue
October 12, 2024Oct 12 Community Expert I’m sorry you’re stuck between a rock and a hard place but we have outlined the issue to you. If your host doesn’t want to do either of what we suggested, there is nothing we can do. We also explained as it is the weekend, it won’t be till Monday that we are able to evaluate the queue for migrations.
October 12, 2024Oct 12 Author They’ve turned the query cache off. From what I can tell so far it’s stopped the whole site being unresponsive and cpu being stuck at 100% for long periods of time, but it’s still using a lot of cpu and spiking up to 100 regularly which never happened until yesterday
