singer-io/tap-postgres

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

Opened this issue · 0 comments

`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`