Thursday, 2014-05-01

*** pcrews_ has quit IRC00:00
fungi#status ok the gate is still fairly backed up, though nodepool is back on track and chipping away at remaining changes. some py3k/pypy node starvation is slowing recovery00:02
openstackstatusfungi: sending ok00:02
*** melwitt has quit IRC00:02
*** ChanServ changes topic to "Gerrit upgraded to 2.8. See: https://wiki.openstack.org/wiki/GerritUpgrade"00:04
-openstackstatus- NOTICE: the gate is still fairly backed up, though nodepool is back on track and chipping away at remaining changes. some py3k/pypy node starvation is slowing recovery00:04
*** matsuhashi has joined #openstack-infra00:04
*** aconrad has quit IRC00:04
openstackstatusfungi: finished sending ok00:06
*** david-lyle has joined #openstack-infra00:09
*** david-lyle has quit IRC00:13
*** yjiang5 is now known as yjiang5_away00:19
jogofungi: I like how fairly backed up is just 7 hours now00:23
jogoand 15 patches :_00:23
jogoalthoguh check is pretty big00:23
*** bhuvan has quit IRC00:23
jeblairthe zuul job queue looks like half-dome00:23
* jeblair goes to play space quest00:24
fungiwoah i haven't thought about space quest in years. once of the funniest sierra game series, for sure. great writing00:26
*** aconrad has joined #openstack-infra00:26
*** packet has quit IRC00:30
tchaypoStevenK: plus it's morning, pre-coffee. this is when i stare at gerrit and go "huh?" rather than trying to write anything useful00:30
StevenKLies. The coffee is right next to you.00:31
tchaypoyes, it's next to me.00:32
tchayposee, if it was *in* me I might have noticed that this isn't #tripleo00:33
fungitchaypo: well, it had a # and a few of the same letters, so you were close anyway00:34
*** lcostantino has joined #openstack-infra00:34
tchaypomore than just the same letters00:34
tchaypoit had some of the same characters!00:34
SlickNikquestion: Do all infra jobs run on nodepool instances that are jenkins slaves? Or only the devstack-vm-gate ones?00:36
jeblairSlickNik: all00:36
*** arnaud__ has joined #openstack-infra00:38
SlickNikjeblair: thanks! The reason I ask is this: I'm trying to write a new infra job that builds the trove guest-image from dib-elements; it needs to be able to check out the elements repo, and a couple of tripleo repos and run diskimage-builder.00:39
SlickNikI'm thinking that Gerrit-git-prep should be sufficient as a builder, and that I shouldn't have to use the hooks in devstack-gate to do this.00:41
SlickNikOr is there a better way to do this, that you'd suggest? Thoughts?00:42
jeblairSlickNik: if the projects involved depend on each other and will end up gating, you may want to use devstack-gate since it's the only thing that knows how to set up multiple projects in zuul's queue00:42
jeblairSlickNik: (hashar is working on a script that will generalize that, so we can do this sort of thing outside of d-g in the future)00:42
jeblairSlickNik: other than that, the bare nodes and devstack nodes are converging, hopefully we'll just have one node type eventually.  main difference at this point is whether they have all the extra devstack stuff cached (images, packages, etc)00:43
jeblairSlickNik: they both have sudo ability and local caches of all the git repos00:44
*** yamahata has quit IRC00:44
*** rhsu has quit IRC00:45
openstackgerritJames E. Blair proposed a change to openstack-infra/nodepool: Fix race in tests  https://review.openstack.org/9149100:46
openstackgerritJames E. Blair proposed a change to openstack-infra/nodepool: Improve logging/stats around launch errors  https://review.openstack.org/9149200:46
*** aconrad has quit IRC00:47
jeblairfungi, mordred, phschwartz: ^ that should tell us _a lot_ more about what's going on in nodepool00:47
SlickNikjeblair: Thanks! That's really helpful.00:48
SlickNikjeblair: Right now we're planning to gate on just the one repository that contains the trove-guest elements.00:48
SlickNikjeblair: But let me give the gating requirements pertaining to this a bit more thought.00:49
*** jhesketh has quit IRC00:49
*** crc32 has quit IRC00:51
jeblairSlickNik: okay, if it's only one repo, you might be able to get away with ggp for now, and maybe we will have the multi-repo script ready by the time you need it00:52
jeblair(definitely the much simpler way to go)00:52
jogohrmm  'gate-python-novaclient-pypy: queue' at top of gate00:52
jogofungi: I assume you are aware  already ^00:56
SlickNikjeblair: Okay, I think that's the route I'll go with for now (and plan on switching to the multi-repo script when we have that). Thanks for your help!00:57
*** weshay has joined #openstack-infra00:58
*** mriedem has joined #openstack-infra00:59
*** manishg has joined #openstack-infra00:59
*** lcostantino has quit IRC01:02
krotschecknibalizer: https://github.com/krotscheck/puppet-storyboard01:04
krotscheckThat _should_ work to set up your own standalone storyboard instance.01:05
krotscheckWhere “should” means “Some of the dependencies might be a bit messed up”01:05
nibalizeroh wild01:07
nibalizeris that the same as the one in the openstack-infra/config project01:07
*** jhesketh has joined #openstack-infra01:08
mgagnegreatest meta puppet module I ever saw so far... https://github.com/krotscheck/puppet-storyboard/tree/master/modules/puppet_module01:08
krotscheckmgagne: No kidding01:09
phschwartzjeblair: That should give us more info when there are failures which will let us debug it for you better.01:09
krotschecknibalizer: No, it’s based on that though.01:09
*** amcrn has quit IRC01:09
krotschecknibalizer: Give me a couple of minutes, I’ll get the README working.01:09
mgagneshould have been puppet module install yodawg/puppet_module01:09
krotscheckAlso, that puppet_module isnt’ required anymore01:09
*** amcrn has joined #openstack-infra01:12
krotschecknibalizer: Done. Readme now reflects the install process I used.01:13
krotschecknibalizer: One thing- the module doesn’t automatically set up any admin users. You’ll have to manually go into the database and set is_superuser in the users table.01:14
nibalizerokay01:14
nibalizerthanks01:14
nibalizerim still at $WORKJOB01:14
nibalizerso cant play with it01:14
nibalizerubt ill try to get going soon01:15
nibalizeralso there is a changset pending against infra/config to make storyboard its own puppet module on openstack01:15
nibalizerso hopefully we can separate those01:15
*** nati_ueno has joined #openstack-infra01:16
krotschecknibalizer: Oh, right. I should go review that.01:16
*** rhsu has joined #openstack-infra01:16
krotschecknibalizer: Thanks  :)01:16
*** mwagner_lap has joined #openstack-infra01:17
*** zns_ has joined #openstack-infra01:17
*** weshay has quit IRC01:18
jesusaurusnibalizer: do you have a link handy for that change? i wanna see what all is needed to do that01:18
nibalizeruh no01:20
nibalizerbut if you search on me should come up01:20
nibalizeri think its -1 right now :(01:21
*** amcrn has quit IRC01:21
*** zns has quit IRC01:22
*** zns_ has quit IRC01:22
*** saschpe has quit IRC01:28
*** saschpe has joined #openstack-infra01:29
*** marcoemorais has quit IRC01:36
openstackgerritA change was merged to openstack-infra/config: add subunit log test sanity  https://review.openstack.org/8579701:43
*** yamahata has joined #openstack-infra01:44
*** nati_ueno has quit IRC01:47
*** nosnos has joined #openstack-infra01:49
*** amcrn has joined #openstack-infra01:52
*** homeless has quit IRC01:55
*** rhsu1 has joined #openstack-infra01:56
*** rhsu has quit IRC01:56
openstackgerritA change was merged to openstack-infra/config: Add django_openstack_auth to the integrated gate  https://review.openstack.org/8652801:58
*** zhiyan_ is now known as zhiyan01:59
openstackgerritA change was merged to openstack-infra/config: Add a check for nova-docker  https://review.openstack.org/8691002:01
*** Alexandra_ has joined #openstack-infra02:01
*** marun has quit IRC02:01
*** mengxd has joined #openstack-infra02:02
openstackgerritA change was merged to openstack-dev/pbr: Fixed a typo in the documentation.  https://review.openstack.org/9051602:02
*** yidclare has quit IRC02:03
openstackgerritA change was merged to openstack-infra/config: Fixes to nodepool installation on jenkins-dev.o.o  https://review.openstack.org/8802602:04
openstackgerritA change was merged to openstack-infra/config: Integrate Launchpad for compass-* projects  https://review.openstack.org/8741802:05
openstackgerritA change was merged to openstack-infra/config: Fix redis.conf pid and data dir settings  https://review.openstack.org/8832302:06
openstackgerritA change was merged to openstack-infra/config: Extract Murano python jobs in a template  https://review.openstack.org/8797402:07
*** Ryan_Lane1 has quit IRC02:07
portanteanybody around that can help with a openstack-infra/config change failure?02:13
portantehttp://logs.openstack.org/24/91424/1/check/gate-config-layout/0192c4d/console.html02:13
portanteit is saying that gate-swift-unittests-func is not defined, but not sure why02:14
openstackgerritA change was merged to openstack-infra/elastic-recheck: Add fingerprint for bug 1314786  https://review.openstack.org/9145302:19
uvirtbotLaunchpad bug 1314786 in openstack-ci "/opt/stack/new/devstack/files/Fedora-x86_64-20-20131211.1-sda.qcow2 is not  cached" [Undecided,New] https://launchpad.net/bugs/131478602:19
fifieldtsdague, hi02:23
openstackgerritA change was merged to openstack-infra/config: Fix gate-heat-templates-dsvm shell script  https://review.openstack.org/8987502:24
*** wenlock has joined #openstack-infra02:25
openstackgerritA change was merged to openstack-infra/config: use buck from master branch  https://review.openstack.org/9021902:26
openstackgerritA change was merged to openstack-infra/config: Fixed several typos in the docs.  https://review.openstack.org/9054402:27
openstackgerritA change was merged to openstack-infra/config: Configuring bundler to use multiple cpus/cores  https://review.openstack.org/9056302:27
openstackgerritA change was merged to openstack-infra/config: index n-sched in grenade runs  https://review.openstack.org/9005402:27
*** zehicle_at_dell has joined #openstack-infra02:32
*** mriedem has quit IRC02:32
*** julim has quit IRC02:33
*** sweston has quit IRC02:36
*** arnaud__ has quit IRC02:47
mattoliverauportante: in your patch, under zuul's layout you place 'gate-swift-unittests-func' under the project 'openstack/swift' which makes sense, but in jenkins job builder its not under swift but under 'sqlalchemy-migrate' is this what you wanted?02:51
openstackgerritA change was merged to openstack-infra/nodepool: Create launch-timeout setting for providers  https://review.openstack.org/8515002:59
portanteugh, mattoliverau thanks03:02
*** Alexandra_ has quit IRC03:06
*** mengxd has quit IRC03:08
*** talluri has quit IRC03:09
openstackgerritPeter Portante proposed a change to openstack-infra/config: Add swift "in-process" functional test runs  https://review.openstack.org/9142403:09
portanteembarrassing ...03:09
*** manishg has quit IRC03:13
*** manishg has joined #openstack-infra03:15
*** manishg has quit IRC03:16
mattoliverauportante: well you had alot of +1's so your not the only one who didn't notice. I only noticed because I was reading the yaml files trying to peice together how they worked, as I haven't set one up before. So yay for fresh eyes on a problem :)03:17
portanteyes, thank you!03:18
*** zhiyan is now known as zhiyan_03:18
openstackgerritA change was merged to openstack-infra/jenkins-job-builder: Tiny spelling fix: YMAL -> YAML  https://review.openstack.org/9129103:19
*** harlowja is now known as harlowja_away03:20
*** harlowja_away is now known as harlowja03:21
*** Ryan_Lane has joined #openstack-infra03:21
*** crc32 has joined #openstack-infra03:22
*** alexpilotti has quit IRC03:25
*** matsuhashi has quit IRC03:28
openstackgerritA change was merged to openstack-infra/config: Added gate-magnetodb-devstack-dsvm as gate  https://review.openstack.org/9101403:35
*** aconrad has joined #openstack-infra03:36
*** Ryan_Lane1 has joined #openstack-infra03:36
openstackgerritJoshua Harlow proposed a change to stackforge/gertty: Handle exiting more gracefully  https://review.openstack.org/9150403:37
harlowjajeblair ^03:37
*** nosnos has quit IRC03:46
harlowjajeblair some other examples u might find useful, https://excess.org/svn/urwid/contrib/trunk/rbreu_menus.py could be useful for a menu03:52
*** crc32 has quit IRC04:05
*** rlandy|afk has quit IRC04:07
*** AaronGreen is now known as AaronGr04:07
*** miqui has quit IRC04:09
lifelessit would  be great if we can get https://review.openstack.org/#/c/89691/ in tomorrow please; would really like time to get stuff into it before the summit04:16
*** yfried has quit IRC04:16
*** Ryan_Lane1 has quit IRC04:19
*** UtahDave has joined #openstack-infra04:21
*** rhsu has joined #openstack-infra04:22
*** rhsu1 has quit IRC04:22
*** matsuhashi has joined #openstack-infra04:35
*** nosnos has joined #openstack-infra04:36
*** marcoemorais has joined #openstack-infra04:42
*** marcoemorais1 has joined #openstack-infra04:45
*** marcoemorais has quit IRC04:46
*** matsuhashi has quit IRC04:48
*** matsuhashi has joined #openstack-infra04:53
*** morganfainberg is now known as morganfainberg_Z05:05
*** Ryan_Lane has quit IRC05:23
*** Ryan_Lane has joined #openstack-infra05:24
*** UtahDave has quit IRC05:30
*** ihrachyshka has joined #openstack-infra05:31
*** ihrachyshka has quit IRC05:33
*** ihrachyshka has joined #openstack-infra05:33
*** yfried has joined #openstack-infra05:35
openstackgerritDerek Higgins proposed a change to openstack-infra/config: Remove setting of RE_EXEC from nova-docker job  https://review.openstack.org/9151505:35
*** harlowja is now known as harlowja_away05:37
*** ihrachyshka has quit IRC05:37
*** derekh has joined #openstack-infra06:02
*** luisg_ has joined #openstack-infra06:02
*** luisg__ has quit IRC06:02
derekhis zuul having problems, we have check-tripleo jobs running in jenkins but nothing listed in the queue06:06
*** dkehn has quit IRC06:10
*** dkehn_ has quit IRC06:10
*** AaronGr has quit IRC06:11
*** rhsu1 has joined #openstack-infra06:22
*** rhsu has quit IRC06:22
*** afazekas has joined #openstack-infra06:26
*** aconrad has quit IRC06:29
*** AaronGr has joined #openstack-infra06:41
*** chandan_kumar has joined #openstack-infra06:44
openstackgerritA change was merged to openstack-infra/devstack-gate: Allow setting services up under apache mod_wsgi  https://review.openstack.org/9081206:45
*** jooools has joined #openstack-infra06:56
*** shardy_afk is now known as shardy07:06
*** chandan_kumar has quit IRC07:07
*** matsuhashi has quit IRC07:09
*** wenlock has quit IRC07:09
*** matsuhas_ has joined #openstack-infra07:12
*** derekh has quit IRC07:13
*** praneshp has quit IRC07:18
*** oomichi has joined #openstack-infra07:19
*** jamielennox is now known as jamielennox|away07:23
*** rhsu1 has quit IRC07:26
*** Ryan_Lane has quit IRC07:31
*** _nadya_ has joined #openstack-infra07:33
*** Ryan_Lane has joined #openstack-infra07:40
*** _nadya_ has quit IRC07:46
*** Ryan_Lane has quit IRC07:48
*** Longgeek has joined #openstack-infra07:48
*** jpich has joined #openstack-infra07:49
*** _nadya_ has joined #openstack-infra07:55
*** mkerrin has joined #openstack-infra08:03
*** andreykurilin_ has joined #openstack-infra08:05
mattoliverauTime to call it a day for me, have a great day/night all.08:10
*** amcrn has quit IRC08:12
*** _nadya_ has quit IRC08:17
*** darraghb has joined #openstack-infra08:18
*** e0ne has joined #openstack-infra08:21
*** andreykurilin_ has quit IRC08:23
*** Longgeek has quit IRC08:24
*** e0ne has quit IRC08:25
*** _nadya_ has joined #openstack-infra08:25
*** andreykurilin_ has joined #openstack-infra08:26
*** andreaf has joined #openstack-infra08:26
*** jp_at_hp has joined #openstack-infra08:30
*** matsuhas_ has quit IRC08:33
*** dkehn has joined #openstack-infra08:33
*** markwash has quit IRC08:34
*** dkehn_ has joined #openstack-infra08:37
*** flaper87|afk is now known as flaper8708:37
*** jcoufal has joined #openstack-infra08:40
*** matsuhashi has joined #openstack-infra08:41
*** andreykurilin_ has quit IRC08:42
*** _nadya_ has quit IRC08:43
*** andreykurilin_ has joined #openstack-infra08:43
*** e0ne has joined #openstack-infra08:45
*** flaper87 is now known as flaper87|afk08:57
*** markmc has joined #openstack-infra08:58
*** derekh has joined #openstack-infra09:07
*** marcoemorais1 has quit IRC09:11
*** e0ne has quit IRC09:12
*** jcoufal has quit IRC09:23
*** jcoufal has joined #openstack-infra09:23
*** oomichi has quit IRC09:28
*** sdake_ has quit IRC09:31
*** matsuhashi has quit IRC09:32
*** matsuhashi has joined #openstack-infra09:33
*** sdake_ has joined #openstack-infra09:53
*** nosnos has quit IRC09:54
openstackgerritGraham Hayes proposed a change to openstack-infra/config: Add stackforge/designate-specs  https://review.openstack.org/8754010:06
sdaguefifieldt: is this normal awake hours for you now?10:06
*** Longgeek has joined #openstack-infra10:14
*** chandan_kumar has joined #openstack-infra10:15
*** ociuhandu has quit IRC10:16
openstackgerritA change was merged to stackforge/python-jenkins: Wrap tests and linting with tox  https://review.openstack.org/8952110:20
*** rcarrill` has quit IRC10:23
*** rcarrillocruz has joined #openstack-infra10:23
*** andreykurilin_ has quit IRC10:31
*** jp_at_hp has quit IRC10:32
*** andreykurilin_ has joined #openstack-infra10:32
openstackgerritDerek Higgins proposed a change to openstack-infra/config: Create tripleo-specs git repo  https://review.openstack.org/8969110:52
*** chandan_kumar has quit IRC10:52
*** e0ne has joined #openstack-infra10:54
*** andreykurilin_ has quit IRC10:54
*** ociuhandu has joined #openstack-infra10:56
*** sdake_ has quit IRC10:58
*** rcarrill` has joined #openstack-infra11:00
*** rcarrillocruz has quit IRC11:02
*** rcarrillocruz has joined #openstack-infra11:04
*** alexpilotti has joined #openstack-infra11:04
*** ociuhandu has quit IRC11:04
*** rcarrill` has quit IRC11:06
derekhsdague: about https://review.openstack.org/#/c/89691/  am I able to have a docs job for a blank repo , or should I populate it with stuff first and import a prepopulated repo ?11:13
*** ociuhandu has joined #openstack-infra11:13
sdaguederekh: that's a good question11:15
sdagueI thought the cookiecutter had enough to get rolling here11:16
sdagueyou definitely shouldn't start with a blank repo, you should start with the cookiecutter11:16
derekhsdague: ok, I think I get it now, will take a look at cookie cutter11:19
*** ociuhandu has quit IRC11:24
openstackgerritSean Dague proposed a change to openstack-infra/config: fix overflow on firefox  https://review.openstack.org/9154811:28
openstackgerritA change was merged to openstack-infra/jenkins-job-builder: Add more tests  https://review.openstack.org/9052411:31
openstackgerritA change was merged to openstack-infra/jenkins-job-builder: Add additional yaml/xml tests, literalinclude them  https://review.openstack.org/9113111:31
*** jcoufal has quit IRC11:34
*** miarmak_ has joined #openstack-infra11:35
*** miarmak has quit IRC11:35
*** bogdando has quit IRC11:36
*** bogdando has joined #openstack-infra11:39
*** _nadya_ has joined #openstack-infra11:43
*** maxbit has joined #openstack-infra11:44
*** doug-fish has left #openstack-infra11:44
*** yamahata has quit IRC11:45
*** _nadya_ has quit IRC11:47
*** dkehn__ has joined #openstack-infra11:48
*** jp_at_hp has joined #openstack-infra11:48
*** rlandy has joined #openstack-infra11:48
*** dkehn__ has quit IRC11:49
*** dkehn_ has quit IRC11:49
*** dkehn__ has joined #openstack-infra11:49
*** dkehn has quit IRC11:50
*** dkehn has joined #openstack-infra11:52
*** hashar has joined #openstack-infra11:52
*** bogdando has quit IRC11:59
*** miarmak_ has quit IRC11:59
*** miarmak has joined #openstack-infra11:59
*** bogdando has joined #openstack-infra11:59
*** bookwar is now known as bookwar_away12:00
*** talluri has joined #openstack-infra12:04
anteayasdague: morning12:08
sdaguemorning12:08
anteayasdague: what is the harm in starting with a blank repo?12:08
anteayaI thought is was okay to do that12:08
*** mbacchi has joined #openstack-infra12:08
sdagueI think these projects should be starting with the cookiecutter as an import point12:09
anteayawhich projects?12:09
anteayaevery new project?12:09
*** aysyd has joined #openstack-infra12:11
*** pdmars has joined #openstack-infra12:11
openstackgerritThomas Leaman proposed a change to openstack/requirements: Move to newer version of python-swiftclient  https://review.openstack.org/7617012:12
sdaguethe new specs projects12:14
*** rfolco has joined #openstack-infra12:14
anteayaah okay thanks12:17
*** weshay has joined #openstack-infra12:17
*** thomasem has joined #openstack-infra12:18
*** maxbit has quit IRC12:22
*** weshay has quit IRC12:27
*** alexpilotti has quit IRC12:29
openstackgerritA change was merged to openstack/requirements: Update sphinxcontrib-pecanwsme to 0.8  https://review.openstack.org/9137012:34
*** thomasem has quit IRC12:36
*** thomasem has joined #openstack-infra12:36
*** thomasem has quit IRC12:37
*** adalbas has joined #openstack-infra12:41
*** alexpilotti has joined #openstack-infra12:41
*** bknudson has quit IRC12:42
*** yamahata has joined #openstack-infra12:43
*** talluri has quit IRC12:46
*** alexpilotti has quit IRC12:47
*** thomasem has joined #openstack-infra12:48
*** hashar has quit IRC12:56
*** miqui has joined #openstack-infra12:57
*** changbl has quit IRC12:59
*** thomasem has quit IRC13:03
*** weshay has joined #openstack-infra13:04
*** thomasem has joined #openstack-infra13:05
openstackgerritDerek Higgins proposed a change to openstack-infra/config: Create tripleo-specs git repo  https://review.openstack.org/8969113:09
*** mriedem has joined #openstack-infra13:12
*** aconrad has joined #openstack-infra13:14
*** signed8bit has joined #openstack-infra13:14
*** julim has joined #openstack-infra13:16
*** doug-fish has joined #openstack-infra13:17
*** eharney has quit IRC13:17
*** smarcet has joined #openstack-infra13:18
*** rcarrill` has joined #openstack-infra13:20
anteayamrmartin: when you are around, what do you see as "content source for static pages of community portal" which are the motivation for https://review.openstack.org/#/c/89734/13:21
*** rcarrillocruz has quit IRC13:22
derekhCould zuul be loosing track of jobs ? according to the zuul status page there are no f20 jobs running in the check-tripleo queue13:25
derekhbut13:25
anteayaI think if jobs are lost track of that is nodepool13:25
derekhthere currently appears to be 12 running on jenkins goodsquishy.com/downloads/tripleo-jobs.html13:25
anteayaif I have the relationships correct in my mind13:26
*** matty_dubs|gone is now known as matty_dubs13:26
anteayawhat am I seeing at the goodsquishy.com url?13:26
anteayalots of data, how is it gathered?13:27
derekhandreaf: pooling the jenkins API, green/red are success/failed13:27
derekhanteaya: and grey are currently running13:27
anteayaokay13:28
derekhJobs have been kicked off multiple times all day, instead of reporting back to gerrit and leaving the queue13:28
anteayaso you are saying that goodsquishy and status.openstack.org/zuul are showing you different states for the same jobs?13:28
anteayaderekh: do you have a url for a patch that has had testing on it without leaving the queue?13:29
derekhanteaya: yup, take https://review.openstack.org/#/c/91161/3 for example13:30
anteayathanks13:30
* anteaya clicks13:30
*** zns has joined #openstack-infra13:30
derekhzuul thinks it is waiting on the f20 job to start13:30
derekhbut infact its run 4 times13:31
pleia2morganfainberg_Z: thanks for looking into reviewday wip, I had completely forgotten that the upgrade would impact it13:31
derekhand one is currently running https://jenkins07.openstack.org/job/check-tripleo-overcloud-f20/261/13:31
derekhbut zull status page doesn't know about it13:31
derekhanteaya: ^13:31
*** manishg has joined #openstack-infra13:31
*** dprince has joined #openstack-infra13:33
anteayaderekh: interesting13:33
derekhanteaya: hmm, the jenkins status page doesn't contain "Triggered by change: 91161,3"13:33
anteayathe jenkins status page? https://jenkins07.openstack.org/job/check-tripleo-overcloud-f20/261/13:34
anteayahmmmm13:35
anteayaBuilding remotely on tripleo-f20-tripleo-test-cloud-rh1-3928696 in workspace /home/jenkins/workspace/check-tripleo-overcloud-f2013:35
derekhanteaya: yup that one13:35
anteaya2014-05-01 12:59:00.587 | Triggered by: https://review.openstack.org/91161 patchset 313:35
*** zns has quit IRC13:36
*** manishg has quit IRC13:36
*** zns has joined #openstack-infra13:36
derekhanteaya: yup, thats in the console log but not in the status page13:36
*** manishg has joined #openstack-infra13:36
anteayaso that is in the console log but not on this page: https://jenkins07.openstack.org/job/check-tripleo-overcloud-f20/261/13:36
derekhanteaya: infact looking at another job that ran 6 times , its the same situation (triggered by line missing on status page) , for all the jobs that ran except the most recent one13:37
anteayaderekh: I'm suspecting nodepool is playing a role in the confusion13:37
anteayaderekh: have you a link to that patch?13:37
*** dkehn_ has joined #openstack-infra13:38
*** maxbit has joined #openstack-infra13:39
derekhanteaya: yup, this patch https://review.openstack.org/#/c/91161/  resulted in the same job getting run 6 times https://jenkins07.openstack.org/job/check-tripleo-undercloud-precise/664/ https://jenkins03.openstack.org/job/check-tripleo-undercloud-precise/532/ https://jenkins05.openstack.org/job/check-tripleo-undercloud-precise/658/ https://jenkins04.openstack.org/job/check-tripleo-undercloud-precise/578/ https://jenkins06.openstack.org/job/check-tri13:39
derekhpleo-undercloud-precise/574/13:39
*** dkehn has quit IRC13:39
derekhand only the most recent https://jenkins07.openstack.org/job/check-tripleo-undercloud-precise/672/ contains the gerrit patchnumber in the status page13:40
*** markmc_ has joined #openstack-infra13:40
*** dkehn__ has quit IRC13:40
*** dkehn has joined #openstack-infra13:41
openstackgerritA change was merged to openstack/requirements: Bump python-keystoneclient to >= 0.8.0  https://review.openstack.org/9074513:42
*** markmc_ has quit IRC13:42
anteayaderekh: so that is the check-tripelo-undercloud-precise job13:42
anteayaso whatever is going on is not isolated to f2013:43
fungianteaya: i only skimmed, but i'm missing the gist of the hand-wavey argument about nodepool having something to do with running jobs (nodepool neither runs jobs nor knows anything about them, it just builds instances, assigns them to jenkins masters, and then deletes them again when jenkins says it's done with them)13:43
*** bknudson has joined #openstack-infra13:44
derekhanteaya: well I'm thinking it might be related , zuul didn't know about the first 5 times that job ran and only registered the 6th one13:44
*** maxbit has quit IRC13:44
*** dkranz has joined #openstack-infra13:44
*** maxbit has joined #openstack-infra13:44
anteayafungi: okay then I am wrong13:44
anteayawhen jobs become disconnected I had thought that nodepool had a role in that13:45
anteayaanyway, it appears that tripleo jobs are running multiple times13:45
fungiwhat do you mean by jobs becoming disconnected?13:46
anteayaderekh feels zuul doesn't know about running jobs13:46
anteayaperhaps that is an incorrect characterization13:46
fungizuul will re-run a job if jenkins fails to report a job status on completion (or in the case of a few other jenkins failure modes as well)13:47
derekhfungi: It looks like there are jobs running in the check-tripleo queue but zuul doesn't show them on the status page and for a lot of them is rerunning them13:47
anteayawell perhaps the issue is with jenkins reporting13:47
anteayaderekh: I'm curious how you can see running jobs that aren't showing on the zuul status page13:48
anteayahow are you collecting that data13:48
derekhanteaya: pooling jenkins13:48
anteayaI don't know what that means13:48
derekhanteaya: that is where the goodsquishy page gets its data, by talking to the 7 jenkins API's13:49
anteayaoh okay talking to the jenkins apis13:49
fungiright now nodepool believes there are 7 tripleo-f20 nodes in use13:49
anteayanow I got it13:49
derekhfungi: for the jobs zuul appears to have "lost", the jenkins status page for the jobs are missing the "Triggered by" line (at least the ones I have looked at)13:50
derekhhttps://jenkins05.openstack.org/job/check-tripleo-undercloud-precise/658/13:50
derekhfungi: ok, but zuul thinks there is non according to status.openstack.org/zuul/13:51
fungiTriggered by: https://review.openstack.org/91161 patchset 313:51
*** yamahata has quit IRC13:52
*** yamahata has joined #openstack-infra13:52
fungiand zuul's status page shows that job ran on that change and has recorded a result of success13:53
derekhfungi: your seeing that here ? https://jenkins05.openstack.org/job/check-tripleo-undercloud-precise/658/13:53
fungiyes13:53
fungiin the console log13:53
*** eharney has joined #openstack-infra13:53
derekhfungi: no I'm not talking about the console log, I'm talking about the page you get when you hit that URL13:53
derekhfungi: compare to https://jenkins07.openstack.org/job/check-tripleo-undercloud-precise/672/13:54
fungioh, yeah no idea how jenkins parses that metadata to display the build status page13:54
fungilooks like the build information is empty13:55
*** dkranz has quit IRC13:55
derekhfungi: so basically , as far as I can see zuul keeps kicking off a job until it gets one that displays the build information13:55
openstackgerritAlex Conrad proposed a change to openstack-infra/jenkins-job-builder: support execute-on for postbuildscript  https://review.openstack.org/9050713:56
fungithat seems possible. have you noticed a pattern of it only affecting certain jobs or certain node labels or certain jenkins masters?13:56
derekhfungi: nope looks like all jobs, any label or jenkins http://goodsquishy.com/downloads/tripleo-jobs.html13:57
derekhfungi: green lines are jobs that successfully ran, I wouldn't expect to see them again13:57
fungioh, but only for changes in the tripleo queues or have you seen it other places too?13:57
derekhfungi: I only monitor the tripleo jobs13:58
derekhfungi: If you want I can that the script and check another job in another queue13:58
*** prad has joined #openstack-infra13:59
fungii'm just spot-checking the other pipelines and don't see any obvious signs of that behavior, so it could be something specific to how those jobs are completing or to the configuration of those particular nodes13:59
sdaguederekh: ++ on extending the monitoring across all the queues, would be good to see if this is more wide spread14:00
fungidefinitely would be good to knowe14:00
fungiknow14:00
*** mfer has joined #openstack-infra14:00
*** chandan_kumar has joined #openstack-infra14:01
derekhsdague: fungi: will pick a job/queue combo and take a look14:01
*** zz_gondoi is now known as gondoi14:02
*** yamahata has quit IRC14:03
fungii've got a couple currently running in that state (both appear to be f20 jobs). i'll have a look in the jenkins log on the corresponding master for any insights14:03
*** freyes has quit IRC14:03
*** maxbit_ has joined #openstack-infra14:03
*** yamahata has joined #openstack-infra14:04
*** maxbit_ has quit IRC14:04
*** maxbit_ has joined #openstack-infra14:05
*** maxbit has quit IRC14:05
*** maxbit_ has quit IRC14:05
*** maxbit has joined #openstack-infra14:06
jeblairsdague, anteaya: as a matter of policy, i don't think we should require an existing repo to import -- but i also agree that specs repos should not start empty.  in addition to importing, i would also be okay with blank repo and docs gating jobs, with the subsequent initial commit being cookiecutter output.14:07
jeblairfungi: let me know if you want me to look into anything14:07
*** aconrad has quit IRC14:08
derekhfungi: thanks , while your looking I'll see if I can get some results for other jobs14:08
anteayajeblair: *nod14:08
fungiso far the only currently running jobs i find exhibiting this behavior are on tripleo-f20 nodes assigned to jenkins04, 06 and 0714:09
anteayafungi: what about the check-tripleo-undercloud-precise job that ran 6 times on https://review.openstack.org/#/c/91161/314:10
*** dkranz has joined #openstack-infra14:10
fungiyes, that one's not currently running14:10
fungii'm not suggesting it's completely isolated to f20 nodes, just that they seem to have a much higher incidence of it14:10
derekhfungi: In general our F20 jobs all run together at the end (which is another problem I have) https://bugs.launchpad.net/nodepool/+bug/130840714:11
uvirtbotLaunchpad bug 1308407 in tripleo "Nodepool favouring precise nodes over f20" [Critical,Triaged]14:11
anteayak14:11
*** jgrimm has joined #openstack-infra14:11
*** thedodd has joined #openstack-infra14:12
*** homeless has joined #openstack-infra14:12
*** akerr has joined #openstack-infra14:13
*** zns has quit IRC14:13
akerrSo I'm probably doing something wrong, but since the gerrit update, when I follow the instructions to grab the new keys I get the following: "ssh_exchange_identification: read: Operation timed out"   any ideas?  This is when I do the ssh -p 29418… command14:14
akerri can ping review.openstack.org and see the web interface no problem14:15
anteayaakerr: are you behind a firewall of any kind?14:15
fungiderekh: as for that, yeah i suspect that you have more demand for tripleo-precise nodes and the build time for bringing up new nodes to meet the perceived demand is resulting in some hysteresis14:15
akerrcorporate firewall, but it worked up until the update14:15
anteayaakerr: some people are finding the new ip blocked when the other was allowed14:16
anteayanot sure if that is playing a role for you or not14:16
akerranteaya: ok, I hoped that wasn't the answer, dealing with IT to open ports isn't fun :/14:16
fungiakerr: the ip addresses of review.openstack.org also changed as part of the upgrade. if your corporate firewall had explicitly allowed egress to the old ip addresses they may need to do the same now for the new addresses14:16
openstackgerritA change was merged to openstack-infra/elastic-recheck: Add a fingerprint for bug 1298355  https://review.openstack.org/9079514:16
uvirtbotLaunchpad bug 1298355 in neutron "Lock wait timeout in update VIP status" [Undecided,New] https://launchpad.net/bugs/129835514:16
anteayaakerr: *nod14:16
fungiakerr: or talk your corporate firewall admins into letting developers reach the internet without deciding what protocols make up the internet ;)14:16
akerrfungi: so I should find a wall to hit my head on?14:17
fungiakerr: i managed to do it... *once*14:17
anteayamight be easier on you14:17
*** talluri has joined #openstack-infra14:17
akerrwell thanks, I guess I'll go start the boulder up the hill14:17
fungiakerr: by becoming one of them, then fixing all the broken systems, watching them all get fired for incompetence, and rewriting policy sanely14:17
fungiakerr: the drawback to that is that then you're stuck as the corporate firewall admin14:18
openstackgerritA change was merged to openstack-infra/nodepool: Fix race in tests  https://review.openstack.org/9149114:18
*** e0ne has quit IRC14:18
*** talluri has quit IRC14:19
anteayacan we submit patches over the gerrit http api?14:19
fungianteaya: now that we have gerrit 2.8, i think we can start experimenting with that, yes14:19
*** talluri has joined #openstack-infra14:19
jeblair2014-04-30 19:48:20,294 INFO zuul.Gearman: Gearman job <gear.Job 0x7fc8ec26b850 handle: H:127.0.0.1:768035 name: build:check-tripleo-undercloud-precise unique: 71ea9bab53b247ca97da4d8dddb018f1> lost due to disconnect14:19
fungianteaya: i believe much of the code needed for it has already been contributed to git-review by others running newer gerrit servers14:20
openstackgerritA change was merged to openstack-infra/nodepool: Improve logging/stats around launch errors  https://review.openstack.org/9149214:20
phschwartzmorning14:20
anteayaakerr: did you want to investigate the gerrit http api?14:20
anteayaakerr: whilst you set the uphill boulder in motion14:20
anteayamorning phschwartz14:20
phschwartzjeblair: I tested the logging change in my vm test env for my infra setup internal here and it is a very nice improvement +114:21
jeblairfungi, derekh: ^14:21
jeblairphschwartz: ah cool, i just approved the changes and was going to try for a nodepool restart in a bit14:21
fungijeblair: derekh: yeah, i'm finding entries in the jenkins log for one of these where it's having trouble communicating with the slave agent for monitoring14:22
*** gondoi is now known as zz_gondoi14:22
derekhfungi: as I understand it, problem is that we have demand for multiple node type and grants are becomming available one at a time, nodepool is always servicing the precise node as its first in the list, hence my patch to randomly shuffle the list14:22
*** crc32 has joined #openstack-infra14:23
jeblairfungi: i think that particular error is zuul disconnecting from its geard14:23
*** talluri has quit IRC14:24
jeblairfungi: (there may be more than one thing going on)14:24
*** zz_gondoi is now known as gondoi14:24
fungijeblair: yeah, i don't yet have a clear picture of whether this is something also encountered by other slaves which don't exhibit the problem behavior14:24
*** alexpilotti has joined #openstack-infra14:24
jeblairbut we did drop 5021 jobs yesterday because of the geard disconnection14:25
*** dstanek has joined #openstack-infra14:25
dstanekbnemec: you around?14:25
bnemecdstanek: On a call, but should be done shortly.14:26
dstanekbnemec: i have a question about your patch: https://review.openstack.org/#/c/9117314:26
dstanekbnemec: ok14:26
*** gondoi is now known as zz_gondoi14:26
fungiderekh: oh, good point, though perhaps something deterministic like a round-robin interleave would be preferable (always a little wary of randomization)14:26
*** ArxCruz has joined #openstack-infra14:27
jeblairderekh, fungi: it's not strictly that it allocates precise because it's first -- it allocates precise because its demand is very high.14:28
derekhsdague: fungi jeblair : doesn't seem to be happening at the moment on other jobs http://goodsquishy.com/downloads/other-jobs.html but scroll down to 90476,5 and you'll see a bunch of jobs that got kicked off multiple times14:28
jeblair(order does play a part, but not nearly as much as demand and the min-ready ratios)14:28
derekhjeblair: it doesn't have to be very high the ratio just has to be above .5 for f20 nodes to be ignored (as we only have one node available on each cycle)14:29
fungijeblair: do you happen to know what normally populates the "build information" in jenkins (where it displays the link to the gerrit change, list of assicoated builds and list of other changes tested with it, et cetera)?14:29
jeblairfungi: zuul14:30
fungiokay, so that's a field zuul injects html into?14:30
jeblairyup14:30
*** david-lyle has joined #openstack-infra14:31
derekhfungi: I could try a round-robin algoritm, will see if I can get it right given different weights14:32
fungijeblair: and zuul does that via jenkins api after the job task is grabbed from the gearman queue, or is it part of the gearman packet?14:32
jeblairfungi: it's another gearman job14:34
*** wenlock has joined #openstack-infra14:36
anteayajeblair: is it worth trying to extend git review to allow for commands over the REST api?14:37
anteayajeblair: or would it be better to refine gertty and suggest folks that want to use the api instead of ssh use gertty?14:37
jeblair2014-04-30 19:21:35,739 INFO zuul.Gearman: Gearman job <gear.Job 0x7fc8b454a410 handle: H:127.0.0.1:761517 name: build:check-tempest-dsvm-full unique: d3f737f004d543e3b9883d3555ab5ea2> lost due to disconnect14:37
jeblair2014-04-30 19:48:20,307 INFO zuul.Gearman: Gearman job <gear.Job 0x7fc8e128e850 handle: H:127.0.0.1:767750 name: build:check-tempest-dsvm-full unique: a03fb3c899154365b9555e645ab158b1> lost due to disconnect14:37
jeblair2014-04-30 19:55:34,878 INFO zuul.Gearman: Gearman job <gear.Job 0x7fc9166d3490 handle: H:127.0.0.1:786256 name: build:check-tempest-dsvm-full unique: 645813b16f594886b3ec6d9dd6e63f91> lost due to disconnect14:38
jeblair2014-04-30 20:10:53,810 INFO zuul.Gearman: Gearman job <gear.Job 0x7fc8e2143f10 handle: H:127.0.0.1:791682 name: build:check-tempest-dsvm-full unique: 9c3c6bb2463442beb4459bdee9c6b94e> lost due to disconnect14:38
fungii wonder whether there were network issues in one of our providers last night14:38
jeblair2014-05-01 01:25:34,589 INFO zuul.Gearman: Build <gear.Job 0x7fc8e01869d0 handle: H:127.0.0.1:800047 name: build:check-tempest-dsvm-full unique: 7819a9c3325e445fa29b541266c0724a> complete, result SUCCESS14:39
funginothing obvious in rackspace's status page14:39
anteayaalso is the date and time in the gerrit 2.8 comments utc time?14:39
jeblairderekh: that's the outcome of each build of 90476,514:39
jeblairfungi: zuul and geard are on the same server14:39
*** zz_gondoi is now known as gondoi14:39
*** akerr has left #openstack-infra14:39
jeblair2014-04-30 18:58:26,506 ERROR gear.Client.unknown: Connection <gear.Connection 0x29ab7d0 host: 127.0.0.1 port: 4730> timed out waiting for a response to a submit job request: <gear.Job 0x7fc915a28710 handle: None name: stop:jenkins05.openstack.org unique: 9c69ff5edd7440d68fb64df07f4e1033>14:39
jeblairfungi: ^14:39
fungioh, right, so this is local socket disconnects between zuul and its gear daemon process14:40
jeblairyep, because geard was too slow14:40
*** dkehn_ is now known as dkehnx14:40
jeblair(for an unknown reason)14:41
fungiit's too bad cacti is abandoned on ubuntu 12.04 lts or we'd be able to look at performance graphs for the server... http://people.canonical.com/~ubuntu-security/cve/2014/CVE-2014-2708.html14:41
uvirtbotfungi: Multiple SQL injection vulnerabilities in graph_xport.php in Cacti 0.8.7g, 0.8.8b, and earlier allow remote attackers to execute arbitrary SQL commands via the (1) graph_start, (2) graph_end, (3) graph_height, (4) graph_width, (5) graph_nolegend, (6) print_source, (7) local_graph_id, or (8) rra_id parameter. (http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2014-2708)14:41
jeblairfungi: hrm, cacti is running.14:41
fungioh, so it is14:42
phschwartzjeblair: I have noticed that geard is not the most efficient when it comes to actually responding to requests. Seems like a latency issue in the software14:42
jeblairfungi: i assumed someone started it because the patch was applied14:42
*** atiwari has joined #openstack-infra14:42
bnemecdstanek: Okay, I'm free14:45
jeblairfungi: ironically, i think it was rebooted because of heartbleed and apache was not stopped then.14:45
fungijeblair: fixed in debian with the 0.8.8b+dfsg-4 upload a few weeks ago https://bugs.debian.org/743565 but not backported to anything besides trusty14:45
jeblairfungi: that's pretty lame.  :(14:45
dstanekbnemec: i tried the patch and it does seem to parse the patchset data better, but it looks like it's not dealing with age properly14:46
dstanekbnemec: were you not having that issue? i'm trying to see if it's just my environment14:46
bnemecdstanek: Yeah, but as I mentioned in the commit message I don't think that's reviewstats.  The data is actually bad.14:46
bnemecIt appears that every vote's timestamp got updated to the same time during the upgrade.14:46
jeblairfungi: how about i "rm /usr/share/cacti/site/graph_xport.php" ?14:46
bnemecSo every vote that happened pre-2.8 is now showing up as a couple of days old.14:46
bnemecI've been meaning to follow-up on that and see if it can be fixed somehow.14:47
fungijeblair: i would accept that as an option14:47
*** pcrews_ has joined #openstack-infra14:48
dstanekbnemec: oh, that's interesting14:48
*** rfolco has quit IRC14:49
jeblairfungi: done14:49
fungibnemec: dstanek: i blame gerrit. it makes extensive use of mysql auto-timestamp fields rather than bothering to manage its own timestamping on things, which is hella-lame14:49
bnemecdstanek: fungi: I think it was only two timestamps (one for code reviews and one for approvals), so we could theoretically filter out the bad data in reviewstats.14:50
bnemecIt means we'll only have stats back to the upgrade, but that's probably more useful than what we've got now.14:50
*** manishg has quit IRC14:50
fungibnemec: dstanek: which means for certain tables, if you go in and update row contents for a data migration of some sort, mysql "conveniently" updates the timestamp for the row14:50
*** annegentle has joined #openstack-infra14:51
dstanekbnemec: i think that would be great - i use reviewstats as sort of a heartbeat to make sure i'm spending enough time on reviews14:51
jeblairwe do have the old data though, so it may be possible to correct14:51
bnemecdstanek: Likewise.  That's why I wanted to get it fixed. :-)14:52
dstanekfungi: can that be turned off during a migration in MySQL?14:52
fungiagreed, but it's probably a fair amount of work... maybe zaro wants to investigate and put together a recommended set of queries for that14:52
sdagueI found a new interesting gerrit upgrade bug14:53
jeblairbnemec: can you work up an etherpad documenting the issues?14:53
sdaguewhen you click on the first file to review14:53
bnemecjeblair: Sure14:53
fungidstanek: well, there are workarounds for it (like adding colname=colname for the timestamp column in your update query) but now that dhip has sailed14:53
sdaguethe vertical scroll bar possition stays at what it was on the overview page14:53
sdaguewhich means you might be deep into the patch14:53
fungis/dhip/ship/14:54
dstanekfungi: i'm just thinking ahead to the next one :-)14:54
*** matsuhashi has quit IRC14:54
fungidstanek: yeah, we discovered it a while back and implemented workarounds in our documented processes for things like project renames/moves14:54
fungibut probably missed it in the gerrit upgrade (or it's missed in gerrit's own upgrade scripts)14:54
*** yamahata has quit IRC14:54
*** markmcclain has joined #openstack-infra14:54
dstanekfungi: sounds like fun14:55
fungiadd to the list of "things which seem like a convenient option, but really aren't and you should never make use of them in your own software"14:55
dstanekthe other thing i noticed with the new gerrit is that i periodicallly get blank pages14:55
dstanekthey contain a little javascript snippet, but that's it - a refresh fixes the issue though14:56
dstanekactually it may be anytime i open the link in a new tab14:57
*** markmcclain1 has joined #openstack-infra14:58
fungidstanek: maybe you're conflicting with the change gerrit made to start forcing links to open in a new tab/window14:58
dstanekfungi: could be, but if i go here https://review.openstack.org/#/q/status:open+project:openstack/keystone,n,z14:59
fungioh, though it's mostly not configured to do that for internal links back to its own pages, only for links to outside resources14:59
dstanekthose links don't open in new tabs so i do that myself14:59
*** markmcclain has quit IRC14:59
hughsaundershey all, who looks after paste.openstack.org? seems to be struggling a little today15:00
fungidstanek: in firefox 24 a ctrl-click on those links doesn't get me a blank tab. what are you running?15:00
anteayamy gertty log today is full of this error: http://paste.openstack.org/show/78234/15:01
anteayahughsaunders: hi, we do, paste.o.o is slow15:02
dstanekfungi: i'm running chrome15:02
dstanekfungi: on mac15:02
hughsaundersanteaya: cool, thanks for running it, most useful :)15:02
fungihughsaunders: watching top on paste.o.o, drizzled seems to eat 100% of a cpu for extended periods when i request a paste with my browser15:03
fungii've heard it suggested that the version of drizzle providing the db backend on it is prone to sluggishness15:03
anteayahughsaunders: thanks but looking at cacti, the cached memory took a jump this morning: http://cacti.openstack.org/cacti/graph_view.php?action=tree&tree_id=1&leaf_id=14&page=215:03
*** marun has joined #openstack-infra15:04
fungialso drizzled seems to be eating over a gigabyte of virtual memory, though that's only about half of the allocated system ram and there's little else contending for it on the vm15:04
jeblairfungi: mordred said something about not having any buffers configured the other day.  i don't know if he did anything about that though.15:06
fungiohhh15:06
*** yamahata has joined #openstack-infra15:07
jeblair2014-04-22T22:16:51  <mordred> there's no real reason that our current paste should be slow ... oh, except there is no buffer pool configured15:07
jeblair2014-04-22T22:16:54  <mordred> *facepalm*15:07
hughsaundersis it using innodb?15:07
jeblair2014-04-22T22:17:27  <clarkb> mordred: does that mean you are going to fix it?15:07
jeblair2014-04-22T22:17:42  <mordred> clarkb: well, by "fix it" first I mean" move it to trove"15:07
jeblairfungi: http://eavesdrop.openstack.org/irclogs/%23openstack-infra/%23openstack-infra.2014-04-22.log15:08
fungijeblair: great context, thanks15:08
fungialso, since we have cacti after all, i'm seeing that zuul is about to run out of space on / again15:08
fungiprobably debug logs15:08
*** gondoi is now known as zz_gondoi15:09
fungiyeah, about 70% of the data on / is in /var/log/zuul15:09
fungii guess it's not eating through it all that quickly though15:10
jeblairyup, we need to compress those15:10
jeblairfungi: i just manually deleted some.  it'll run out again if we don't fix it.15:10
fungik15:11
jeblairso... if you have 1000 jenkins slaves (which we do, more or less), and they can run 2500 jobs (which ours can, more or less).  that's 2.5 million gearman function registrations.15:11
mordredjeblair: dude15:12
mordredthat's a lot15:12
jeblair(i'm setting up a geard stress test, and that's the first thing i noticed -- it takes a while for my 1000 slaves to register their functions)15:12
anteayamordred: can you look at these? https://review.openstack.org/#/q/status:open+project:openstack-infra/gitdm,n,z poor StevenK has been waiting over a month15:20
mordredanteaya: on it15:21
anteayamordred: thanks15:21
mordredfungi: think we should migrate paste to trove?15:21
sdagueanteaya: I've got +2 on that as well if needed15:21
anteayasdague: awesome thanks15:22
anteayalet's see what mordred does15:22
mordredOMG15:22
anteayajust as a note, I am waiting for input from jeblair on https://review.openstack.org/#/c/89421/ since I need to here what direction he wants to go in, the infra-manuals publish job15:22
anteayahear15:22
*** jaypipes has quit IRC15:23
fungimordred: seems like a sane idea. drizzle is mysql-like enough that we can just mysqldump and then source the result in trove, right?15:23
mordredwhy would I ever want the link to a project on a change to take me to the admin screen for that project and not for other changes for that project15:23
mordredfungi: that's right15:23
*** mrodden has joined #openstack-infra15:23
sdaguemordred: oh, yeh, I notice that this morning as well15:23
mordredfungi: I think I put up a change already to add hostname support15:23
*** zz_gondoi is now known as gondoi15:23
*** zns has joined #openstack-infra15:23
sdaguethe magnifying glass takes you where you want15:23
fungimordred: i'll find it15:23
mordredsdague: yah15:23
*** ociuhandu has joined #openstack-infra15:26
openstackgerritA change was merged to openstack-infra/gitdm: Add StevenK to the HP group list  https://review.openstack.org/8270615:26
*** changbl has joined #openstack-infra15:27
*** manishg has joined #openstack-infra15:27
*** mestery has quit IRC15:27
*** yfried has quit IRC15:28
*** manishg has quit IRC15:29
openstackgerritA change was merged to openstack-infra/gitdm: Update mtreinish's employment history  https://review.openstack.org/9043915:33
*** zns has quit IRC15:34
anteayathanks15:35
*** ociuhandu has quit IRC15:36
jeblairsdague, mordred: yep, there are 8x more pixels devoted to navigating you to the admin screen than there are for getting you to the list of changes to the project.  i'm pretty sure that's because the admin screen in 8x more important than the list of changes in a project.15:36
*** zns has joined #openstack-infra15:38
sdaguejeblair: heh15:38
*** chandan_kumar has quit IRC15:39
*** maxbit_ has joined #openstack-infra15:39
*** maxbit_ has quit IRC15:40
annegentlehey mordred I had a great call with Colette Alexander and Doug Moran this week15:40
*** manishg has joined #openstack-infra15:41
mordredannegentle: awesome! I hear that went well15:42
*** rfolco has joined #openstack-infra15:43
*** maxbit has quit IRC15:43
jeblairanteaya: why are you waiting for input from me on that?15:47
anteayajeblair: yes15:47
anteayaoh why15:47
anteayabecause there are two option outlined15:47
anteayaand I have my inclinations but would like to hear your preference15:48
*** gondoi is now known as zz_gondoi15:48
anteayaI can just go with my inclination if you would like15:48
jeblairanteaya: where are the two options?15:48
*** zz_gondoi is now known as gondoi15:48
anteayamgagne: gave two suggestions: https://review.openstack.org/#/c/89421/9/modules/openstack_project/files/jenkins_job_builder/config/infra-publish-jobs.yaml15:50
anteayaAFAIK, jeblair would like the folder to be named "manual". In this case, the JJB variable {name} will be replaced by the JJB project name: infra-manual. The manual will get uploaded to infra/infra-manual which isn't good.15:50
anteayaIn the end, if the project name seldom corresponds to the folder name into which the docs is published, I suggest introducing a new JJB variable: doc-publisher-folder.15:50
anteayaThis JJB variable should be added to projects.yaml and defined with the value "manual":15:50
anteayait is to do with the format for naming the job and the resultant url15:51
bnemecdstanek: fungi: jeblair: https://etherpad.openstack.org/p/gerrit-2.8-reviewstats15:53
jeblairanteaya: option (A)15:55
anteayajeblair: thank you15:55
anteayathat was the one I like too15:55
*** UtahDave has joined #openstack-infra15:58
*** eharney has quit IRC15:59
jeblairbnemec: so we need to find the fields in the db with the wrong data16:00
jeblairbnemec: in order to do that, i need to find the fields in the query with the wrong data16:00
jeblairbnemec: so let's come up with a query that illustrates it16:00
*** thomasem has quit IRC16:00
*** packet has joined #openstack-infra16:01
*** packet has quit IRC16:01
*** thomasem has joined #openstack-infra16:01
*** thomasem has quit IRC16:01
jeblairbnemec: let's start with finding one change that illustrates (at least one, ideally all of) the problem(s)16:01
*** thomasem has joined #openstack-infra16:02
bnemecjeblair: A db query or the Gerrit query reviewstats uses?  I don't think reviewstats directly queries the db so I'm not sure I have access to that.16:02
openstackgerritDerek Higgins proposed a change to openstack-infra/config: Create tripleo-specs git repo  https://review.openstack.org/8969116:02
*** packet has joined #openstack-infra16:02
jeblairbnemec: no, an ssh query (which is what reviewstats uses)16:02
bnemecjeblair: Cool, I should be able to do that.16:03
jeblairbnemec: cool16:03
derekhjeblair: fungi: is there anything I can do for the vanishing jobs issue ? or is there more investigations to be done?16:03
*** sweston has joined #openstack-infra16:04
mordredjeblair: just read the etherpad above - do you think it's worth trying to extract the old timestamps from the db dump?16:04
jeblairderekh: no i think we identified the problem a while ago -- zuul dropped the gearman connection and relaunched running jobs16:04
jeblairmordred: that's what i'm trying to facilitate.16:04
*** markmcclain1 has quit IRC16:05
jeblairmordred: i'm trying to identify what timestamps need to be extracted.16:05
mordredkk16:06
derekhjeblair: ok, so there are still running jobs that zuul doesn't know about, do I just need to wait it out16:07
jeblairderekh: link to one?  the example i looked at was from yesterday16:08
derekhjeblair: https://jenkins04.openstack.org/job/check-tripleo-overcloud-f20/229/16:08
*** weshay has quit IRC16:08
fungithis one is currently running and has no build status... https://jenkins07.openstack.org/job/check-tripleo-overcloud-f20/264/16:09
jeblair2014-04-30 20:10:53,501 INFO zuul.Gearman: Gearman job <gear.Job 0x7fc8c4919f10 handle: H:127.0.0.1:792065 name: build:check-tripleo-overcloud-f20 unique: 275628aeaa5f46a291c6aab17b9cb3be> lost due to disconnect16:09
fungiahh, right, "from yesterday" meaning the change was enqueued yesterday, not that the job started yesterday16:10
*** mrodden has quit IRC16:11
*** eharney has joined #openstack-infra16:11
jeblairi'm a little surprised that ended up running; i need to think about whether that's the right thing for geard to do in this case.16:12
*** matty_dubs is now known as matty_dubs|lunch16:12
*** talluri has joined #openstack-infra16:13
fungithe one currently running which i linked was similarly lost between zuul/gear at 20:10:53 yesterday16:13
zaromorning16:14
fungii find it odd that it's just tripleo jobs which are getting perpetually restarted due to this. we don't seem to have changes in other pipelines sticking around exhibiting this behavior16:15
fungieven though there were changes in other pipelines affected by the disconnects, according to the logs16:16
jeblairfungi: are you saying no changes other than tripleo-related ones were restarted?16:19
anteayamorning zaro16:20
anteayazaro: is gerrit 2.8 commenting using utc time?16:20
fungijeblair: i don't know that no other changes were restarted, just that we have tripleo changes with jobs getting rerun which were originally enqueued yesterday16:21
fungiand it doesn't look like we have changes in any other queues for anywhere near that long16:21
jeblairfungi: tripleo doesn't have enough nodes16:21
jeblairfungi: those changes were likely actually waiting that long16:22
fungiyeah, pinning down whether they're getting restarted more than once since yesterday is proving challenging16:22
jogohow did this happen? http://logs.openstack.org/75/91375/1/gate/gate-glance-python26/9c03553/console.html#_2014-05-01_02_40_45_31616:22
jogoa dependency escaped the pypi mirror16:23
bnemecjeblair: I think you already saw it, but I added a query for a single change demonstrating the problem in https://etherpad.openstack.org/p/gerrit-2.8-reviewstats16:23
fungithough at this point i'm really only finding restarts on f20-based jobs which would support the supposition that they really did just get disconnected and not rerun until 20+ hours later16:23
fungior rather, that they got lost in zuul but took 20+ hours before a jenkins master had an available node of that type to go ahead and run the job (even though at this point zuul doesn't know it's being run)16:24
jeblairbnemec: so it looks like it's all the votes, but not the submit time.  any other times affected?16:24
*** weshay has joined #openstack-infra16:24
*** mrodden has joined #openstack-infra16:24
jogofungi: ^16:25
bnemecjeblair: Not that I've seen.  The createdOn and lastUpdated times look reasonable on that change, and those are the only other timestamps I see.16:26
jeblairfungi: i think i found a bug in geard16:26
derekhfungi: but the jobs I was looking at origionaly started yesterday evening and have been continuously restarted overnight some upto 6 times16:26
derekhfungi: the problems on check-tempest-dsvm-fullcheck-tempest-dsvm-neutron16:26
derekhalso ran upto 6 times16:26
derekhfungi: but got cleared a lot quicker16:26
jeblairderekh: because it runs on precise nodes and they come up more often.16:27
fungijogo: that's interesting... that job seems to have tried to download the req from somewhere other than our mirror16:27
jeblairit's worth noting that if geard has jobs queued that zuul does not know about, nodepool can not take them into consideration when it's calculating load.16:28
jogofungi: yeah I can't figure out how that happened16:28
derekhjeblair: I'm talking about the check queue, not tripleo, what I mean is the same problem happened at the same time, only the multiple jobs got cleared a lot faster because the quota to handle them is higher16:28
*** jpich has quit IRC16:28
jogofungi: oh shit I found it16:29
*** talluri has quit IRC16:29
fungijogo: http://git.openstack.org/cgit/openstack/glance/tree/test-requirements.txt#n2216:29
jogohttp://git.openstack.org/cgit/openstack/glance/tree/test-requirements.txt#n2216:29
jogoyuyp16:29
jogoderp16:29
fungiheh16:29
fungigit blame here i come16:29
jeblairderekh: yeah.  i'm trying to figure out if we're talking past each other.  i think the problem is well explained at this point; is there something you think we're missing?16:30
dstanekbnemec: nice16:30
mordredjogo: how did that make it past the requirements gate?16:31
derekhjeblair: no if ye are happy, I'm happy, I just saw a comment saying this was possibly only related to the check-tripleo queue, all I was saying is that wasn't true16:31
fungijogo: https://review.openstack.org/#/c/59699/12/test-requirements.txt16:31
*** jooools has quit IRC16:31
dstanekbnemec: instead of filtering out specific timestamps can you just pick one and filter anything before it?16:31
fungiwtf?16:31
*** nati_ueno has joined #openstack-infra16:31
jogomordred: because the global reqs check probablly doesn't work when a specific file is called for16:31
mordredjogo: oh! I think we explicitly don't try to check those because of legacy16:32
mordredwe should remove that exclusion to the check16:32
jogomordred: ++16:32
fungiclearly it allows people to act carelessly16:32
bnemecdstanek: Yeah, potentially.  I figured out why Approvals aren't showing up too.  I probably need to update my patch Approved -> Workflow.16:32
jeblairderekh: cool, i agree with you that it is not tripleo-specific (we may be more likely to see evidence of it there due to the differences in node availability)16:33
*** marcoemorais has joined #openstack-infra16:33
derekhjeblair: yup16:33
jeblairbnemec: approved will show up in older changes, workflow in newer ones; probably best to handle both16:34
*** alexpilotti has quit IRC16:34
jogomordred: also pysendfile is in our mirror already16:34
bnemecjeblair: Yeah, makes sense.16:34
mordredjogo: yah. you fixing or you want me to?16:34
*** zns has quit IRC16:34
jogomordred: we should just ban '-f ' to external deps16:35
jogomordred: I am writting up a glance patch16:35
fungijogo: mordred: i'm thinking it may have been in response to this comment in the bug linked from that commit message...16:35
fungihttps://bugs.launchpad.net/glance/+bug/1271806/comments/316:35
uvirtbotLaunchpad bug 1271806 in glance "unable to run tests due to missing deps in the virtual env" [Wishlist,Fix released]16:35
mordredjogo: we should just hard-ban anything thats not in global requirements without exclusions16:35
jogofungi: hehe wow16:37
fungistrangely, pysendfile has been in our mirror for more than a year... http://pypi.openstack.org/openstack/pysendfile/16:37
jogomordred: ++16:37
jogofungi: it looks like that was a local failure the guy saw or something16:37
anteayaI have a concern about the commiter offering patch 12, not a trivial change with no other reviews and self-approving16:37
mordredwhere is our actual "must match global requirements" check?16:37
jogomordred: in PBR I think16:38
jogofungi: https://review.openstack.org/9160316:38
fungijogo: ahh, yep, that was around the time pip updated to start refusing externally-linked packages, so that was probably a contributor to the confusion there16:38
jogoyeah16:39
mordredthat's the integration job - I don't see the check for does your change match16:39
* jogo files a glance bug to track 16:39
zaroanteaya: i'm not sure.  can you tell?16:39
fungijogo: good, goof16:39
fungis/goof/good/16:39
mordredfoudn it16:40
*** sacharya has joined #openstack-infra16:40
anteayazaro: I was hoping someone would know, I will keep an eye on it and see if I can track it16:41
anteayazaro: thanks16:41
openstackgerritMonty Taylor proposed a change to openstack-infra/config: Stop giving -f and -e lines a pass in requirements  https://review.openstack.org/9160416:42
mordredfungi, jogo: ^^16:43
*** Longgeek has quit IRC16:43
jogomordred: I saw that out of the corner of my eye and thought it said "stop giving an f*"16:43
jogoa f*16:43
fungiquite the opposite, in fact ;)16:43
jogomordred fungi: https://bugs.launchpad.net/glance/+bug/1315062 tracking bug16:43
uvirtbotLaunchpad bug 1315062 in glance "don't pull pysendfile from googlecode" [Undecided,New]16:43
jogofungi: yup hehe16:44
fungimordred: does the reqs sync proposal script also ignore -e and -f lines when building patches? if so, we should probably fix that too16:45
*** bhuvan has joined #openstack-infra16:46
fungimordred: also, this might end up leaving us unable to update requirements on projects in havana... weren't we linking to a tarball of an oslo.messaging beta in the havana timeframe?16:46
*** lakshmi has joined #openstack-infra16:46
fungioh, actually no i think we successfully avoided releasing havana with links to unreleased beta reqs16:47
fungiso if we're not fine there, it needs to be broken so it becomes more visible16:48
mordredjogo: looks like we're slow on the draw and someone else already filed the bug and the patch16:49
jogomordred: oh16:50
jogolink?16:50
jogomordred: damn16:50
jogoahh https://review.openstack.org/#/c/91547/16:50
fungiyeah, the reqs proposal script seems to ignore things which don't look like normal requirements (to handle comments and whatnot)... https://review.openstack.org/#/c/88719/6/test-requirements.txt16:51
*** etoews has joined #openstack-infra16:51
openstackgerritJoe Gordon proposed a change to openstack-infra/elastic-recheck: Add fingerprint for bug 1315062  https://review.openstack.org/9160516:54
uvirtbotLaunchpad bug 1315062 in glance "don't pull pysendfile from googlecode (dup-of: 1314968)" [Undecided,New] https://launchpad.net/bugs/131506216:54
uvirtbotLaunchpad bug 1314968 in glance "Installing test-requirements fails because pysendfile.2.0.0.tar.gz cannot be found" [Undecided,In progress] https://launchpad.net/bugs/131496816:54
openstackgerritBen Nemec proposed a change to openstack-infra/reviewstats: Update for Gerrit 2.8  https://review.openstack.org/9117316:54
openstackgerritBen Nemec proposed a change to openstack-infra/reviewstats: Workaround the Gerrit upgrade timestamp issue  https://review.openstack.org/9160616:54
*** dprince has quit IRC16:54
bnemecdstanek: ^ should filter out the bad timestamps16:54
*** markmcclain has joined #openstack-infra16:55
*** rcarrillocruz has joined #openstack-infra16:56
jogomordred: http://paste.openstack.org/show/7825616:57
jogolooks like ironic is the only one16:58
jogowith pecan16:58
jogodevananda: ^16:58
*** ociuhandu has joined #openstack-infra16:58
*** rcarrill` has quit IRC16:59
jogooh that has been fixed16:59
*** maxbit has joined #openstack-infra17:02
jogomordred:  a better list of the '-e ' offenders http://paste.openstack.org/show/7825717:03
jogolooks like we have some folks installing other openstack components from !tarballs17:04
openstackgerritVasudev Kamath proposed a change to openstack-dev/pbr: Documentation updates  https://review.openstack.org/9160917:04
*** maxbit_ has joined #openstack-infra17:05
mordredjogo: all of those are fixable pretty easily17:06
*** markmc has quit IRC17:06
fungiyeah, those probably indicate there are reqs which could stand to be (pre)released to pypi, worst case17:06
*** derekh has quit IRC17:06
jogoyup17:06
fungiwhich is likely to be beneficial regardless17:06
jogoI am a little surprised at how not too bad they are17:06
*** Ryan_Lane has joined #openstack-infra17:06
openstackgerritJames E. Blair proposed a change to openstack-infra/gear: geard: be more careful removing jobs  https://review.openstack.org/9161017:06
jeblairderekh is gone... :(17:07
jeblairfungi: ^ that should address the "ghost jobs" part of the problem, though the underlying cause of "geard did not respond for 30 seconds" is still unknown.17:07
mordredjogo: making patches for those17:08
*** maxbit has quit IRC17:08
fungijeblair: it's at least a start17:09
*** SumitNaiksatam has quit IRC17:10
*** ociuhandu has quit IRC17:10
*** hcc has joined #openstack-infra17:11
fungilgtm17:11
*** _nadya_ has joined #openstack-infra17:12
mordredjogo: submitted changes for both of them17:12
*** salv-orlando has quit IRC17:13
*** alexpilotti has joined #openstack-infra17:14
*** matty_dubs|lunch is now known as matty_dubs17:14
*** talluri has joined #openstack-infra17:16
* anteaya goes for a walk17:16
*** zns has joined #openstack-infra17:17
*** clayg has joined #openstack-infra17:18
claygin this grenade job n-net failed to start and caused vms' to go into error - but I can't find the root cause of the n-net failure?  http://logs.openstack.org/02/91502/1/check/check-grenade-dsvm/912e89e/logs/new/17:18
*** zns has quit IRC17:18
*** arosen has left #openstack-infra17:18
*** zns has joined #openstack-infra17:19
*** annegentle has quit IRC17:19
claygthere seems to be some mention of a tee "/opt/stack/status/stack/n-net.failure" - but I can't see where/if this status/stack directory is captured?17:21
*** bhuvan has quit IRC17:24
*** SumitNaiksatam has joined #openstack-infra17:24
*** Ajaeger has joined #openstack-infra17:25
*** e0ne has joined #openstack-infra17:26
*** arnaud__ has joined #openstack-infra17:26
*** maxbit has joined #openstack-infra17:27
*** markmcclain has quit IRC17:27
*** maxbit__ has joined #openstack-infra17:29
*** reed has joined #openstack-infra17:30
*** morganfainberg_Z is now known as morganfainberg17:30
*** maxbit_ has quit IRC17:30
fungiclayg: perplexing. it doesn't look from the console log xtrace like screen thinks it failed to start n-net, so the n-net.failure file wouldn't have been created in that case17:30
fungihowever i agree there seems to be no screen log archived for it either17:30
fungiand plenty of n-cpu errors17:30
fungiwhich seem to stem from being unable to interact with the (presumably not running) n-net17:31
claygyeah and all the n-cpu errors basically say, "no one seems to be handling n-net requests)17:31
fungiagreed17:31
fungiShrews: finally found a moment to look into the update_bug.py failure you spotted--traceback makes me wonder whether we changed the account or authentication method we're using... http://paste.openstack.org/show/78260/17:31
dstanekbnemec: seems to be working. thanks!17:31
*** maxbit has quit IRC17:32
bnemecdstanek: np, glad to hear it :-)17:32
reedhello working folks17:32
*** reed has quit IRC17:32
*** reed has joined #openstack-infra17:33
fungiShrews: seems the user i would *expect* it to be using is in the bug team for that bug/chanfge17:33
fungiwelcome back reed!17:33
reedhi fungi17:34
Shrewsfungi: zoinks! this is obviously mordred's fault, though i have no direct evidence17:34
reedlooks like I got disconnected briefly17:34
fungireed: "<-- reed (~reed@fsf/member/reed) has quit (Excess Flood)"17:34
reedgerrit seems to be complaining that I'm committing with the wrong email address but I don't know where to change it17:34
fungireed: best place to do it is in your ~/.git/config17:35
fungier, ~/.gitconfig17:35
reedah!17:36
mordredreed: "git config --global user.email blah@blah.com"17:36
fungithat's where i usually set my name, email and signingkey17:36
reedI wonder why that's there now... and I wonder why gerrit didn't pick it up earlier17:36
mordredreed: or, if you disagree, you can add an email address to gerrit17:36
*** gyee has joined #openstack-infra17:36
fungiyeah, the git config --global command basically edits that file for you17:36
*** praneshp has joined #openstack-infra17:37
fungireed: also, if you've already committed something, the previous name and email are already in the commit as the author and won't be reset without some additional magic and an --amend17:37
reeddamn, now I need to undo the commit17:37
fungier, as the committer17:37
*** ramashri has joined #openstack-infra17:37
reedyeah, right17:37
reedgit uncommit17:37
fungii think it's --reset-committer or something like that17:37
fungidon't need to undo the commit itselg17:37
fungigit commit --amend --reset-author17:38
*** thedodd has quit IRC17:38
fungii guess --amend normally updates the committer but not the author17:38
openstackgerritStefano Maffulli proposed a change to openstack-infra/config: Adding list for Superuser magazine's team  https://review.openstack.org/9162317:39
reed:)17:39
fungisuperuser magazine, huh?17:40
*** e0ne has quit IRC17:40
reedfungi, it's a new initiative of the Foundation, there will be a publication featuring users17:40
fungiahh17:41
*** darraghb has quit IRC17:45
openstackgerritArnaud Legendre proposed a change to openstack-infra/config: Create glance-specs git repo  https://review.openstack.org/9046117:46
*** maxbit has joined #openstack-infra17:46
*** praneshp has quit IRC17:46
*** maxbit__ has quit IRC17:47
*** yidclare has joined #openstack-infra17:48
*** e0ne has joined #openstack-infra17:49
SpamapShm17:51
openstackgerritArnaud Legendre proposed a change to openstack-infra/config: Create glance-specs git repo  https://review.openstack.org/9046117:51
SpamapScheck-tripleo seems to have no f20 slaves17:52
SpamapSbut I see 12 on the cloud17:52
*** praneshp has joined #openstack-infra17:52
fungiSpamapS: yeah, see earlier scrollback with jeblair and derekh17:52
SpamapSah ok I thought I'd see jobs running17:53
*** bhuvan has joined #openstack-infra17:53
SpamapSfungi: so "just wait it out" was what derekh said, but is there a place I can see how long we have to wait?17:53
SpamapSI want to start rolling out trusty to that cloud so we can get rid of our network problems17:53
fungiSpamapS: apparently communication between zuul and its gear daemon got choked yesterday, which due to a bug (patch pending) caused the jobs to still end up in the queue and run by jenkins even though zuul was then blind to the fact that they were running17:54
*** rcarrillocruz has quit IRC17:54
*** _nadya_ has quit IRC17:54
SpamapSOk, so there's stuff running that we can't see..17:54
SpamapSand when it finishes, we'll see?17:54
*** markmcclain has joined #openstack-infra17:55
fungiSpamapS: and due to the general starvation on the tripleo cloud, in particular for less-commonly-requested node types, those queued jobs are still running on f20 nodes as they become available17:55
SpamapS| free_ram_mb          | 77100   |17:55
SpamapS| vcpus                | 456     |17:55
SpamapS| vcpus_used           | 114     |17:55
fungieventually they get rerun by zuul using a gearman queue item it's aware exists and then the result for that rerun will report17:56
SpamapSfungi: do we need to bump up the quota?17:56
SpamapSI only see 41 instances, error, build, and active included17:56
fungiSpamapS: i think the current quota was constrained by the number of tripleo "work environments" configured on the te-broker?17:56
SpamapSoh that's entirely possible17:57
* fungi is a little fuzzy on the terminology for that17:57
SpamapStestenvs17:57
fungii remember someone saying there were only 40 environments built out17:57
SpamapSTHere are either 7 or 10 testenvs.. can't tell if the errors in undercloud mean anything17:58
SpamapSeach one can do 4 jobs at once.17:58
SpamapSI think17:58
SpamapS40 would make sense17:58
fungiokay, that's probably what it was17:58
SpamapSI have more hardware now17:58
fungienough environments for 40 jobs then17:58
SpamapSso once lifeless wakes up.. I'll ask him if we should add a couple.17:58
fungisounds like you could make use of it, yeah17:58
*** clayg has left #openstack-infra17:58
*** mestery has joined #openstack-infra17:58
SpamapSI have 10 boxes available, but 5 are _mine_ ;)17:58
*** rcarrillocruz has joined #openstack-infra17:59
fungianyway, the pending zuul patch is to make sure those gearman items get dequeued if zuul is going to ignore them, so that they don't end up running and wasting resources17:59
*** dstanek is now known as dstanek_zzz18:00
fungithough the jury's still out on why geard gets bogged down when we flood it with millions of requests. jeblair is trying to profile it under manufactured stress for a better picture of what's happening18:00
*** hcc is now known as hdd18:00
*** melwitt has joined #openstack-infra18:01
*** etoews has quit IRC18:04
fungiShrews: i'm definitely confused on the update_bug.py failures... the ~gerrit2/.launchpadlib/creds file being used to authenticate to lp is definitely identical...18:04
fungistill digging18:05
*** dangers_away is now known as dangers18:06
*** etoews has joined #openstack-infra18:06
openstackgerritAndreas Jaeger proposed a change to openstack/requirements: Update openstack-doc-tools for translation of api-site  https://review.openstack.org/9074618:07
*** moted has joined #openstack-infra18:07
*** aconrad has joined #openstack-infra18:08
JayFfungi: ty for modifying the SPF record, I can tell when you did it because the emails started going to my inbox :)18:09
openstackgerritRamy Asselin proposed a change to openstack-infra/config: nodepool image update works behind a http proxy  https://review.openstack.org/8738418:10
*** manishg has quit IRC18:10
SpamapSfungi: "Python" ? ;)18:10
jogowho is part of testing-cabal besides lifeless?18:10
*** manishg has joined #openstack-infra18:10
SpamapSfungi: have we tried geard under pypy ?18:10
jogoI want to use https://github.com/testing-cabal/testtools/pull/7818:10
SpamapSjogo: I think jml?18:11
SpamapShttps://launchpad.net/~testing-cabal18:11
SpamapSjelmer too18:11
fungiSpamapS: actually an intresting suggestion, and no i don't suspect it's been tested under pypy but might be interesting to see the performance numbers compared18:11
SpamapSok.. caffeine and lunch needed..18:11
*** harlowja_away is now known as harlowja18:12
SpamapSfungi: it's also possible that even though the threads are just for I/O, the GIL is still eating geard's lunch18:13
SpamapSlunch.. right.. need..18:13
* SpamapS will return18:13
*** ArxCruz has quit IRC18:16
*** ociuhandu has joined #openstack-infra18:18
*** amcrn has joined #openstack-infra18:21
*** sdake has quit IRC18:21
openstackgerritA change was merged to openstack-infra/elastic-recheck: Add fingerprint for bug 1315062  https://review.openstack.org/9160518:21
uvirtbotLaunchpad bug 1315062 in glance "don't pull pysendfile from googlecode (dup-of: 1314968)" [Undecided,New] https://launchpad.net/bugs/131506218:22
uvirtbotLaunchpad bug 1314968 in glance "Installing test-requirements fails because pysendfile.2.0.0.tar.gz cannot be found" [Undecided,In progress] https://launchpad.net/bugs/131496818:22
*** sdake has joined #openstack-infra18:22
*** jaypipes has joined #openstack-infra18:23
*** ramashri has quit IRC18:23
*** jp_at_hp has quit IRC18:24
fungihas anybody in here submitted abstracts on openstack-infra topics for linuxcon-na?18:26
fungiproposal submission period ends tomorrow18:27
*** dstanek_zzz is now known as dstanek18:27
anteayayeah I just got that email too18:32
anteayathey have a goverance topic18:32
anteayamight submit something about our ptl and tc election process18:32
fungioh, i didn't see an e-mail, it was just on my list of things i was procrastinating on18:33
fungibut you should totally do that18:34
openstackgerritJames E. Blair proposed a change to openstack-infra/gear: Restructure logging  https://review.openstack.org/9164318:34
jeblairfungi: ^ that is not a fix to the underlying issue, however, i think that if we merge that and move zuul's logging to /opt, we may be in a better place to track it down the next time it happens18:35
sdaguefungi: jogo submitted an ER talk18:35
sdagueI just submitted something that I called OpenStack in 10 minutes with Devstack18:35
*** changbl has quit IRC18:36
anteayacool18:40
*** arnaud___ has joined #openstack-infra18:40
anteayahow long is the time slot for a "presentation"?18:40
anteayaI have to make_a_new_account and don't think I can fill 40 minutes on our election process18:40
fungiyou could probably go into greater detail on other parts of our project governance besides just the elections18:41
openstackgerritDerek Higgins proposed a change to openstack-infra/devstack-gate: Set default for DEVSTACK_GATE_USE_APACHE  https://review.openstack.org/9164618:42
anteayamy brain is foggy, I haven't had a decent night sleep in weeks (you don't want to know) can you elaborate?18:42
anteayaperhaps I am so close to it I can't see what others might want to know about18:43
*** thedodd has joined #openstack-infra18:43
*** arnaud__ has quit IRC18:44
fungiwell, you could talk about how the subprojects self-organize to govern things like code review, documentation, translations and so on18:44
fungiat levels below the more visible ptl/tc strata18:44
*** e0ne has quit IRC18:45
fungior you could talk about the foundation board elections as well and how the election model differs, what's been going on with the efforts to change that and the current challenges faced18:45
anteayaah yes18:46
anteayahmmmm, might steer away from the board level18:46
fungiit is a sticky wicket18:46
anteayaI am sure there are better informed folks than myself to address that18:46
anteayaI need less sticky18:46
anteayaso the self-organizing bit sounds good18:46
*** e0ne has joined #openstack-infra18:47
anteayaI'm so immersed in it, i don't know other projects don't do it18:47
anteayabut you are right, that would be good to talk about as well18:47
anteayathanks fungi18:47
*** zns has quit IRC18:47
fungiin that case an interesting bit might be the new specs-as-code-review experiment/movement18:47
fungias well, as the fact that our governance documents are now starting to get managed as code review18:48
anteayahmmmmm, I can hand-wavey it in and then assess how much time it gets, based on my understanding, when I go to talk18:48
anteayayes, I like that we have a governance repo18:48
anteayayou are great at this18:49
funginot really. if i were great at it i wouldn't have been procrastinating about submitting an abstract ;)18:49
*** zns has joined #openstack-infra18:49
anteayaI'm out of excuses for not putting in a talk submission18:49
anteayafungi: tell me about what you would like to talk about18:49
*** yfried has joined #openstack-infra18:49
*** changbl has joined #openstack-infra18:50
fungieh, something which won't compete with anyone who already submitted talks they want to give. i'm happy to be filler ;)18:58
fungiwhich is why i'm curious who/what's already submitted so i don't step on their toes at the last minute18:59
anteayaI think you have lots of options19:01
*** e0ne has quit IRC19:01
fungiyep19:01
anteayaI for one would like to watch you walk through how you track down problems in our system19:01
*** manishg has quit IRC19:01
anteayayou have a very systematic approach for going through the logs19:02
*** e0ne has joined #openstack-infra19:02
anteayaunfortunatly anything on servers is hidden19:02
anteayaso how zuul jenkins and nodepool all talk to each other19:02
anteayaI would like to see that from a persepective of sifting through the logs19:02
anteayawhat ever you talk about I hope you include code19:03
*** rcarrillocruz has quit IRC19:03
fungiwell, the infra overview already got presented at linuxcon-na last year, so probably best not to repeat that one ;)19:05
*** e0ne has quit IRC19:05
anteayathey system has changed a bit since last year19:05
*** e0ne has joined #openstack-infra19:05
fungioh, actually that's the zuul deep-dive, not the infra overview19:06
fungibut there's a fair amount of overlap19:06
*** andreykurilin_ has joined #openstack-infra19:06
*** rcarrillocruz has joined #openstack-infra19:07
*** dkliban_afk is now known as dkliban19:07
*** maxbit has quit IRC19:10
anteayaI haven't memorized all the presentations maybe19:11
anteayahas their been a nodepool deep dive slidedeck yet?19:11
openstackgerritBen Nemec proposed a change to openstack-infra/config: Add dib-utils project  https://review.openstack.org/9028119:11
*** manishg has joined #openstack-infra19:11
funginot yet, though i question my availability to write one between now and then19:12
*** marcoemorais has quit IRC19:15
anteayafair enough19:15
anteayathey want slides submitted a week in advance19:15
anteayaha ha ha19:15
*** marcoemorais has joined #openstack-infra19:21
notmynameanteaya: is there a list of current PTLs anywhere?19:26
*** andreykurilin_ has quit IRC19:26
notmynameanteaya: ah, I see it on an election result page (not findable on a search, though) https://wiki.openstack.org/wiki/PTL_Elections_March/April_201419:27
*** andreykurilin_ has joined #openstack-infra19:27
openstackgerritDerek Higgins proposed a change to openstack-infra/devstack-gate: Add the sbins to PATH  https://review.openstack.org/9165519:28
anteayanotmyname: http://git.openstack.org/cgit/openstack/governance/tree/reference/programs.yaml19:29
anteayanotmyname: yeah I find the wiki search unusable19:30
fungianteaya: last time i talked to Ryan_Lane he suggested that a recent patch/upgrade may have caused the search index to stop getting updated19:30
notmynameanteaya: I was looking under https://wiki.openstack.org/wiki/Governance (where the TC has a list, along with details about BoD and UC)19:30
anteayafungi: cool, that would help things19:31
fungianteaya: for example https://wiki.openstack.org/w/index.php?title=Special%3ASearch&profile=default&search=openstack-ci-admins&fulltext=Search19:31
*** Ajaeger has quit IRC19:31
fungithat returns a couple of results i removed from articles a month or two ago19:31
anteayafungi: awesome19:31
fungithat search should have been returning zero results for a long time now19:32
anteayanotmyname: I wouldn't want to make changes to the Governance wiki page without having a chat with ttx first19:32
anteayasince it would be him maintaining it19:32
anteayahe has mused about scraping governance/programs.yaml for wiki updates19:32
anteayaI can mention it to him when he is back next week19:33
*** eharney has quit IRC19:33
anteayaI use the governance repo as the canonical source19:33
fungihttp://git.openstack.org/cgit/openstack/governance/tree/reference/programs.yaml does seem to be current as of the most recent elections19:33
anteayabut the info should be deseminated better, I do agree19:33
anteayaApril 16th it was updated, yes19:34
*** zehicle_at_dell has quit IRC19:37
*** ihrachyshka has joined #openstack-infra19:38
portantejeblair, is there a way to try out https://review.openstack.org/91424 prior to accepting the commit?19:43
*** marcoemorais has quit IRC19:44
*** marcoemorais has joined #openstack-infra19:45
*** nati_ueno has quit IRC19:45
fungiportante: you could launch a plain ubuntu 12.04 lts vm, grab openstack-infra/config, use install_jenkins_slave.sh in the root of that repo to set up the system with our usual bits, then check out swift and try to 'tox -e func'19:46
*** jaypipes has quit IRC19:48
*** e0ne has quit IRC19:48
notmynamefungi: http://b.z19r.com/post/did-you-just-tell-me-to-go-fuck-myself ;-)19:48
*** e0ne has joined #openstack-infra19:48
funginotmyname: bwahahaha19:48
*** zhiyan_ is now known as zhiyan19:49
*** maxbit has joined #openstack-infra19:53
*** schofield has joined #openstack-infra19:55
*** schofield has quit IRC19:56
*** schofield has joined #openstack-infra19:57
*** khyati_ has joined #openstack-infra19:57
*** packet has quit IRC19:58
*** nati_ueno has joined #openstack-infra19:58
*** bookwar_away is now known as bookwar19:58
*** eharney has joined #openstack-infra20:03
*** schofield has left #openstack-infra20:04
*** markwash has joined #openstack-infra20:04
jeblairportante: heh, thus the 'start off non-voting suggestion'20:05
*** e0ne has quit IRC20:05
portantejeblair: okay, so it is likely that won't gate this getting accepted, then?20:06
jeblairportante: correct, as long as it's non-voting, it should be fine.  i just aprvd it.20:06
*** derekh_ has joined #openstack-infra20:06
portantegreat, thanks20:06
*** annegentle has joined #openstack-infra20:06
mriedemi just hit this in a stable/icehouse patch, but the tests passed, never seen it before: "sub_unit.log was > 50 MB of uncompressed data!!!"20:07
mriedemis that an infra issue?20:07
fungimriedem: there were recent qa checks added to help prevent changes from generating waaaaay too much log noise20:08
*** timrc is now known as timrc-afk20:08
mriedemfungi: hmm, it's a backport from master20:08
mriedemso if it were a problem i'd expect to also see it on master20:08
fungimriedem: not sure if it checks sub_unit.log though... what's the change?20:09
mriedemfungi: https://review.openstack.org/#/c/91635/20:09
fungithis could certainly be something else20:09
mriedemfungi: not just my change http://goo.gl/rTgBwV20:11
fungimriedem: sdague's https://review.openstack.org/85797 merged today20:11
mriedem6 hits today, all stable branches20:11
openstackgerritA change was merged to openstack-infra/config: Add swift "in-process" functional test runs  https://review.openstack.org/9142420:11
mriedemsdague: does that change depend on something in the stable branches for it to not puke all over?20:12
fungimriedem: it's possible nova was already very noisy in icehouse and we should consider only enforcing that on master?20:12
mriedemfungi: sdague: https://bugs.launchpad.net/openstack-ci/+bug/131513820:14
uvirtbotLaunchpad bug 1315138 in openstack-ci "stable backports failing with "sub_unit.log was > 50 MB of uncompressed data!!!"" [Undecided,New]20:14
jeblairthe subunit log _is_ 181M uncompressed; i'm not sure we just want to _ignore_ that20:14
*** timrc-afk is now known as timrc20:15
mriedemjeblair: so i'm not sure what to do here, this is a cherry pick20:16
*** andreykurilin_ has quit IRC20:16
mriedemi have no idea why this particular cherry pick would cause issues either...20:16
mriedemit shouldn't, it's not really a code change20:16
mriedemit's a hacking rule change20:16
*** derekh_ has quit IRC20:17
jeblairmriedem: well as fungi said, it's not this change that is the problem, it's enforcing the rule20:17
jeblairi believe there were some patches merged to fix the log spamminess20:17
jeblairso perhaps we can find them and merge them to the stable branches20:17
fungimriedem: for comparison, the final py27 run for the master version of that change is much, much smaller... http://logs.openstack.org/49/88649/1/gate/gate-nova-python27/6b7f0fb/20:17
mriedemyeah, so have to hunt those changes on master down and cherry pick them first20:18
mriedemi'd argue that https://review.openstack.org/#/c/85797/ shouldn't merge until the log spamming is cleaned up in stable branches also20:18
mriedemhard to enforce the rule otherwise20:18
jeblair27% of the log lines contain the string "stevedore.extension"20:19
fungiit's possible that nova on stable/icehouse has been generating much larger subunit logs for a while and the enforcement numbers were based on master instead20:19
jeblairmriedem: hopefully sdague or mtreinish will know more context20:21
fungisomething was tweaked to make debug loglevel be local to the project and not extend to imported dependencies yeah?20:21
mriedemjogo: ^ you know anything about that on master?20:21
mriedemi remember it vaguely20:21
jeblairjust found I7317092c0a2bad8efd11ece3ba521d58c2acae42 from jogo20:22
fungithat's the one i was thinking of. also looks very safe to backport20:23
mriedemi'll propose it20:23
jeblairalso sdague did I04ff2f0650f1e6035d8de5c5802b96ce4294891b20:23
SergeyLukjanovjeblair, fungi, clarkb, mordred, sdague, I'll be traveling for the next few days, will be available starting from saturday afternoon and completely alive (hopefully) since monday pst (I'll be in CA before the summit)20:24
*** flaper87|afk is now known as flaper8720:24
fungiSergeyLukjanov: i hope someone told you ca is nowhere near the summit ;)20:24
fungisafe travels!20:24
SergeyLukjanovfungi, yup, I know :) google maps told it20:24
jeblairmriedem: the commit msg in the 2nd one indicates both changes are related20:24
SergeyLukjanovfungi, just some work stuff20:24
SergeyLukjanovfungi, thx ;)20:25
jeblairSergeyLukjanov: thanks, sadly, i won't be in ca next week so i won't see you until the summit20:25
mriedemjeblair: thanks, i'll backport them20:25
mriedemjeblair: and then bug the shit out of sdague and jogo if i missed anything :)20:25
*** _david_ has joined #openstack-infra20:25
jeblairmriedem: send them email copies of the log files ;)20:26
_david_jeblair, have a look, please: https://gerrit-review.googlesource.com/5671220:26
anteayafungi: here is the content of my proposal thus far: https://etherpad.openstack.org/p/Ig9fEfzRQC20:26
jeblair_david_: cool idea!20:27
SergeyLukjanovjeblair, oh, ok :)20:27
_david_jeblair, the idea is to (ab-)use magic branch to implement wip stickeness: git push wip20:27
mgagneanteaya: She is a Gerrit  upstream contributor :D20:27
_david_jeblair, that way we could seamlessly extend git-review to support it ;-)20:28
anteayamgagne: I am20:30
anteayawhat the heck was it, oh yeah "the"20:30
*** khyati_ has quit IRC20:30
anteayaa doc was missing a "the"20:30
anteayawooo20:30
*** annegentle has quit IRC20:30
bknudsoncan we disable a check job for stable/icehouse? any examples?20:32
fungianteaya: lgtm. i'd attend that!20:32
mgagnebknudson: disable or mark as non-voting ?20:32
anteayafungi: thanks20:33
*** ihrachyshka has quit IRC20:33
anteayacopy/pasting then pressing send20:33
*** _david_ has quit IRC20:33
bknudsonmgagne: there's no point to running the rally job on stable/icehouse for keystone since it was only set up for juno20:33
bknudsonit's already nonvoting20:33
mgagnebknudson: =)20:33
fungibknudson: you specify a branch name or regular expression20:34
*** SumitNaiksatam has quit IRC20:34
fungibknudson: in the same place where you set voting20:34
fungibknudson: you should see tons of examples there in the jobs list within layout.yaml20:34
bknudsonok, will take a look20:35
*** rfolco has quit IRC20:35
jeblairhuh20:35
anteayasubmitted20:35
fungibknudson: a lot of them set negative lookahead matching on the branch(es) which are undesirable, so they're be skipped20:35
anteayanow i just have to remember to give them slides the week prior20:35
jeblairno wonder they were confused about landin the rally jobs20:35
anteayajeblair: what do you use to create the slides that go in the presentation repo?20:36
jeblairapparently we have already landed two of them20:36
mriedemjeblair: jogo: sdague: fungi: mega backport https://review.openstack.org/#/q/status:open+project:openstack/nova+branch:stable/icehouse+topic:bug/1315138,n,z20:36
*** adalbas has quit IRC20:36
fungijeblair: yeah, i approved one the other day where the ptl of the project in question had already +1'd it (and after discussing the details of the tests, and that they're mainly contained within the projects being tested)20:37
fungithough it didn't come to light that they were only written to run on specific branches20:38
jeblairfungi: yeah, i had a few objections to the one i reviewed: a) no ptl weigh in, b) i thought it should start in experimental, c) not keen on gating openstack projects on stackforge projects20:38
jeblairc isn't _technically_ an issue yet, but it's a matter of setting expectations.20:39
fungiright, c) worried me less since it was non-voting check only and the job duration is primarily under the control of the project being tested (depends on the scope of tests they implement in their project)20:39
*** andreaf has quit IRC20:39
openstackgerritMichael Krotscheck proposed a change to openstack-infra/storyboard: Added priorities to tasks  https://review.openstack.org/9167520:41
jeblairthe bad news is that the primary key for the approvals table is composed of 4 fields20:41
jeblairthe good news is that both it and the timestamp field appear to have the same definition20:41
jeblairhttps://etherpad.openstack.org/p/gerrit-2.8-reviewstats20:42
jeblair(in the old and new gerrit dbs)20:42
jeblair(i bolded the diffs)20:42
fungioh, and they dropped a key in the new schema20:45
fungia secondary key anyway20:47
*** mbacchi has quit IRC20:47
*** lakshmi has quit IRC20:48
fungii can kind of see the reasoning behind updating that timestamp on change. i think the one i took most exception to is that the change creation timestamp in the changes table had on update set as well, and i couldn't fathom why you'd ever update the creation date20:49
*** e0ne has joined #openstack-infra20:49
*** adalbas has joined #openstack-infra20:49
jogomriedem: that isn't so big20:49
jogomriedem: I like how you have the explication marks in the bug title20:50
mriedemjogo: just copy/paste from the log message :)20:50
*** yfried has quit IRC20:50
jogomriedem: oh hehe20:50
mriedemTHE SKY IS FALLING OMFG!!!20:50
mriedemjogo: that's failing on stable/havana also...not sure how though since your debug logging stuff didn't get into havana20:51
mriedemunless it's neutron jobs failing on havana, i didn't check20:51
SpamapSWhere would be the best place to report bugs regarding the new skin for gerrit?20:52
jogomriedem: hmm  it could be log related but not sure20:52
*** e0ne has quit IRC20:52
*** lakshmi has joined #openstack-infra20:53
jeblairSpamapS: if it's a css thing, probably openstack-ci on lp.20:53
jeblairSpamapS: (it might be our fault, or we might be able to fix it; if neither of those apply, then upstream gerrit.)20:54
SpamapSjeblair: in this case, the "Report Bug" link is _really_ close to the => arrow on listings20:55
SpamapSjeblair: I click it about 10% of the time :-/20:55
*** e0ne has joined #openstack-infra20:56
SpamapSironically, I was pretty sure that is our CSS, and so that particular "Report Bug" link is not the one I want. ;)20:56
jeblairSpamapS: https://gerrit-review.googlesource.com/#/q/status:open20:56
SpamapSalso the project name link in reviews used to take you back to open reviews for the project, but now takes you to the completely worthless project description page... _that_ seems like a gerrit bug20:56
jeblairSpamapS: upstream has the too-close-link bug too20:57
*** e0ne has quit IRC20:57
SpamapSjeblair: ahh good20:57
jeblairSpamapS: you might want to file both of those as upstream bugs; we might be able to fix the report-bug closeness by doing more local css customization, so maybe also file that locally (or just fix it :)20:57
*** e0ne has joined #openstack-infra20:57
SpamapSwill report upstream then20:57
SpamapSjeblair: before I run off and report another one.. are we also looking to widen the comment boxes so that jenkins results don't wrap?20:58
jeblairSpamapS: where?20:59
jeblairSpamapS: (link to change illustrating problem)20:59
jeblairfungi: though the interpretation of category_id has changed :(21:00
jeblairbut i have to write a script anyway, so i can map21:00
SpamapSjeblair: never mind, they're already wider since I looked yesterday. ;)21:00
*** e0ne has quit IRC21:01
SpamapShttps://code.google.com/p/gerrit/issues/detail?id=2631 upstream bug about Report Bug proximity to =>21:02
SpamapShttps://bugs.launchpad.net/openstack-ci/+bug/1315151 openstack-ci version of same report21:03
uvirtbotLaunchpad bug 1315151 in openstack-ci "Report Bug is very close to "next page" link in change listings" [Undecided,New]21:03
*** david-lyle has quit IRC21:03
*** andreaf has joined #openstack-infra21:04
jeblairSpamapS: so i have 1216846 rows i need to update...21:05
jeblairSpamapS: like:21:05
jeblairupdate patch_set_approvals set granted='2011-11-23 17:04:14' where change_id=1861 and patch_set_id=2 and account_id=112 and category_id='Code-Review';21:05
jeblairSpamapS: do you have any suggestions about the best way to go about that?21:06
*** ramashri has joined #openstack-infra21:08
jeblairfungi: it's possible these entries may have legitimately changed since then (if a user clears and then re-sets a vote to the same value)21:09
SpamapSjeblair: is the only way you can identify them by PK?21:09
jeblairfungi: as we have found -- if a user just re-votes with the same value, it will not update the timestamp.  that seems the most likely case, the other one seems less likely.21:09
jeblairSpamapS: yeah, see the schema(s) at the bottom of https://etherpad.openstack.org/p/gerrit-2.8-reviewstats21:10
SpamapSjeblair: http://dev.mysql.com/doc/refman/5.5/en/load-data.html might be interesting to you21:10
jeblairalso, some of these rows may have been deleted; and i think we just want to ignore that case.21:10
SpamapSjeblair: note that LOAD DATA INFILE corresponds exactly with SELECT INTO OUTFILE21:11
jeblairSpamapS: however, if rows don't exist, we don't want to re-create them21:11
jeblairSpamapS: so load data probably isn't what we want in this case21:12
SpamapShttp://dev.mysql.com/doc/refman/5.5/en/load-data.html21:13
SpamapSdoh sorry21:13
sdaguejeblair: where is the granted ts coming from?21:14
SpamapSjeblair: so I'd create a new table, and then delete using an outer join.21:14
jeblairsdague: old database21:14
*** matty_dubs is now known as matty_dubs|gone21:14
*** smarcet has quit IRC21:15
sdaguecan you load it in a 2nd table in the new db, then subselect that field?21:15
sdagueit won't be fast, but it will be what you want21:16
SpamapSjeblair: so,   on the old database, select into outfile.. new database.. create table new_thing like old_thing; .. load data infile into it.. delete new_table from new_table outer join old_table on .. where old_table.pk is null ... is my short hand making sense?21:16
SpamapSjeblair: finally select into outfile from new_table .. load data infile into old table21:17
jeblairSpamapS: how complicated is that if pk is 4 fields?21:17
*** jamielennox|away is now known as jamielennox21:18
*** thomasem has quit IRC21:19
SpamapSjeblair: just 4 part joins instad of 1 part. as complicated as writing update queries with 4 part where's.21:19
*** miqui has quit IRC21:19
*** jgrimm has quit IRC21:20
jeblairk21:20
SpamapSactually the last part might not need load data / select outfile ... update .. select is a thing.21:21
jeblairi think the thing to decide now is what to do in the case of "If a user has deleted their vote, then left a new one of the same value, we won't be able to tell."21:21
jeblair(a) ignore the issue and let the script overwrite it to the value of their pre-migration vote21:21
jeblair(b) attempt to identify the time range of inproperly updated records and only adjust records with timestamps within that range21:21
jeblairfungi, sdague: ^ opinions?21:22
*** sweston has quit IRC21:22
*** bookwar has left #openstack-infra21:22
*** flaper87 is now known as flaper87|afk21:23
sdaguehonestly, I'd be fine with a)21:23
sdagueit seems like the level of history corruption is very low there21:24
*** zhiyan is now known as zhiyan_21:24
SpamapShow does one even delete their own vote?21:25
jeblairokay, then i think we can use SpamapS's idea (after we translate the category ids; i can just do that on the intermediate data file directly)21:25
jeblairSpamapS: little X next to your name, or change it to something else then change it back will produce the same result for this issue.21:26
*** dkranz has quit IRC21:26
*** e0ne has joined #openstack-infra21:26
*** changbl has quit IRC21:27
jeblairSpamapS: how do i do that without local filesystem access on the database server?21:27
jeblair(yay trove!)21:27
SpamapSjeblair: load data local infile21:29
SpamapSjeblair: select into outfile.. hm21:29
*** adalbas has quit IRC21:30
SpamapSjeblair: ahh! the mysql client will spit it out in the right flavor of csv I think21:31
SpamapSjeblair: so mysql -e 'select ...' --silent > textfile21:31
mordredola21:32
jeblairSpamapS: cool, thx21:33
*** manishg has quit IRC21:33
*** pdmars has quit IRC21:34
openstackgerritA change was merged to openstack-infra/config: Adds insecure option to launch_node.py  https://review.openstack.org/8669021:35
*** homeless has quit IRC21:35
*** aysyd has quit IRC21:35
*** zns has quit IRC21:37
portantejeblair: fyi, in-process func tests can use run-unittests.sh, it takes a "version" for the first argument, not a pure environment21:37
portanteso if we had yaml setup that used run-tox.sh that would work21:38
*** dangers is now known as dangers_away21:38
portantebut I'll have to look at this later21:38
jeblairportante: i think we do21:38
portantethanks for the help anyway, see http://logs.openstack.org/78/87078/4/check/gate-swift-unittests-func/8ce760f/console.html21:38
jeblairSpamapS: actually, your shorthand isn't making sense21:38
jeblairSpamapS: can you spell it out a bit more at the bottom of https://etherpad.openstack.org/p/gerrit-2.8-reviewstats ?21:38
jeblairSpamapS: particularly, i think you changed some metavars in your shorthand (not sure what happens to the table "new_thing"21:39
jeblairSpamapS: i'm not as concerned about the specific query syntax as i am in understand which things you think should be done to which tables and in what sequence21:40
SpamapSjeblair: yeah I did not think it through :) will add to etherpad21:40
openstackgerritA change was merged to openstack-infra/config: Move dsvm-virtual-ironic out of experimental  https://review.openstack.org/9045221:41
*** adalbas has joined #openstack-infra21:43
mordredSpamapS: why not just mysqldump -hold_gerrit reviewdb patch_set_approvals > psa.sql ; mysql -hnew_gerrit_trove -e 'create schema fixthings' ; cat psa.sql | mysql -hnew_gerrit_trove fixthings ?21:46
SpamapSjeblair: ok21:47
*** changbl has joined #openstack-infra21:48
mordredSpamapS: and then do a multi-table update query with a join between the two so yo're just updating the ts columns and setting them to the values in the old table?21:48
SpamapSmordred: we'd need a --where in there.. but yeah that could work21:48
SpamapSmordred: probably a lot simpler. We started from a very different place than we finished. :)21:48
SpamapSjeblair: anyway, my now exposed as overly complex instructions are at the bottom of gerrit-2.8-reviewstats ...21:49
mordredupdate new_psa n, old_psa set n.ts_field = o.ts_field where o.key1 = n.key1 and o.key2 = n.key2 ...21:49
jeblairSpamapS: woo!  thanks21:49
SpamapSYeah there's only one column that needs updating isn't there?21:49
jeblairSpamapS: yeah21:49
mordredSpamapS: I get the benefit of swooping in and reading all of your work21:49
SpamapSok so let's go to the better idea..21:49
*** bhuvan has quit IRC21:49
jeblairmordred: you want to spell that out in the etherpad?21:49
mordredjeblair: I think SpamapS is about to21:50
jeblairk21:50
*** ArxCruz has joined #openstack-infra21:50
*** zehicle_at_dell has joined #openstack-infra21:51
*** aconrad has quit IRC21:51
fungii step away to cook dinner and suddenly so many pings in scrollback21:52
*** adalbas has quit IRC21:52
mordredfungi: NEVER EAT AGAIN!!!21:52
lifelesssphi21:52
mordredjeblair: the better idea SpamapS is writing out can also be tested in a local db too, to make sure the update query is right21:52
mordredjeblair: you know, load a dump of the two tables into local schemas21:53
*** mburned is now known as mburned_out21:53
mordredlifeless: that's one of the odder things you've ever said21:53
jeblairmordred: yeah, i was planning on doing that regardless.  so far i've learned my version of mysql doesn't support load data local infile.21:53
fungi1.2 million rows before breakfast21:54
SpamapSmordred: ok, look now..21:54
SpamapShttps://etherpad.openstack.org/p/gerrit-2.8-reviewstats21:54
SpamapSjeblair: ^ better idea done21:54
*** bhuvan has joined #openstack-infra21:55
mordredjeblair: that's because load data local infile is a security fisk21:55
fungijeblair: still catching up, but perhaps the "problem" updates all have the exact same timestamp rather than that time or newer21:55
*** marun has quit IRC21:55
lifelessjogo: jelmer, jml, uhm need to check the acls to remember who else21:55
SpamapSjeblair: did load data local infile get removed finally?21:55
mordredSpamapS: do you really need the edit things step?21:55
SpamapSwhy hasn't mysql just copied the postgres COPY command yet?21:55
lifelessSpamapS: 'oh hi'21:55
jeblairfungi: it's a range.21:55
SpamapSmordred: I don't know21:55
SpamapSmordred: I got the feeling jeblair didn't want to revert _ALL_ of the votes21:55
mordredI don't think you do21:55
*** marun has joined #openstack-infra21:55
SpamapSlifeless: yo21:56
jogolifeless: you can review it right ;)21:56
mordredhow do you select the ones you don't want to revert?21:56
SpamapSdon't know :-/21:56
* mordred fine with whatever - just asking annoying questions21:56
SpamapSthat's for jeblair21:56
jeblairer21:56
jeblairwe only want to update rows that exist21:56
jeblairthat's the only selection criteria21:56
mordredright. that should be handled by the join condition21:57
jeblairthere is an edit step to change the label values21:57
mordredgotcha21:57
jeblairwhich i have written twice now for TSV files, and am about to write a third time for CSV ones :/21:57
openstackgerritBrant Knudson proposed a change to openstack-infra/config: Add stable filter for keystone python33 and rally  https://review.openstack.org/9169021:57
mordredyou could do it as a query after you load the dump?21:57
jeblairmordred: i think so21:57
*** marun has quit IRC21:58
fungii didn't know you could do csv with mysqlclient stdout redirection... only ever knew about tsv21:58
* mordred feels bad he was offline travelling on the day with the fun db queries21:58
SpamapSthats what you get21:59
SpamapSwell that, and jet lag21:59
SpamapSand a mediocre meal22:00
SpamapSand all the orange juice you can drink22:00
*** marcoemorais has quit IRC22:00
fungitang, the drink that went to the moon22:01
jeblairSpamapS, mordred: create database is denied in trove22:01
fungii think you can probably do it from troveclient (though i've only ever done it from the provider's webui)22:02
jeblairi mean, i guess we could use the trove api to make a new db and give the user access22:02
bknudsonI can't WIP my review on stable/icehouse?22:02
*** marcoemorais has joined #openstack-infra22:03
*** dstanek is now known as dstanek_zzz22:03
fungibknudson: work-in-progress is now a workflow -1 vote since the gerrit upgrade22:03
fungibknudson: so review the change and set your workflow vote to -i22:04
bknudsonfungi: I don't have that button -- https://review.openstack.org/#/c/91677/22:04
bknudsonit shows up on this one -- https://review.openstack.org/#/c/91690/22:04
openstackgerritMichael Krotscheck proposed a change to openstack-infra/storyboard-webclient: Added task priority to edit and display of tasks  https://review.openstack.org/9169322:04
*** yfried has joined #openstack-infra22:05
fungioh, interesting... i wonder whether we have an exclusive something set on stable/.* branches22:05
jeblairfungi, mordred: i have granted gerrit2 access to fixthings and reviewdb on the production trove instance22:06
fungijeblair: k22:06
mattoliverauMorning22:08
*** ramashri has quit IRC22:09
mordredjeblair: ++22:11
*** e0ne has quit IRC22:11
bknudsonopened a bug https://bugs.launchpad.net/openstack-ci/+bug/131517822:12
uvirtbotLaunchpad bug 1315178 in openstack-ci "User can't mark stable review as work in progress" [Undecided,New]22:12
*** e0ne has joined #openstack-infra22:12
fungizaro: what's the chance that our exclusive label workflow 0..+1 for openstack-stable-maint group on22:12
fungirefs/heads/stable/* is preventing change owners from setting workflow -1?22:13
fungiand any suggestions on a workaround?22:13
*** markmcclain has quit IRC22:14
mgagneis there an place I can find stats about openstack infra? ie like the number of nodes created per day22:15
*** marcoemorais has quit IRC22:15
fungimgagne: http://graphite.openstack.org/ plus elbow grease22:15
mgagnefungi: could I borrow your elbow? any wiki with pre-defined queries?22:16
fungimgagne: though the graphs at the bottom of http://status.openstack.org/zuul/ provide some great starting points22:16
fungi(protip... see the get params in the urls for those images)22:17
SlickNikjeblair / fungi / mordred: At some point I want to catch up with you guys and get a quick brain-dump on how you're using trove — what's working well, and what's painful / lacking. Perhaps f2f in ATL?22:18
mordredSlickNik: we'd love to give you that feedback :)22:18
fungiSlickNik: i'm pretty sure we have feedback22:19
*** changbl has quit IRC22:19
jeblairmordred: double check what i've been putting in the ep22:19
mordredjeblair: looking22:19
jeblairmordred, fungi: i did those 3 update statements, and i was a little surprised that granted didn't get updated; am i missing something?22:19
fungiSlickNik: any insight into why rackspace trove instances are reachable on 3306/tcp from every tenant in the same region?22:19
jeblair(i thought i was going to have to do granted=granted)22:20
*** lakshmi has quit IRC22:21
*** doug-fish has left #openstack-infra22:22
*** dstanek_zzz is now known as dstanek22:22
*** lakshmiS has joined #openstack-infra22:22
*** lakshmiS has quit IRC22:23
mordredjeblair: that looks like good output22:23
jeblairmordred: any idea why granted didn't update when i ran those update statements?22:23
mordredit says it changed a million rows22:24
mordredwait- when you say "those update statements"22:24
SlickNikfungi: AFAIK they have been using something different from the upstream secgroups extension (which only landed in Havana).22:24
jeblairmordred: no, the 3 update statements above22:24
*** rlandy has quit IRC22:24
mordredI wouldn't expect those to change granted at all22:24
SlickNikfungi: Not sure about the details of that though.22:24
jeblairmordred: then why do we have this problem in the first place?22:25
mordredI would guess something having to do with the restore of the dump22:25
mordredand/or something to do with the data migrations in gerrit22:25
SlickNikjeblair / mordred / fungi: I'll ensure I come find you guys in ATL. :)22:25
mordredlike, part of the upgrade ran data migration scripts22:25
mordredmaybe I should go read those22:26
jeblairmordred: not the dump; the problem hasn't appeared loading data so far, and it did not affect SUMB changes -- those labels didn't update.22:26
fungiSlickNik: good answer to a somewhat rhetorical question (part of our complaints probably stem from a provider's implementation choices)22:26
jeblairmordred: it only affected the rows where lables changed22:26
jeblairmordred: which, of course, is what i'm recreating in those update statements22:26
jeblair  `granted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,22:26
jeblairmordred: ^ i would have thought the problem stemmed from "ON UPDATE CURRENT_TIMESTAMP"22:26
mordredyah. I follow you now22:27
jeblairwhich i thought meant "if this row is updated, always set granted to the current time"22:27
*** bknudson has quit IRC22:27
*** yidclare has quit IRC22:27
jeblairif we don't have an explanation for why we haven't seen that, then i think i should do another dry run on the trove instance22:28
mordredjeblair: ++22:28
mordredjeblair: also, I'm going to go read the schema migrations22:28
*** lakshmiS has joined #openstack-infra22:28
jeblairi will make a 3rd database on the prod trove instance to stand in for reviewdb and dry run again22:29
*** aconrad has joined #openstack-infra22:29
mgagnefungi: close enough: http://docs.openstack.org/infra/publications/2014-lca-zuul/#(8)22:29
fungiSlickNik: at the moment _my_ biggest concern is simply that we have to mask out the dns names of our trove instances in our otherwise public configuration because anyone who knows the ip address can potentially leverage pre-authentication bugs in mysqld or start trying to brute-force our account credentials (and i'm very much not a fan of "security by obscurity" there)22:30
fungimgagne: those are fairly recent numbers if you're not looking for *current* numbers, yes22:31
mgagnefungi: just wanted to get an order of magnitude, thanks =)22:31
*** marcoemorais has joined #openstack-infra22:32
*** prad has quit IRC22:33
jeblairfungi, mordred: we need to fix mysql backups on review.o.o (they aren't happening because of the incorrect defaults file)22:36
jeblairafter we do that, we should check/fix bup.22:37
fungioh, great point. the old backups probably assumed a defaults file which pointed at the local mysqld22:38
*** thedodd has quit IRC22:38
sdagueso... do we have a policy around people uploading other people's patches without credit?22:38
sdaguean instance of that just happened in the devstack queue22:38
openstackgerritJoe Gordon proposed a change to openstack-infra/elastic-recheck: Remove Closed bugs that haven't been seen in two weeks  https://review.openstack.org/9169522:38
anteayasdague: not so much policy that I know but frowning certainly22:39
fungisdague: uploading someone else's work withouit credit shouldn't require a policy. it's just flat-out wrong22:39
sdagueyes, once it was pointed out I changed my -1 to a -222:39
jeblairsdague: link?22:40
sdaguehttps://review.openstack.org/#/c/90965/ is the review in question22:40
*** wenlock has quit IRC22:40
fungicopyright infringement is illegal in most jurisdictions22:40
fungi"don't break the law" probably doesn't need encoding in policy22:40
anteayaah sorry, i was meaning someone committing on behalf of someone else, not theft22:41
*** jhesketh has quit IRC22:41
sdaguethat's fine, I wasn't sure if we had some more gentle redirection22:41
anteayayeah, I think there is already policy on outright stealing someone else's work22:41
anteayaI think someone who does this has moved beyond the gentle redirection stage22:42
cody-somervilleIt may be a mistake.22:42
jeblairyeah, let's not go overboard22:42
sdagueyeah, agreed22:43
jeblairit's worth noting that the original patch had no copyright information22:43
sdaguewell, it doesn't need to22:43
jeblairwhich means there was no authorship information to remove as far as that goes22:43
fungiwell, keep in mind that different cultures place different levels of value on "intellectual property"22:43
cody-somervillePlus it's probably not copyright infringement either. The other patch was submitted under CLA. Attribution is not required by Apache license.22:43
*** gondoi is now known as zz_gondoi22:43
sdaguecody-somerville: sure, though it is a CLA violation22:43
sdaguehttps://review.openstack.org/static/cla.html - #522:43
jeblairsdague: i'm not saying it needed it, i'm saying that the second person may not have violated the license22:43
sdaguesure, I don't actually want to flame the person. I was just trying to figure out if we had a more general education in "don't do that"22:44
*** marcoemorais has quit IRC22:44
sdaguealready sorted out22:44
fungii tend to assume ignorance rather than malice, however it does need crediting if it merges in my (personal) opinion22:44
sdaguethe original contributor emailed me and was pretty mad about it22:45
anteayaabout what part of it?22:45
sdaguethat it was his work22:45
fungia "co-authored-by" header in the commit message might have averted all of that22:45
sdaguewith no reference ot it22:45
sdagueyeh22:45
anteayaright, that makes sense22:45
*** marcoemorais has joined #openstack-infra22:45
sdaguewhich is all fair22:45
anteayahas the author of the second patch said anything?22:45
sdaguenot yet22:45
sdagueI just got the email an hour ago22:46
*** marcoemorais has quit IRC22:46
anteayamakes sense22:46
sdagueso it's all late breaking22:46
jeblairthe way the project operates things like oslo, however, goes to show that as a project we don't actually value git-level attribution very much22:46
anteayaI would be interested to hear his perspective, if he shares it22:46
sdaguehonestly, if you haven't been steeped in open source for a long time, copyright nuances escape most people. Especially under a certain age22:47
fungigently pointing them toward the co-authored-by header discussed at https://wiki.openstack.org/wiki/GitCommitMessages#Including_external_references is probably warranted22:47
*** marcoemorais has joined #openstack-infra22:47
cody-somervilleAlthough I'd probably be inclined to credit the other author in some way, the original change was abandoned and it would be a shame if the wrong message was given that you can't pick up abandoned changes and continue with them.22:47
sdagueso trying to figure out the best education path22:47
anteayaI think in these circumstances direct communication with the original author is called for22:48
anteayaat least an attempt to email the person22:48
anteayathat is why there is an email in every git commit22:48
*** rahmu has left #openstack-infra22:49
openstackgerritA change was merged to openstack-dev/specs-cookiecutter: Add optional spell checker target  https://review.openstack.org/8807222:49
cody-somervillefungi: ++ on sending link to that discussion.22:49
fungicody-somerville: i'm tempted to support amending the (new in gerrit 2.8!) abandon control acl to all registered users. the problem is that i believe it would allow people to abandon the patches of others as well. maybe an upstream bug to allow others to adopt abandoned changes is in order22:49
cody-somervillemaybe we should move back to bzr and then the original history will be preserved ;)22:50
fungii envision an "adopt this change" button on abandoned changes, which also solves the problem of conveying the change owner field to another account too22:51
jeblaircody-somerville: i realize you are not serious, but nonetheless, i don't see how that would help....?22:51
*** sacharya has quit IRC22:52
sdaguefungi: that would be a great feature22:52
*** andreykurilin_ has joined #openstack-infra22:52
cody-somervillejeblair: They'd bzr clone the other person's change, make their commits, push it up for review. Those changes get merged into trunk as one commit but the history of the branch submitted remains "inside" that single commit.22:52
jeblair(the only thing you lose by not being able to adopt an abandoned change is the review history, which is not something that is in either scm)22:53
jeblaircody-somerville: you can do that with git too; just change the change-id and push up a new patchset.  which is not entirely dissimilar to what happened here.22:53
fungijeblair: well, with normal workflows, the change author would also remain as it had been originally unless you reset it22:53
fungibut yes, changing the change-id would also get you the same22:53
cody-somervillejeblair: that's just a single commit. with bzr the original separate commits would be retained in the history. You wouldn't use commit --amend with bzr.22:54
fungibazaar is bizarre22:54
cody-somervilleon the target branch, you'd just see a normal single commit22:55
jeblaircody-somerville: we're kind of comparing apples and oranges here; you're suggesting that things about gerrit's workflow would be solved by using bzr22:55
jeblaircody-somerville: git (and even gerrit) can certainly support merging branches22:56
jeblairwe have chosen quite deliberately not to do that22:56
jeblair(except in unusual circumstances)22:56
cody-somervilleAh. I've only really ever used git with gerrit.22:56
jeblairbecause of the way we want the history to look22:56
cody-somervilleYou can get same thing with bzr. It basically smooshes all the commits being proposed into a single one.22:57
*** arnaud___ has quit IRC22:57
cody-somervillebut the actual ancestry, and the individual commits, are still preserved and can be seen if you pass in the right arguments to bzr22:58
fungigit calls that "squash" but yes22:58
fungioh, well it also just concatenates all the commit messages in git when you do that22:58
fungiso not really multi-layered when you squash22:58
sdagueyeh, you could do all the same things with feature branches though22:58
fungimerge commits may indeed be a better analogy22:58
jeblairmordred: aha, i was wrong -- the timestamps were updated,22:59
sdaguebut people don't really want intermediate crap patches in the history :)22:59
jeblairmordred: that reassures me22:59
*** etoews has quit IRC22:59
fungisdague: well, some people seem to think they do (there have been discussions about people who dislike gerrit's requirements around squashing and rebasing and who prefer github's pull requests featuring branches with iterative commits on them)23:00
jeblairfungi: those people don't tend to be reviewers :)23:00
fungii find the github workflow very annoying because, yes, nearly impossible to review sanely23:01
mgagnefungi: "oops, fixed typo"23:01
*** andreaf has quit IRC23:02
mordredjeblair: oh good. except we don't want them updated when we load the dump23:02
jeblairmordred: i think it's the update that does it, and that should be easy t ofix.23:02
fungithere is, after all, a couple decades of experience which has led to the lkml workflow. and as much as new devs tend to complain about how hard it is to get a patch into the mainline linux kernel, it's still around23:02
sdagueright. That's for projects with 1 - 3 developers, where everyone has all the project context in their head all the time :)23:02
mordredjeblair: yah. just alter the column in the old table to not have the on update, yeah?23:02
mgagnefungi: some changes have 40 patch sets, imagine having 40 commits to review in a PR :-/23:02
sdaguemgagne: only 4023:03
mordredoh - which is what you did in the alter23:03
fungimgagne: "can you squash that so i can review it in context?" ;)23:03
cody-somervilleIn launchpad, you review the diff of the branch, not each 40 commits.23:03
sdagueinitial baremetal series was about 30 patches, and got into the 60s on revisiosn23:03
jeblairmordred: no, the alter doesn't seem to do it; just update23:03
fungicody-somerville: so lp does the squash for you. awesome23:03
*** ArxCruz has quit IRC23:03
mordredjeblair: I mean, if you alter the table as you have in the script there to remove the on update clause, then do the alter23:03
mordredit _shoudln't_ update the timestamp at that point, right?23:04
jeblairmordred: i didn't remove the onupdate clause23:04
mordredbah. I just saw the alter on the other column, my bad23:04
*** andreykurilin_ has quit IRC23:04
jeblairmordred, fungi: i updated the etherpad to reflect using 'granted=granted' in the updates23:05
fungicody-somerville: i'll be the first to admit that post-rcs/cvs (and to some extent post-svn) there were several contenders with better models/features compared to git. in the end git won, and is still better than svn, so i'm happy enough to use it ;)23:05
jeblairmordred: er i don't think what you are writing is necessary23:05
fungijeblair: that's basically what we do with the update queries on project renames too23:05
*** andreykurilin_ has joined #openstack-infra23:05
cody-somervillefungi: nice thing is you can see commit message for every change they make in response to reviews plus diff (and just the diff of the commit, so you don't get other cruft in there).23:06
jeblairmordred, fungi: i just dry-ran the current instructions locally and it works23:06
mordredok. cool23:06
fungijeblair: excellent23:06
cody-somervillefungi: but then when it lands, you get the single merge commit23:06
mordredcody-somerville: that's just how the output of the log commands work23:06
jeblairdoing it again on the prod server23:07
cody-somervillefungi: but the intermediate commits can still be found hidden within that merge commit (hence why I even brought this up)23:07
mordredcody-somerville: it's not a difference in the tools themselves. you can configure git to not show the intermediary commits in its log output too23:07
mordredand you can configure bzr to show them all the time23:07
fungicody-somerville: yeah, i get that a commit object is multi-layered there. it's definitely an interesting model23:07
SpamapSI often wonder if keeping all those intermediary commits is one of the reasons git appears so much faster than bzr23:08
mordredpeople in the gh pr model keep the intermediary commits, and the review is done on the diff of the branches23:08
cody-somervilleI think part of the reason git appears so much faster is that there are better/faster places to host other than launchpad ;)23:08
*** signed8bit is now known as signed8bit_ZZZzz23:08
fungicody-somerville: touché23:08
mattoliveraugood old sourceforge did bzr... git still won :P23:09
mordredI think we could have a gerrit-like branch-merge review model that is a mix of both - what we'd be losing is a cleanly bisectable hisotyr23:09
cody-somervillemordred: How?23:09
mordredthe tools could be made to present the diffs for review in the manner consistent with our current review workflow23:09
SpamapSbisect works fine w/ merges last I checked.23:10
fungimordred: well, if you bisect along the branch history and not within the sub-branches, i'm not sure you really lose bisectability23:10
mordredpossibly so23:10
jeblairmordred: this takes me back 2.5 years.  :)23:10
mordredbut git by default flattens it, as cody mentioned23:10
mordredso, by default, you get a thing that looks like each of the intermediary commits is a real thing23:10
sdaguealso, on the anti bzr pov, I'd have to stab you all if we were using it :)23:10
mordredeven though they aren't interesting23:10
*** Alexandra_ has joined #openstack-infra23:11
mordredsdague: be glad you arrived post-switch then :)23:11
cody-somervilleI wish git had a better "ui". :)23:11
cody-somervillebzr was simple and intuitive to use for the most part.23:11
mordredcody-somerville: I actually at this point think git's ui is 1000000000 better23:11
sdaguemordred: yes, very much so23:11
mordredbut it does have a steeper learning curve23:11
mordredI find going back to bzr very painful now23:11
sdaguecody-somerville: I've only heard that ever said by people that spent forever with bzr :)23:11
mordredeven though I was a fanboi for quite a while23:11
fungii still know darcs and hg worshippers too23:12
sdaguehg at least has a reasonable size community around it23:12
* SlickNik wonders if he should throw hg into the mix 23:12
*** SumitNaiksatam has joined #openstack-infra23:12
mordredI think the python community obsession with it will keep it around for a while23:13
jeblairmordred, fungi: testreview db on prod trove has final test version of patch_set_approvals table.  want to double check it?23:13
mordredjeblair: looking23:13
fungijeblair: looking23:13
*** jhesketh_ has joined #openstack-infra23:13
sdaguemordred: probably, though this paints a pretty clear picture - http://redmonk.com/sogrady/2013/12/19/dvcs-and-git-2013/23:13
*** jhesketh_ is now known as jhesketh23:14
jheskethMorning23:14
fungijeblair: did we have any examples of the incorrectly updated patchset approvals in prod?23:14
jeblairfungi: the etherpad has one23:15
mordredjeblair: I see a mix of Code-Review style and SUBM in the table23:15
*** zns has joined #openstack-infra23:16
mordredjeblair: does SUBM need to get changed too?23:16
jeblairmordred: check out line 118 in the etherpad23:16
fungimordred: i think that's expected23:16
mordredossum23:16
jeblairmordred: those are the values in the current db (short answer, no, subm stays the same)23:16
mordredthanks23:16
mordredthat's great.23:16
clarkbhg is terrible. bzr > hg. that is all back to afk23:16
fungiclarkb: go back to your vacation. i DID NOT see you in here23:17
jeblairthere's no arguing with that :)23:17
openstackgerritA change was merged to openstack-infra/elastic-recheck: Remove Closed bugs that haven't been seen in two weeks  https://review.openstack.org/9169523:17
*** mikal is now known as stillbert23:18
mordredclarkb: ++23:19
fungianyway, we should all just be thankful. i have a friend who runs infotech at epic games, and he has to support their perforce revision control server cluster23:19
*** moted has quit IRC23:20
fungipretty much all he does is whine about how he wishes they could just switch to *any* modern open/free-developed dvcs23:20
mordredjeblair: it looks good to me23:20
mordredjeblair: there are old timestamp values, and there are also tiemstamp values still from today23:20
jeblairmordred: since i've done all the steps to test, there's no reason i can't just run the last step again changing the schema name to reviewdb, right?23:21
mordredjeblair: that's right23:21
jeblair(to do it for realz)23:21
*** melwitt has quit IRC23:21
jeblaircool23:21
jeblairjust waiting on the go from fungi (no rush)23:21
fungijeblair: i'm still staring. i switched computers so took me a minute to re-find the etherpad23:22
fungievening and all23:22
morganfainbergjeblair, clarkb, ping wanted to ask if there was a serious issue if keystone under mod_wsgi produced a slightly different format for the log.  notably, apache 2.2 prepends some... data that can't be customized to the log line23:22
mordredmorganfainberg: got examples?23:23
morganfainbergmordred, yeah [Thu May 01 16:22:52 2014] [error] 2014-05-01 16:22:52.092 32280 DEBUG keystone.common.wsgi [-] arg_dict: {} __call__ /opt/stack/keystone/keystone/common/wsgi.py:18123:23
Alex_GaynorSo there's a revision at the top of the gate pipeline, and one if it's jobs hasn't started, and there's no obvious reason why not23:23
SpamapSfungi: Perforce was really awesome. 10 years ago. :)23:23
morganfainbergmordred, that is w/ apache, w/o take the [<datestamp>][error] off23:23
mordredmorganfainberg: wow. it's so nice of it to prepend that23:23
SpamapSfungi: I will say, their meld-ish tool did a hell of a lot better showing you "what was yours, what was theirs, what is the common base"23:24
mordredyou can't customize that with logline?23:24
*** imcsk8 has quit IRC23:24
*** asettle is now known as Captain_Kirk23:24
morganfainbergmordred, nope, this is errorlog. 2.4 has the ErrorLogFormat directive that lets you customize23:24
*** imcsk8 has joined #openstack-infra23:24
sdaguewhy is debug in error log?23:24
mordredoh! wait - why wouldn't we just use 2.4 then?23:24
sdaguemordred: need Ubuntu >= 13.1023:24
*** e0ne has quit IRC23:24
mordredgotcha23:24
morganfainbergsdague, all output / debug from the CGIs mod_wsgi etc go to apache errorlog23:25
morganfainbergsdague, customlog (accesslog?) is meant for request/response etc info23:25
sdagueso I feel like in this situation you really shouldn't be just printing to stdout23:25
*** Captain_Kirk is now known as SettleDown23:25
sdagueinstead should have a dedicated log file23:25
sdagueis that an option with wsgi?23:26
morganfainbergsdague, that was the next step to try, i am pretty sure i can, but, it means the screen log watcher will need to be fixed in devstack in this case23:26
*** imcsk8 has quit IRC23:26
sdaguesure23:26
morganfainbergsdague, not a big deal, but was asking the path of least resistance :)23:26
*** imcsk8 has joined #openstack-infra23:27
fungijeblair: apologies for the delay. the test table lgtm23:27
sdaguebut I think the volume of log data we do, real people would not appreciate that in their apache error_log23:27
morganfainbergsdague, i expected to need to fix some logging stuff in these cases23:27
fungijeblair: select * from patch_set_approvals where change_id=51114; shows granted as circa 2013 for all votes23:27
morganfainbergsdague, well it is an isolated error log specific to keystone (we run it in a vhost) so only keystone logs are in there23:27
fungiwhich is as it should be23:27
morganfainbergsdague, not the global errorlog23:28
jeblairAlex_Gaynor: unfortunately, logging that would answer that question is in a pending change, so i don't have it right now.23:28
sdaguemorganfainberg: ok, fair, still seems weird23:28
morganfainbergsdague, it's how many things run under apache works. i agree, this is something i think i can fix with logging.conf23:28
Alex_Gaynorjeblair: hmm, is there any way to jiggle the switch, or similar so it doesn't block the whole pipeline?23:28
morganfainbergsdague, and consistent logging amkes it easier to point people in the right direction23:28
sdagueyeh, agreed.23:29
morganfainbergsdague, with apache 2.4 (when we move there) i might just make it use errorlogformat...but i'll cross that hurdle when we get to that point23:29
jeblairAlex_Gaynor: yeah, uploading a new patchset to it will kick it out, or we could restart zuul.23:29
sdaguedid the apache issue where logging too much data can stall the server ever get fixed?23:29
sdagueI thought if you write > 4k in one go it goes missing23:30
jeblairmordred, fungi: running the update in prod now.23:30
Alex_Gaynorjeblair: it's not my patch unfortunately, it's just blocking mine :-)23:30
morganfainbergsdague, oh, huh, i remember that bug now.23:30
*** amcrn has quit IRC23:30
jeblairRows matched: 1216479  Changed: 1143230  Warnings: 023:30
morganfainbergsdague, i hope it was fixed... but tbh, haven't tried logging >4k in a long time23:30
mordredjeblair: woot23:30
sdagueyeh, some of those stack traces.... might be interesting :)23:30
morganfainbergsdague, oh.. hmm. might need to funnel this through rsyslog.23:30
morganfainbergsdague, multiple processes trying to write to the same file = bad.23:31
jeblairbnemec: old gerrit approval timestamps have been restored23:31
*** mestery has quit IRC23:31
morganfainbergsdague, i'll work on some stuff to get this going and consistent one way or another, we can discuss further once i get a proposed fix in gerrit.23:31
sdaguemorganfainberg: so honestly, if we are going to use apache this way, then probably you just want to change the log format line for 2.2 and drop the date23:32
jlkclarkb: with j-j-b, have you dealt with creating some sort of singular job grouping, that you can use in a publisher trigger, so that you can trigger one thing, rather than 20?23:32
sdagueI think making rsyslog a requirement for apache is differently od23:32
morganfainbergsdague, oh the keystone log format?23:32
jeblairAlex_Gaynor: i'm trying one more thing23:32
sdagueyeh, then at least you wouldnt' be putting in double dates23:32
sdaguein 2.4 you could fix the apache log23:33
sdaguebut not having subsec resolution is all you give up23:33
sdagueanyway, got to run off and make some dinner23:33
morganfainbergsdague, well we have some time to tune this if we don't like how it comes out. i'll propose that type of fix then.  initially this will be only a nonvote, and if it needs more work we can fix it :)23:33
morganfainbergsdague, ++ sounds good will post that change to devstack tonight (keystone log change under apache)23:34
Alex_Gaynorjeblair: godspeed, and best of luck :-)23:34
*** crc32 has quit IRC23:34
jeblairAlex_Gaynor: nope that didn't work.  i'll restart zuul.23:34
Alex_Gaynorjeblair: funtimes, sorry :-(23:34
jeblairi'm mostly just sorry i don't get to put the logging changes in yet :(23:35
*** hogepodge has quit IRC23:35
jlkclarkb: and is there any way to manage jenkins views from j-j-b?23:35
*** andreykurilin_ has quit IRC23:35
*** luisg_ has quit IRC23:36
Alex_Gaynorjeblair: do we need to "recheck no bug" everything now?23:36
jeblairAlex_Gaynor: yep23:37
*** amcrn has joined #openstack-infra23:37
Alex_Gaynorjeblair: cheers. thanks so much23:37
fungijlk: jjb doesn't configure jenkins views that i'm aware23:37
jlkthat's what I'm seeing.23:38
mordredjeblair: I'm going to submit a change to upstream gerrit to fix the migration23:38
jeblairmordred: wow23:38
*** luisg_ has joined #openstack-infra23:38
fungijlk: we never really made heavy use of views because, for the most part, it was easier to abstract that out to other interfaces23:38
jlkyeah, that's fair. We're using views now, but mostly because we just don't have anything better in front of us23:39
mordredjeblair: beacuse, you know, it's a data loss thing which is kinda bad23:39
jlkI think we're about 2 steps away from directly editing jenkins job builder yaml though, and going to something which can /generate/ jenkins job builder yaml. Not enough programmatic control to be truly DRY.23:39
fungijlk: also, we have 1.5k devs interested in data and don't really want them all logging into the jenkins interface... and then there's the fact that we have 8 jenkins masters now, for scalability reasons23:40
jlkhah yes23:40
fungiso views on one master don't really mean much any more23:40
fungijlk: i'll agree that jjb yaml isn't as dry as it could be. more templating and macro magic in jjb is probably worth investing in23:42
jlkthat and using job names generated in one yaml as data in another yaml23:42
jlke.g. I generate 8 jobs from one yaml, but I want a 9th job to trigger those 8 jobs23:42
jlkso right now I have to enumerate out all 8 jobs in the 9th' yaml23:42
*** bknudson has joined #openstack-infra23:42
fungijlk: ahh, i think zuul was basically an answer to that (among other things)23:43
anteayaI am off to a motel, since I can get no sleep in my house, I will be online once i return tomorrow I have no estimated time for that23:43
anteayanight23:43
fungianteaya: i hope you get some rest23:43
anteayathanks23:43
anteayaI hope so too23:43
fungijlk: zuul now has templates of its own, so adding a template to a project can basically cause multiple jobs to run in various pipelines for any change to a project now23:44
jlkhrm.23:45
jlkwe're not yet into zuul23:45
*** bknudson1 has joined #openstack-infra23:45
fungijlk: just something to keep in mind for if/when you get there23:45
jlkyeah, thanks23:45
mordredhttps://gerrit-review.googlesource.com/56750 in case anyone is interested23:46
*** bknudson has quit IRC23:47
fungimordred: though really, internalizing timestamp management rather than relying on the underlying database to update timestamp fields when you change a row is where sanity can eventually be found23:48
mordredfungi: well, sure23:49
mordredbut I'm not going to write that patch23:49
fungii can understand why ;)23:49
*** oomichi has joined #openstack-infra23:49
*** oomichi has quit IRC23:53
*** ramashri has joined #openstack-infra23:55

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!