irfan_alam
01/06/2021, 2:48 AMpsycopg2.OperationalError: SSL SYSCALL error: EOF detected
While transferring data from tap-postgres to target-postgres.
The table has about 32 Lac rows.
meltano | Running extract & load...
meltano | No state was found, complete import.
target-postgres | INFO PostgresTarget created with established connection: `user=xxx password=xxx dbname=xxx host=xxx port=xxx sslmode=prefer sslcert=~/.postgresql/postgresql.crt sslkey=~/.postgresql/postgresql.key sslrootcert=~/.postgresql/root.crt sslcrl=~/.postgresql/root.crl`, PostgreSQL schema: `xxx_schema`
tap-postgres | time=2021-01-05 19:16:58 name=tap_postgres level=INFO message=Selected streams: []
target-postgres | INFO Sending version information to <http://singer.io|singer.io>. To disable sending anonymous usage data, set the config parameter "disable_collection" to true
tap-postgres | time=2021-01-05 19:25:57 name=tap_postgres level=INFO message=No streams marked as currently_syncing in state file
target-postgres | Traceback (most recent call last):
target-postgres | File "/project/.meltano/loaders/target-postgres/venv/bin/target-postgres", line 8, in <module>
target-postgres | sys.exit(cli())
target-postgres | File "/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/__init__.py", line 45, in cli
target-postgres | main(args.config)
target-postgres | File "/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/__init__.py", line 39, in main
target-postgres | target_tools.main(postgres_target)
target-postgres | psycopg2.OperationalError: SSL SYSCALL error: EOF detected
target-postgres |
meltano | Loading failed (1): (see above)
meltano | ELT could not be completed: Target failed
Can anyone please help?