Thursday, 2016-05-05

stewie925_hey guys - I have this line of code 'conductor_api.API.heartbeat = Mock()'  declared globally, and I need to initialize conductor_api.API.heartbeat within the setup method00:13
stewie925_how do I correctly initialize this 'conductor_api.API.heartbeat' ?00:13
stewie925_hey amrith :)00:28
amrithhello00:28
amrithso, pmalik has a -100:28
stewie925_that is right00:29
stewie925_oh wait - the one on the review doesnt show my changes yet00:29
stewie925_so I changed those .called_once_with  into  .assert_called_once_with00:29
stewie925_but I dont want to just commit it - so I ran tox test (py27) on my local machine00:29
stewie925_and I am getting those assertion errors that I posted in the reply section,   with pmalik providing his inputs00:30
amrithcan we chat abotu this in the morning?00:31
stewie925_http://paste.openstack.org/show/496115/    shows the changes I made (git diff) showing the assert_called_once_with,  PLUS the error log00:31
stewie925_sure we can :)00:31
stewie925_thank you amrith00:31
amrithI have your email address, I'll email you a phone number, or you can give me a numebr and I'll call you.00:31
stewie925_oh thank you so much!00:31
amrithlet's figure out what's going on with this.00:31
stewie925_you have a good night00:32
amrithemail is on the way ...00:32
stewie925_thanks - pls let me know the best time to call you (I am in Pacific time)00:32
amrithemail is on the way ...00:34
amrithg'night00:34
stewie925_nite :)00:35
*** amit213 has quit IRC00:42
*** cheneydc has joined #openstack-trove00:54
*** amrith is now known as _amrith_01:01
*** _amrith_ is now known as amrith01:02
*** stewie925_ has quit IRC01:10
*** ozialien10 has quit IRC01:12
*** amit213 has joined #openstack-trove01:13
*** amit213 has quit IRC01:16
*** pmackinn has quit IRC02:12
*** tqtran has quit IRC02:19
*** arist has quit IRC02:21
*** arist has joined #openstack-trove02:21
*** amrith is now known as _amrith_02:47
*** cdelatte has quit IRC03:03
openstackgerritPetr Malik proposed openstack/trove: Test alternative MySQL status check  https://review.openstack.org/31278103:49
*** imandhan has joined #openstack-trove03:54
*** imandhan has quit IRC04:00
*** pbelamge has joined #openstack-trove04:06
*** pbelamge has quit IRC04:09
*** pbelamge has joined #openstack-trove04:11
*** imandhan has joined #openstack-trove04:49
*** pbelamge has quit IRC04:59
openstackgerritPetr Malik proposed openstack/trove: Unittests patch 'CONF.datastore_manager'  https://review.openstack.org/30870705:07
*** royoung has quit IRC05:09
*** royoung has joined #openstack-trove05:19
*** openstackgerrit has quit IRC06:03
*** openstackgerrit has joined #openstack-trove06:03
*** mingdang1 has joined #openstack-trove06:10
*** tesseract has joined #openstack-trove06:44
*** tesseract is now known as Guest2128806:45
*** mingdang1 has quit IRC07:01
*** pbelamge has joined #openstack-trove07:21
*** pbelamge has quit IRC07:22
*** pbelamge has joined #openstack-trove07:24
*** imandhan has quit IRC07:26
*** imandhan has joined #openstack-trove07:26
*** imandhan has quit IRC07:31
*** cheneydc has quit IRC07:34
*** cheneydc has joined #openstack-trove07:34
*** jinxing has joined #openstack-trove07:52
*** dmk0202 has joined #openstack-trove07:57
*** dmk0202 has quit IRC08:03
*** dmk0202 has joined #openstack-trove08:11
*** imandhan has joined #openstack-trove08:27
*** imandhan has quit IRC08:32
*** jinxing has quit IRC09:04
*** jinxing has joined #openstack-trove09:06
*** imandhan has joined #openstack-trove09:24
*** imandhan has quit IRC09:28
*** tosky has joined #openstack-trove09:53
*** pbelamge has quit IRC09:59
*** pbelamge has joined #openstack-trove10:00
*** cheneydc has quit IRC10:01
*** _amrith_ is now known as amrith10:21
*** pbelamge has quit IRC10:31
*** links has joined #openstack-trove11:05
*** amrith is now known as _amrith_11:12
*** georgelorch has quit IRC11:46
*** georgelorch has joined #openstack-trove11:46
*** links has quit IRC11:53
*** tellesnobrega_af is now known as tellesnobrega11:57
*** jinxing has quit IRC11:58
*** jinxing has joined #openstack-trove11:59
*** georgelorch has quit IRC12:01
*** georgelorch has joined #openstack-trove12:14
*** mingdang1 has joined #openstack-trove12:20
*** jinxing has quit IRC12:21
*** georgelorch has quit IRC12:36
*** georgelorch has joined #openstack-trove12:39
*** bapalm has joined #openstack-trove12:54
*** tosky_ has joined #openstack-trove13:00
*** _amrith_ is now known as amrith13:03
*** tosky has quit IRC13:03
*** pmackinn has joined #openstack-trove13:40
*** jinxing has joined #openstack-trove13:43
*** openstackgerrit has quit IRC13:47
*** openstackgerrit has joined #openstack-trove13:47
openstackgerritPeter Stachowski proposed openstack/trove-specs: Replication/cluster locality  https://review.openstack.org/29899413:48
*** links has joined #openstack-trove14:07
*** links has quit IRC14:16
*** tosky_ has quit IRC14:22
*** tosky_ has joined #openstack-trove14:23
*** mingdang1 has quit IRC14:26
*** krotscheck has quit IRC14:27
*** krotscheck has joined #openstack-trove14:33
*** imandhan has joined #openstack-trove14:33
*** miqui has joined #openstack-trove14:36
*** cdelatte has joined #openstack-trove14:48
dougshelley66we yup14:57
dougshelley66sorry wrong window :)14:57
*** ayoung has quit IRC14:59
*** stewie925 has joined #openstack-trove15:00
*** ewilson has joined #openstack-trove15:03
*** stewie925 has quit IRC15:09
*** stewie925 has joined #openstack-trove15:09
openstackgerritPetr Malik proposed openstack/trove: Unittests patch 'CONF.datastore_manager'  https://review.openstack.org/30870715:23
*** dmk0202 has quit IRC15:38
*** Guest21288 has quit IRC15:46
*** jinxing has quit IRC15:52
*** georgelorch has quit IRC15:57
*** davideagnello has joined #openstack-trove16:05
stewie925I am encountering an assertion error after changing method name from '.called_once_with' to '.assert_called_once_with'.16:10
stewie925'git diff' and tox py27 test results posted in http://paste.openstack.org/show/496248/16:10
stewie925thank you!16:11
*** imandhan has quit IRC16:12
*** imandhan has joined #openstack-trove16:12
*** imandhan has quit IRC16:16
*** egafford has quit IRC16:19
amrithstewie925, I'll take a look16:29
amriththx16:29
stewie925thanks very much amrith16:29
amrithnp16:30
*** zxiiro has joined #openstack-trove17:14
*** zxiiro has left #openstack-trove17:14
*** tqtran has joined #openstack-trove17:23
*** kuthurium has quit IRC17:24
*** nikhil has quit IRC17:31
*** nikhil has joined #openstack-trove17:32
*** egafford has joined #openstack-trove17:40
*** itlinux has joined #openstack-trove17:52
*** tosky_ has quit IRC17:56
amrithstewie925, here's what's happening18:00
*** ewilson has quit IRC18:00
amrithcalled_once_with is a no-op18:00
* stewie925 listens18:00
amriththerefore you are now actually testing something when you switch to assert_called_once_with()18:00
*** ewilson has joined #openstack-trove18:00
amrithand you just realized that the old test did nothing18:00
amrithYIKES18:00
stewie925hehehe18:00
stewie925yeah yikes18:00
openstackgerritPetr Malik proposed openstack/trove: Test alternative MySQL status check  https://review.openstack.org/31278118:01
amrithstewie925, I am not sure what this test is actually trying to do18:04
amrithyou may want to look at https://review.openstack.org/#/c/121828/118:04
amriththat's another project that found this issue of a noop18:04
stewie925i see18:04
stewie925thank you amrith - I'll look into this merged review18:05
stewie925and hope will understand more18:06
amrithlet me send you a proposed change18:06
amrithfor you to try ...18:06
stewie925appreciate your help on this, amrith18:08
amrithnp stewie92518:10
stewie925hi amrith may I message you in pvt?18:16
amrithsure18:16
amrithbut I guess now everyone knows that we're going away to chat in the corner :)18:16
* amrith wanders away 18:17
*** tqtran has quit IRC18:44
*** tqtran has joined #openstack-trove18:50
amrithso stewie925 ...18:52
amrithhere's another patch for you to look at18:52
amrithhttps://gist.github.com/amrith/06d6783106e64bed4c42b2b47719b67f18:52
amriththe issues now are these18:53
amrith1. the heartbeat now has a timestamp which means testing is a hairball18:53
amrith2. I'm not sure why the heartbeat is sending up an instance-id of None18:53
amrithnot FAKE_ID18:53
stewie925thank you amrith19:05
stewie925Im getting a secure connection failed when trying to click on that link you provided19:06
kfox1111so, whats the correct procedure for recovering a percona cluster after hard power off?19:11
*** pmackinn is now known as pmackinn-afk19:16
kfox1111Does trove have features to help recover, or is it up to the ops to recover?19:19
*** syewie925 has joined #openstack-trove19:21
-openstackstatus- NOTICE: Gerrit is restarting to address performance issues related to a suspected memory leak19:22
stewie925I am able to see your patch amrith, thanks19:22
kfox1111what are the default ports for pxc? I want to add ssh too.19:46
amrithkfox1111, 3306, 4444, 4567, 456819:46
kfox1111ok. thanks.19:47
amrithre: recovery, if you bring up all the instances, pxc should recover itself19:47
amrithbeyond that let me check19:47
amrithI believe it is ops19:47
amrithoh, ssh is 22 :)19:48
kfox1111yeah. :)19:48
amrithgood trip back from austin I hope19:48
kfox1111I'm doing all sorts of bad things to the instances to see what I have to recover from and what just works. :)19:49
kfox1111yup. uneventful. how about yours? good I hope?19:49
amrithgood flight, small scare initially because of the wx in aus19:49
amrithbut luckily that all went north19:49
amrithand sat on dallas19:49
kfox1111ah. glad it turned out well.19:49
amrithso we had to head over new orleans, hug the coast and then shoot up19:50
amritha little bumpy19:50
amrithbut otherwise all good.19:50
kfox1111fun. :/19:50
kfox1111I get airsick. :/19:50
kfox1111does trove set up clustercheck on the nodes?19:51
*** syewie925 has quit IRC19:51
amrithkfox1111, I'm not sure.19:52
amrithcp16net, yt ^^19:52
kfox1111running it manually shows: Galera cluster node is not synced.19:53
kfox1111hmm...19:53
kfox1111 /etc/sysconfig/clustercheck doesn't exist...19:54
kfox1111wait.. wrong node...19:55
kfox1111though there isn't a cluster check user...19:56
kfox1111there's an xinetd file for mysql cluster check, but no service  I think...19:57
*** amrith is now known as _amrith_20:11
*** stewie925 has quit IRC20:13
kfox1111I've been using systemd too long.... cant remember the weird ways upstart enables things...20:29
*** dmk0202 has joined #openstack-trove20:29
-openstackstatus- NOTICE: Gerrit is restarting to revert incorrect changes to test result displays20:30
*** cdelatte has quit IRC20:34
kfox1111hmm... xinetd isn't working...20:38
kfox1111ah, there we go: service/protocol combination not in /etc/services: mysqlchk/tcp20:42
kfox1111ok. apt-get install xinetd and20:44
kfox1111echo "mysqlchk        9200/tcp" >> /etc/services20:44
kfox1111got it to run externally.20:44
kfox1111just gota figure out how to get it to provide real status.20:44
*** pmackinn-afk is now known as pmackinn20:47
*** egafford has quit IRC20:50
*** amit213 has joined #openstack-trove20:50
kfox1111trove's not letting me add a user with host='localhost'20:54
kfox1111know why that may be?20:54
kfox1111so, it will take a host='127.0.0.1'. that just doesn't work in mysql.20:59
kfox1111so something's rejecting 'localhost'20:59
kfox1111it doesn't seem to make it to the guest agent...21:00
*** rcernin has joined #openstack-trove21:05
*** cdelatte has joined #openstack-trove21:24
*** mingdang1 has joined #openstack-trove21:26
kfox1111so, I seem to be stuck...21:58
kfox1111I need a way to add a local user for clustercheck so lbaas can load balance safely,21:58
kfox1111but I can't add the user via trove user-create.21:59
kfox1111I think trove's createing the root user too?21:59
kfox1111is the mysql root password available on the vm somewhere?22:15
dougshelley66have you tried trove root-enable to one of the instances?22:16
dougshelley66i'm not absolutely sure that will work with a galera cluster configured by trove but worth a shot :)22:16
kfox1111I'm looking for a way to tweak my cloud-init script so that it either: sets the right user/password for clustercheck or lets me create the clustercheck default user/password via the cli.22:17
kfox1111I'd like all pxc clusters to have cluster check working out of the box if possible.22:18
kfox1111maybe I can just put in a cron job to keep trying to add the clustercheck user until it succeeds, then delete the cron job...22:19
dougshelley66i'll tell you a secret22:22
dougshelley66there is a .my.cnf in the "trove" home directory that contains a set of credentials22:22
dougshelley66i believe those creds have root access to the db22:22
*** cdelatte has quit IRC22:22
kfox1111hmm.. let me see if I can find that.22:23
dougshelley66so whatever user is running the guestagent, lookup the homedir for him22:23
kfox1111trove is the user, /var/lib/trove is the home...22:23
kfox1111not there...22:24
dougshelley66do you see .guest.prepare.end?22:24
dougshelley66which version of trove do you have22:24
kfox1111liberty.22:24
dougshelley66ok in that case i think the creds are in /etc/mysql/my.cnf in the [client] section22:25
dougshelley66i believe they were moved out during mitaka22:25
kfox1111k. thx.22:27
dougshelley66i wonder why clustercheck would pick up those credentials by default22:28
dougshelley66that is the normal mysql pattern, client programs read the [client] section in my.cnf22:28
*** rcernin has quit IRC22:29
kfox1111got it....22:36
kfox1111echo "* *  * * * root " mysql -e \"GRANT PROCESS ON "*.*" TO "'clustercheckuser'@'localhost' IDENTIFIED BY 'clustercheckpassword!'"\" "&& rm -f /etc/cron.d/reguser" > /etc/cron.d/reguser22:36
kfox1111horible hack... but works. :)22:36
kfox1111it defaults to that user/password if one isn't specified.22:39
*** ewilson has quit IRC22:41
kfox1111ok... so now, I need to create a heat template for stamping out load balancers that can talk to this thing.22:44
*** cdelatte has joined #openstack-trove22:51
*** david-lyle has quit IRC22:51
*** david-lyle has joined #openstack-trove22:53
*** david-lyle has quit IRC22:58
*** johnma has quit IRC23:01
*** davideag_ has joined #openstack-trove23:04
*** davideagnello has quit IRC23:07
*** sgotliv has quit IRC23:21
*** mingdang1 has quit IRC23:27
*** krotscheck has quit IRC23:31
*** krotscheck has joined #openstack-trove23:31
*** cdelatte has quit IRC23:34
*** tqtran has quit IRC23:41
*** dmk0202 has quit IRC23:42
*** davideag_ has quit IRC23:45
*** _amrith_ is now known as amrith23:48

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