sumotools1.webapp.phx1.mozilla.com no longer getting dumps from input

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
--
blocker
RESOLVED FIXED
5 years ago
3 years ago

People

(Reporter: Cww, Assigned: sheeri)

Tracking

Details

(Reporter)

Description

5 years ago
We had input.mozilla.org database dumps fed into the sumotools1.webapp.phx1.mozilla.com (input_mozilla_org_new database). This apparently broke on August 13th. It's critical for all feedback reporting that is done by the team including the weekly Firefox OS report and desktop/android feedback reports.

Updated

5 years ago
Assignee: infra → server-ops-database
Component: Infrastructure: Other → Server Operations: Database
Product: Infrastructure & Operations → mozilla.org
QA Contact: jdow → scabral
(Assignee)

Comment 1

5 years ago
Will look into it.
(Assignee)

Updated

5 years ago
Assignee: server-ops-database → scabral
(Assignee)

Comment 2

5 years ago
It ran manually with no errors, so you should have the data you need now.

The hourly exports are in /data/backup-drop/generic/input_mozilla_org_new/, they come in at 15 minutes after the hour, and they look like they're the right size.

The cron job is scheduled to run every hour on 20 minutes past the hour, so that shouldn't be a problem.

There are no cron errors sent to infra-dbnotices.

crond is running.

The cron file was set to be 0755 instead of 0644, I'll recheck in 15 mins or so after the run should have happened, to see if the import is successful after this change.
(Assignee)

Comment 3

5 years ago
These have been working for the last week; resolving. Please reopen if there's an issue.
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.