)]}'
{"id":"openstack%2Fdevstack~687374","triplet_id":"openstack%2Fdevstack~master~I2310d50dfbd704e522a45e023415c6a58fb43442","project":"openstack/devstack","branch":"master","topic":"bug/1844929","hashtags":[],"change_id":"I2310d50dfbd704e522a45e023415c6a58fb43442","subject":"Configure mysqld with max_allowed_packet\u003d16M","status":"ABANDONED","created":"2019-10-08 18:12:36.000000000","updated":"2019-11-21 16:56:26.000000000","total_comment_count":4,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"f44ab76ffb8347a4e5f0e3514132a9da3f5b8c66","_number":687374,"virtual_id_number":687374,"owner":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":1,"date":"2019-10-08 22:02:22.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","value":1,"default_value":0,"optional":true},"Code-Review":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"rejected":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"all":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":-1,"date":"2019-10-10 15:39:35.000000000","permitted_voting_range":{"min":-1,"max":0},"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"date":"2019-10-08 18:14:29.000000000","_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"}],"values":{"-1":"Branch Freeze"," 0":"No Priority","+1":"Important Change","+2":"Gate Blocker Fix / Urgent Change"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-10-08 18:14:29.000000000","updated_by":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"reviewer":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"state":"REVIEWER"},{"updated":"2019-10-08 22:02:22.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"}],"messages":[{"id":"b485a1c67ccb55020df75366dbeb6e99c08b7ae7","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-10-08 18:12:36.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"4399a1e31b7721c9bd0d20ae72402904700cae66","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-10-08 18:13:31.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"d44a78e558ca9e5a40a27052066a225c40034c43","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-10-08 18:21:43.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"62f4e96713448c10ff1a28b28b519f3da645103e","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-10-08 22:02:22.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- legacy-devstack-dsvm-updown https://zuul.opendev.org/t/openstack/build/d894fa62111a4da8a01ae4a3dede5400 : SUCCESS in 33m 14s\n- tempest-full https://zuul.opendev.org/t/openstack/build/b7563893a11d4638a6378adc6b1a9b01 : SUCCESS in 1h 42m 53s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/7ea2bf496f5c48ea83c1c3c99ac825ce : SUCCESS in 1h 04m 54s\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/8d8f332a22074ed8bd5c6b60efa711b3 : SUCCESS in 59m 40s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/6c3dc80e281649ee8a957f7bf7bef20d : SUCCESS in 1h 40m 58s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/1c41d95b409248f192de44fb04a9975a : SUCCESS in 4m 14s\n- devstack https://zuul.opendev.org/t/openstack/build/1a3f34dcf31e4d5189326423e0d85406 : SUCCESS in 26m 13s\n- devstack-xenial https://zuul.opendev.org/t/openstack/build/81e5cf67748b440bbd7e5461d64d8f73 : SUCCESS in 32m 03s\n- devstack-ipv6 https://zuul.opendev.org/t/openstack/build/2c06928e81c34539a56fdf82107f000f : SUCCESS in 32m 06s\n- devstack-platform-centos-7 https://zuul.opendev.org/t/openstack/build/a977984afd1340ee9bb60fa46f8dbd61 : TIMED_OUT in 2h 07m 57s (non-voting)\n- devstack-platform-opensuse-15 https://zuul.opendev.org/t/openstack/build/764926aa5aa14838bc78b8886fb5edd1 : TIMED_OUT in 2h 06m 33s (non-voting)\n- devstack-platform-fedora-latest https://zuul.opendev.org/t/openstack/build/b24907b7e642416d96659c6ca616f6be : POST_FAILURE in 1h 35m 29s (non-voting)\n- devstack-platform-xenial https://zuul.opendev.org/t/openstack/build/681e7e192794477493f6469e82f66b74 : SUCCESS in 1h 40m 08s (non-voting)\n- devstack-multinode https://zuul.opendev.org/t/openstack/build/2b9edfe72bdd46cb90c6539555601fd9 : SUCCESS in 42m 54s\n- devstack-multinode-xenial https://zuul.opendev.org/t/openstack/build/040f8c4108734376a3b36d3641d593a1 : SUCCESS in 44m 33s\n- devstack-unit-tests https://zuul.opendev.org/t/openstack/build/341ce7f6ef86438780e691c4b11f00a3 : SUCCESS in 3m 58s\n- openstack-tox-bashate https://zuul.opendev.org/t/openstack/build/06d9348d554346fea516b13ad443fc2b : SUCCESS in 2m 13s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/15144301bac945099af7641adae6d33c : SUCCESS in 57m 08s (non-voting)\n- swift-dsvm-functional https://zuul.opendev.org/t/openstack/build/0dfd28ba047a43aeab797f0152b5d249 : SUCCESS in 41m 37s (non-voting)\n- neutron-grenade-multinode https://zuul.opendev.org/t/openstack/build/36c24d71503548aa9550a755f1d7522d : SUCCESS in 1h 10m 58s\n- neutron-tempest-linuxbridge https://zuul.opendev.org/t/openstack/build/1b5c909651f6445087850b80faeba9e2 : SUCCESS in 1h 25m 05s\n- tempest-multinode-full https://zuul.opendev.org/t/openstack/build/9a0aa78f715f4381b795e74bd21958d3 : SUCCESS in 2h 11m 43s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/13f12b46e64c4e1194d96b775352673f : SUCCESS in 1h 03m 15s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/cf43878e8fdd4c58ab7d9a90d4e1465d : SUCCESS in 1h 07m 32s","accounts_in_message":[],"_revision_number":1},{"id":"8b31eaf318e30b35e2b74036aed080ecac96b140","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-10-09 19:17:29.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"5a031e9df929fe60164c5cd2d543e60b4a78da7a","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-10-09 19:19:11.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"adcb16986a52d4b09b084447e1590815c0636821","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-10-10 15:39:35.000000000","message":"Patch Set 1: Workflow-1","accounts_in_message":[],"_revision_number":1},{"id":"14674f7135104527cd9f9411e5318a3665dcd4d3","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-11-21 16:56:26.000000000","message":"Abandoned","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"2ac912ce2fd5a50983a4db6cd6708e6297525621","revisions":{"2ac912ce2fd5a50983a4db6cd6708e6297525621":{"kind":"REWORK","_number":1,"created":"2019-10-08 18:12:36.000000000","uploader":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"ref":"refs/changes/74/687374/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/devstack","ref":"refs/changes/74/687374/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/devstack refs/changes/74/687374/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/devstack refs/changes/74/687374/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/devstack refs/changes/74/687374/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/devstack refs/changes/74/687374/1"}}},"commit":{"parents":[{"commit":"dad5665036c83dfc25de28fe82ad7831b6f0915c","subject":"Update DEVSTACK_SERIES to ussuri","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/dad5665036c83dfc25de28fe82ad7831b6f0915c"}]}],"author":{"name":"Matt Riedemann","email":"mriedem.os@gmail.com","date":"2019-10-08 18:05:31.000000000","tz":-240},"committer":{"name":"Matt Riedemann","email":"mriedem.os@gmail.com","date":"2019-10-08 18:05:31.000000000","tz":-240},"subject":"Configure mysqld with max_allowed_packet\u003d16M","message":"Configure mysqld with max_allowed_packet\u003d16M\n\nBased on [1] and seeing it\u0027s fairly common [2] configure mysql\nto use max_allowed_packet\u003d16M to avoid aborted connection issues\nseen in grenade runs.\n\nWhat we\u0027re seeing in bug 1844929 is that during a grenade run\nupgrading to Train, mysqld is started three times (install, devstack\nold side restart, devstack new side restart) and after the final\nrestart we start losing connections which manifest themselves during\nnova scheduling with \"Timed out waiting for response from cell\"\nerrors trying to query the nova_cell1 database.\n\nIt\u0027s not clear what might have changed in Train. To figure that out\nwe likely need more verbose mysqld logging enabled in a patch that\nhits the failure. But for now it seems useful to try and set\nmax_allowed_packet to a higher size as a workaround.\n\n[1] https://dba.stackexchange.com/questions/19135/mysql-error-reading-communication-packets/19139#19139\n[2] http://codesearch.openstack.org/?q\u003dmax_allowed_packet\u0026i\u003dnope\u0026files\u003d\u0026repos\u003d\n\nChange-Id: I2310d50dfbd704e522a45e023415c6a58fb43442\nRelated-Bug: #1844929\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/2ac912ce2fd5a50983a4db6cd6708e6297525621"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/2ac912ce2fd5a50983a4db6cd6708e6297525621"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}