Closed Bug 1323053 Opened 9 years ago Closed 9 years ago

FxA redash queries stuck in "Query in queue..."

Categories

(Cloud Services :: Metrics: Data Tools, defect, P2)

Product:
Cloud Services
Component:
Metrics: Data Tools
Type:
defect
Points:
1

Tracking

(Not tracked)

Status:
RESOLVED WORKSFORME

People

(Reporter: rfkelly, Unassigned)

References

Details

(Whiteboard: [SvcOps])

I haven't been able to run any re:dash queries against the FxA redshift instance for a couple of days now. When I press "execute" on a query like this one: https://sql.telemetry.mozilla.org/queries/1867/source It submits the query, but the status never moves past "Query in queue...". Our dashboards, usually updated daily, are reporting their last update was 4 days ago: https://sql.telemetry.mozilla.org/dashboard/fxa-kpis I wonder if something is stuck inside redash and preventing queries from executing?
Whiteboard: [SvcOps]
Blake can you take a look?
Points: --- → 1
Flags: needinfo?(bimsland)
Priority: -- → P2
Component: Metrics: Pipeline → Metrics: Data Tools
It looks like queries may be up and running again now, I can see some re:dash scheduled jobs running the AWS management console for redshift. I'll keep an eye on them and close this bug if it everything seems back to normal.
Looks like queries are running properly now, closing this out.
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → WORKSFORME
Flags: needinfo?(bimsland)
You need to log in before you can comment on or make changes to this bug.