Timeout when converting bug into question (BugTask:+create-question)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Curtis Hovey |
Bug Description
*** pg8.4 *** OOPS-1759ED1387
Note that while *this* one is a soft timeout, we've seen hard timeouts too, and the fact that the session is being updated correctly sftrongly suffests that the appserver thread state is being preserved for the whole time,which is undesirable.
https:/
Branch: launchpad-rev-9760
Revno: 9760
SQL time: 3065 ms
Non-sql time: 29668 ms
Total time: 32733 ms
Statement Count: 676
https:/
This send 115 emails, and by subtracting the time between the last two events and dividing, its ~ 200ms per email, +- say 30.
emails are buffered in memory and then spooled once the DB commits (so that we don't mail twice in the event of automatic retry.
672. 6042 1ms SQL-launchpad-
673. 32722 1ms SQL-session UPDATE SessionData SET last_accessed = CURRENT_TIMESTAMP WHERE client_id = %s AND last_accessed < CURRENT_TIMESTAMP - '540 seconds'::interval
There are a few things that may need looking at here:
- why is it taking 200ms to queue a mail
- why isn't the offload-to-thread stuff working?
There are a couple of things highlighted by this too:
- we don't see the commit in the oops details
- we're not getting a hard timeout and we should
In terms of code, the mail sending code is
lp.bugs.
which is bug.convertToQu
which does notify(
(Based on looking at where the sends occur relative to the question being made in the action trace.
Related branches
- Brad Crittenden (community): Approve (code)
-
Diff: 291 lines (+115/-27)6 files modifiedlib/lp/answers/doc/notifications.txt (+8/-4)
lib/lp/answers/model/question.py (+12/-7)
lib/lp/answers/notification.py (+17/-10)
lib/lp/answers/tests/test_question_notifications.py (+32/-1)
lib/lp/answers/tests/test_questiontarget.py (+42/-1)
lib/lp/bugs/tests/test_bugtarget.py (+4/-4)
summary: |
Timeout Error (OOPS-1367EC560) When Converting Bug into Question + (BugTask:+create-question) |
tags: |
added: timeout removed: oops |
summary: |
- Timeout Error (OOPS-1367EC560) When Converting Bug into Question - (BugTask:+create-question) + Timeout when converting bug into question (BugTask:+create-question) |
description: | updated |
description: | updated |
tags: | added: pg83 |
tags: | removed: pg83 |
description: | updated |
affects: | launchpad-foundations → launchpad-answers |
Changed in launchpad: | |
importance: | High → Critical |
Changed in launchpad: | |
status: | Triaged → Fix Released |
status: | Fix Released → Triaged |
Changed in launchpad: | |
status: | Fix Committed → In Progress |
tags: | removed: qa-untestable |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
I have also experienced this problem attempting to turn https:/ /bugs.edge. launchpad. net/ubuntu/ +bug/254130/ +create- question into a question. It timed out with Error ID: OOPS-1403ED797. I am also using the "bugs.edge. launchpad. net" server and I accessed the site with Firefox 3.5.4. I attempted to do this 4 times over a 3 hour period without success. The first 3 attempts included a comment and the last did not (to see whether it was part of the problem). This is also my first bug to question conversion attempt.
Is there any workaround so that the handling of the bug I was trying to convert can be completed?