[SOLVED] instructure-dap-client - asyncio:Fatal error on SSL transport

David-Torrens
Community Novice
‎10-25-2023 03:16 AM

Hi all,

Syncing was working previously (mid August).

Changes since then.

Destination database upgraded from PostgreSQL 9 to 11.
dap client from 0.3.10 to 0.3.15

It looks like a TLS cert issue, but the cert on the destination is valid until 23rd of August 2024. CA is AWS.

 

Thank you.



> dap syncdb --connection-string postgresql://tst_canvas_sync01:'REDACTED'@tst-think03.rds.amazonaws.com/tst_canvas_sync01 --namespace canvas --table accounts

2023-10-11 15:41:29,961 - INFO - Query started with job ID: 510fc847-5334-4eae-9948-2fc69c976782
2023-10-11 15:41:29,961 - INFO - Query job still in status: waiting. Checking again in 5 seconds...
2023-10-11 15:41:35,102 - INFO - Query job still in status: running. Checking again in 5 seconds...
2023-10-11 15:41:40,243 - INFO - Query job still in status: running. Checking again in 5 seconds...
2023-10-11 15:41:45,357 - INFO - Query job still in status: running. Checking again in 5 seconds...
2023-10-11 15:41:50,657 - INFO - Query job still in status: running. Checking again in 5 seconds...
2023-10-11 15:41:55,839 - INFO - Query job still in status: running. Checking again in 5 seconds...
2023-10-11 15:42:01,186 - INFO - Query job still in status: running. Checking again in 5 seconds...
2023-10-11 15:42:06,304 - INFO - Query job still in status: running. Checking again in 5 seconds...
2023-10-11 15:42:11,438 - INFO - Query job still in status: running. Checking again in 5 seconds...
2023-10-11 15:42:16,580 - INFO - Query job still in status: running. Checking again in 5 seconds...
2023-10-11 15:42:29,205 - INFO - Data has been successfully retrieved:
{"id": "510fc847-5334-4eae-9948-2fc69c976782", "status": "complete", "expires_at": "2023-10-12T15:41:28Z", "objects": [{"id": "510fc847-5334-4eae-9948-2fc69c976782/part-00000-70f937f7-2eb7-4048-a71d-ad3a2b9d274e-c000.json.gz"}], "schema_version": 2, "since": "2023-10-11T04:41:44Z", "until": "2023-10-11T14:00:39Z"}
ERROR:asyncio:Fatal error on SSL transport
protocol: <asyncio.sslproto.SSLProtocol object at 0x7fb06aaf6f20>
transport: <_SelectorSocketTransport closing fd=6>
Traceback (most recent call last):
  File "/usr/lib/python3.10/asyncio/selector_events.py", line 924, in write
    n = self._sock.send(data)
OSError: [Errno 9] Bad file descriptor

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3.10/asyncio/sslproto.py", line 690, in _process_write_backlog
    self._transport.write(chunk)
  File "/usr/lib/python3.10/asyncio/selector_events.py", line 930, in write
    self._fatal_error(exc, 'Fatal write error on socket transport')
  File "/usr/lib/python3.10/asyncio/selector_events.py", line 725, in _fatal_error
    self._force_close(exc)
  File "/usr/lib/python3.10/asyncio/selector_events.py", line 737, in _force_close
    self._loop.call_soon(self._call_connection_lost, exc)
  File "/usr/lib/python3.10/asyncio/base_events.py", line 753, in call_soon
    self._check_closed()
  File "/usr/lib/python3.10/asyncio/base_events.py", line 515, in _check_closed
    raise RuntimeError('Event loop is closed')
RuntimeError: Event loop is closed

0 Likes