)]}'
{"id":"openstack%2Fopenstack-ansible-galera_server~507789","triplet_id":"openstack%2Fopenstack-ansible-galera_server~master~I4e00e5ddf306b285e276bbf57ee82d4f69aa2743","project":"openstack/openstack-ansible-galera_server","branch":"master","topic":"bug/1719791","hashtags":[],"change_id":"I4e00e5ddf306b285e276bbf57ee82d4f69aa2743","subject":"templates: Increase max_allowed_packet and net_read_timeout options","status":"ABANDONED","created":"2017-09-27 08:47:28.000000000","updated":"2017-10-06 11:12:40.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"fabc8df11622417d381c68d27d7f4b84a9ce6551","_number":507789,"virtual_id_number":507789,"owner":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"all":[{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},{"_account_id":538,"name":"Major Hayden","email":"major@mhtx.net","username":"rackerhacker"},{"date":"2017-10-06 11:12:26.000000000","_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},{"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},{"value":1,"date":"2017-09-27 10:12:55.000000000","_account_id":3,"name":"Jenkins","username":"jenkins"}],"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":{"approved":{"_account_id":538,"name":"Major Hayden","email":"major@mhtx.net","username":"rackerhacker"},"all":[{"value":0,"permitted_voting_range":{"min":-2,"max":2},"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},{"value":2,"date":"2017-10-04 15:54:11.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":538,"name":"Major Hayden","email":"major@mhtx.net","username":"rackerhacker"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":3,"name":"Jenkins","username":"jenkins"}],"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":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},{"_account_id":538,"name":"Major Hayden","email":"major@mhtx.net","username":"rackerhacker"},{"value":0,"permitted_voting_range":{"min":-1,"max":0},"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},{"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},{"_account_id":3,"name":"Jenkins","username":"jenkins"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Backport-Candidate":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},{"_account_id":538,"name":"Major Hayden","email":"major@mhtx.net","username":"rackerhacker"},{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},{"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},{"_account_id":3,"name":"Jenkins","username":"jenkins"}],"values":{"-1":"Not A Backport Candidate"," 0":"Backport Review Needed","+1":"Proposed Backport"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":3,"name":"Jenkins","username":"jenkins"},{"_account_id":538,"name":"Major Hayden","email":"major@mhtx.net","username":"rackerhacker"},{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},{"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2017-09-27 09:13:13.000000000","updated_by":{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},"reviewer":{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},"state":"REVIEWER"},{"updated":"2017-09-27 09:27:00.000000000","updated_by":{"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},"reviewer":{"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},"state":"REVIEWER"},{"updated":"2017-09-27 09:27:05.000000000","updated_by":{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},"reviewer":{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},"state":"REVIEWER"},{"updated":"2017-09-27 10:12:55.000000000","updated_by":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"reviewer":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"state":"REVIEWER"},{"updated":"2017-10-04 15:54:11.000000000","updated_by":{"_account_id":538,"name":"Major Hayden","email":"major@mhtx.net","username":"rackerhacker"},"reviewer":{"_account_id":538,"name":"Major Hayden","email":"major@mhtx.net","username":"rackerhacker"},"state":"REVIEWER"}],"messages":[{"id":"7e38122c7e7cf01dcc986a936fe706b54113ecc1","author":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"date":"2017-09-27 08:47:28.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"f0933e2340af6304a76dc367d62f31fce1b7b89e","author":{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},"date":"2017-09-27 09:13:13.000000000","message":"Patch Set 1:\n\ncan you try just the 16M addition to the server ? I am not sure I see a need for the raise to 32MB anywhere..","accounts_in_message":[],"_revision_number":1},{"id":"678eafc4395f1c0344e8ee13c93d839f8e8a5390","author":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"date":"2017-09-27 09:17:17.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"2d3400da37a832c553aef07169cc032268e7e153","author":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"date":"2017-09-27 09:26:37.000000000","message":"Patch Set 2:\n\n\u003e can you try just the 16M addition to the server ? I am not sure I\n \u003e see a need for the raise to 32MB anywhere..\n\nI just noticed that the max-allowed-packet is already defined to 16M so it seems that was not enough or maybe I simply need the net-read-timeout option","accounts_in_message":[],"_revision_number":2},{"id":"2d39957672651178d9caf3c348f59408259ba82b","author":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"date":"2017-09-27 09:26:52.000000000","message":"Uploaded patch set 3.","accounts_in_message":[],"_revision_number":3},{"id":"bac021b18ecd617b5ec93970e324b8451d944541","author":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"date":"2017-09-27 09:28:31.000000000","message":"Uploaded patch set 4.","accounts_in_message":[],"_revision_number":4},{"id":"6f6903217dcda3b5e96004be35d589494bf3d7cb","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2017-09-27 10:12:55.000000000","message":"Patch Set 4: Verified+1\n\nBuild succeeded (check pipeline).\n\n- gate-openstack-ansible-galera_server-docs-ubuntu-xenial http://docs-draft.openstack.org/89/507789/4/check/gate-openstack-ansible-galera_server-docs-ubuntu-xenial/f1d19f6//doc/build/html/ : SUCCESS in 1m 34s\n- gate-openstack-ansible-galera_server-linters-ubuntu-xenial http://logs.openstack.org/89/507789/4/check/gate-openstack-ansible-galera_server-linters-ubuntu-xenial/9a748fd/ : SUCCESS in 2m 48s\n- gate-openstack-ansible-galera_server-ansible-func-centos-7 http://logs.openstack.org/89/507789/4/check/gate-openstack-ansible-galera_server-ansible-func-centos-7/7cd08ce/ : SUCCESS in 25m 57s\n- gate-openstack-ansible-galera_server-ansible-func-ubuntu-xenial http://logs.openstack.org/89/507789/4/check/gate-openstack-ansible-galera_server-ansible-func-ubuntu-xenial/4619e9a/ : SUCCESS in 20m 08s\n- gate-openstack-ansible-galera_server-ansible-func-opensuse-423 http://logs.openstack.org/89/507789/4/check/gate-openstack-ansible-galera_server-ansible-func-opensuse-423/619dc21/ : SUCCESS in 21m 48s\n- gate-openstack-ansible-galera_server-ansible-ssl-centos-7-nv http://logs.openstack.org/89/507789/4/check/gate-openstack-ansible-galera_server-ansible-ssl-centos-7-nv/b7d0201/ : FAILURE in 17m 04s (non-voting)\n- gate-openstack-ansible-galera_server-ansible-ssl-ubuntu-xenial-nv http://logs.openstack.org/89/507789/4/check/gate-openstack-ansible-galera_server-ansible-ssl-ubuntu-xenial-nv/3b5e4af/ : FAILURE in 12m 40s (non-voting)\n- gate-openstack-ansible-galera_server-ansible-upgrade-centos-7 http://logs.openstack.org/89/507789/4/check/gate-openstack-ansible-galera_server-ansible-upgrade-centos-7/084fa06/ : SUCCESS in 39m 30s\n- gate-openstack-ansible-galera_server-ansible-upgrade-ubuntu-xenial http://logs.openstack.org/89/507789/4/check/gate-openstack-ansible-galera_server-ansible-upgrade-ubuntu-xenial/7ca2d9e/ : SUCCESS in 23m 51s","accounts_in_message":[],"_revision_number":4},{"id":"d7d5a8b9a390a1c45ba33a55bcd2740f634dffe2","author":{"_account_id":538,"name":"Major Hayden","email":"major@mhtx.net","username":"rackerhacker"},"date":"2017-10-04 15:54:11.000000000","message":"Patch Set 4: Code-Review+2","accounts_in_message":[],"_revision_number":4},{"id":"a1c668b7736f2f528754bf5ec5c2cce012e8795b","author":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"date":"2017-10-06 11:12:26.000000000","message":"Patch Set 4:\n\nSo regarding this, the real problem was a problematic galera server so maybe we don\u0027t need to change the configuration right now.","accounts_in_message":[],"_revision_number":4},{"id":"3d3dbf2389aa12a2aadfcfdafb5162c71fa24d32","author":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"date":"2017-10-06 11:12:40.000000000","message":"Abandoned","accounts_in_message":[],"_revision_number":4}],"current_revision_number":4,"current_revision":"1e70388a1520bf3031b378a6c9009c532f252781","revisions":{"45135d31941c149ea2bbf164a36209ca6ff6ed68":{"kind":"REWORK","_number":1,"created":"2017-09-27 08:47:28.000000000","uploader":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"ref":"refs/changes/89/507789/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-ansible-galera_server","ref":"refs/changes/89/507789/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/1"}}},"commit":{"parents":[{"commit":"1f55ed39f36041be2ccb81462be0abcc6c4b3814","subject":"Updated from global requirements","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/1f55ed39f36041be2ccb81462be0abcc6c4b3814"}]}],"author":{"name":"Markos Chandras","email":"mchandras@suse.de","date":"2017-09-27 08:25:05.000000000","tz":60},"committer":{"name":"Markos Chandras","email":"mchandras@suse.de","date":"2017-09-27 08:47:14.000000000","tz":60},"subject":"templates: Increase max_allowed_packet option to 32M","message":"templates: Increase max_allowed_packet option to 32M\n\nThe default value for the mysqld process is 4M which may not be enough\nanymore. This leads to problems like the following one:\n\n2017-09-27 02:16:57.182 16925 CRITICAL keystone [-] Unhandled error: DBMigrationError: (pymysql.err.OperationalError) (2013, \u0027Lost connection to MySQL server during query\u0027) [SQL: u\u0027ALTER TABLE user ADD CONSTRAINT ixu_user_name_domain_id UNIQUE (domain_id, name)\u0027]\n2017-09-27 02:16:57.182 16925 ERROR keystone Traceback (most recent call last):\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/bin/keystone-manage\", line 10, in \u003cmodule\u003e\n2017-09-27 02:16:57.182 16925 ERROR keystone     sys.exit(main())\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/manage.py\", line 45, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     cli.main(argv\u003dsys.argv, config_files\u003dconfig_files)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/cli.py\", line 1331, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     CONF.command.cmd_class.main()\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/cli.py\", line 523, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     upgrades.expand_schema()\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/common/sql/upgrades.py\", line 323, in expand_schema\n2017-09-27 02:16:57.182 16925 ERROR keystone     _sync_common_repo(version\u003dNone)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/common/sql/upgrades.py\", line 170, in _sync_common_repo\n2017-09-27 02:16:57.182 16925 ERROR keystone     init_version\u003dinit_version, sanity_check\u003dFalse)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py\", line 81, in db_sync\n2017-09-27 02:16:57.182 16925 ERROR keystone     raise exception.DBMigrationError(ex)\n2017-09-27 02:16:57.182 16925 ERROR keystone DBMigrationError: (pymysql.err.OperationalError) (2013, \u0027Lost connection to MySQL server during query\u0027) [SQL: u\u0027ALTER TABLE user ADD CONSTRAINT ixu_user_name_domain_id UNIQUE (domain_id, name)\u0027]\n2017-09-27 02:16:57.182 16925 ERROR keystone\n\nLets increase the value to 32M. According to the upstream documentation\nit\u0027s safe to increase the value to a higher limit because extra memory\nis only going to be used when really needed.\n\nLink: https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html\nCloses-Bug: #1719791\nChange-Id: I4e00e5ddf306b285e276bbf57ee82d4f69aa2743\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/45135d31941c149ea2bbf164a36209ca6ff6ed68"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/45135d31941c149ea2bbf164a36209ca6ff6ed68"}]},"branch":"refs/heads/master"},"16f42e23973e9492ddb178df7cea0564eb62c7d4":{"kind":"REWORK","_number":2,"created":"2017-09-27 09:17:17.000000000","uploader":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"ref":"refs/changes/89/507789/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-ansible-galera_server","ref":"refs/changes/89/507789/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/2"}}},"commit":{"parents":[{"commit":"1f55ed39f36041be2ccb81462be0abcc6c4b3814","subject":"Updated from global requirements","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/1f55ed39f36041be2ccb81462be0abcc6c4b3814"}]}],"author":{"name":"Markos Chandras","email":"mchandras@suse.de","date":"2017-09-27 08:25:05.000000000","tz":60},"committer":{"name":"Markos Chandras","email":"mchandras@suse.de","date":"2017-09-27 09:14:01.000000000","tz":60},"subject":"templates: Increase max_allowed_packet and net_read_timeout options","message":"templates: Increase max_allowed_packet and net_read_timeout options\n\nkeystone has recently started to fail with the following error:\n\n2017-09-27 02:16:57.182 16925 CRITICAL keystone [-] Unhandled error: DBMigrationError: (pymysql.err.OperationalError) (2013, \u0027Lost connection to MySQL server during query\u0027) [SQL: u\u0027ALTER TABLE user ADD CONSTRAINT ixu_user_name_domain_id UNIQUE (domain_id, name)\u0027]\n2017-09-27 02:16:57.182 16925 ERROR keystone Traceback (most recent call last):\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/bin/keystone-manage\", line 10, in \u003cmodule\u003e\n2017-09-27 02:16:57.182 16925 ERROR keystone     sys.exit(main())\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/manage.py\", line 45, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     cli.main(argv\u003dsys.argv, config_files\u003dconfig_files)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/cli.py\", line 1331, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     CONF.command.cmd_class.main()\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/cli.py\", line 523, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     upgrades.expand_schema()\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/common/sql/upgrades.py\", line 323, in expand_schema\n2017-09-27 02:16:57.182 16925 ERROR keystone     _sync_common_repo(version\u003dNone)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/common/sql/upgrades.py\", line 170, in _sync_common_repo\n2017-09-27 02:16:57.182 16925 ERROR keystone     init_version\u003dinit_version, sanity_check\u003dFalse)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py\", line 81, in db_sync\n2017-09-27 02:16:57.182 16925 ERROR keystone     raise exception.DBMigrationError(ex)\n2017-09-27 02:16:57.182 16925 ERROR keystone DBMigrationError: (pymysql.err.OperationalError) (2013, \u0027Lost connection to MySQL server during query\u0027) [SQL: u\u0027ALTER TABLE user ADD CONSTRAINT ixu_user_name_domain_id UNIQUE (domain_id, name)\u0027]\n2017-09-27 02:16:57.182 16925 ERROR keystone\n\nAccording to the upstream documentation this could happen when the\nserver is waiting for more data from the client or when we are sending\npackets which are greater than max_allowed_packet. So lets increase the\nvalue to 32M. According to the upstream documentation it\u0027s safe to\nincrease the value to a higher limit because extra memory is only going\nto be used when really needed. Finally, we increase net_read_timeout to\n60 seconds in order to give more time to the transaction to complete on\nbusy or slower hosts.\n\nLink: https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html\nCloses-Bug: #1719791\nChange-Id: I4e00e5ddf306b285e276bbf57ee82d4f69aa2743\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/16f42e23973e9492ddb178df7cea0564eb62c7d4"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/16f42e23973e9492ddb178df7cea0564eb62c7d4"}]},"branch":"refs/heads/master"},"35776d5d9b51358c50d04f2a38f57c1437d8a507":{"kind":"REWORK","_number":3,"created":"2017-09-27 09:26:52.000000000","uploader":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"ref":"refs/changes/89/507789/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-ansible-galera_server","ref":"refs/changes/89/507789/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/3"}}},"commit":{"parents":[{"commit":"1f55ed39f36041be2ccb81462be0abcc6c4b3814","subject":"Updated from global requirements","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/1f55ed39f36041be2ccb81462be0abcc6c4b3814"}]}],"author":{"name":"Markos Chandras","email":"mchandras@suse.de","date":"2017-09-27 08:25:05.000000000","tz":60},"committer":{"name":"Markos Chandras","email":"mchandras@suse.de","date":"2017-09-27 09:25:43.000000000","tz":60},"subject":"templates: Increase max_allowed_packet and net_read_timeout options","message":"templates: Increase max_allowed_packet and net_read_timeout options\n\nkeystone has recently started to fail with the following error:\n\n2017-09-27 02:16:57.182 16925 CRITICAL keystone [-] Unhandled error: DBMigrationError: (pymysql.err.OperationalError) (2013, \u0027Lost connection to MySQL server during query\u0027) [SQL: u\u0027ALTER TABLE user ADD CONSTRAINT ixu_user_name_domain_id UNIQUE (domain_id, name)\u0027]\n2017-09-27 02:16:57.182 16925 ERROR keystone Traceback (most recent call last):\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/bin/keystone-manage\", line 10, in \u003cmodule\u003e\n2017-09-27 02:16:57.182 16925 ERROR keystone     sys.exit(main())\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/manage.py\", line 45, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     cli.main(argv\u003dsys.argv, config_files\u003dconfig_files)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/cli.py\", line 1331, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     CONF.command.cmd_class.main()\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/cli.py\", line 523, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     upgrades.expand_schema()\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/common/sql/upgrades.py\", line 323, in expand_schema\n2017-09-27 02:16:57.182 16925 ERROR keystone     _sync_common_repo(version\u003dNone)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/common/sql/upgrades.py\", line 170, in _sync_common_repo\n2017-09-27 02:16:57.182 16925 ERROR keystone     init_version\u003dinit_version, sanity_check\u003dFalse)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py\", line 81, in db_sync\n2017-09-27 02:16:57.182 16925 ERROR keystone     raise exception.DBMigrationError(ex)\n2017-09-27 02:16:57.182 16925 ERROR keystone DBMigrationError: (pymysql.err.OperationalError) (2013, \u0027Lost connection to MySQL server during query\u0027) [SQL: u\u0027ALTER TABLE user ADD CONSTRAINT ixu_user_name_domain_id UNIQUE (domain_id, name)\u0027]\n2017-09-27 02:16:57.182 16925 ERROR keystone\n\nAccording to the upstream documentation this could happen when the\nserver is waiting for more data from the client or when we are sending\npackets which are greater than max_allowed_packet. So lets increase the\nvalue to 32M. According to the upstream documentation it\u0027s safe to\nincrease the value to a higher limit because extra memory is only going\nto be used when really needed. Finally, we increase net_read_timeout to\n60 seconds in order to give more time to the transaction to complete on\nbusy or slower hosts.\n\nLink: https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html\nCloses-Bug: #1719791\nChange-Id: I4e00e5ddf306b285e276bbf57ee82d4f69aa2743\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/35776d5d9b51358c50d04f2a38f57c1437d8a507"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/35776d5d9b51358c50d04f2a38f57c1437d8a507"}]},"branch":"refs/heads/master"},"1e70388a1520bf3031b378a6c9009c532f252781":{"kind":"REWORK","_number":4,"created":"2017-09-27 09:28:31.000000000","uploader":{"_account_id":23163,"name":"Markos Chandras (hwoarang)","email":"markos@chandras.me","username":"mchandras"},"ref":"refs/changes/89/507789/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-ansible-galera_server","ref":"refs/changes/89/507789/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-ansible-galera_server refs/changes/89/507789/4"}}},"commit":{"parents":[{"commit":"1f55ed39f36041be2ccb81462be0abcc6c4b3814","subject":"Updated from global requirements","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/1f55ed39f36041be2ccb81462be0abcc6c4b3814"}]}],"author":{"name":"Markos Chandras","email":"mchandras@suse.de","date":"2017-09-27 08:25:05.000000000","tz":60},"committer":{"name":"Markos Chandras","email":"mchandras@suse.de","date":"2017-09-27 09:28:23.000000000","tz":60},"subject":"templates: Increase max_allowed_packet and net_read_timeout options","message":"templates: Increase max_allowed_packet and net_read_timeout options\n\nkeystone has recently started to fail with the following error:\n\n2017-09-27 02:16:57.182 16925 CRITICAL keystone [-] Unhandled error: DBMigrationError: (pymysql.err.OperationalError) (2013, \u0027Lost connection to MySQL server during query\u0027) [SQL: u\u0027ALTER TABLE user ADD CONSTRAINT ixu_user_name_domain_id UNIQUE (domain_id, name)\u0027]\n2017-09-27 02:16:57.182 16925 ERROR keystone Traceback (most recent call last):\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/bin/keystone-manage\", line 10, in \u003cmodule\u003e\n2017-09-27 02:16:57.182 16925 ERROR keystone     sys.exit(main())\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/manage.py\", line 45, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     cli.main(argv\u003dsys.argv, config_files\u003dconfig_files)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/cli.py\", line 1331, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     CONF.command.cmd_class.main()\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/cmd/cli.py\", line 523, in main\n2017-09-27 02:16:57.182 16925 ERROR keystone     upgrades.expand_schema()\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/common/sql/upgrades.py\", line 323, in expand_schema\n2017-09-27 02:16:57.182 16925 ERROR keystone     _sync_common_repo(version\u003dNone)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/keystone/common/sql/upgrades.py\", line 170, in _sync_common_repo\n2017-09-27 02:16:57.182 16925 ERROR keystone     init_version\u003dinit_version, sanity_check\u003dFalse)\n2017-09-27 02:16:57.182 16925 ERROR keystone   File \"/openstack/venvs/keystone-testing/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py\", line 81, in db_sync\n2017-09-27 02:16:57.182 16925 ERROR keystone     raise exception.DBMigrationError(ex)\n2017-09-27 02:16:57.182 16925 ERROR keystone DBMigrationError: (pymysql.err.OperationalError) (2013, \u0027Lost connection to MySQL server during query\u0027) [SQL: u\u0027ALTER TABLE user ADD CONSTRAINT ixu_user_name_domain_id UNIQUE (domain_id, name)\u0027]\n2017-09-27 02:16:57.182 16925 ERROR keystone\n\nAccording to the upstream documentation this could happen when the\nserver is waiting for more data from the client or when we are sending\npackets which are greater than max_allowed_packet. So lets increase the\nvalue to 32M. According to the upstream documentation it\u0027s safe to\nincrease the value to a higher limit because extra memory is only going\nto be used when really needed. Finally, we increase net_read_timeout to\n60 seconds in order to give more time to the transaction to complete on\nbusy or slower hosts.\n\nLink: https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html\nCloses-Bug: #1719791\nChange-Id: I4e00e5ddf306b285e276bbf57ee82d4f69aa2743\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/1e70388a1520bf3031b378a6c9009c532f252781"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-ansible-galera_server/commit/1e70388a1520bf3031b378a6c9009c532f252781"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}