Hi. This is a new error I got. Anyone know why it ...
# ask-community
j
Hi. This is a new error I got. Anyone know why it just started appearing? Fails like this once out every 100 tasks. Anyone know why it just started appearing?
Copy code
Flow could not be retrieved from deployment.
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/dist-packages/prefect/engine.py", line 247, in retrieve_flow_then_begin_flow_run
    flow = await load_flow_from_flow_run(flow_run, client=client)
  File "/usr/local/lib/python3.9/dist-packages/prefect/client.py", line 104, in with_injected_client
    return await fn(*args, **kwargs)
  File "/usr/local/lib/python3.9/dist-packages/prefect/deployments.py", line 47, in load_flow_from_flow_run
    await storage_block.get_directory(from_path=None, local_path=".")
  File "/usr/local/lib/python3.9/dist-packages/prefect/filesystems.py", line 98, in get_directory
    shutil.copytree(from_path, local_path, dirs_exist_ok=True)
  File "/usr/lib/python3.9/shutil.py", line 568, in copytree
    return _copytree(entries=entries, src=src, dst=dst, symlinks=symlinks,
  File "/usr/lib/python3.9/shutil.py", line 522, in _copytree
    raise Error(errors)
shutil.Error: [('/home/app/app/.prefect/orion.db-shm', './.prefect/orion.db-shm', "[Errno 2] No such file or directory: '/home/app/app/.prefect/orion.db-shm'")]
šŸ‘€ 1
m
Hey @js10 Do you have an example for the flow/tasks that are being run so we can try and reproduce this?
b
Also, QQs, • What version of Prefect are you running? • Around when did this start happening?
j
Removed some stuff so this is really pseudocode, but it's just two simple flows in one file that execute at 15 and 30 min intervals.
Copy code
import sys
sys.path.append("/home/app/app")


import pytz
import uuid
from datetime import datetime

from prefect import flow, task, get_run_logger

@task(name='trend:store')
def store_data(data, kw, timeframe, geo):
  logger = get_run_logger()
  <http://logger.info|logger.info>(f"saved some stuff to db from the internet")

@flow(name="store7day")
def store_7_day():
  store_data(data, coninuous_7_day, timeframe='123', geo='US')

@flow(name="store4h")
def store_4_hour():
  store_data(data, coninuous_7_day, timeframe='123', geo='US')




if __name__ == "__main__":
  store_meta()
Copy code
prefect = "^2.0.2"
this started happening when I upgraded to 2.0.2
could it be an issue with the same container executing the two flows?
a
looks like you got to a point where you hit the limits of SQLite https://www.sqlite.org/wal.html and it may be time to consider upgrading either to Cloud 2.0 or to Postgres -- the reason is that it's essentially a single file not meant for concurrent writes you can sign up for Cloud 2.0 using https://app.prefect.cloud/
šŸ‘ 1