Skip to content
This repository has been archived by the owner on Sep 23, 2024. It is now read-only.

Connection Lost - No Retry (Feature Request?) #10

Open
visch opened this issue Apr 1, 2021 · 0 comments
Open

Connection Lost - No Retry (Feature Request?) #10

visch opened this issue Apr 1, 2021 · 0 comments
Labels
bug Something isn't working

Comments

@visch
Copy link

visch commented Apr 1, 2021

Describe the bug
Internet connection went out in the middle of pulling data.

tap-oracle | CRITICAL ORA-03135: connection lost contact
tap-oracle | Process ID: 944
tap-oracle | Session ID: 756 Serial number: 28249
tap-oracle | Traceback (most recent call last):
tap-oracle |   File "/home/visch/git/oracle2mssql/oracle2mssql/.meltano/extractors/tap-oracle/venv/bin/tap-oracle", line 8, in <module>
tap-oracle |     sys.exit(main())
tap-oracle |   File "/home/visch/git/oracle2mssql/oracle2mssql/.meltano/extractors/tap-oracle/venv/lib/python3.8/site-packages/tap_oracle/__init__.py", line 565, in main
tap-oracle |     raise exc
tap-oracle |   File "/home/visch/git/oracle2mssql/oracle2mssql/.meltano/extractors/tap-oracle/venv/lib/python3.8/site-packages/tap_oracle/__init__.py", line 562, in main
tap-oracle |     main_impl()
tap-oracle |   File "/home/visch/git/oracle2mssql/oracle2mssql/.meltano/extractors/tap-oracle/venv/lib/python3.8/site-packages/tap_oracle/__init__.py", line 556, in main_impl
tap-oracle |     do_sync(conn_config, args.catalog, args.config.get('default_replication_method'), state)
tap-oracle |   File "/home/visch/git/oracle2mssql/oracle2mssql/.meltano/extractors/tap-oracle/venv/lib/python3.8/site-packages/tap_oracle/__init__.py", line 533, in do_sync
tap-oracle |     state = sync_traditional_stream(conn_config, stream, state, sync_method_lookup[stream.tap_stream_id], end_scn)
tap-oracle |   File "/home/visch/git/oracle2mssql/oracle2mssql/.meltano/extractors/tap-oracle/venv/lib/python3.8/site-packages/tap_oracle/__init__.py", line 471, in sync_traditional_stream
tap-oracle |     state = full_table.sync_table(conn_config, stream, state, desired_columns)
tap-oracle |   File "/home/visch/git/oracle2mssql/oracle2mssql/.meltano/extractors/tap-oracle/venv/lib/python3.8/site-packages/tap_oracle/sync_strategies/full_table.py", line 160, in sync_table
tap-oracle |     connection.close()
tap-oracle | cx_Oracle.OperationalError: ORA-03135: connection lost contact
tap-oracle | Process ID: 944
tap-oracle | Session ID: 756 Serial number: 28249

To Reproduce
Steps to reproduce the behavior:

  1. Start pulling data from Oracle
  2. Turn off your internet connection
  3. Turn your internet connection back on

Expected behavior
If the connection to the database comes back before a defined timeout then I'd expect the data pull to continue running or retry.

Your environment

  • Version of tap: latest
  • Version of python 3.8

Additional context
Add any other context about the problem here.

@visch visch added the bug Something isn't working label Apr 1, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant