I have successfully run orion server; created work_queue and agent ; and run a flow in WSL2. However I am unable to run it in a docker container. I set the ip address to $(hostname -i) which is 172.17.0.2 which allows the UI to be visible from windows.
If I launch orion on port 8082 then I can see the UI, set the config, set the storage, create a work queue. view the work-queue from command line; it is also in the db; but it does not appear on the UI. I can also launch an agent for the work-queue which claims to be connected to http://172.17.0.2:8082/api but it does not appear in the db.
If I launch orion on the default port then as soon as I try to set the config I get a server error with a huge database stacktrace. Error is “sqlite3.OperationalError: near “,”: syntax error” and stacktrace ends as below:
SELECT counts.interval_start, counts.interval_end, coalesce(json_group_array(json(counts.state_agg)) FILTER (WHERE counts.state_agg IS NOT NULL), ‘’) AS states
FROM (SELECT intervals.interval_start AS interval_start, intervals.interval_end AS interval_end, CASE WHEN (count(runs.id) = ?) THEN NULL ELSE json_object(?, runs.state_type, ?, runs.state_name, ?, count(runs.id), ?, sum(max(?, CAST(STRFTIME(‘%s’, runs.estimated_run_time) AS INTEGER))), ?, sum(max(?, CAST(STRFTIME(‘%s’, runs.estimated_start_time_delta) AS INTEGER)))) END AS state_agg
FROM intervals LEFT OUTER JOIN (SELECT flow_run.id AS id, flow_run.expected_start_time AS expected_start_time, (SELECT CASE WHEN (flow_run.state_type = ?) THEN strftime(?, (julianday(flow_run.total_run_time) + julianday(strftime(?, (? + julianday(strftime(‘%Y-%m-%d %H:%M:%f000’, ‘now’))) - julianday(flow_run_state.timestamp)))) - ?) ELSE flow_run.total_run_time END AS anon_1
WHERE flow_run.state_id = flow_run_state.id) AS estimated_run_time, CASE WHEN (flow_run.start_time > flow_run.expected_start_time) THEN strftime(?, (? + julianday(flow_run.start_time)) - julianday(flow_run.expected_start_time)) WHEN (flow_run.start_time IS NULL AND (flow_run.state_type NOT IN (?, ?, ?)) AND flow_run.expected_start_time < strftime(‘%Y-%m-%d %H:%M:%f000’, ‘now’)) THEN strftime(?, (? + julianday(strftime(‘%Y-%m-%d %H:%M:%f000’, ‘now’))) - julianday(flow_run.expected_start_time)) ELSE ? END AS estimated_start_time_delta, flow_run_state.type AS state_type, flow_run_state.name AS state_name
FROM flow_run JOIN flow_run_state ON flow_run.state_id = flow_run_state.id
WHERE flow_run.expected_start_time <= ? AND flow_run.expected_start_time >= ?) AS runs ON runs.expected_start_time >= intervals.interval_start AND runs.expected_start_time < intervals.interval_end GROUP BY intervals.interval_start, intervals.interval_end, runs.state_type, runs.state_name) AS counts GROUP BY counts.interval_start, counts.interval_end ORDER BY counts.interval_start
LIMIT ? OFFSET ?]
[parameters: (‘2022-03-21T00:00:00+00:00’, ‘2022-03-21T00:00:00+00:00’, ‘+5760.0 seconds’, ‘+5760.0 seconds’, ‘2022-03-23T00:00:00+00:00’, ‘-5760.0 seconds’, 0, ‘state_type’, ‘state_name’, ‘count_runs’, ‘sum_estimated_run_time’, 0, ‘sum_estimated_lateness’, 0, ‘RUNNING’, ‘%Y-%m-%d %H:%M:%f000’, ‘%Y-%m-%d %H:%M:%f000’, 2440587.5, 2440587.5, ‘%Y-%m-%d %H:%M:%f000’, 2440587.5, ‘COMPLETED’, ‘FAILED’, ‘CANCELLED’, ‘%Y-%m-%d %H:%M:%f000’, 2440587.5, ‘1970-01-01 00:00:00.000000’, ‘2022-03-23 00:00:00.000000’, ‘2022-03-21 00:00:00.000000’, 500, 0)]
(Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)