Bianca Rosa
07/05/2022, 10:13 AMBianca Rosa
07/05/2022, 10:13 AMOperation name: InstanceOverviewInitialQuery
Message: (mysql.connector.errors.ProgrammingError) 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(PARTITION BY runs.pipeline_name ORDER BY runs.id DESC) AS `rank`
FROM runs
WH' at line 2
[SQL: SELECT subquery.id, subquery.run_body, subquery.create_timestamp, subquery.update_timestamp, subquery.start_time, subquery.end_time
FROM (SELECT runs.id AS id, runs.run_body AS run_body, runs.create_timestamp AS create_timestamp, runs.update_timestamp AS update_timestamp, runs.start_time AS start_time, runs.end_time AS end_time, rank() OVER (PARTITION BY runs.pipeline_name ORDER BY runs.id DESC) AS `rank`
FROM runs
WHERE runs.pipeline_name IN (%(pipeline_name_1)s, %(pipeline_name_2)s, %(pipeline_name_3)s, %(pipeline_name_4)s)) AS subquery
WHERE subquery.`rank` <= %(rank_1)s ORDER BY subquery.`rank` ASC]
[parameters: {'<redated>'}]
(Background on this error at: <http://sqlalche.me/e/f405>)
Path: ["workspaceOrError","locationEntries",0,"locationOrLoadError","repositories",0,"pipelines",0,"runs"]
Locations: [{"line":77,"column":3}]
prha
07/05/2022, 4:41 PMBianca Rosa
07/05/2022, 5:37 PMBianca Rosa
07/05/2022, 5:38 PMBianca Rosa
07/05/2022, 5:39 PMprha
07/05/2022, 6:29 PM0.15.4
to use an alternate query for older versions of MySQL. Thanks for the report!prha
07/05/2022, 6:39 PMDagster Bot
07/05/2022, 6:39 PMprha
07/07/2022, 10:53 PM0.15.5
. Let us know if you run into any more problems!