Syncing from postgres to postgres doesn't work

Connector Questions & Issues
,
1

hello, we have an error with syncing from postgres to postgres:
It worked syncing from mysql to google warehouse and all other services do sync, just postgres to postgres doesnt work.
does this log help?

   at io.temporal.internal.activity.POJOActivityTaskHandler$POJOActivityImplementation.execute(POJOActivityTaskHandler.java:180) ~[temporal-sdk-1.8.1.jar:?]
   at io.temporal.internal.activity.POJOActivityTaskHandler.handle(POJOActivityTaskHandler.java:120) ~[temporal-sdk-1.8.1.jar:?]
   at io.temporal.internal.worker.ActivityWorker$TaskHandlerImpl.handle(ActivityWorker.java:204) ~[temporal-sdk-1.8.1.jar:?]
   at io.temporal.internal.worker.ActivityWorker$TaskHandlerImpl.handle(ActivityWorker.java:164) ~[temporal-sdk-1.8.1.jar:?]
   at io.temporal.internal.worker.PollTaskExecutor.lambda$process$0(PollTaskExecutor.java:93) ~[temporal-sdk-1.8.1.jar:?]
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
   at java.lang.Thread.run(Thread.java:833) [?:?]
Caused by: java.util.concurrent.CancellationException
   at java.util.concurrent.CompletableFuture.cancel(CompletableFuture.java:2478) ~[?:?]
   at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getCancellationChecker$3(TemporalAttemptExecution.java:201) ~[io.airbyte-airbyte-workers-0.36.3-alpha.jar:?]
   at io.airbyte.workers.temporal.CancellationHandler$TemporalCancellationHandler.checkAndHandleCancellation(CancellationHandler.java:53) ~[io.airbyte-airbyte-workers-0.36.3-alpha.jar:?]
   at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getCancellationChecker$4(TemporalAttemptExecution.java:204) ~[io.airbyte-airbyte-workers-0.36.3-alpha.jar:?]
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) ~[?:?]
   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) ~[?:?]
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) ~[?:?]




   
   at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:160) ~[?:?]
   	at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:248) ~[?:?]
   	at java.io.BufferedWriter.flush(BufferedWriter.java:257) ~[?:?]
   	at io.airbyte.workers.protocols.airbyte.DefaultAirbyteDestination.notifyEndOfStream(DefaultAirbyteDestination.java:98) ~[io.airbyte-airbyte-workers-0.36.3-alpha.jar:?]
   	at io.airbyte.workers.protocols.airbyte.DefaultAirbyteDestination.close(DefaultAirbyteDestination.java:111) ~[io.airbyte-airbyte-workers-0.36.3-alpha.jar:?]
   	at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:126) ~[io.airbyte-airbyte-workers-0.36.3-alpha.jar:?]
   	at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:57) ~[io.airbyte-airbyte-workers-0.36.3-alpha.jar:?]
   	at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.36.3-alpha.jar:?]
   	at java.lang.Thread.run(Thread.java:833) [?:?]

→

  • Is this your first time deploying Airbyte?: no , it worked syncing from mysql to google warehouse and all other services do sync
  • OS Version / Instance: Ubuntu
  • Memory / Disk: 16Gb / 500 Gb
  • Deployment: No docker or Kubernetes
  • Airbyte Version: * 0.36.3-alpha
  • Source name/version: * [CORL MAIN Postgres]
  • Destination name/version: [Artichoke Warehouse NEU - Postgres]
  • Step: The issue is happening during sync
  • Description:
2

Hello! Can you upload the complete logs? The snippet posted doesn’t contain the root cause error or maybe there are more relevant information needed in the complete logs to understand the problem.

4

Hello marcosmarxm , can I send you the logs private? and if we find the error we could use the important stuff and post it here?

5

Sure, are you in our Slack community?

6

yes for sure you have the same name there?

7

okey just found you on github with this name

8

my member ID: U02SC8B2XH7

9

Yes I’m using the same name. Please send in Slack

10

i cannot find u there with the search function

11

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.