jack
09/12/2022, 9:15 PMChris Gunderson
09/12/2022, 10:02 PMNiels Prins
09/13/2022, 8:07 AMAfaque Ahmad
09/13/2022, 8:08 AMAndreas Nord
09/13/2022, 8:26 AM08:12:06.349 | INFO | prefect.infrastructure.docker-container - Docker container 'practical-bear' has status 'exited'
But the log on prefect cloud is stuck on Executing of the last task of the flow.Saurabh Indoria
09/13/2022, 9:01 AMDennis Hinnenkamp
09/13/2022, 9:20 AM09:19:54.856 | INFO | prefect.agent - Submitting flow run '9e981ee3-5d70-43b8-992a-6bd5c433d24c'
09:19:55.054 | INFO | prefect.infrastructure.process - Opening process 'blond-rabbit'...
09:19:55.130 | INFO | prefect.agent - Completed submission of flow run '9e981ee3-5d70-43b8-992a-6bd5c433d24c'
09:19:57.018 | INFO | Flow run 'blond-rabbit' - Created task run 'shell_run_command-7398b6ba-0' for task 'shell_run_command'
09:19:57.019 | INFO | Flow run 'blond-rabbit' - Executing 'shell_run_command-7398b6ba-0' immediately...
09:19:57.251 | INFO | Task run 'shell_run_command-7398b6ba-0' - Soda Core 3.0.6
09:19:58.517 | INFO | Task run 'shell_run_command-7398b6ba-0' - Attempting to acquire lock 281472472552592 on /home/vscode/.cache/snowflake/ocsp_cache.lock
09:19:58.518 | INFO | Task run 'shell_run_command-7398b6ba-0' - Lock 281472472552592 acquired on /home/vscode/.cache/snowflake/ocsp_cache.lock
09:19:58.518 | INFO | Task run 'shell_run_command-7398b6ba-0' - Attempting to acquire lock 281472472682848 on /home/vscode/.cache/snowflake/ocsp_cache.lock
Timeout on acquiring lock 281472472682848 on /home/vscode/.cache/snowflake/ocsp_cache.lock
09:19:58.519 | INFO | Task run 'shell_run_command-7398b6ba-0' - Attempting to release lock 281472472552592 on /home/vscode/.cache/snowflake/ocsp_cache.lock
Lock 281472472552592 released on /home/vscode/.cache/snowflake/ocsp_cache.lock
09:20:00.123 | INFO | Task run 'shell_run_command-7398b6ba-0' - Scan summary:
1/1 check FAILED:
v_stg_transactions in we_liberate_data
row_count between 10 and 1000 [FAILED]
09:20:00.125 | INFO | Task run 'shell_run_command-7398b6ba-0' - check_value: 6209
Oops! 1 failures. 0 warnings. 0 errors. 0 pass.
09:20:00.125 | INFO | Task run 'shell_run_command-7398b6ba-0' - Sending results to Soda Cloud
09:20:00.484 | INFO | Task run 'shell_run_command-7398b6ba-0' - Soda Cloud Trace: 3791758754192003542
09:20:00.878 | INFO | Task run 'shell_run_command-7398b6ba-0' - Attempting to acquire lock 281472486055312 on /home/vscode/.cache/snowflake/ocsp_cache.lock
09:20:00.878 | INFO | Task run 'shell_run_command-7398b6ba-0' - Lock 281472486055312 acquired on /home/vscode/.cache/snowflake/ocsp_cache.lock
09:20:00.879 | INFO | Task run 'shell_run_command-7398b6ba-0' - Attempting to release lock 281472486055312 on /home/vscode/.cache/snowflake/ocsp_cache.lock
Lock 281472486055312 released on /home/vscode/.cache/snowflake/ocsp_cache.lock
09:20:00.930 | ERROR | Task run 'shell_run_command-7398b6ba-0' - Encountered exception during execution:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/prefect/engine.py", line 1185, in orchestrate_task_run
result = await task.fn(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/prefect_shell/commands.py", line 90, in shell_run_command
raise RuntimeError(msg)
RuntimeError: Command failed with exit code 2:
Lock 281472486055312 released on /home/vscode/.cache/snowflake/ocsp_cache.lock
09:20:00.952 | ERROR | Task run 'shell_run_command-7398b6ba-0' - Finished in state Failed('Task run encountered an exception.')
09:20:00.952 | ERROR | Flow run 'blond-rabbit' - Encountered exception during execution:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/prefect/engine.py", line 588, in orchestrate_flow_run
result = await flow_call()
File "flows/test/test_soda_transactions.py", line 11, in test_transactions
command2 = await shell_run_command(
File "/usr/local/lib/python3.8/site-packages/prefect/engine.py", line 863, in get_task_call_return_value
return await future._result()
File "/usr/local/lib/python3.8/site-packages/prefect/futures.py", line 236, in _result
return final_state.result(raise_on_failure=raise_on_failure)
File "/usr/local/lib/python3.8/site-packages/prefect/orion/schemas/states.py", line 143, in result
raise data
File "/usr/local/lib/python3.8/site-packages/prefect/engine.py", line 1185, in orchestrate_task_run
result = await task.fn(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/prefect_shell/commands.py", line 90, in shell_run_command
raise RuntimeError(msg)
RuntimeError: Command failed with exit code 2:
Lock 281472486055312 released on /home/vscode/.cache/snowflake/ocsp_cache.lock
09:20:00.966 | ERROR | Flow run 'blond-rabbit' - Finished in state Failed('Flow run encountered an exception.')
09:20:01.240 | INFO | prefect.infrastructure.process - Process 'blond-rabbit' exited cleanly.
Amol Shirke
09/13/2022, 9:33 AMGintautas Jankus
09/13/2022, 11:13 AMSander
09/13/2022, 11:59 AMLennert Van de Velde
09/13/2022, 1:57 PMJames Phoenix
09/13/2022, 2:00 PMSlackbot
09/13/2022, 2:01 PMJames Phoenix
09/13/2022, 2:18 PMJehan Abduljabbar
09/13/2022, 4:07 PMAlexandru Anghel
09/13/2022, 4:15 PMfrom prefect.schedules import Schedule
). In this way, it's entering the task while loop and the UI shows only one flow run in "Running" state (until you decide to kill it).
Is there a way to replicate this scenario in Orion? If i use the Interval schedule, it's creating flow runs every 30 seconds and it's difficult for the users to read the UI once you have more flows running.
Thank you!Sergiy Popovych
09/13/2022, 4:33 PMAlexey Stoletny
09/13/2022, 4:37 PMkiran
09/13/2022, 5:43 PMJehan Abduljabbar
09/13/2022, 5:55 PMPranit
09/13/2022, 6:07 PMPranit
09/13/2022, 6:07 PMprefect agent start -q 'default'
John Song
09/13/2022, 7:00 PMJohn Song
09/13/2022, 7:01 PMJohn Song
09/13/2022, 7:02 PMJohn Song
09/13/2022, 7:18 PMJohn Song
09/13/2022, 7:18 PMNathaniel Russell
09/13/2022, 7:48 PMprefect.client.get_client()
supposed to know which account of prefect cloud to use? how does it get the api key?Jens Freund
09/13/2022, 8:03 PMprefect orion start
in windows powershell, the Prefect Orion logo appears with information about the Orion URLs but is immediately followed by the error message: "Error: Got unexpected extra argument (prefect.orion.api.server:create_app) Orion stopped!"
The problem occurs since version 2.3.0 (it occurs also in 2.3.1 and 2.3.2). Version 2.2.0 works well. My operating system is Windows 10 and I would attach the information from the prefect version
command into the thread.
If you had any idea what could be the cause of the error, you would help me a lot! Thank you very much in advance!Slackbot
09/13/2022, 8:20 PMSlackbot
09/13/2022, 8:20 PMChristopher Boyd
09/13/2022, 8:44 PM