)]}'
{"id":"openstack%2Fdevstack~517773","triplet_id":"openstack%2Fdevstack~master~I5b384586b5d9e62f6fadde622f80b316bbbdbd1d","project":"openstack/devstack","branch":"master","topic":"utf8mb4","hashtags":[],"change_id":"I5b384586b5d9e62f6fadde622f80b316bbbdbd1d","subject":"Use utf8mb4 for MySQL like databases","status":"ABANDONED","created":"2017-11-04 18:34:21.000000000","updated":"2019-01-29 06:20:24.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"705d31cb15624792b1932eb0deb08f4c62fe7679","_number":517773,"virtual_id_number":517773,"owner":{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},{"date":"2017-11-04 21:14:24.000000000","_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"date":"2017-11-05 00:15:15.000000000","_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"value":0,"date":"2017-11-04 18:47:28.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":1,"date":"2017-11-04 20:20:46.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"}],"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":{"disliked":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"all":[{"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":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":-1,"date":"2017-11-07 00:36:50.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"}],"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":"","value":-1,"default_value":0,"optional":true},"Workflow":{"rejected":{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},"all":[{"value":-1,"date":"2017-11-07 01:00:40.000000000","permitted_voting_range":{"min":-1,"max":0},"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"}],"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":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"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":-1,"max":2},"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"}],"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":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2017-11-04 18:47:28.000000000","updated_by":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"reviewer":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2017-11-04 20:20:46.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"},{"updated":"2017-11-04 21:14:24.000000000","updated_by":{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2017-11-05 00:15:15.000000000","updated_by":{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2017-11-07 00:36:50.000000000","updated_by":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"reviewer":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"state":"REVIEWER"}],"messages":[{"id":"a30e850f8518c43631be5f1828feddfd0e6e792a","author":{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},"date":"2017-11-04 18:34:21.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"9cd3010c03cd67d1a0ec20f82025eedd3e133033","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2017-11-04 18:47:28.000000000","message":"Patch Set 1:\n\nBuild failed. Test completed on IBM PowerKVM platform. For rechecking only on the IBM PowerKVM CI, add a review comment with pkvm: recheck. For contact and more information, see https://wiki.openstack.org/wiki/PowerKVM\n\n- tempest-dsvm-full-xenial http://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/devstack/73/517773/1/check/tempest-dsvm-full-xenial/c6f4391/ : FAILURE in 12m 52s","accounts_in_message":[],"_revision_number":1},{"id":"469265de09fca3c3e25efc1eac99e54b1583bb63","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2017-11-04 20:20:46.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- legacy-tempest-dsvm-py35 http://logs.openstack.org/73/517773/1/check/legacy-tempest-dsvm-py35/187e9d6/ : SUCCESS in 1h 15m 48s\n- build-openstack-sphinx-docs http://logs.openstack.org/73/517773/1/check/build-openstack-sphinx-docs/6a5b567/html/ : SUCCESS in 3m 25s\n- openstack-tox-bashate http://logs.openstack.org/73/517773/1/check/openstack-tox-bashate/ea99741/ : SUCCESS in 4m 04s\n- legacy-devstack-unit-tests http://logs.openstack.org/73/517773/1/check/legacy-devstack-unit-tests/a5ae641/ : SUCCESS in 4m 26s\n- ironic-tempest-dsvm-ipa-wholedisk-bios-agent_ipmitool-tinyipa http://logs.openstack.org/73/517773/1/check/ironic-tempest-dsvm-ipa-wholedisk-bios-agent_ipmitool-tinyipa/8ff312a/ : SUCCESS in 45m 36s (non-voting)\n- legacy-devstack-dsvm-updown http://logs.openstack.org/73/517773/1/check/legacy-devstack-dsvm-updown/f994bfa/ : SUCCESS in 29m 54s\n- legacy-devstack-dsvm-py35-updown http://logs.openstack.org/73/517773/1/check/legacy-devstack-dsvm-py35-updown/bbb092c/ : SUCCESS in 35m 35s (non-voting)\n- legacy-swift-dsvm-functional http://logs.openstack.org/73/517773/1/check/legacy-swift-dsvm-functional/8cd51ad/ : SUCCESS in 23m 25s (non-voting)\n- legacy-grenade-dsvm-neutron http://logs.openstack.org/73/517773/1/check/legacy-grenade-dsvm-neutron/1431cd5/ : SUCCESS in 51m 22s\n- legacy-grenade-dsvm-neutron-multinode http://logs.openstack.org/73/517773/1/check/legacy-grenade-dsvm-neutron-multinode/a7f25e0/ : SUCCESS in 1h 01m 41s\n- legacy-tempest-dsvm-neutron-full-centos-7 http://logs.openstack.org/73/517773/1/check/legacy-tempest-dsvm-neutron-full-centos-7/7970892/ : FAILURE in 22m 28s (non-voting)\n- legacy-tempest-dsvm-neutron-linuxbridge http://logs.openstack.org/73/517773/1/check/legacy-tempest-dsvm-neutron-linuxbridge/fdbe5c6/ : SUCCESS in 1h 19m 13s\n- legacy-tempest-dsvm-neutron-full-opensuse-423 http://logs.openstack.org/73/517773/1/check/legacy-tempest-dsvm-neutron-full-opensuse-423/5765765/ : FAILURE in 17m 01s (non-voting)\n- legacy-tempest-dsvm-neutron-multinode-full http://logs.openstack.org/73/517773/1/check/legacy-tempest-dsvm-neutron-multinode-full/d4df227/ : SUCCESS in 1h 40m 35s (non-voting)\n- legacy-tempest-dsvm-neutron-full http://logs.openstack.org/73/517773/1/check/legacy-tempest-dsvm-neutron-full/d65afcd/ : SUCCESS in 1h 30m 23s\n- devstack http://logs.openstack.org/73/517773/1/check/devstack/0bd0f5c/ : SUCCESS in 20m 02s","accounts_in_message":[],"_revision_number":1},{"id":"dfd5225edc286360a75cb896d60416f6e61f1196","author":{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},"date":"2017-11-04 21:14:24.000000000","message":"Patch Set 1:\n\nBuild failed.  To recheck use \u0027xenserver: recheck\u0027.  For 3rd party ci contact info: https://wiki.openstack.org/wiki/ThirdPartySystems\n\n- dsvm-tempest-neutron-network http://dd6b71949550285df7dc-dda4e480e005aaa13ec303551d2d8155.r49.cf1.rackcdn.com/73/517773/1/check/dsvm-tempest-neutron-network/cbcda51 : FAILURE in 2h 39m 33s","accounts_in_message":[],"_revision_number":1},{"id":"a4fbb791aaa50ee797885c1c873e10b2f52557bd","author":{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},"date":"2017-11-05 00:15:15.000000000","message":"Patch Set 1:\n\nTesting succeeded on ubuntu-xenial-s390x. For rechecking only on the ubuntu-xenail-s390x CI, add a review comment with recheck-zkvm. Contact info: zkvm-ci@linux.vnet.ibm.com. For more information, see https://wiki.openstack.org/wiki/ThirdPartySystems/IBM_zKVM_CI\n\n- check-tempest-dsvm-neutron-full-ubuntu-xenial-s390x http://sng01.objectstorage.softlayer.net/v1/AUTH_1940ea10-6e82-4501-b2f9-eb236510e575/ibmzkvmci/production/517773/1/check-tempest-dsvm-neutron-full-ubuntu-xenial-s390x/3e39cd9 : SUCCESS in 1h 13m 25s","accounts_in_message":[],"_revision_number":1},{"id":"ac1bb898d838d091835e449beb3bad729e81380c","author":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"date":"2017-11-07 00:36:50.000000000","message":"Patch Set 1: Code-Review-1\n\nWhat do i know about the details of this?  not much ...\n\nbut it seems like it\u0027s been fairly explicitly decided to only support 3-byte unicode and nova, at least, may very well have field lengths that can cause problems with this [1]?  i\u0027d personally want to see weigh in from people who know about this that it\u0027s safe...   \n\nmy -1 is mostly that i\u0027d like to see it explained why this is safe\n\n[1] https://git.openstack.org/cgit/openstack/nova-specs/tree/specs/kilo/implemented/relax-resource-name-restrictions.rst","accounts_in_message":[],"_revision_number":1},{"id":"799a51af975b92f10d5404864ce6128f5c4d6f78","author":{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},"date":"2017-11-07 01:00:40.000000000","message":"Patch Set 1: Workflow-1\n\nYeah, it looks like it causes failures:\n\nnCREATE TABLE migrate_version (\\n\\trepository_id VARCHAR(250) NOT NULL, \\n\\trepository_path TEXT, \\n\\tversion INTEGER, \\n\\tPRIMARY KEY (repository_id)\\n)\\n\\n\u0027]\u001b[00m: InternalError: (1071, u\u0027Specified key was too long; max key length is 767 bytes\u0027)","accounts_in_message":[],"_revision_number":1},{"id":"f3bab55087dd2f814e6de2a9158d98da999234da","author":{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},"date":"2019-01-29 06:20:24.000000000","message":"Abandoned\n\nNo time for this atm","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"4fc9d9531fcb5ae9333353f6c65a44fa96b8810c","revisions":{"4fc9d9531fcb5ae9333353f6c65a44fa96b8810c":{"kind":"REWORK","_number":1,"created":"2017-11-04 18:34:21.000000000","uploader":{"_account_id":6593,"name":"Dirk Mueller","email":"dirk@dmllr.de","username":"dmllr"},"ref":"refs/changes/73/517773/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/devstack","ref":"refs/changes/73/517773/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/devstack refs/changes/73/517773/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/devstack refs/changes/73/517773/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/devstack refs/changes/73/517773/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/devstack refs/changes/73/517773/1"}}},"commit":{"parents":[{"commit":"29bc8e645c5d3dd90361df89efc2e53798bd3bc4","subject":"Merge \"Add \"sudo\" before the journalctl command\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/29bc8e645c5d3dd90361df89efc2e53798bd3bc4"}]}],"author":{"name":"Dirk Mueller","email":"dirk@dmllr.de","date":"2017-11-04 18:31:10.000000000","tz":60},"committer":{"name":"Dirk Mueller","email":"dirk@dmllr.de","date":"2017-11-04 18:31:10.000000000","tz":60},"subject":"Use utf8mb4 for MySQL like databases","message":"Use utf8mb4 for MySQL like databases\n\nthe utf8 encoding in MySQL/MariaDB only supports codepoints up to 3\nbytes. For full unicode support we need utf8mb4. There are more\nreasons other than not being able to store U+1F4A9 PILE OF POO\ncorrectly, see https://mathiasbynens.be/notes/mysql-utf8mb4\n\nChange-Id: I5b384586b5d9e62f6fadde622f80b316bbbdbd1d\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/4fc9d9531fcb5ae9333353f6c65a44fa96b8810c"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/4fc9d9531fcb5ae9333353f6c65a44fa96b8810c"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}