mozilla-services / mozilla-services/updatebot
Updatebot Task cannot connect to MySQL instance
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 9
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
Seems to be an infrequent occurrence (this is the first I've seen) but putting it on file so we can track how many times it happens.
For an unknown reason, Updatebot can't connect to the sql proxy.
[task 2021-03-29T18:03:14.594Z] no sqlproxy output in 2 seconds, this means it probably didn't error.
[task 2021-03-29T18:03:14.594Z] Getting Updatebot ready...
[task 2021-03-29T18:03:14.594Z] Writing local config file
[task 2021-03-29T18:03:14.594Z] Running updatebot
[task 2021-03-29T18:03:15.417Z] Traceback (most recent call last):
[task 2021-03-29T18:03:15.417Z] File "/builds/worker/.cache/pypoetry/virtualenvs/updatebot-VFmGBxYp-py3.7/lib/python3.7/site-packages/pymysql/connections.py", line 583, in connect
[task 2021-03-29T18:03:15.417Z] **kwargs)
[task 2021-03-29T18:03:15.417Z] File "/usr/lib/python3.7/socket.py", line 727, in create_connection
[task 2021-03-29T18:03:15.417Z] raise err
[task 2021-03-29T18:03:15.417Z] File "/usr/lib/python3.7/socket.py", line 716, in create_connection
[task 2021-03-29T18:03:15.417Z] sock.connect(sa)
[task 2021-03-29T18:03:15.417Z] ConnectionRefusedError: [Errno 111] Connection refused
First occurrence: https://firefox-ci-tc.services.mozilla.com/tasks/Y65-olGBQcS80Buc-0euCg/runs/0
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the linked task run and its pymysql connection failure, then trace Updatebot’s SQL-proxy startup and MySQL connection configuration in the repository. Done means identifying why the proxy connection was refused and recording or addressing a reproducible fix; the issue names no target file or test.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100