Hi, we just witnessed an error when running a prefect task locally on a windows 11 machine. This error is not popping up on mac. Do you know how to fix that?

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: json_each
[SQL: INSERT INTO flow_run_notification_queue (flow_run_notification_policy_id, flow_run_state_id) SELECT flow_run_notification_policy.id, CAST(? AS CHAR(36)) AS anon_1
FROM flow_run_notification_policy
WHERE flow_run_notification_policy.is_active IS 1 AND (flow_run_notification_policy.state_names = ? OR EXISTS (SELECT 1
FROM json_each(flow_run_notification_policy.state_names) AS json_each
WHERE json_each.value IN (?))) AND (flow_run_notification_policy.tags = ? OR EXISTS (SELECT 1
FROM json_each(flow_run_notification_policy.tags) AS json_each
WHERE json_each.value IN (SELECT 1 FROM (SELECT 1) WHERE 1!=1)))]
[parameters: ('8d01934d-c9c8-4f23-a3af-ec03ee1586a0', '[]', 'Pending', '[]')]
(Background on this error at: <https://sqlalche.me/e/14/e3q8>)

Hi i am unable to start my Prefect Server, getting below error:

graphql_1   | ValueError: Uniqueness violation.
graphql_1   |
graphql_1   | The above exception was the direct cause of the following exception:
graphql_1   |
graphql_1   | Traceback (most recent call last):
graphql_1   |   File "/usr/local/lib/python3.7/site-packages/graphql/execution/execute.py", line 674, in await_completed
graphql_1   |     return await completed
graphql_1   |   File "/usr/local/lib/python3.7/site-packages/graphql/execution/execute.py", line 659, in await_result
graphql_1   |     return_type, field_nodes, info, path, await result
graphql_1   |   File "/usr/local/lib/python3.7/site-packages/graphql/execution/execute.py", line 733, in complete_value
graphql_1   |     raise result
graphql_1   |   File "/usr/local/lib/python3.7/site-packages/graphql/execution/execute.py", line 628, in await_result
graphql_1   |     return await result
graphql_1   |   File "/prefect-server/src/prefect_server/graphql/extensions.py", line 52, in resolve
graphql_1   |     result = await result
graphql_1   |   File "/prefect-server/src/prefect_server/graphql/tenants.py", line 14, in resolve_create_tenant
graphql_1   |     "id": await api.tenants.create_tenant(name=input["name"], slug=input["slug"])
graphql_1   |   File "/prefect-server/src/prefect_server/api/tenants.py", line 29, in create_tenant
graphql_1   |     tenant_id = await models.Tenant(name=name, slug=slug).insert()
graphql_1   |   File "/prefect-server/src/prefect_server/database/orm.py", line 222, in insert
graphql_1   |     insert_mutation_name=self.__root_fields__.get("insert"),
graphql_1   |   File "/prefect-server/src/prefect_server/database/hasura.py", line 237, in insert
graphql_1   |     result = await self.execute_mutations_in_transaction(mutations=[graphql])
graphql_1   |   File "/prefect-server/src/prefect_server/database/hasura.py", line 165, in execute_mutations_in_transaction
graphql_1   |     as_box=as_box,
graphql_1   |   File "/prefect-server/src/prefect_server/database/hasura.py", line 89, in execute
graphql_1   |     raise ValueError("Uniqueness violation.")
graphql_1   | graphql.error.graphql_error.GraphQLError: Uniqueness violation.
graphql_1   |
graphql_1   | GraphQL request:2:3
graphql_1   | 1 | mutation ($input: create_tenant_input!) {
graphql_1   | 2 |   create_tenant(input: $input) {
graphql_1   |   |   ^
graphql_1   | 3 |     id

Hi. Is it possible to specify disk space for KubernetesRun run config?

Hello How can I rename a task output ? Is it possible to use with it a task nout=3 ?

Hey guys, I want to pull down a

.csv

file from a google cloud bucket. It seems like this task is the correct way to go? An alternative I can see is just implementing a python callable that uses the python library for google cloud storage. I'd like some feedback if I'm approaching this problem correctly?

Hi Team. In prefect 2.0, is there a way to visualize the flows like how we could do in prefect 1.0 with flow.visualize()?

Hello. I’m trying to figure out why my configured results don’t seem to be respected/used for caching between flow runs. I have a task decorated to use checkpointing. On each run of the flow, I see the task complete with a

Success

state, and the results file has been overwritten. If I’m understanding correctly this should be completing with

Cached

. Any suggestions?

Is the "sql_server" optional dependency (for writing to MSSQL) available in Prefect 2.0? If not, what are alternatives, do I just stick with 1.0 until things like that get implemented into 2.0, or is there a new way to go about connecting to MSSQL?

is it possible to configure the ecs agent so that it sets the flow run container command to include

-l

(I want a login shell). Seems like currently its passing the command like so

overrides
    containerOverrides
        command": [
            "/bin/sh",
            "-c",
            "prefect execute flow-run"
        ]

Also, possible or not, is this command stable / is it safe to customize this?

In Prefect 2, is the default storage option set per-workspace or the same across all workspaces?

hi, i got a flow success event before the time all task really successed. in the bellow pic, i receive a flow success at 1.09 pm , but still got a task success at 1.13 pm. is this a bug?

Hi what is the alternative for upstream_tasks in prefect 2.0

Hi! I have a flow that executes a

RunNamespacedJob

task. Because of a known bug the way I'm obtaining the logs are via

ReadNamespacedPodLogs

. All that working well. Recently I changed the pod spec to run the application as an

initContainer

then some docker image to capture results as the actual

container

. So I have an image that generates content and logs in the

ìnitContainer

and a

container

that process the produced content (upload to gcs basically). Problem: the logs from the initContainer are not being captured by prefect, only the logs from the container. Any recommendation? 🙏

Good morning 🙂 So I have been working on this really extensive ETL and finally uploaded it to the cloud but there it is failing... I have a parameter like this:

weeks = Parameter("weeks", required=False, default=None)

Afterwards there is a case block where either the last actual weeks is getting pulled or set to the provided Parameter. Locally it's working like a charm but when I want to execute the flow within the cloud, I get an error for the week task:

The following error messages were provided by the GraphQL server: INTERNAL_SERVER_ERROR: Variable "$input" got invalid value null at "input.states[0].task_run_id"; Expected non-nullable type UUID! not to be null. The GraphQL query was: mutation($input: set_task_run_states_input!) { set_task_run_states(input: $input) { states { status message id } } } The passed variables were: {"input": {"states": [{"state": {"context": {"tags": []}, "cached_inputs": {}, "message": "Starting task run.", "_result": {"__version__": "0.14.10", "type": "NoResultType"}, "__version__": "0.14.10", "type": "Running"}, "task_run_id": null, "version": null}]}}

Task 'weeks': Finished task run for task with final state: 'ClientFailed' Do you know what might be the problem here? Why is it stated that I got a null value? It should be None.

Hi, I'm trying to list files from a S3 bucket but don't know how to get the result of the task. Can anyone help here? I would have thought to get an array of file names instead of a task object.

Hi Prefect Community, I am currently receiving an error when using a local (on my pc) prefect agent which pulls from a work queue in the the prefect cloud. The error only occurs when I try to use the RayTaskRunner:

(begin_task_run pid=141324) ImportError: cannot import name 'SubprocessFlowRunner' from partially initialized module 'prefect.flow_runners' (most likely due to a circular import) (/home/christian/Documents/ray_and_prefect/env/lib/python3.9/site-packages/prefect/flow_runners/__init__.py)

I am using the following dependencies: prefect==2.0b7 prefect-ray==0.1.0 ray==1.13.0 Apparently I am doing something wrong with my dependencies or when I am importing them. Do you have any idea?

Hi, i'm trying to run flow locally from ide (vs code) and i got this: what have I done wrong ?

Hi, quick question, why

map

function fail? and works when

map

was replace with

bind

?

from prefect import task, Flow, unmapped


@task
def first():
    return range(10)


@task
def second():
    return True


@task
def third(numbers):
    print(numbers)


with Flow(name='test') as flow:
    numbers = first()
    second_result = second()

    # third.bind(numbers=numbers, upstream_tasks=[second_result])
    third.map(numbers=unmapped(numbers), upstream_tasks=[second_result])

flow.run()

Is there a docker-compose.yml file out there for running prefect server. We are currently on 0.15 and I want to upgrade to 1.2.3. When I first set up server there was just a single compose file, I can’t seem to find that anymore

Hello! Running into an issue I don't fully understand. I have a series of flows that have been running for a couple of months without incident. We're running all of our production on 1.2.0-python3.8 for the ECS Agent and for all ECSRun instances. Our flows use S3 storage. Nothing has been purposely or visibly changed with our Prefect installation- no new flow deployments, or changes to our AWS infrastructure. Our flows, which do little more than kick off AWS Batch jobs via the BatchSubmit task are now consistently failing with the following error on the BatchSubmit invocation:

Unexpected error: AttributeError("'S3Result' object has no attribute 'upload_options'")
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/prefect/engine/runner.py", line 48, in inner
    new_state = method(self, state, *args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/prefect/engine/task_runner.py", line 930, in get_task_run_state
    result = self.result.write(value, **formatting_kwargs)
  File "/usr/local/lib/python3.8/site-packages/prefect/engine/results/s3_result.py", line 89, in write
    ExtraArgs=self.upload_options,
AttributeError: 'S3Result' object has no attribute 'upload_options'

Attached is one of the flows that are failing. Does the task running code record execution state back to the storage bucket? Thanks in advance!

Hi, in 2.0 I was wondering if it’s possible for the scheduler to prevent a single flow from “Running” concurrently? For example, if I use an IntervalSchedule with an interval of 5 minutes, and my first flow run takes 8 minutes, can the scheduler skip or wait until the first flow finishes before starting the new flow run?

Prefect 2 question here: Are an agent and work queue necessary in order to run a k8 job? For instance if i am using prefect cloud and create a deployment with kubernetes flow runner. Running the flow via the GUI or using "deployment run" from vm/local machine without an agent and queue setup results in no flow being run and a state of late. The prefect docs just say you need: Remote storage and

kubectl

configured to connect to a cluster

Hi all, how do you access the labels of the agent running a flow at runtime? I assumed there would be something in the context, but that doesn’t seem to be the case? Is there any agent level information you can access from inside a flow or task?

I have a running flow where a number of tasks are in a paused state. I’d like to programmatically approve all of them. What’s the best way to do that? I find that when I programmatically set all of their states to resume, I get varying behavior. Sometimes the tasks stay resumed and never get running. Any ideas why?

Hi, I'm going through v2 docs and was wondering if module storage from v1 (

prefect.storage.Module

) would be available in the future releases. We're running Prefect + Dask setup on k8s from a monorepo (i.e. agents and dask workers deployments run the same docker image & tag), where flows are sourced from Python modules (and registered before agents start up during a new release), therefore I'd prefer to not use any object storage for storing flows or results if possible

hey folks, I have a hopefully rather simple question also prefect noob. I’m trying to test the cacheing/restart features. For simplicity, I have 5 csv’s I’m downloading within 1 task. If the first csv is successful but then the task fails on the 2nd csv, I would like to restart the task where it left off and not need to re-download the 1st csv. From my understanding I need to leverage the results feature? I understand there’s a parameter for max retries but when retrying, is there any configuration needed to inform the task to start from the 2nd csv? Also if the max retries fails, I’d like the ability to re-start manually (presumably after fixing x bug that stopped the 2nd csv from downloading) again without having to re-download the 1st csv

So I've been using Prefect Cloud 2.0 on my personal account for a few weeks now, and we got our company account setup earlier this week. I can't figure out to login to beta.prefect.io using the company account. I can switch between mine and the companies with normal prefect.io. Does it need to be enabled and/or is it like that because its still in beta?

Is the new 2.0 release coming today?

Hello all, I'm having difficulties figuring out what this error means

Unexpected error: KeyError(0)
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/prefect/engine/runner.py", line 48, in inner
    new_state = method(self, state, *args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/prefect/engine/flow_runner.py", line 569, in get_flow_run_state
    executors.prepare_upstream_states_for_mapping(
  File "/usr/local/lib/python3.8/site-packages/prefect/utilities/executors.py", line 682, in prepare_upstream_states_for_mapping
    value = upstream_state.result[i]
KeyError: 0