XF 2.1 Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 176128 bytes)

[siONtI]

I'm getting this error when someone replies to a specific thread on my forum (thread has 23321 replies / 1167 pages). This error is generated only on this thread.

Also it takes a longer-than-normal time from when you click on 'Post Thread' button to when the post actually appears. Sometimes it doesn't and i have to refresh the page for the post to appear and, if i don't and click on 'Post Thread' again it will create a double-post.

Any idea why is this happening?

ErrorException: Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 176128 bytes) src/XF/Db/Mysqli/Statement.php:86
Generated by: admin Aug 6, 2019 at 9:21 PM

Stack trace
#0 [internal function]: XF::handleFatalError()
#1 {main}

Request state
array(4) {
  ["url"] => string(47) "/threads/randomthread.8012/add-reply"
  ["referrer"] => bool(false)
  ["_GET"] => array(1) {
    ["/threads/randomthread_8012/add-reply"] => string(0) ""
  }
  ["_POST"] => array(10) {
    ["message_html"] => string(11) "<p>test</p>"
    ["author_user_id"] => string(1) "1"
    ["attachment_hash"] => string(32) "489694b8b99b2d04f64a4fd2991b65c2"
    ["attachment_hash_combined"] => string(86) "{"type":"post","context":{"thread_id":8012},"hash":"489694b8b99b2d04f64a4fd2991b65c2"}"
    ["last_date"] => string(10) "1565122625"
    ["last_known_date"] => string(10) "1565122573"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(47) "/threads/randomthread.8012/page-1167"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[djbaxter]

Split the thread.

Move the last couple or couple of hundred of posts top {thread title} Part 2 in the same forum and then close part 1.

 

[siONtI]

Splitting the thread is not an option.
Any other solution?

 

[Xon]

~128mb is probably not enough memory, try allowing 256mb per php worker.