Skip to content

OSError: [Errno 22] Invalid argument when use tap-postgres with target-bigquery #115

@sonnh97

Description

@sonnh97
`INFO Failed to retrieve SSL status
INFO Selected streams: ['poseidon-public-po_order']
INFO No currently_syncing found
INFO Beginning sync of stream(poseidon-public-po_order) with sync method(incremental)
INFO Stream poseidon-public-po_order is using incremental replication with replication key id
CRITICAL [Errno 22] Invalid argument
Traceback (most recent call last):
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\runpy.py", line 193, in _run_module_as_main
    "__main__", mod_spec)
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36\Scripts\tap-postgres.exe\__main__.py", line 7, in <module>
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\site-packages\tap_postgres\__init__.py", line 711, in main
    raise exc
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\site-packages\tap_postgres\__init__.py", line 708, in main
    main_impl()
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\site-packages\tap_postgres\__init__.py", line 702, in main_impl
    do_sync(conn_config, args.properties, args.config.get('default_replication_method'), state)
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\site-packages\tap_postgres\__init__.py", line 669, in do_sync
    state = sync_traditional_stream(conn_config, stream, state, sync_method_lookup[stream['tap_stream_id']], end_lsn)
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\site-packages\tap_postgres\__init__.py", line 558, in sync_traditional_stream
    state = do_sync_incremental(conn_config, stream, state, desired_columns, md_map)
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\site-packages\tap_postgres\__init__.py", line 467, in do_sync_incremental
    sync_common.send_schema_message(stream, [replication_key])
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\site-packages\tap_postgres\sync_strategies\common.py", line 31, in send_schema_message
    write_schema_message(schema_message)
  File "c:\users\administrator\appdata\local\programs\python\python36\lib\site-packages\tap_postgres\sync_strategies\common.py", line 15, in write_schema_message
    sys.stdout.flush()
OSError: [Errno 22] Invalid argument
Exception ignored in: <_io.TextIOWrapper name='<stdout>' mode='w' encoding='cp1252'>
OSError: [Errno 22] Invalid argument`

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions