Hi, we just witnessed an error when running a pref...
# prefect-communityn
Nikolaus Landgraf
07/06/2022, 2:12 PMHi, 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?
Copy code
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>)z
Zanie
07/06/2022, 2:22 PM
@Marvin open “SQLite ‘no such table: json_each’ error during notification check”
Zanie
07/06/2022, 2:22 PM
We’ll need to investigate this. Does it happen consistently?
m
Marvin
07/06/2022, 2:23 PMn
Nikolaus Landgraf
07/06/2022, 2:24 PMyes it happens for all the tasks that we are trying to run on windows
k
Kevin Kho
07/06/2022, 2:25 PM
What is your Python version?
z
Zanie
07/06/2022, 2:25 PM
Can you share the output of
prefect versionZanie
07/06/2022, 2:26 PM
It seems likely that your SQLite version does not meet the minimum required.
n
Nikolaus Landgraf
07/06/2022, 3:03 PM Copy code
Version: 2.0b7
API version: 0.6.0
Python version: 3.8.10
Git commit: eb9f17a8
Built: Wed, Jun 22, 2022 12:07 PM
OS/Arch: win32/AMD64
Profile: default
Server type: ephemeral
Server:
Database: sqlite
SQLite version: 3.35.5z
Zanie
07/06/2022, 3:12 PM
Thanks! It seems like that version should be sufficient. What are you using for python management?
n
Nikolaus Landgraf
07/06/2022, 7:15 PMwe use poetry
z
Zanie
07/06/2022, 8:16 PM
Would you mind trying a miniconda environment? It’ll install a newer SQLite version.
12 Views