Thursday, 2016-05-12

*** lifeless has quit IRC00:46
*** lifeless has joined #storyboard00:47
*** fay_ has joined #storyboard07:01
pedroalvarezhey Zara! I see you have been trying to use Ansible's StoryBoard role08:26
pedroalvarezany luck?08:26
pedroalvarezI was in the process of improving it to make it more robust..08:27
Zarapedroalvarez: hi! :D I got stuck at the `ansible-playbook -i hosts instance-config.yml` step; it said it couldn't find the inventory file09:03
ZaraI'll try to get the exact error up now09:03
*** jtomasek_ has joined #storyboard09:04
*** openstackgerrit has quit IRC09:04
*** openstackgerrit has joined #storyboard09:04
ZaraERROR: Unable to find an inventory file, specify one with -i ?09:05
ZaraI tried in a few different places in case I was running it from the wrong directory, but it gave an error everywhere I tried it09:06
Zarathe readme mentions tweaking vars.yml , but not how, so idk if I need to change something in there09:06
Zaraanyway, more importantly, how was your holiday? :D09:15
pedroalvarezyeah, I may have to improve docs and more things.. :S09:20
pedroalvarezis this something you need to use soon?09:20
pedroalvarezthe trip was great, I needed it :)09:20
Zarapedroalvarez: I'd like to use it (I'm trying to put together a quick operators guide) but I can also try with puppet so it's not urgetn.09:21
Zara*urgent09:21
Zarayay! \o/09:21
Zaraglad it was good09:21
*** jtomasek has quit IRC09:22
pedroalvarezI'll continue the cleanup I was doing, and improve docs as part of it09:22
*** jtomasek_ is now known as jtomasek09:35
Zara\o/11:43
Zarathank you11:43
Zaraaw, my new vm was so new  it didn't have git on it11:44
*** ttx has quit IRC11:56
openstackgerritAdam Coldrick proposed openstack-infra/storyboard: Allow lists of boards and worklists to be paged  https://review.openstack.org/30948112:03
SotKnow not broken and leaky!12:04
Zara:D12:04
persiaSotK: Am I reading that correctly that it now does two SQL queries for every call, one to get the small set being returned, and one to get the full count?12:06
*** ttx has joined #storyboard12:07
SotKyep, I think that it will emit two queries whichever way I do it if I'm paginating using sql (rather than manually paging the result) though12:09
* SotK can squash the two function calls into one, I just based it off how its done elsewhere12:10
persiaI'm mostly curious about the performance.12:11
persiaIf I was handcrafting SQL, I would probably done a subquery (so "select ... numboards as (select ...) ..."), but that might not actually be better, depending on how the DB works.12:12
persiaOn the other hand, if it is done this way in other places, and there's no indication that reducing the number of round trips from the API server to the DB server matters, then I'm just being silly.12:13
* persia vaguely suspects that the expected latency between browser and API server far exceeds expected latency between API server and DB server to such a degree that these sorts of optimisations are useless, after thinking about it a bit12:14
* SotK expects that too12:15
SotKif it turns out to cause significant trouble, we can go through and turn it into subqueries everywhere12:15
persiaProbably worth real investigation before doing that: just because the DBAs who set up the DBs I used to use optimised for that sort of subquery doesn't mean that the DBs being used for SB today are optimised for the same things.12:16
openstackgerritAdam Coldrick proposed openstack-infra/storyboard: Improve the worklist filtering functionality  https://review.openstack.org/31028712:28
openstackgerritAdam Coldrick proposed openstack-infra/storyboard: Improve the board filtering functionality  https://review.openstack.org/31030112:40
*** jseutter_ has joined #storyboard12:49
*** jseutter__ has quit IRC12:50
krotscheckDid anyone do an npm mirror check on storyboard-webclient?13:34
krotscheckhttp://lists.openstack.org/pipermail/openstack-dev/2016-May/094719.html13:34
Zaraoops, don't think so, can check now (thanks for bringing it to our attention; missed the email)13:37
Zaracould be exciting if it deletes everything and I have no way to install it again =D13:38
persiadeleting .npmrc should fix your environment if it breaks from that13:38
Zarathings are installing now... so far just warnings... I think we have a lot of out-of-date things13:42
*** anteaya has joined #storyboard13:58
Zaraseems to have worked fine, warnings but no errors13:58
Zarayup, all is well.14:02
*** fay_ has quit IRC14:03
*** fay_ has joined #storyboard14:08
* Zara hopes she hasn't done anything weird trying to deploy a storyboard instance via puppet14:09
Zarait made users for infra people, so now I'm nervous xD14:10
Zarafinished catalogue run after about 20 mins14:24
ZaraI can see 5 worker processes... not much else14:24
SotKis apache running?14:26
Zaralooking at logs now, I think that's what failed14:26
Zara* The apache2 configtest failed.14:26
Zarasounds like a hint...14:26
Zaragrr, after fixing some things, still getting:15:03
ZaraAH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1. Set the 'ServerName' directive globally to suppress this message15:03
ZaraAction 'start' failed.15:03
pedroalvarezhm...15:04
pedroalvarezrings a bell15:04
Zarawonder where the apache error log lives15:04
pedroalvarez/var/log/apache15:05
SotK/var/log/apache15:05
SotKsnap15:05
pedroalvarez3 seconds? snap?15:05
pedroalvarezboo15:05
SotKhuh, its was 1 second difference for me15:05
pedroalvarez2 seconds of lag? boo15:05
pedroalvarez:)15:06
persiaZara: also check the output of `host 127.0.0.1`15:06
persiaIf that is not a FQDN, something deeper in the config us complicating things.15:06
ZaraI get 1.0.0.127.in-addr.arpa domain name pointer localhost.15:07
Zarathanks, pedroalvarez, SotK15:07
pedroalvarezI think the solution is to add "127.0.0.1 `hostname`" in /etc/hosts15:07
pedroalvarezbut also it looks like that msg is only a warning, and not the real error15:08
Zarayeah15:09
persiaIt should only be a warning, and, yes, that us one way to solve the issue.15:09
ZaraI think the real error is an ssl cert issue15:09
Zarabased on the apache error log15:09
persiaAnother is to have the Apache config bind to a non-local address.15:09
*** fay_ has quit IRC15:11
*** fay_ has joined #storyboard15:11
krotscheckZara: Awesome, thanks for the update.15:41
krotscheckZara The ServerName is a red herring. Shell into your node and try to manually run 'service apache2 start' - it should give you a sane err message. If not, try apachectl configtest15:42
krotscheckAh yes.15:43
krotscheckCert issue.15:43
Zaranp :) yeah.. the purpose was to see if I could fill out a quickstart guide for people wanting to spinup a storyboard instance quickly, but puppet is fiddly and it's near the end of the day... yay, software.15:49
*** jtomasek has quit IRC16:03
Zaratoo warm in this room; I'm falling asleep16:04
* Zara records abject failure in https://storyboard.openstack.org/#!/story/200053516:08
Zaraat least that now records points of failure for both ansible and puppet install, from someone who's new to both16:10
* pedroalvarez stars the story16:13
Zaraheading home soon; too sleepy16:24
* persia wonders why 304565 isn't landing16:26
Zarathe previous patch needs to merge first16:27
Zara(I asked for a commit message amendment to that one.)16:27
Zarasometimes I review more than commit messages, honest16:27
Zara(that is https://review.openstack.org/#/c/304562/)16:28
Zarahaven't got to much review today, unfortunately; has been a puppet day16:29
ZaraI'll try to look at boards pagination tomorrow... and maybe even the task-tracker spec! and and and all the filtering things and... yeah.16:29
persiaAha!  The ordering/stacking bits always confuse me.16:31
persiaThanks for the explanation16:31
Zaranp, my understanding is that anything in the 'related changes' list below a patch needs to be merged before the patch can be. (and things end up laid out like that when commits aren't atomic, so it functions as a patch series, though ymmv for that)16:35
*** jseutter_ has quit IRC16:35
ZaraI'm heading home, anyway, 'night! :D16:37
*** jseutter has joined #storyboard17:59
*** openstackgerrit has quit IRC18:18
*** openstackgerrit has joined #storyboard18:18
*** jtomasek has joined #storyboard18:26
*** jseutter has quit IRC22:50
*** thrace has quit IRC23:23
*** thrace has joined #storyboard23:25

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