Fullmental
Active member
Hello, we are experiencing an issue where a user will post a response in a thread, either via quick reply or full reply, and that user will occasionally experience a 10-60 second wait before they see that post operation complete. However, from a separate tab it shows the post operation is almost instantly completed. This seems to occur regardless of post length or complexity - even the word "test" with nothing else can prompt a 60 second wait time before the poster's page refreshes. At other times, it's nearly instant though, so the issue is very intermittent. It also seems to happen on some profile posts as well.
We're trying to identify why this is occurring, and how the wait time can be reduced. Because the posts appear almost immediately on the front page, we don't think it is a database issue. We've tested disabling all add-ons and re-enabling them one by one, and no one add-on seems to really cause it.
I tried using the slow query logger by Xon and unfortunately I'm not seeing any helpful info there either (provided below in case I'm blind/dumb/both). Due to the intermittent nature of the issue, I'm unsure how to proceed. Is there any sort of logging tool we can use within XF that can pinpoint the specific issue?
We're trying to identify why this is occurring, and how the wait time can be reduced. Because the posts appear almost immediately on the front page, we don't think it is a database issue. We've tested disabling all add-ons and re-enabling them one by one, and no one add-on seems to really cause it.
I tried using the slow query logger by Xon and unfortunately I'm not seeing any helpful info there either (provided below in case I'm blind/dumb/both). Due to the intermittent nature of the issue, I'm unsure how to proceed. Is there any sort of logging tool we can use within XF that can pinpoint the specific issue?
Code:
[LIST]
[*]
[*]Exception: Slow query: 15.2418 seconds, /forum/threads/first-world-problems.157/add-reply
[*]
[*]src/addons/SV/SlowQueryLogger/Db/Mysqli/SlowQueryLogAdapter.php:387
[*]
[/LIST]
[LIST]
[*]
[*]Generated by: Fullmental
[*]
[*]Aug 4, 2022 at 11:07 PM
[*]
[/LIST]
[HEADING=2]Stack trace[/HEADING]
#0 src/XF/Db/Mysqli/Statement.php(108): SV\SlowQueryLogger\Db\Mysqli\SlowQueryLogAdapter->logQueryCompletion()
#1 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#2 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#3 src/XF/Search/Source/MySqlFt.php(96): XF\Db\AbstractAdapter->insert('xf_search_index', Array, false, 'title = VALUES(...')
#4 src/XF/Search/Search.php(40): XF\Search\Source\MySqlFt->index(Object(XF\Search\IndexRecord))
#5 src/XF/Behavior/Indexable.php(46): XF\Search\Search->index('post', Object(SV\ThreadReplyBanTeeth\XF\Entity\Post), false)
#6 src/XF.php(365): XF\Behavior\Indexable->XF\Behavior\{closure}()
#7 src/XF/Mvc/Dispatcher.php(156): XF::triggerRunOnce(true)
#8 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#9 src/XF/App.php(2344): XF\Mvc\Dispatcher->run()
#10 src/XF.php(512): XF\App->run()
#11 index.php(20): XF::runApp('XF\\Pub\\App')
#12 {main}
[HEADING=2]Request state[/HEADING]
array(4) {
["url"] => string(49) "/forum/threads/first-world-problems.157/add-reply"
["referrer"] => string(73) "https://nuzlockeforums.com/forum/threads/first-world-problems.157/page-28"
["_GET"] => array(1) {
["/forum/threads/first-world-problems_157/add-reply"] => string(0) ""
}
["_POST"] => array(10) {
["message_html"] => string(184) "<p>Went to the dog park and there was a giant hole in the fence. </p><p><br></p><p>Cool. Guess my dog can't play and have fun outside for the foreseeable future. Sorry, buddy!</p>"
["attachment_hash"] => string(32) "7e3dab1a39dcba625b3a58dc8fffd7df"
["attachment_hash_combined"] => string(85) "{"type":"post","context":{"thread_id":157},"hash":"7e3dab1a39dcba625b3a58dc8fffd7df"}"
["last_date"] => string(10) "1656841440"
["last_known_date"] => string(10) "1656841440"
["load_extra"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(47) "/forum/threads/first-world-problems.157/page-28"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
Last edited:
