Hi,
After upgrading Redash (stand-alone) from V4 to V7 via upgrade script, I have an issue with Athena DB connector.
I also updated python requirements.txt according to my github thread (https://github.com/getredash/redash/issues/3979)
But still I am getting the same error.
I would like to move to docker but I can find fully guide on how to do that.
Redash is running on nginx.
Steps to Reproduce
- sudo upgrade
- sudo service nginx restart
- Test Athena connection
- sudo pip install pyathena (latest version)
- updating requirements_all_ds.txt from git
- sudo pip install -Iv snowflake-connector-python==1.6.10
- restating nginx again
this is the error message:
[2019-07-15 09:13:11,670][PID:20972][DEBUG][snowflake.connector.ocsp_pyopenssl] Produced At: 20190715071240Z
[2019-07-15 09:13:11,713][PID:20972][DEBUG][botocore.vendored.requests.packages.urllib3.connectionpool] “POST / HTTP/1.1” 200 471
[2019-07-15 09:13:11,719][PID:20972][DEBUG][snowflake.connector.ocsp_pyopenssl] Certificate is attached in Basic OCSP Response: Certs:
[2019-07-15 09:13:11,721][PID:20972][WARNING][snowflake.connector.ocsp_pyopenssl] Failed to get OCSP response: Attempted " eq " operation on ASN.1 schema object. Retrying…1/3 .
[2019-07-15 09:13:11,721][PID:20972][INFO][snowflake.connector.ocsp_pyopenssl] getting OCSP response from remote
[2019-07-15 09:13:11,726][PID:20972][DEBUG][botocore.vendored.requests.packages.urllib3.util.retry] Converted retries value: 5 -> Retry(total=5, connect=None, read=None, redirect=None)
[2019-07-15 09:13:11,726][PID:20972][DEBUG][botocore.vendored.requests.packages.urllib3.util.retry] Converted retries value: 5 -> Retry(total=5, connect=None, read=None, redirect=None)
[2019-07-15 09:13:11,732][PID:20972][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): 13.224.68.150
[2019-07-15 09:13:11,769][PID:20972][INFO][snowflake.connector.ocsp_pyopenssl] ok
[2019-07-15 09:13:11,770][PID:20972][DEBUG][snowflake.connector.ocsp_pyopenssl] Tolerable Validity range for OCSP response: +1296(s)
[2019-07-15 09:13:11,776][PID:20972][INFO][snowflake.connector.ocsp_pyopenssl] ok
[2019-07-15 09:13:11,777][PID:20972][DEBUG][snowflake.connector.ocsp_pyopenssl] Tolerable Validity range for OCSP response: +6084(s)
[2019-07-15 09:13:11,780][PID:20972][INFO][snowflake.connector.ocsp_pyopenssl] ok
[2019-07-15 09:13:11,781][PID:20972][DEBUG][snowflake.connector.ocsp_pyopenssl] Tolerable Validity range for OCSP response: +6084(s)
[2019-07-15 09:13:11,825][PID:20972][DEBUG][botocore.vendored.requests.packages.urllib3.connectionpool] “POST / HTTP/1.1” 200 471
[2019-07-15 09:13:11,828][PID:20972][DEBUG][snowflake.connector.ocsp_pyopenssl] Certificate is attached in Basic OCSP Response: Certs:
[2019-07-15 09:13:11,828][PID:20972][WARNING][snowflake.connector.ocsp_pyopenssl] Failed to get OCSP response: Attempted " eq " operation on ASN.1 schema object. Retrying…2/3 .
[2019-07-15 09:13:11,828][PID:20972][INFO][snowflake.connector.ocsp_pyopenssl] getting OCSP response from remote
[2019-07-15 09:13:11,830][PID:20972][DEBUG][botocore.vendored.requests.packages.urllib3.util.retry] Converted retries value: 5 -> Retry(total=5, connect=None, read=None, redirect=None)
[2019-07-15 09:13:11,830][PID:20972][DEBUG][botocore.vendored.requests.packages.urllib3.util.retry] Converted retries value: 5 -> Retry(total=5, connect=None, read=None, redirect=None)
[2019-07-15 09:13:11,831][PID:20972][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): 13.224.68.131
[2019-07-15 09:13:11,963][PID:20972][DEBUG][botocore.vendored.requests.packages.urllib3.connectionpool] “POST / HTTP/1.1” 200 471
[2019-07-15 09:13:11,966][PID:20972][DEBUG][snowflake.connector.ocsp_pyopenssl] Certificate is attached in Basic OCSP Response: Certs:
[2019-07-15 09:13:11,966][PID:20972][WARNING][snowflake.connector.ocsp_pyopenssl] Failed to get OCSP response: Attempted " eq " operation on ASN.1 schema object. Retrying…3/3 .
[2019-07-15 09:13:11,976][PID:20972][DEBUG][botocore.endpoint] Exception received when sending HTTP request.
Traceback (most recent call last):
File “/usr/local/lib/python2.7/dist-packages/botocore/endpoint.py”, line 204, in _get_response
if handler_response is None:
File “/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/sessions.py”, line 573, in send
r = adapter.send(request, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/adapters.py”, line 370, in send
timeout=timeout
File “/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connectionpool.py”, line 544, in urlopen
body=body, headers=headers)
File “/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connectionpool.py”, line 341, in _make_request
self._validate_conn(conn)
File “/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connectionpool.py”, line 761, in _validate_conn
conn.connect()
File “/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connection.py”, line 238, in connect
ssl_version=resolved_ssl_version)
File “/usr/local/lib/python2.7/dist-packages/snowflake/connector/ssl_wrap_socket.py”, line 750, in ssl_wrap_socket_with_ocsp
File “/usr/local/lib/python2.7/dist-packages/snowflake/connector/ocsp_pyopenssl.py”, line 1097, in validate
File “/usr/lib/python2.7/multiprocessing/pool.py”, line 567, in get
raise self._value
PyAsn1Error: Attempted " eq " operation on ASN.1 schema object
- Redash Version: 7.0.0+b17535 (15c815f)
- Browser/OS: chrome/windows 10
- How did you install Redash: with upgrade script