)]}'
{"id":"openstack%2Fceilometer~238038","triplet_id":"openstack%2Fceilometer~master~Ic53e1addf38a4d5934b4e627c4c974c6db42517e","project":"openstack/ceilometer","branch":"master","topic":"bug/1506717","hashtags":[],"change_id":"Ic53e1addf38a4d5934b4e627c4c974c6db42517e","subject":"avoid using isolation level","status":"MERGED","created":"2015-10-21 12:49:46.000000000","updated":"2015-10-23 21:43:40.000000000","submitted":"2015-10-23 21:43:38.000000000","submitter":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"19901a670f0959d593afcfc9c0df91856cfadc11","_number":238038,"virtual_id_number":238038,"owner":{"_account_id":6537,"name":"gordon chung","email":"gord@live.ca","username":"chungg"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"all":[{"value":0,"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"value":0,"_account_id":6924,"name":"Pradeep Kilambi","email":"pkilambi@redhat.com","username":"pkilambi"},{"value":0,"_account_id":10345,"name":"Anna Sortland","email":"annasort@us.ibm.com","username":"annasort"},{"value":0,"_account_id":13637,"name":"Divya K Konoor","email":"dikonoor@in.ibm.com","username":"dikonoor"},{"value":0,"_account_id":10608,"name":"Matthew Edmonds","email":"edmondsw@us.ibm.com","username":"edmondsw"},{"value":0,"date":"2015-10-21 13:04:50.000000000","_account_id":15843,"name":"Intel Hardware-Meters CI","email":"ipmi-ci@intel.com","username":"ipmici"},{"value":2,"date":"2015-10-23 21:43:38.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":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"all":[{"value":2,"date":"2015-10-23 11:38:10.000000000","_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"value":2,"date":"2015-10-23 17:43:51.000000000","_account_id":6924,"name":"Pradeep Kilambi","email":"pkilambi@redhat.com","username":"pkilambi"},{"value":1,"date":"2015-10-23 21:00:05.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":10345,"name":"Anna Sortland","email":"annasort@us.ibm.com","username":"annasort"},{"value":1,"date":"2015-10-23 05:47:41.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":13637,"name":"Divya K Konoor","email":"dikonoor@in.ibm.com","username":"dikonoor"},{"value":0,"_account_id":10608,"name":"Matthew Edmonds","email":"edmondsw@us.ibm.com","username":"edmondsw"},{"value":0,"_account_id":15843,"name":"Intel Hardware-Meters CI","email":"ipmi-ci@intel.com","username":"ipmici"},{"value":0,"_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":{"approved":{"_account_id":6924,"name":"Pradeep Kilambi","email":"pkilambi@redhat.com","username":"pkilambi"},"all":[{"value":0,"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"value":1,"date":"2015-10-23 17:43:51.000000000","_account_id":6924,"name":"Pradeep Kilambi","email":"pkilambi@redhat.com","username":"pkilambi"},{"value":0,"date":"2015-10-23 05:47:27.000000000","_account_id":10345,"name":"Anna Sortland","email":"annasort@us.ibm.com","username":"annasort"},{"value":0,"date":"2015-10-23 05:47:05.000000000","_account_id":13637,"name":"Divya K Konoor","email":"dikonoor@in.ibm.com","username":"dikonoor"},{"value":0,"date":"2015-10-23 05:47:15.000000000","_account_id":10608,"name":"Matthew Edmonds","email":"edmondsw@us.ibm.com","username":"edmondsw"},{"value":0,"_account_id":15843,"name":"Intel Hardware-Meters CI","email":"ipmi-ci@intel.com","username":"ipmici"},{"value":0,"_account_id":3,"name":"Jenkins","username":"jenkins"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":3,"name":"Jenkins","username":"jenkins"},{"_account_id":6924,"name":"Pradeep Kilambi","email":"pkilambi@redhat.com","username":"pkilambi"},{"_account_id":10345,"name":"Anna Sortland","email":"annasort@us.ibm.com","username":"annasort"},{"_account_id":10608,"name":"Matthew Edmonds","email":"edmondsw@us.ibm.com","username":"edmondsw"},{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"_account_id":13637,"name":"Divya K Konoor","email":"dikonoor@in.ibm.com","username":"dikonoor"},{"_account_id":15843,"name":"Intel Hardware-Meters CI","email":"ipmi-ci@intel.com","username":"ipmici"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2015-10-21 13:04:50.000000000","updated_by":{"_account_id":15843,"name":"Intel Hardware-Meters CI","email":"ipmi-ci@intel.com","username":"ipmici"},"reviewer":{"_account_id":15843,"name":"Intel Hardware-Meters CI","email":"ipmi-ci@intel.com","username":"ipmici"},"state":"REVIEWER"},{"updated":"2015-10-23 05:47:05.000000000","updated_by":{"_account_id":13637,"name":"Divya K Konoor","email":"dikonoor@in.ibm.com","username":"dikonoor"},"reviewer":{"_account_id":13637,"name":"Divya K Konoor","email":"dikonoor@in.ibm.com","username":"dikonoor"},"state":"REVIEWER"},{"updated":"2015-10-23 05:47:15.000000000","updated_by":{"_account_id":10608,"name":"Matthew Edmonds","email":"edmondsw@us.ibm.com","username":"edmondsw"},"reviewer":{"_account_id":10608,"name":"Matthew Edmonds","email":"edmondsw@us.ibm.com","username":"edmondsw"},"state":"REVIEWER"},{"updated":"2015-10-23 05:47:27.000000000","updated_by":{"_account_id":10345,"name":"Anna Sortland","email":"annasort@us.ibm.com","username":"annasort"},"reviewer":{"_account_id":10345,"name":"Anna Sortland","email":"annasort@us.ibm.com","username":"annasort"},"state":"REVIEWER"},{"updated":"2015-10-23 11:38:10.000000000","updated_by":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"reviewer":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"state":"REVIEWER"},{"updated":"2015-10-23 17:43:51.000000000","updated_by":{"_account_id":6924,"name":"Pradeep Kilambi","email":"pkilambi@redhat.com","username":"pkilambi"},"reviewer":{"_account_id":6924,"name":"Pradeep Kilambi","email":"pkilambi@redhat.com","username":"pkilambi"},"state":"REVIEWER"},{"updated":"2015-10-23 21:43:38.000000000","updated_by":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"reviewer":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"state":"REVIEWER"}],"messages":[{"id":"57ee04126fe4c1901e46b0cab16c90e24774c937","author":{"_account_id":6537,"name":"gordon chung","email":"gord@live.ca","username":"chungg"},"date":"2015-10-21 12:49:46.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"7d2189f4a3177aa0cb136643655cc2039722f9f7","author":{"_account_id":15843,"name":"Intel Hardware-Meters CI","email":"ipmi-ci@intel.com","username":"ipmici"},"date":"2015-10-21 13:04:50.000000000","message":"Patch Set 1:\n\n* ipmi-test http://52.27.155.124/ipmi/238038/1 : SUCCESS","accounts_in_message":[],"_revision_number":1},{"id":"e3b8d4fe93077cccd47ea6e95b79c7ee459ac8eb","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2015-10-21 14:08:59.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- gate-ceilometer-pep8 http://logs.openstack.org/38/238038/1/check/gate-ceilometer-pep8/f70dffa/ : SUCCESS in 3m 44s\n- gate-ceilometer-docs http://docs-draft.openstack.org/38/238038/1/check/gate-ceilometer-docs/a8b7c96//doc/build/html/ : SUCCESS in 4m 25s\n- gate-ceilometer-python27 http://logs.openstack.org/38/238038/1/check/gate-ceilometer-python27/24b4ae6/ : SUCCESS in 4m 25s\n- gate-ceilometer-python34 http://logs.openstack.org/38/238038/1/check/gate-ceilometer-python34/fb26eac/ : SUCCESS in 4m 47s\n- gate-tempest-dsvm-ceilometer-mongodb-full http://logs.openstack.org/38/238038/1/check/gate-tempest-dsvm-ceilometer-mongodb-full/25e32df/ : SUCCESS in 55m 32s (non-voting)\n- gate-tempest-dsvm-ceilometer-mysql-neutron-full http://logs.openstack.org/38/238038/1/check/gate-tempest-dsvm-ceilometer-mysql-neutron-full/9225c38/ : SUCCESS in 1h 16m 38s\n- gate-tempest-dsvm-ceilometer-mysql-full http://logs.openstack.org/38/238038/1/check/gate-tempest-dsvm-ceilometer-mysql-full/463c21e/ : SUCCESS in 55m 10s\n- gate-tempest-dsvm-ceilometer-postgresql-full http://logs.openstack.org/38/238038/1/check/gate-tempest-dsvm-ceilometer-postgresql-full/421f60d/ : SUCCESS in 1h 00m 37s\n- gate-ceilometer-dsvm-functional-mongodb http://logs.openstack.org/38/238038/1/check/gate-ceilometer-dsvm-functional-mongodb/8a02d09/ : SUCCESS in 39m 14s\n- gate-ceilometer-dsvm-functional-postgresql http://logs.openstack.org/38/238038/1/check/gate-ceilometer-dsvm-functional-postgresql/2e62db0/ : SUCCESS in 45m 27s\n- gate-grenade-dsvm-ceilometer http://logs.openstack.org/38/238038/1/check/gate-grenade-dsvm-ceilometer/dc6efa1/ : SUCCESS in 46m 34s\n- gate-ceilometer-dsvm-integration http://logs.openstack.org/38/238038/1/check/gate-ceilometer-dsvm-integration/1302268/ : SUCCESS in 43m 35s","accounts_in_message":[],"_revision_number":1},{"id":"9f688b391c96a342184d47241ca41f1c523af0b7","author":{"_account_id":13637,"name":"Divya K Konoor","email":"dikonoor@in.ibm.com","username":"dikonoor"},"date":"2015-10-23 05:47:41.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"ed100354d752044e10f0af13675a27282fdc96a7","author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"date":"2015-10-23 11:38:10.000000000","message":"Patch Set 1: Code-Review+2\n\nwe got some messed up data models...","accounts_in_message":[],"_revision_number":1},{"id":"f16c0da58fd8c0b527213f04f4c3539114d68684","author":{"_account_id":6924,"name":"Pradeep Kilambi","email":"pkilambi@redhat.com","username":"pkilambi"},"date":"2015-10-23 17:43:51.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"c207f8d18b89ed16411bfe916ee02ea2df01418f","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2015-10-23 17:43:57.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.\nhttp://status.openstack.org/zuul/","accounts_in_message":[],"_revision_number":1},{"id":"030b55b6c351e93ff10fc9319907f55ea90170d8","author":{"_account_id":10345,"name":"Anna Sortland","email":"annasort@us.ibm.com","username":"annasort"},"date":"2015-10-23 21:00:05.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"6583a776d553277c6c4aab8098a5ee161e0b9f8f","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2015-10-23 21:43:38.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- gate-ceilometer-docs http://docs-draft.openstack.org/38/238038/1/gate/gate-ceilometer-docs/3b0279d//doc/build/html/ : SUCCESS in 4m 10s\n- gate-ceilometer-pep8 http://logs.openstack.org/38/238038/1/gate/gate-ceilometer-pep8/a73bedf/ : SUCCESS in 5m 37s\n- gate-ceilometer-python27 http://logs.openstack.org/38/238038/1/gate/gate-ceilometer-python27/c318d95/ : SUCCESS in 3m 42s\n- gate-ceilometer-python34 http://logs.openstack.org/38/238038/1/gate/gate-ceilometer-python34/eda37a0/ : SUCCESS in 4m 48s\n- gate-ceilometer-dsvm-functional-mongodb http://logs.openstack.org/38/238038/1/gate/gate-ceilometer-dsvm-functional-mongodb/15afd10/ : SUCCESS in 37m 46s\n- gate-ceilometer-dsvm-functional-postgresql http://logs.openstack.org/38/238038/1/gate/gate-ceilometer-dsvm-functional-postgresql/913518e/ : SUCCESS in 42m 39s\n- gate-tempest-dsvm-ceilometer-mysql-neutron-full http://logs.openstack.org/38/238038/1/gate/gate-tempest-dsvm-ceilometer-mysql-neutron-full/9db6b77/ : SUCCESS in 1h 08m 54s\n- gate-tempest-dsvm-ceilometer-mysql-full http://logs.openstack.org/38/238038/1/gate/gate-tempest-dsvm-ceilometer-mysql-full/e0cf3e0/ : SUCCESS in 44m 54s\n- gate-tempest-dsvm-ceilometer-postgresql-full http://logs.openstack.org/38/238038/1/gate/gate-tempest-dsvm-ceilometer-postgresql-full/657ca44/ : SUCCESS in 57m 57s\n- gate-grenade-dsvm-ceilometer http://logs.openstack.org/38/238038/1/gate/gate-grenade-dsvm-ceilometer/b2feeec/ : SUCCESS in 1h 05m 03s\n- gate-ceilometer-dsvm-integration http://logs.openstack.org/38/238038/1/gate/gate-ceilometer-dsvm-integration/8c9b9d4/ : SUCCESS in 42m 31s","accounts_in_message":[],"_revision_number":1},{"id":"45a3b17b542f5a7afa4b53e0684db889296a48d1","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2015-10-23 21:43:40.000000000","message":"Change has been successfully merged into the git repository.","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"898cd3d036c4358aa16f7b3e2028365dc9829213","revisions":{"898cd3d036c4358aa16f7b3e2028365dc9829213":{"kind":"REWORK","_number":1,"created":"2015-10-21 12:49:46.000000000","uploader":{"_account_id":6537,"name":"gordon chung","email":"gord@live.ca","username":"chungg"},"ref":"refs/changes/38/238038/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/ceilometer","ref":"refs/changes/38/238038/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/ceilometer refs/changes/38/238038/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/ceilometer refs/changes/38/238038/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/ceilometer refs/changes/38/238038/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/ceilometer refs/changes/38/238038/1"}}},"commit":{"parents":[{"commit":"15f44c6946753c3f11c27640cb991c8f806f726f","subject":"specify runtime environment for scripts","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/ceilometer/commit/15f44c6946753c3f11c27640cb991c8f806f726f"}]}],"author":{"name":"gordon chung","email":"gord@live.ca","date":"2015-10-21 12:44:58.000000000","tz":-240},"committer":{"name":"gordon chung","email":"gord@live.ca","date":"2015-10-21 12:44:58.000000000","tz":-240},"subject":"avoid using isolation level","message":"avoid using isolation level\n\ndepending on sql driver, REPEATABLE READ isolation level may lock\nan entire table and cause write timeouts. isolation level was set\noriginally to ensure consistent reads between 2 queries required to\nbuild events. that said, we can avoid table locks by making\nassumption that the 1st query is the correct base and any difference\ngiven by 2nd query can be discarded.\n\nChange-Id: Ic53e1addf38a4d5934b4e627c4c974c6db42517e\nCloses-Bug: #1506717\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/ceilometer/commit/898cd3d036c4358aa16f7b3e2028365dc9829213"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/ceilometer/commit/898cd3d036c4358aa16f7b3e2028365dc9829213"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"15f44c6946753c3f11c27640cb991c8f806f726f","is_merged_in_target_branch":true,"change_id":"Ibbcefb671de76146529b9a6e2debfee154a1aaa7","change_number":237647,"patch_set_number":1,"change_status":"MERGED"}],"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}