[Bug]: Pipelines on Hop server sometimes hangs in state "Waiting", with a little information in log. about hop HOT 3 OPEN

Request for Additional Pipeline Details

Hello Oen1997,

Thanks for your input on the pipeline setup. To better address the issue, could you provide more detailed information about the pipeline configuration? Specifically:

1. Transforms Used:

   • Could you list the specific transforms and their configurations that are currently used in the pipeline?

2. CSV Input:

   • Is there a CSV input in the pipeline? If so, it would be helpful to check whether the 'lazy conversion' checkbox is marked. This option helps manage memory more efficiently by delaying data type conversions.

3. Data Carrying Between Pipelines:

   • Please verify if the pipeline is carrying tables from one stage to another excessively. This practice can lead to memory overflow and introduce bugs, especially when combined with database lookup transforms.

Your detailed feedback on these points will help us identify and fix the issue more effectively.

Best regards,
AlefRP

from hop.

Pipeline is very simple, output is only ~2 million rows:

Avro target folder is set on GS.
By the way, in parallel Im running similar pipelines (different times) on another software, another server, and uploading to GS large CSV's via "gcloud storage cp" command, and that never failed, so I would exclude network related issues.

from hop.

Another pipeline is hanging for few days, with zero info in log:

from hop.