https://linen.dev logo
#plugins-general
Title
# plugins-general
i

irfan_alam

01/06/2021, 2:48 AM
I am getting this error -
psycopg2.OperationalError: SSL SYSCALL error: EOF detected
While transferring data from tap-postgres to target-postgres. The table has about 32 Lac rows.
Copy code
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?