https://prefect.io logo
Title
s

Sophia Alice

08/30/2022, 9:16 PM
Hi! I have a Prefect flow that runs successfully and returns a
Flow Run Succeeded
but the process doesn’t exit after success and instead hangs. Any idea what’s happening?
n

Nate

08/30/2022, 9:33 PM
Hi @Sophia Alice! Where are your flows running? and what do the agent logs look like?
s

Sophia Alice

08/30/2022, 9:36 PM
Hi @Nate! Flows are running locally (local for me is a MBP with an Intel chip) and here is one of the logs:
Retrieving local flow... Done
Configured local flow run
└── Parameters: {'credentials_path': 'credentials.yaml', 'county': 25}
Running flow locally...
└── 14:32:52 | INFO    | Beginning Flow run for 'pdi-voterfile-gcp-sync'
└── 14:32:52 | INFO    | Task 'county': Starting task run...
└── 14:32:52 | INFO    | Task 'get_sql_template': Starting task run...
└── 14:32:52 | INFO    | Task 'county': Finished task run for task with final state: 'Success'
└── 14:32:52 | INFO    | Task 'get_sql_template': Finished task run for task with final state: 'Success'
└── 14:32:52 | INFO    | Task 'get_counties': Starting task run...
└── 14:32:52 | INFO    | Task 'get_counties': Finished task run for task with final state: 'Success'
└── 14:32:52 | INFO    | Task 'render_query': Starting task run...
└── 14:32:52 | INFO    | Task 'render_query': Finished task run for task with final state: 'Mapped'
└── 14:32:52 | INFO    | Task 'credentials_path': Starting task run...
└── 14:32:52 | INFO    | Task 'credentials_path': Finished task run for task with final state: 'Success'
└── 14:32:52 | INFO    | Task 'load_yaml': Starting task run...
└── 14:32:52 | INFO    | Task 'load_yaml': Finished task run for task with final state: 'Success'
└── 14:32:52 | INFO    | Task 'get_credential': Starting task run...
└── 14:32:52 | INFO    | Task 'get_credential': Starting task run...
└── 14:32:52 | INFO    | Task 'get_credential': Finished task run for task with final state: 'Success'
└── 14:32:52 | INFO    | Task 'get_credential': Finished task run for task with final state: 'Success'
└── 14:32:52 | INFO    | Task 'get_credential': Starting task run...
└── 14:32:52 | INFO    | Task 'get_credential': Finished task run for task with final state: 'Success'
└── 14:32:52 | INFO    | Task 'Vertica': Starting task run...
└── 14:32:52 | INFO    | Task 'Vertica': Finished task run for task with final state: 'Mapped'
└── 14:32:52 | INFO    | Task 'table_name': Starting task run...
└── 14:32:52 | INFO    | Task 'table_name': Finished task run for task with final state: 'Mapped'
└── 14:32:52 | INFO    | Task 'start_jvm': Starting task run...
└── 14:32:52 | INFO    | Task 'GCPSecret': Starting task run...
└── 14:32:53 | INFO    | Task 'start_jvm': Finished task run for task with final state: 'Success'
└── 14:32:54 | INFO    | Task 'GCPSecret': Finished task run for task with final state: 'Success'
└── 14:32:54 | INFO    | Task 'load_json': Starting task run...
└── 14:32:54 | INFO    | Task 'load_json': Finished task run for task with final state: 'Success'
└── 14:32:54 | INFO    | Task 'BigQueryLoadFile': Starting task run...
└── 14:32:54 | INFO    | Task 'BigQueryLoadFile': Finished task run for task with final state: 'Mapped'
└── 14:32:54 | INFO    | Task 'render_query[0]': Starting task run...
└── 14:32:54 | INFO    | Task 'render_query[0]': Finished task run for task with final state: 'Success'
└── 14:32:54 | INFO    | Task 'Vertica[0]': Starting task run...
└── 14:33:21 | INFO    | Task 'Vertica[0]': Finished task run for task with final state: 'Success'
└── 14:33:21 | INFO    | Task 'table_name[0]': Starting task run...
└── 14:33:22 | INFO    | Task 'table_name[0]': Finished task run for task with final state: 'Success'
└── 14:33:22 | INFO    | Task 'BigQueryLoadFile[0]': Starting task run...
└── 14:33:35 | INFO    | Task 'BigQueryLoadFile[0]': Finished task run for task with final state: 'Success'
└── 14:33:35 | INFO    | Flow run SUCCESS: all reference tasks succeeded
Flow run succeeded!
n

Nate

08/30/2022, 9:53 PM
hmm, where do you notice that the flow is hanging?
s

Sophia Alice

08/31/2022, 12:41 AM
After the flow should be done. There’s another process that’s supposed to run after and it never starts. It looks like this in the terminal. it’ll stay like this until I hit ^C
n

Nate

08/31/2022, 2:32 AM
Do you mind sharing the logs where you ran
prefect agent start -q yourqueue
if possible? These appear to be the flow run logs those might give us more info on whether or not the process exited cleanly / what went wrong