)]}'
{"id":"openstack%2Fdevstack-gate~61820","triplet_id":"openstack%2Fdevstack-gate~master~Ib4cdfc929b93b289916295ff365a46979555a574","project":"openstack/devstack-gate","branch":"master","hashtags":[],"change_id":"Ib4cdfc929b93b289916295ff365a46979555a574","subject":"Don\u0027t save mysql logs","status":"MERGED","created":"2013-12-12 17:00:27.000000000","updated":"2013-12-14 09:25:06.000000000","submitted":"2013-12-14 09:25:06.000000000","submitter":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"d65a9bd8d2dd4a516d677fd69e7eecd3292f8d62","_number":61820,"virtual_id_number":61820,"owner":{"_account_id":1,"name":"James E. Blair","email":"jim@acmegating.com","username":"corvus"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"all":[{"value":0,"_account_id":1,"name":"James E. Blair","email":"jim@acmegating.com","username":"corvus"},{"value":0,"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},{"value":2,"date":"2013-12-14 09:25:06.000000000","_account_id":3,"name":"Jenkins","username":"jenkins"},{"value":0,"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},{"value":0,"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"}],"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":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"all":[{"value":0,"date":"2013-12-13 22:05:04.000000000","permitted_voting_range":{"min":0,"max":1},"_account_id":1,"name":"James E. Blair","email":"jim@acmegating.com","username":"corvus"},{"value":2,"date":"2013-12-13 18:51:21.000000000","_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},{"value":0,"_account_id":3,"name":"Jenkins","username":"jenkins"},{"value":1,"date":"2013-12-12 17:01:21.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},{"value":0,"date":"2013-12-13 00:25:18.000000000","permitted_voting_range":{"min":0,"max":1},"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"}],"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":1,"name":"James E. Blair","email":"jim@acmegating.com","username":"corvus"},"all":[{"value":1,"date":"2013-12-13 22:05:04.000000000","_account_id":1,"name":"James E. Blair","email":"jim@acmegating.com","username":"corvus"},{"value":0,"date":"2013-12-13 18:51:21.000000000","_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},{"value":0,"_account_id":3,"name":"Jenkins","username":"jenkins"},{"value":0,"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},{"value":0,"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":1,"name":"James E. Blair","email":"jim@acmegating.com","username":"corvus"},{"_account_id":3,"name":"Jenkins","username":"jenkins"},{"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2013-12-12 17:01:21.000000000","updated_by":{"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},"reviewer":{"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},"state":"REVIEWER"},{"updated":"2013-12-13 00:25:18.000000000","updated_by":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"reviewer":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"state":"REVIEWER"},{"updated":"2013-12-13 18:51:21.000000000","updated_by":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"reviewer":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"state":"REVIEWER"},{"updated":"2013-12-14 09:25:06.000000000","updated_by":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"reviewer":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"state":"REVIEWER"}],"messages":[{"id":"8dd9d16b4be670b8e08d166e86252efb67cfe513","author":{"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},"date":"2013-12-12 17:01:21.000000000","message":"Patch Set 1: Looks good to me, but someone else must approve\n\n","accounts_in_message":[],"_revision_number":1},{"id":"941308eebad910fbab2eb4a09d8d952255057199","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2013-12-12 18:19:31.000000000","message":"Patch Set 1: Works for me\n\nBuild succeeded.\n\n- check-dg-tempest-dsvm-full http://logs.openstack.org/20/61820/1/check/check-dg-tempest-dsvm-full/48a3d2e : SUCCESS in 43m 31s\n- check-dg-tempest-dsvm-full-reexec http://logs.openstack.org/20/61820/1/check/check-dg-tempest-dsvm-full-reexec/cb4bebc : SUCCESS in 41m 10s\n- check-tempest-dsvm-full http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-full/5d60db4 : SUCCESS in 35m 51s\n- check-tempest-dsvm-postgres-full http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-postgres-full/0a94795 : SUCCESS in 33m 58s\n- check-tempest-dsvm-neutron http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-neutron/b0649cc : SUCCESS in 31m 52s\n- gate-tempest-dsvm-large-ops http://logs.openstack.org/20/61820/1/check/gate-tempest-dsvm-large-ops/bbef63c : SUCCESS in 22m 14s\n- gate-tempest-dsvm-neutron-large-ops http://logs.openstack.org/20/61820/1/check/gate-tempest-dsvm-neutron-large-ops/bcd59dc : SUCCESS in 23m 15s\n- check-grenade-dsvm http://logs.openstack.org/20/61820/1/check/check-grenade-dsvm/13acaa2 : SUCCESS in 32m 08s\n- check-swift-dsvm-functional http://logs.openstack.org/20/61820/1/check/check-swift-dsvm-functional/43e3099 : SUCCESS in 11m 43s\n- check-tempest-dsvm-full-grizzly http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-full-grizzly/cf74840 : SUCCESS in 36m 02s (non-voting)\n- check-tempest-dsvm-neutron-grizzly http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-neutron-grizzly/19e69d4 : FAILURE in 6m 22s (non-voting)\n- check-tempest-dsvm-postgres-full-grizzly http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-postgres-full-grizzly/50b3eb9 : SUCCESS in 39m 53s (non-voting)\n- check-devstack-dsvm-cells-grizzly http://logs.openstack.org/20/61820/1/check/check-devstack-dsvm-cells-grizzly/c4280a6 : SUCCESS in 10m 22s (non-voting)\n- check-tempest-dsvm-cells-grizzly http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-cells-grizzly/eadbc2f : SUCCESS in 21m 29s (non-voting)\n- check-tempest-dsvm-cells-full-grizzly http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-cells-full-grizzly/6b113b8 : SUCCESS in 32m 19s (non-voting)\n- check-tempest-dsvm-full-havana http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-full-havana/769dd6b : SUCCESS in 44m 53s (non-voting)\n- check-tempest-dsvm-neutron-havana http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-neutron-havana/c15712f : SUCCESS in 39m 53s (non-voting)\n- check-tempest-dsvm-postgres-full-havana http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-postgres-full-havana/341943a : SUCCESS in 39m 17s (non-voting)\n- check-devstack-dsvm-cells-havana http://logs.openstack.org/20/61820/1/check/check-devstack-dsvm-cells-havana/95e5777 : SUCCESS in 11m 04s (non-voting)\n- check-tempest-dsvm-cells-havana http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-cells-havana/34a8365 : FAILURE in 22m 04s (non-voting)\n- check-tempest-dsvm-cells-full-havana http://logs.openstack.org/20/61820/1/check/check-tempest-dsvm-cells-full-havana/1ba60de : FAILURE in 8m 12s (non-voting)\n","accounts_in_message":[],"_revision_number":1},{"id":"9182a52a3baa1e2a43619ef7ac8f2b29e015f33e","author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"date":"2013-12-13 00:25:18.000000000","message":"Patch Set 1:\n\nHmmm, I\u0027m torn here. On the one hand, 600MiB of logs is way to much. OTOH finding out about genuinely slow queries would be very useful. Can we change the threshold set by devstack instead?","accounts_in_message":[],"_revision_number":1},{"id":"6b125bf28ee616d244f65f46de8643fcf123a16b","author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"date":"2013-12-13 18:51:21.000000000","message":"Patch Set 1: Looks good to me (core reviewer)\n\nI think we can compromise here by manually grabbing slow logs for folks that need them in specific instances. I would be very surprised if anyone actually looks at these on a consistent basis.","accounts_in_message":[],"_revision_number":1},{"id":"8f281f6188b660848a2535cad3495ebab0f90a72","author":{"_account_id":1,"name":"James E. Blair","email":"jim@acmegating.com","username":"corvus"},"date":"2013-12-13 22:05:04.000000000","message":"Patch Set 1: Approved\n\nlifeless, I personally think that would be a fine thing to do.  When I asked about it, apparently some devs like all sql statements logged locally.","accounts_in_message":[],"_revision_number":1},{"id":"85eb22304fa020e7d35d1010f1cd74a5550c23fb","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2013-12-13 22:05:17.000000000","message":"Patch Set 1: No score\n\nStarting gate jobs.\nhttp://status.openstack.org/zuul/","accounts_in_message":[],"_revision_number":1},{"id":"0c857ff3478f9a4b66fcdfa9a4d9e854378372d1","author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"date":"2013-12-14 06:12:51.000000000","message":"Patch Set 1:\n\nHeh, ah well. We\u0027ll sort something solid out for TripleO-gate:)","accounts_in_message":[],"_revision_number":1},{"id":"87501e1c591f6d80a219dad1b74403dd912f7385","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2013-12-14 09:25:06.000000000","message":"Patch Set 1: Verified\n\nBuild succeeded.\n\n- gate-tempest-dsvm-full http://logs.openstack.org/20/61820/1/gate/gate-tempest-dsvm-full/a0acbd2 : SUCCESS in 41m 53s\n- gate-tempest-dsvm-postgres-full http://logs.openstack.org/20/61820/1/gate/gate-tempest-dsvm-postgres-full/8491f3b : SUCCESS in 37m 04s\n- gate-tempest-dsvm-neutron http://logs.openstack.org/20/61820/1/gate/gate-tempest-dsvm-neutron/3e10765 : SUCCESS in 31m 46s\n- gate-tempest-dsvm-large-ops http://logs.openstack.org/20/61820/1/gate/gate-tempest-dsvm-large-ops/4700f0e : SUCCESS in 20m 02s\n- gate-tempest-dsvm-neutron-large-ops http://logs.openstack.org/20/61820/1/gate/gate-tempest-dsvm-neutron-large-ops/dad2bc3 : SUCCESS in 16m 55s\n- gate-grenade-dsvm http://logs.openstack.org/20/61820/1/gate/gate-grenade-dsvm/7177bb4 : SUCCESS in 44m 36s\n- gate-swift-dsvm-functional http://logs.openstack.org/20/61820/1/gate/gate-swift-dsvm-functional/d9ff9c9 : SUCCESS in 14m 22s\n","accounts_in_message":[],"_revision_number":1},{"id":"d65a9bd8d2dd4a516d677fd69e7eecd3292f8d62","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2013-12-14 09:25:06.000000000","message":"Change has been successfully merged into the git repository.","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"c72c0bc633a88b4bc95671cac535796c50af3f88","revisions":{"c72c0bc633a88b4bc95671cac535796c50af3f88":{"kind":"REWORK","_number":1,"created":"2013-12-12 17:00:27.000000000","uploader":{"_account_id":1,"name":"James E. Blair","email":"jim@acmegating.com","username":"corvus"},"ref":"refs/changes/20/61820/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/devstack-gate","ref":"refs/changes/20/61820/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/devstack-gate refs/changes/20/61820/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/devstack-gate refs/changes/20/61820/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/devstack-gate refs/changes/20/61820/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/devstack-gate refs/changes/20/61820/1"}}},"commit":{"parents":[{"commit":"6d069cbd697cd38018b062302d1f57c0f5e44044","subject":"Merge \"update documentation with specific of rax setup\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack-gate/commit/6d069cbd697cd38018b062302d1f57c0f5e44044"}]}],"author":{"name":"James E. Blair","email":"jeblair@openstack.org","date":"2013-12-12 16:59:00.000000000","tz":-480},"committer":{"name":"James E. Blair","email":"jeblair@openstack.org","date":"2013-12-12 16:59:00.000000000","tz":-480},"subject":"Don\u0027t save mysql logs","message":"Don\u0027t save mysql logs\n\nCurrently a full tempest run produces 600MiB of _compressed_ log data,\nof which 324MiB are mysql logs.  This is because devstack configures\nthe mysql slow query log to log every query.  This seems like an\nexcessive level of debugging for the gate, so lets not save those\nlogs.\n\nChange-Id: Ib4cdfc929b93b289916295ff365a46979555a574\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack-gate/commit/c72c0bc633a88b4bc95671cac535796c50af3f88"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack-gate/commit/c72c0bc633a88b4bc95671cac535796c50af3f88"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}