603707 - Topcrashers controller is returning a 500 Internal Server Error after staging was updated this morning

Status: VERIFIED FIXED

(Socorro :: General, task)

Description

[Stephen Donner [:stephend] Not actively reading bugmail]

(According to Ryan, this starting happening after the most recent push to stage 10:30 am.)

There is an issue with the topcrashers controller: specifically, it's returning a 500 Internal Server Error:

http://crash-stats.stage.mozilla.com/topcrasher/byversion/Firefox/3.6.9

GET /topcrasher/byversion/Firefox/3.6.9 HTTP/1.1
Host: crash-stats.stage.mozilla.com
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en,en-us;q=0.5
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 115
Connection: keep-alive
Referer: http://crash-stats.stage.mozilla.com/topcrasher/byversion/Firefox/3.6.9
<snip>

HTTP/1.1 500 Internal Server Error
Date: Tue, 12 Oct 2010 18:59:37 GMT
Server: Apache/2.2.3 (Red Hat)
X-Powered-By: PHP/5.2.9
Content-Length: 1930
Connection: close
Content-Type: text/html; charset=UTF-8

Comment 1

[Stephen Donner [:stephend] Not actively reading bugmail]

(Probably not really related, but there's also bug 603569.)

Comment 2

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

There's nothing out of the ordinary found in the Kohana log.

The other night we created dropped and re-created the builds table on stage.  I noticed the same orange screen of failure on the builds page.  We tracked down the problem, which ended up being a database permissions error.  Since we added a new table to the database, that should probably be the next step.

Jabba, can you please edit the priveleges for the db user using the following command (enter the appropriate username):

GRANT SELECT, UPDATE, INSERT, DELETE ON signature_productdims TO username;

Comment 3

[Justin Dow [:jabba]]

I ran the command successfully.

Comment 4

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

Thanks Jabba! - that fixed the problem.  We now see results on:

http://crash-stats.stage.mozilla.com/topcrasher/byversion/Firefox/3.6.9

Comment 5

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED; thanks!