trying to delete a test review results in a "500 Internal Server Error"

[Steve McInerney]

Via the admin interface, and on request:
https://reviews.staging.ubuntu.com/admin/reviewsapp/review/1424/delete/

generates:
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

[Michael Nelson (michael.nelson)]

Hi Steve.

Looking at the rnr.log on vanadium, from 2011-11-30 11:26, we had 3 occurrences [1] of bug 873228 before midnight (an SSO bug, that affects us and other services using SSO). Assuming that matches with you, then this is an SSO issue, a dupe of bug 873228.

However, at 2011-12-01 03:06 we saw 'FATAL: the database system is shutting down' [2], though that seems to have rectified itself within the minute.

[1] https://pastebin.canonical.com/56602/
[2] https://pastebin.canonical.com/56604/

[Michael Nelson (michael.nelson)]

On Thu, Dec 1, 2011 at 1:17 PM, Michael Nelson
<email address hidden> wrote:
> Hi Steve.
>
> Looking at the rnr.log on vanadium, from 2011-11-30 11:26, we had 3
> occurrences [1] of bug 873228 before midnight (an SSO bug, that affects
> us and other services using SSO). Assuming that matches with you, then
> this is an SSO issue, a dupe of bug 873228.
>
> However, at 2011-12-01 03:06 we saw 'FATAL: the database system is
> shutting down' [2], though that seems to have rectified itself within
> the minute.
>
> [1] https://pastebin.canonical.com/56602/
> [2] https://pastebin.canonical.com/56604/

Sorry - All the above errors were on production, I'd failed to see you
were using staging.

>
> --
> You received this bug notification because you are a member of Ratings
> and Reviews Developers, which is subscribed to Ratings and Reviews
> server.
> https://bugs.launchpad.net/bugs/898402
>
> Title:
>  trying to delete a test review results in a "500 Internal Server
>  Error"
>
> Status in Ratings and Reviews server:
>  New
>
> Bug description:
>  Via the admin interface, and on request:
>  https://reviews.staging.ubuntu.com/admin/reviewsapp/review/1424/delete/
>
>  generates:
>  Internal Server Error
>
>  The server encountered an internal error or misconfiguration and was
>  unable to complete your request.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/rnr-server/+bug/898402/+subscriptions

--
Michael Nelson
Canonical Ltd.
[phone] (mob)
<email address hidden>
IRC nick: noodles (noodles775 on Freenode)
Ubuntu - Linux for human beings | www.ubuntu.com | www.canonical.com

[Anthony Lenton (elachuni)]

Right, got the logs for staging, the traceback is
https://pastebin.canonical.com/56660/
(same issue that hit thedac today)

It explains why you can't do anything via the admin that would write to the DB, it's missing the table to write the adminaudit logs to.