https://prefect.io logo
Title
s

Stephen Herron

08/01/2022, 3:31 PM
Hi I’m trying to convert some v1 flows to v2 - just some simple snowflake queries at the moment but I sometimes get this error:
RuntimeError: Set changed size during iteration
Worker information:
    Approximate queue length: 0
    Pending log batch length: 0
    Pending log batch size: 0
I’m not trying to do anything with async but that appears to be where this is coming from (I guess it’s used via the
snowflake-prefect
integration?
n

Nate

08/01/2022, 3:59 PM
hmm, if you're just running stuff locally and you're comfortable with doing so, I think you could try
prefect orion database reset -y
here
s

Stephen Herron

08/01/2022, 5:02 PM
thanks @Nate I tried this but it ran into an issue
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: type
[SQL: ALTER TABLE block_schema ADD COLUMN type VARCHAR]
n

Nate

08/01/2022, 5:09 PM
yep okay, so I would go ahead and run
rm -rf ~/.prefect/orion.db
and then try and reset the database again
I've run into this in the past