)]}'
{"id":"openstack%2Fdevstack~146789","triplet_id":"openstack%2Fdevstack~master~Ia8308dcaa3a6555a303b0991b8bf6873cc553096","project":"openstack/devstack","branch":"master","topic":"mysql-max-conn","hashtags":[],"change_id":"Ia8308dcaa3a6555a303b0991b8bf6873cc553096","subject":"Increase mysql/mariadb max-connection","status":"ABANDONED","created":"2015-01-13 07:48:54.000000000","updated":"2015-02-19 10:21:02.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"5694216f250de2eb991c3685a5c2b1654a3846ff","_number":146789,"virtual_id_number":146789,"owner":{"_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},"disliked":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"all":[{"value":1,"date":"2015-01-13 08:37:24.000000000","_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"value":-1,"date":"2015-01-17 17:46:07.000000000","_account_id":3,"name":"Jenkins","username":"jenkins"},{"date":"2015-01-13 11:12:05.000000000","_account_id":7350,"name":"Jordan Pittier","email":"jordan.pittier@gmail.com","username":"JordanP"},{"date":"2015-01-13 12:14:20.000000000","_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},{"date":"2015-01-16 00:13:01.000000000","_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":{"all":[{"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":3,"name":"Jenkins","username":"jenkins"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":7350,"name":"Jordan Pittier","email":"jordan.pittier@gmail.com","username":"JordanP"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},{"value":0,"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":"","default_value":0,"optional":true},"Workflow":{"all":[{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"_account_id":3,"name":"Jenkins","username":"jenkins"},{"_account_id":7350,"name":"Jordan Pittier","email":"jordan.pittier@gmail.com","username":"JordanP"},{"value":0,"permitted_voting_range":{"min":-1,"max":0},"_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},{"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":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":3,"name":"Jenkins","username":"jenkins"},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":7350,"name":"Jordan Pittier","email":"jordan.pittier@gmail.com","username":"JordanP"},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},{"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":3,"name":"Jenkins","username":"jenkins"},{"_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},{"_account_id":7350,"name":"Jordan Pittier","email":"jordan.pittier@gmail.com","username":"JordanP"},{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2015-01-13 08:37: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":"2015-01-13 11:12:05.000000000","updated_by":{"_account_id":7350,"name":"Jordan Pittier","email":"jordan.pittier@gmail.com","username":"JordanP"},"reviewer":{"_account_id":7350,"name":"Jordan Pittier","email":"jordan.pittier@gmail.com","username":"JordanP"},"state":"REVIEWER"},{"updated":"2015-01-16 00:13:01.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"},{"updated":"2015-01-17 17:46:07.000000000","updated_by":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"reviewer":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"state":"REVIEWER"}],"messages":[{"id":"9374ed0707debb36b6d93b93e9f56bf7ca419ba6","author":{"_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},"date":"2015-01-13 07:48:54.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"8350f7eda62abdd31745588a645c4997ab75060b","author":{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},"date":"2015-01-13 08:37:24.000000000","message":"Patch Set 1: Verified+1\n\nPassed using XenAPI driver with XenServer 6.2: Logs at http://dd6b71949550285df7dc-dda4e480e005aaa13ec303551d2d8155.r49.cf1.rackcdn.com/89/146789/1/4845/results.html\n\nUse \"xenserver: recheck\" to trigger only xenserver re-check.  XenServer CI contact: openstack@citrix.com.\n\nDebugging suggestions at https://wiki.openstack.org/wiki/Debugging_XenServer_CI_failures","accounts_in_message":[],"_revision_number":1},{"id":"186cf76476a3885d1361f515f7d781cd73c9d470","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2015-01-13 08:53:30.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- check-tempest-dsvm-full http://logs.openstack.org/89/146789/1/check/check-tempest-dsvm-full/859649a/ : SUCCESS in 38m 13s\n- check-tempest-dsvm-postgres-full http://logs.openstack.org/89/146789/1/check/check-tempest-dsvm-postgres-full/9e42abf/ : SUCCESS in 35m 52s\n- check-tempest-dsvm-neutron-full http://logs.openstack.org/89/146789/1/check/check-tempest-dsvm-neutron-full/1ca1bb1/ : SUCCESS in 57m 45s\n- check-grenade-dsvm http://logs.openstack.org/89/146789/1/check/check-grenade-dsvm/a202e7b/ : SUCCESS in 35m 27s\n- gate-tempest-dsvm-large-ops http://logs.openstack.org/89/146789/1/check/gate-tempest-dsvm-large-ops/fc31569/ : SUCCESS in 21m 01s\n- gate-tempest-dsvm-neutron-large-ops http://logs.openstack.org/89/146789/1/check/gate-tempest-dsvm-neutron-large-ops/06f3131/ : SUCCESS in 20m 10s\n- gate-devstack-bashate http://logs.openstack.org/89/146789/1/check/gate-devstack-bashate/7cc425b/ : SUCCESS in 14s\n- gate-devstack-unit-tests http://logs.openstack.org/89/146789/1/check/gate-devstack-unit-tests/fed7fe5/ : SUCCESS in 11s\n- check-devstack-dsvm-cells http://logs.openstack.org/89/146789/1/check/check-devstack-dsvm-cells/80e1b34/ : SUCCESS in 16m 43s\n- check-grenade-dsvm-partial-ncpu http://logs.openstack.org/89/146789/1/check/check-grenade-dsvm-partial-ncpu/669c3dc/ : SUCCESS in 34m 02s\n- check-neutron-dsvm-functional http://logs.openstack.org/89/146789/1/check/check-neutron-dsvm-functional/970ec60/ : SUCCESS in 19m 37s\n- check-swift-dsvm-functional http://logs.openstack.org/89/146789/1/check/check-swift-dsvm-functional/595efbb/ : SUCCESS in 25m 16s\n- check-tempest-dsvm-ironic-pxe_ssh http://logs.openstack.org/89/146789/1/check/check-tempest-dsvm-ironic-pxe_ssh/7b3f9aa/ : SUCCESS in 33m 12s\n- check-tempest-dsvm-f20 http://logs.openstack.org/89/146789/1/check/check-tempest-dsvm-f20/bcc4dc3/ : SUCCESS in 33m 41s (non-voting)\n- check-tempest-dsvm-centos7 http://logs.openstack.org/89/146789/1/check/check-tempest-dsvm-centos7/1380156/ : SUCCESS in 47m 47s (non-voting)\n- gate-devstack-publish-docs http://docs-draft.openstack.org/89/146789/1/check/gate-devstack-publish-docs/7f5e8bc//doc/build/html/ : SUCCESS in 1m 31s","accounts_in_message":[],"_revision_number":1},{"id":"07a1440ae923eb0a1b4cb0bda9ecd1f9ce7dce48","author":{"_account_id":7350,"name":"Jordan Pittier","email":"jordan.pittier@gmail.com","username":"JordanP"},"date":"2015-01-13 11:12:05.000000000","message":"Patch Set 1:\n\nHi,\nFor information :\n\nhttps://bugs.launchpad.net/devstack/+bug/1403284\nhttps://review.openstack.org/#/c/142347/","accounts_in_message":[],"_revision_number":1},{"id":"02907867fda37cf522e44e97b836a0c0ca4b1882","author":{"_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},"date":"2015-01-13 12:14:20.000000000","message":"Patch Set 1:\n\nIn 4 vcpu neutron setup I have 42 processes which has mysql connection. n-api has vcpu/2 workers , several services already defaults to the vcpu number worker, so this number expected to be higher in a gate vm which can have 8 vcpu.\n\nEach process (worker with one connection pool) expected to use sqlalchemy connection pool with 0 starting connection, 5 connection to keep (pool_size), and max_overflow\u003d10 which means a pool size can be increased to 10 temporary.\n\n42*5 \u003d 210 connection.\n42*10 \u003d 420 connection.\n\nThe pool never initiate connection decreases under to the pool_size(5).\n\nEven in 4 vcpu setup, under load we can go beyond even the 200 connection limit.\n\nNeutron still not configured to use multiple workers :(, however it should use.\n\nPS.: It is really 42, I am not kidding:\n$ lsof -P | grep 3306 | grep -v mysqld| awk \u0027{print $2}\u0027 | sort -u | wc -l\n42","accounts_in_message":[],"_revision_number":1},{"id":"002fc9d04d236fd1c03bd309d59cbcafbc2b91cf","author":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"date":"2015-01-16 00:13:01.000000000","message":"Patch Set 1:\n\n@afazekas so is the enough, or not?  does this also depend on I7ede29430923b0983b20ab27d9f3b7244deaa477 ?","accounts_in_message":[],"_revision_number":1},{"id":"a410340967a9619a7fd501cc568cf0b74d4c1b93","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2015-01-17 17:46:07.000000000","message":"Patch Set 1: Verified-1\n\nMerge Failed.\n\nThis change was unable to be automatically merged with the current state of the repository. Please rebase your change and upload a new patchset.","accounts_in_message":[],"_revision_number":1},{"id":"cd82ddfd429df6c8742657d8001cf6885b61f6fc","author":{"_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},"date":"2015-02-19 10:21:02.000000000","message":"Abandoned\n\nNow, most services defaults to 1 as `low water mark` instead of 5.","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"2aa7561547157c497c721710a4d555be69b2ef65","revisions":{"2aa7561547157c497c721710a4d555be69b2ef65":{"kind":"REWORK","_number":1,"created":"2015-01-13 07:48:54.000000000","uploader":{"_account_id":5803,"name":"Attila Fazekas","email":"afazekas@redhat.com","username":"afazekas"},"ref":"refs/changes/89/146789/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/devstack","ref":"refs/changes/89/146789/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/devstack refs/changes/89/146789/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/devstack refs/changes/89/146789/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/devstack refs/changes/89/146789/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/devstack refs/changes/89/146789/1"}}},"commit":{"parents":[{"commit":"3eaa0781e3d87bee6d343573954b682f1f23d4b9","subject":"Merge \"Fix get_packages when $DISTRO is not set\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/3eaa0781e3d87bee6d343573954b682f1f23d4b9"}]}],"author":{"name":"Attila Fazekas","email":"afazekas@redhat.com","date":"2015-01-13 07:28:01.000000000","tz":60},"committer":{"name":"Attila Fazekas","email":"afazekas@redhat.com","date":"2015-01-13 07:28:01.000000000","tz":60},"subject":"Increase mysql/mariadb max-connection","message":"Increase mysql/mariadb max-connection\n\nJobs are failing with \"OperationalError\" \"Too many connections\",\nerror messages.\n\nThe postgresql default max connection (100) is already increased to 200,\nbecause of gate issues.\n\nThis change increases the default mysql(151) to 200, by using the\nsame the MAX_DB_CONNECTION environment variable as used\nwith postgresql.\n\nChange-Id: Ia8308dcaa3a6555a303b0991b8bf6873cc553096\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/2aa7561547157c497c721710a4d555be69b2ef65"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/2aa7561547157c497c721710a4d555be69b2ef65"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}