Unable to connect to production database from bedrock admin node

RESOLVED FIXED

Status

Infrastructure & Operations
WebOps: Other
RESOLVED FIXED
2 years ago
2 years ago

People

(Reporter: jgmize, Unassigned)

Tracking

Details

(Whiteboard: [kanban:https://webops.kanbanize.com/ctrl_board/2/2255] )

(Reporter)

Description

2 years ago
First noticed by :lizzard due to delays publishing Firefox 43.0b6. 

Steps to replicate:

ssh bedrockadm
source /data/bedrock/www/www.mozilla.org-django/venv/bin/activate
cd /data/bedrock/src/www.mozilla.org-django/bedrock
./manage.py update_product_details"

Results in traceback, last line is:

OperationalError: (2013, "Lost connection to MySQL server at 'reading initial communication packet', system error: 0")

This happens for any command that attempts to connect to the prod db.

Updated

2 years ago
Whiteboard: [kanban:https://webops.kanbanize.com/ctrl_board/2/2255]

Updated

2 years ago
Depends on: 1227765

Comment 1

2 years ago
My apologies: switching over the bedrockadm  host to use the SCL3 DB VIPs got missed in this rush.

The command given above appears to be working now. [1]  Please have the #moc poke me if it looks like we're still having issues.


[1]
$ ./manage.py update_product_details
Updating firefox_primary_builds.json from server
Updating firefox_history_major_releases.json from server
Updating mobile_history_development_releases.json from server
Updating firefox_history_stability_releases.json from server
Updating thunderbird_history_major_releases.json from server
Updating mobile_history_stability_releases.json from server
Updating thunderbird_primary_builds.json from server
Updating thunderbird_beta_builds.json from server
Updating thunderbird_history_development_releases.json from server
Updating firefox_history_development_releases.json from server
Updating mobile_details.json from server
Updating languages.json from server
Updating thunderbird_versions.json from server
Updating firefox_versions.json from server
Updating mobile_history_major_releases.json from server
Updating firefox_beta_builds.json from server
Updating thunderbird_history_stability_releases.json from server
Regions were up to date.
(Reporter)

Comment 2

2 years ago
Thanks :cyliang, I verified this issue is resolved. Unfortunately I found a separate issue while verifying see bug 1227868.
Status: NEW → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → FIXED
(Reporter)

Updated

2 years ago
See Also: → bug 1227868
You need to log in before you can comment on or make changes to this bug.