Forums

Error issue on PA but not locally

.

Successfully deleted all error logs on 2023-11-17 04:01:26.200802
2023-11-17 04:01:38,877: Exception on /db [GET]
urllib3.exceptions.SSLError: [SSL: DECRYPTION_FAILED_OR_BAD_RECORD_MAC] decryption failed or bad record mac (_ssl.c:2548)
**NO MATCH**
The above exception was the direct cause of the following exception:
**NO MATCH**
Traceback (most recent call last):
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/requests/adapters.py", line 486, in send
    resp = conn.urlopen(
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/urllib3/connectionpool.py", line 844, in urlopen
    retries = retries.increment(
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/urllib3/util/retry.py", line 515, in increment
    raise MaxRetryError(_pool, url, reason) from reason  # type: ignore[arg-type]
urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='sheets.googleapis.com', port=443): Max retries exceeded with url: /v4/spreadsheets/1GQjQCGu63a5rzG7QbwHtZs3qPSpoCS8NRAIXfv1a1ik/values/%27DB_Prod%27 (Caused by SSLError(SSLError(1, '[SSL: DECRYPTION_FAILED_OR_BAD_RECORD_MAC] decryption failed or bad record mac (_ssl.c:2548)')))
**NO MATCH**
During handling of the above exception, another exception occurred:
**NO MATCH**
Traceback (most recent call last):
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/flask/app.py", line 1455, in wsgi_app
    response = self.full_dispatch_request()
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/flask/app.py", line 869, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/flask/app.py", line 867, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/flask/app.py", line 852, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
  File "/home/cargotec/WebApp_adeudos/Flask_app.py", line 315, in show_database
    list_of_Lists = wb_names_pr.get_all_values()
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/gspread/utils.py", line 732, in wrapper
    return f(*args, **kwargs)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/gspread/worksheet.py", line 502, in get_all_values
    return self.get_values(**kwargs)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/gspread/utils.py", line 732, in wrapper
    return f(*args, **kwargs)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/gspread/worksheet.py", line 467, in get_values
    vals = fill_gaps(self.get(range_name, **kwargs))
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/gspread/utils.py", line 732, in wrapper
    return f(*args, **kwargs)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/gspread/worksheet.py", line 868, in get
    response = self.spreadsheet.values_get(range_name, params=params)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/gspread/spreadsheet.py", line 175, in values_get
    r = self.client.request("get", url, params=params)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/gspread/client.py", line 81, in request
    response = getattr(self.session, method)(
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/requests/sessions.py", line 602, in get
    return self.request("GET", url, **kwargs)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/google/auth/transport/requests.py", line 542, in request
    response = super(AuthorizedSession, self).request(
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/requests/sessions.py", line 589, in request
    resp = self.send(prep, **send_kwargs)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/requests/sessions.py", line 703, in send
    r = adapter.send(request, **kwargs)
  File "/home/cargotec/.virtualenvs/venv/lib/python3.10/site-packages/requests/adapters.py", line 517, in send
    raise SSLError(e, request=request)
requests.exceptions.SSLError: HTTPSConnectionPool(host='sheets.googleapis.com', port=443): Max retries exceeded with url: /v4/spreadsheets/1GQjQCGu63a5rzG7QbwHtZs3qPSpoCS8NRAIXfv1a1ik/values/%27DB_Prod%27 (Caused by SSLError(SSLError(1, '[SSL: DECRYPTION_FAILED_OR_BAD_RECORD_MAC] decryption failed or bad record mac (_ssl.c:2548)')))

Have a look at this Stack Overflow forum discussion -- some users suggest adding keep-alive option to headers, while others propose upgrading urllib3.