https://prefect.io logo
t

Tyson Chavarie

07/27/2023, 7:15 PM
I'm having an issue here mapped tasks are stuck in pending, it has just been since 12:30pm today. This flow has been in place unchanged since 7/10...
the get_tables_to_replicate step is correctly returning a list of tables but the extract step never leaves pending state until my execution environment times out 60 minutes later
I'm on my postgres server where the source data is located and I don't see any running queries
is there an issue with mapped tasks or anything?
@TK -- FYI
I also opened a ticket with Marvin
a

Arnaud

08/10/2023, 9:24 AM
Hi @Tyson Chavarie, I have the same problem with some of my flows. Every day or two, one of them is suddenly stuck in a pending state. Without any action on my side, this one and the following ones in the pool will never be executed. The only solution I've found so far is to use automation and cancel it if it's in pending state for more than 3 minutes. I still haven't found the root cause of this problem. Do you have any information on this issue?
image.png
t

Tanishq Hooda

08/14/2023, 11:42 AM
Posted a similar issue where flows are getting stuck in Pending state for long, can you please check your agent logs, if you get the same error as mine? https://prefect-community.slack.com/archives/CL09KU1K7/p1692001886996109