Jon C
08/18/2022, 9:44 PMYou hit an unexpected error while fetching data from Dagster.
. Below is the full error. Any help much appreciatedOperation name: RootWorkspaceQuery
Message: (psycopg2.errors.UndefinedColumn) column jobs.job_body does not exist
LINE 1: SELECT jobs.job_body
^
[SQL: SELECT jobs.job_body
FROM jobs
WHERE jobs.repository_origin_id = %(repository_origin_id_1)s AND jobs.job_type = %(job_type_1)s]
[parameters: {'repository_origin_id_1': '7c25106ac3cb0dd4a3c3a3163e559995edd1d392', 'job_type_1': 'SCHEDULE'}]
(Background on this error at: <https://sqlalche.me/e/14/f405>)
Path: ["workspaceOrError","locationEntries",0,"locationOrLoadError","repositories",0,"schedules"]
Locations: [{"line":38,"column":15}]
sandy
08/18/2022, 10:02 PMprha
08/18/2022, 10:12 PMdagster instance migrate
might resolve it.Jon C
08/18/2022, 10:17 PM1.0.3
. I did connect this new dagster instance with an external Postgres DB. This DB had been in use by another older dagster instance. I will run with your suggestion to see if it fixes that.