1205065 - inventory.mozilla.com report generation timeout

Status: RESOLVED FIXED

(Infrastructure & Operations :: Infrastructure: Tools, task)

Description

[Adam Muntner [:adamm] (use NEEDINFO)]

When attempting to generate a report from the inventory database using the available options of screen or csv output, the query/script is timed out by the webserver. 

The user's browser reports: 

"Service Unavailable

The service is temporarily unavailable. Please try again later."

Is there something wrong with the server/app, or does the max query time setting just need to be lengthened?

Comment 1

[Rob Tucker [:rtucker]]

Basically depending on the queries entered, they can get extremely resource intensive.
I can pretty easily generate more complicated reports by hand though.

My suggestion is we won'tfix this as inventory is set to be deprecated and I can generate a report for you by hand.

/cc cshields for his comment

Comment 2

[Adam Muntner [:adamm] (use NEEDINFO)]

Rob, can you please generate a list of all production systems in Inventory?

Comment 3

[Rob Tucker [:rtucker]]

Can you be specific about the fields you need in the report please?

Comment 4

[Adam Muntner [:adamm] (use NEEDINFO)]

Just hostname and allocated to, please.

Comment 5

[Rob Tucker [:rtucker]]

(In reply to Adam Muntner :adamm from comment #4)
> Just hostname and allocated to, please.

I've sent you a report. It has a few extra columns, but you should be able to easily disregard.

Comment 6

[Rob Tucker [:rtucker]]

I haven't heard any complaints about the report I sent. 
going to close this out