)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"change_message_id":"df1744a04ddd9655a050933195b641e339d8f3b7","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"c35755ef_99e37eeb","updated":"2023-08-17 13:55:21.000000000","message":"im more or less trusting Stephen and zzzeek basedon on the\nconverstation in https://github.com/sqlalchemy/sqlalchemy/issues/10098\n\nthis look correct inspecting the SQL equivalent comment\nand form the function names i would expect the modified code to be equivalent.\nits also close to what i would have tried to write sinc ei would have worked it out in sql first and then converted to pythohn so usign select instead of query better aligns to that.","commit_id":"14456df477ed5d73aca5585f71e87f5af2d8f9b2"},{"author":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"change_message_id":"1b141c7480e59e7e5e6dfa317f391bfed2d53d20","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"699d6801_5c1e39f0","updated":"2023-09-27 12:35:57.000000000","message":"let\u0027s see what the CI says about it before +Wing it.","commit_id":"14456df477ed5d73aca5585f71e87f5af2d8f9b2"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"7ad498a6fc8af37e2d782a1219d5a529161de4c5","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"29bf3590_7c8a4c37","updated":"2023-09-13 14:21:09.000000000","message":"recheck","commit_id":"14456df477ed5d73aca5585f71e87f5af2d8f9b2"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"e3604558bd3b0c8c14fde1328adbe0215e3fca71","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"3cb63e7a_666fc808","updated":"2023-09-27 12:31:42.000000000","message":"recheck","commit_id":"14456df477ed5d73aca5585f71e87f5af2d8f9b2"},{"author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"change_message_id":"8298c4ecd48f16605be72e3c689d1119e060b68d","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"923f20fc_13392c73","updated":"2023-09-13 09:58:36.000000000","message":"recheck","commit_id":"14456df477ed5d73aca5585f71e87f5af2d8f9b2"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"19993f1e629a3b5a160d99b28d710970476d6eca","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"f531149b_34f8eff0","updated":"2023-08-17 10:55:32.000000000","message":"recheck unrelated failure in grenade job","commit_id":"14456df477ed5d73aca5585f71e87f5af2d8f9b2"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"01e78e352e74e638913de54571ec7637c0c27fd6","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":2,"id":"16a4bb51_36dfb088","updated":"2023-09-27 15:01:46.000000000","message":"Oh, interesting. This is failing on MySQL 5.7 (?) in the grenade job. From the [`controller/logs/grenade.sh_log.txt` log file](https://a21c4205282e4de8b5b5-316ead88afa2be91e0f5b80937dadc42.ssl.cf5.rackcdn.com/888281/2/check/grenade/b6d0d8d/controller/logs/grenade.sh_log.txt)\n\n```\n2023-09-27 13:25:48.166 | + /opt/stack/new/grenade/projects/15_placement/upgrade.sh:main:63 :   /usr/local/bin/placement-manage db online_data_migrations\n2023-09-27 13:25:49.539 | Error attempting to run \u003cfunction set_root_provider_ids at 0x7fc837741360\u003e\n2023-09-27 13:25:49.539 | Traceback (most recent call last):\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py\", line 1900, in _execute_context\n2023-09-27 13:25:49.539 |     self.dialect.do_execute(\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py\", line 736, in do_execute\n2023-09-27 13:25:49.539 |     cursor.execute(statement, parameters)\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/cursors.py\", line 148, in execute\n2023-09-27 13:25:49.539 |     result \u003d self._query(query)\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/cursors.py\", line 310, in _query\n2023-09-27 13:25:49.539 |     conn.query(q)\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/connections.py\", line 548, in query\n2023-09-27 13:25:49.539 |     self._affected_rows \u003d self._read_query_result(unbuffered\u003dunbuffered)\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/connections.py\", line 775, in _read_query_result\n2023-09-27 13:25:49.539 |     result.read()\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/connections.py\", line 1156, in read\n2023-09-27 13:25:49.539 |     first_packet \u003d self.connection._read_packet()\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/connections.py\", line 725, in _read_packet\n2023-09-27 13:25:49.539 |     packet.raise_for_error()\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/protocol.py\", line 221, in raise_for_error\n2023-09-27 13:25:49.539 |     err.raise_mysql_exception(self._data)\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/err.py\", line 143, in raise_mysql_exception\n2023-09-27 13:25:49.539 |     raise errorclass(errno, errval)\n2023-09-27 13:25:49.539 | pymysql.err.NotSupportedError: (1235, \"This version of MySQL doesn\u0027t yet support \u0027LIMIT \u0026 IN/ALL/ANY/SOME subquery\u0027\")\n2023-09-27 13:25:49.539 | \n2023-09-27 13:25:49.539 | The above exception was the direct cause of the following exception:\n2023-09-27 13:25:49.539 | \n2023-09-27 13:25:49.539 | Traceback (most recent call last):\n2023-09-27 13:25:49.539 |   File \"/opt/stack/new/placement/placement/cmd/manage.py\", line 140, in _run_online_migration\n2023-09-27 13:25:49.539 |     found, done \u003d migration_meth(ctxt, count)\n2023-09-27 13:25:49.539 |   File \"/usr/local/lib/python3.10/dist-packages/oslo_db/sqlalchemy/enginefacade.py\", line 1001, in wrapper\n2023-09-27 13:25:49.539 |     return fn(*args, **kwargs)\n2023-09-27 13:25:49.540 |   File \"/opt/stack/new/placement/placement/objects/resource_provider.py\", line 518, in set_root_provider_ids\n2023-09-27 13:25:49.540 |     res \u003d context.session.execute(stmt)\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/orm/session.py\", line 1712, in execute\n2023-09-27 13:25:49.540 |     result \u003d conn._execute_20(statement, params or {}, execution_options)\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py\", line 1705, in _execute_20\n2023-09-27 13:25:49.540 |     return meth(self, args_10style, kwargs_10style, execution_options)\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/sql/elements.py\", line 333, in _execute_on_connection\n2023-09-27 13:25:49.540 |     return connection._execute_clauseelement(\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py\", line 1572, in _execute_clauseelement\n2023-09-27 13:25:49.540 |     ret \u003d self._execute_context(\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py\", line 1943, in _execute_context\n2023-09-27 13:25:49.540 |     self._handle_dbapi_exception(\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py\", line 2122, in _handle_dbapi_exception\n2023-09-27 13:25:49.540 |     util.raise_(newraise, with_traceback\u003dexc_info[2], from_\u003de)\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/util/compat.py\", line 208, in raise_\n2023-09-27 13:25:49.540 |     raise exception\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py\", line 1900, in _execute_context\n2023-09-27 13:25:49.540 |     self.dialect.do_execute(\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py\", line 736, in do_execute\n2023-09-27 13:25:49.540 |     cursor.execute(statement, parameters)\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/cursors.py\", line 148, in execute\n2023-09-27 13:25:49.540 |     result \u003d self._query(query)\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/cursors.py\", line 310, in _query\n2023-09-27 13:25:49.540 |     conn.query(q)\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/connections.py\", line 548, in query\n2023-09-27 13:25:49.540 |     self._affected_rows \u003d self._read_query_result(unbuffered\u003dunbuffered)\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/connections.py\", line 775, in _read_query_result\n2023-09-27 13:25:49.540 |     result.read()\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/connections.py\", line 1156, in read\n2023-09-27 13:25:49.540 |     first_packet \u003d self.connection._read_packet()\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/connections.py\", line 725, in _read_packet\n2023-09-27 13:25:49.540 |     packet.raise_for_error()\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/protocol.py\", line 221, in raise_for_error\n2023-09-27 13:25:49.540 |     err.raise_mysql_exception(self._data)\n2023-09-27 13:25:49.540 |   File \"/usr/local/lib/python3.10/dist-packages/pymysql/err.py\", line 143, in raise_mysql_exception\n2023-09-27 13:25:49.540 |     raise errorclass(errno, errval)\n2023-09-27 13:25:49.540 | oslo_db.exception.DBNotSupportedError: (pymysql.err.NotSupportedError) (1235, \"This version of MySQL doesn\u0027t yet support \u0027LIMIT \u0026 IN/ALL/ANY/SOME subquery\u0027\")\n2023-09-27 13:25:49.540 | [SQL: UPDATE resource_providers SET updated_at\u003d%(updated_at)s, root_provider_id\u003dresource_providers.id WHERE resource_providers.id IN (SELECT resource_providers.id \n2023-09-27 13:25:49.540 | FROM resource_providers \n2023-09-27 13:25:49.540 | WHERE resource_providers.root_provider_id IS NULL \n2023-09-27 13:25:49.540 |  LIMIT %(param_1)s)]\n2023-09-27 13:25:49.540 | [parameters: {\u0027updated_at\u0027: datetime.datetime(2023, 9, 27, 13, 25, 49, 531970), \u0027param_1\u0027: 50}]\n2023-09-27 13:25:49.540 | (Background on this error at: https://sqlalche.me/e/14/tw8g)\n2023-09-27 13:25:49.554 | Running batches of 50 until complete\n2023-09-27 13:25:49.554 | Error attempting to run \u003cfunction set_root_provider_ids at 0x7fc837741360\u003e\n```","commit_id":"3e53aaa2c6b83fd875bf94cb3cfa7c7385bfd647"}]}