Closed
Bug 538649
Opened 15 years ago
Closed 15 years ago
run sql query against Socorro production for troubleshooting issue
Categories
(Infrastructure & Operations Graveyard :: WebOps: Other, task)
Tracking
(Not tracked)
RESOLVED
WORKSFORME
People
(Reporter: ozten, Unassigned)
Details
Please run the following query in production to help with troubleshooting a prod issue.
select
CAST(ceil(EXTRACT(EPOCH FROM (window_end - timestamp without time zone '2009-12-25 00:00:00' - interval '8 hours')) / 86400) AS INT) * interval '24 hours' + timestamp without time zone '2009-12-25 00:00:00' as day,
case when os.os_name = 'Windows NT' then
'Windows'
when os.os_name = 'Mac OS X' then
'Mac'
else
os.os_name
end as os_name,
sum(count)
from
top_crashes_by_signature tcbs
join osdims os on tcbs.osdims_id = os.id
and os.os_name in ('Windows','Mac OS X','Linux','Windows NT')
where
(timestamp without time zone '2009-12-25 00:00:00' - interval '8 hours') < window_end
and window_end <= (timestamp without time zone '2010-01-08 00:00:00' - interval '8 hours')
and productdims_id = 169
group by
day,
os_name
order by
1, 2;
This is a read only query... CCing morgamic for oversight.
Reporter | ||
Comment 1•15 years ago
|
||
I've found another way to troubleshoot this issue.
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → WORKSFORME
Updated•11 years ago
|
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Updated•6 years ago
|
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•