Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
tforums Posted January 18, 2023 Posted January 18, 2023 (edited) Ever since the last upgrade we have had load issues with mysql (mariadb). It appears a process for only ONE of the 3 IPB installs is running constantly 24/7. Does anyone know what this process is and why it running all the time? The DB and user names have been removed from the statement below. Quote 11577 | *** | localhost | *** | Execute | 4 | Sending data | /*DB::USER::IPS\Helpers\Table\_Content::getRows:494*/ SELECT forums_topics.*, author.*, last_com | 0.000 | I frequently see another statement "Creating sort index" instead of "Sending Data". If that helps. Edited January 18, 2023 by tforums
tforums Posted January 18, 2023 Author Posted January 18, 2023 Is there a Bug in the system? I see a lot of these errors in the system logs: Quote TypeError: Illegal offset type in isset or empty (0) #0 /www/forums/system/Helpers/Table/Table.php...
Solution Jim M Posted January 18, 2023 Solution Posted January 18, 2023 2 hours ago, tforums said: Ever since the last upgrade we have had load issues with mysql (mariadb). It appears a process for only ONE of the 3 IPB installs is running constantly 24/7. Does anyone know what this process is and why it running all the time? The DB and user names have been removed from the statement below. I frequently see another statement "Creating sort index" instead of "Sending Data". If that helps. This is a partial query it appears. Is that the full log? 52 minutes ago, tforums said: Is there a Bug in the system? I see a lot of these errors in the system logs: That would likely indicate that there is an error in a custom or third party application/plugin/theme. You would want to disable those and then switch an unmodified theme to test. tforums 1
tforums Posted January 18, 2023 Author Posted January 18, 2023 1 hour ago, Jim M said: This is a partial query it appears. Is that the full log? That would likely indicate that there is an error in acustom or third party application/plugin/theme. You would want to disable those and then switch an unmodified theme to test. Thanks! It turns out to be the Portal 1.8.1 app causing the problem. This is odd because it is marked as 4.7.x compatible and works fine in our other installs.
tforums Posted January 18, 2023 Author Posted January 18, 2023 (edited) UPDATE - It must have been a cached configuration issue. After updating the settings, it appears to be working without adding any load. Edited January 18, 2023 by tforums
Mark H Posted January 18, 2023 Posted January 18, 2023 We're glad to hear you got this sorted out. But please do update the topic if the problem continues.
tforums Posted January 18, 2023 Author Posted January 18, 2023 SORRY! I spoke too soon. Seeing the hanging processes again in the DB after some time. Disabling Portal App stops them, so I am back on trying to debug this install.
tforums Posted January 18, 2023 Author Posted January 18, 2023 (edited) UPDATE - The process list hanging / CPU load issue seems to be tied to the Portal app being set as the forum homepage. When I set the home page to the IPB System, there are no "Sending data / Creating sort index" tasks and CPU load goes back to normal. I have confirmed the load issue can be reproduced by switching Portal back to the default forum homepage. I have disabled the Portal for Guests, and that seems to have cooled things off, but my guess is there's still something not right. What's odd is we've had this app installed at the homepage for years without issues until the last update. Edited January 18, 2023 by tforums
Mark H Posted January 18, 2023 Posted January 18, 2023 In that case, we'd suggest you contact the author of that 3rd-party app for assistance in diagnosing this issue. tforums 1
tforums Posted January 18, 2023 Author Posted January 18, 2023 (edited) 9 minutes ago, Mark H said: In that case, we'd suggest you contact the author of that 3rd-party app for assistance in diagnosing this issue. I am trying to, but any PM to the developer @Michael.J shows a forums error: Quote Sorry, there is a problem Something went wrong. Please try again. Edited January 18, 2023 by tforums
Mark H Posted January 18, 2023 Posted January 18, 2023 OK, that PM error is something we're aware of and will be patching very soon. tforums 1
tforums Posted January 18, 2023 Author Posted January 18, 2023 2 hours ago, Mark H said: OK, that PM error is something we're aware of and will be patching very soon. Thanks, I found the support forum and posted there.
Gary Posted January 18, 2023 Posted January 18, 2023 Hi @tforums, Let us know how you go after speaking to the developer. Hopefully everything is resolved for you shortly.
Recommended Posts