#6539 Timeouts on approving moderated comments [ss4838]

v1.0.1
closed
General
2015-08-20
2013-08-08
Chris Tsai
No

[forge:site-support:#4838]

Guys, it's really annoying when 7 from 10 attempts apply any moderation ends by error 500 and description "Oops, looks like something went wrong."

After asking for further information, and these are for approving anonymous comments, and this appears to be a timeout issue. This is ongoing for the reporter when he moderates comments on the stellarium forums. I believe he is eventually able to get it to go through, but it takes a number of tries usually.

Discussion

  • Dave Brondsema

    Dave Brondsema - 2013-09-03

    Slow query is:

    Tue Sep  3 02:38:51.369 [conn3931298] query project-data.forum_post query: { full_slug: "20130903021406:8611" } ntoreturn:0 ntoskip:0 nscanned:2952357 keyUpdates:0 numYields: 926 locks(micros) r:55718061 nreturned:1 reslen:567 30783ms
    
     
  • Dave Brondsema

    Dave Brondsema - 2013-09-03
    • status: open --> in-progress
    • assigned_to: Dave Brondsema
    • Size: --> 1
    • Milestone: limbo --> forge-sep-06
     
  • Dave Brondsema

    Dave Brondsema - 2013-09-03
    • status: in-progress --> code-review
     
  • Dave Brondsema

    Dave Brondsema - 2013-09-03

    db/6539

    To test, make sure that moderating still works. It's not really feasible to replicate the slowness locally, but inspecting the code and the slow query log I found should make it clear this is better

     
  • Tim Van Steenburgh

    • QA: Tim Van Steenburgh
     
  • Tim Van Steenburgh

    • status: code-review --> closed
     

Log in to post a comment.