Hi, Airbyte OSS deployed on EC2. Source Connector:...
# replication-troubleshooting
f
Hi, Airbyte OSS deployed on EC2. Source Connector: Hubspot Target Connector: Redshift + S3 staging Error: I am facing the following error when running my Hubspot to Redshift connection.
Copy code
Caused by: java.lang.RuntimeException: java.sql.SQLException: [Amazon](500310) Invalid operation: Problem reading manifest file - S3CurlException: Connection timed out after 50001 milliseconds, CurlError 28, multiCurlError 0, CanRetry 1, UserError 0 
Details: -----------------------------------------------
  error:  Problem reading manifest file - S3CurlException: Connection timed out after 50001 milliseconds, CurlError 28, multiCurlError 0, CanRetry 1, UserError 0
  code:      9001
  context:   <s3://insurely-airbyte-prod/data_sync/prod/hubspot_campaigns/2022_10_18_07_682ec106-c3f7-498b-9f10-ac0fbd3f233d/ff8681dd-d32a-4184-a263-b66f22843c66.manifest>
  query:     2051168
  location:  s3_utility.cpp:334
  process:   padbmaster [pid=18629]
  -----------------------------------------------;
	at io.airbyte.commons.lang.Exceptions.castCheckedToRuntime(Exceptions.java:58)
	at io.airbyte.commons.lang.Exceptions.toRuntime(Exceptions.java:41)
	at io.airbyte.integrations.destination.redshift.operations.RedshiftS3StagingSqlOperations.executeCopy(RedshiftS3StagingSqlOperations.java:137)
	at io.airbyte.integrations.destination.redshift.operations.RedshiftS3StagingSqlOperations.lambda$copyIntoTmpTableFromStage$1(RedshiftS3StagingSqlOperations.java:107)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.stream.Streams$StreamBuilderImpl.forEachRemaining(Streams.java:411)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at io.airbyte.integrations.destination.redshift.operations.RedshiftS3StagingSqlOperations.lambda$copyIntoTmpTableFromStage$2(RedshiftS3StagingSqlOperations.java:107)
	at io.airbyte.commons.lang.Exceptions.castCheckedToRuntime(Exceptions.java:54)
	at io.airbyte.commons.lang.Exceptions.toRuntime(Exceptions.java:41)
	at io.airbyte.integrations.destination.redshift.operations.RedshiftS3StagingSqlOperations.copyIntoTmpTableFromStage(RedshiftS3StagingSqlOperations.java:105)
	at io.airbyte.integrations.destination.staging.StagingConsumerFactory.lambda$onCloseFunction$3(StagingConsumerFactory.java:195)
	... 6 more
✍️ 1
This error is occurring for some of my other connectors as well.
Any help on problem solving would be greatly appreciated
u
@[DEPRECATED] Marcos Marx turned this thread into Zendesk ticket 2896 to ensure timely resolution!
f
I have resolved this. Had to do with a networking issues between Redshift and the S3 bucket.