Thursday, 2015-07-23

*** pmackinn has joined #openstack-trove00:10
*** ashleighfarnham has joined #openstack-trove00:14
*** ashleighfarnham has quit IRC00:19
*** pmackinn has quit IRC00:26
*** pmackinn has joined #openstack-trove00:34
*** pmackinn has quit IRC00:37
*** chlong has quit IRC00:52
*** mingdang1 has joined #openstack-trove00:52
*** _amrith_ is now known as amrith00:59
*** erkules has joined #openstack-trove01:09
*** erkules_ has quit IRC01:12
*** haomaiwang has quit IRC01:12
*** mingdang1 has quit IRC01:13
*** dbennett has joined #openstack-trove01:19
dbennett@cp16net ping01:20
*** pmackinn has joined #openstack-trove01:25
*** pmackinn has quit IRC01:42
*** mingdang1 has joined #openstack-trove01:43
*** ashleighfarnham has joined #openstack-trove01:59
*** rjaiswal has quit IRC02:04
*** ashleighfarnham has quit IRC02:04
*** chlong has joined #openstack-trove02:11
*** lexholden has quit IRC02:11
*** mingdang1 has quit IRC02:14
amrithsushilkm, yt?02:22
amrithsushilkm, when you get this would you please ping me.02:22
amrithwould like to get to the bottom of the datastore/version spec quickly02:22
amrithand move it along.02:22
amrithcp16net, yt?02:22
amrithcp16net ^^02:22
*** esmute_ has quit IRC02:24
*** esmute_ has joined #openstack-trove02:53
cp16nethello02:57
cp16neti just got back to my puter02:58
amrithcp16net, howdy!03:19
amrithgots a couples of minutez to chat03:20
amrithI knew I wanted to chat about something03:20
amrithlet me see if I can remember03:20
amrithah yes. datastore version spec ... would you please take a look at my comments. I'd like to get to some conclusion of it quickly; it seems to be getting old.03:21
cp16netoh yeah03:26
cp16netso you mentioned why have the body?03:27
cp16netfor the patch or post on the response03:27
cp16netsushilkm: around?03:28
cp16netamrith: you left?03:30
cp16netmaybe you are distracted like i am :-P03:30
*** amrith is now known as _amrith_03:34
*** coolsvap|away is now known as coolsvap03:34
*** ashleighfarnham has joined #openstack-trove03:39
*** rjaiswal has joined #openstack-trove03:42
*** ashleighfarnham has quit IRC03:44
cp16net_amrith_: disappeared03:45
cp16netnot to be confused with amrith03:46
openstackgerritPeter Stachowski proposed openstack/trove: Add support for Redis replication  https://review.openstack.org/20327803:51
*** esmute_ has quit IRC04:04
*** _amrith_ is now known as amrith04:07
amrithcp16net, I'm back04:11
amrithI have magical powers04:12
amrithI can disappear from time to time ;)04:12
cp16netme too04:29
cp16neti bet you are not here tho04:30
*** georgelorch has quit IRC04:30
*** georgelorch has joined #openstack-trove04:32
openstackgerritOpenStack Proposal Bot proposed openstack/trove: Updated from global requirements  https://review.openstack.org/20315204:43
*** sgotliv_ has quit IRC04:47
amrithi'm here04:52
amrithi'm not sure why my hexchat isn't notifying me.04:52
amrithcp16net, yt?04:52
georgelorchdbennett, cp16net IIRC is on east coast US and lefred was helping out. Check back in tomorrow AM. Thanks aging guys, you'll never have to buy a round if I'm present.04:52
amrithmaybe that will make your irc client blink04:52
cp16netlol04:52
cp16netyeah something poped out at me04:52
amrithgeorgelorch, you really are a peach. What do you mean "Thanks aging guys"?04:53
amrithWho is the "aging guys"04:53
cp16netgeorgelorch: i'm CST in Texas04:53
amrithgeorgelorch is AZ04:53
georgelorchLOL I meant again, it seems I'm the one aging the most04:53
amrithYeah right04:53
cp16net:-D04:53
amrithas they would say in TX, "turd blossom" which apparently is a term of high endearment.04:54
amrithwhy, I know not.04:54
amrithI'm not a texan04:54
georgelorchahh cp16net, cool, dbennett is actually really close to you, lefred is in Belgium04:54
cp16netthere much stranger terms i've heard04:54
cp16netbut perfer not to use them in public04:54
georgelorchans amrith is well...he's amrith, what else is there to say04:55
amrithoh puhleeze!04:55
amrithgeorgelorch, amen to that.04:55
cp16net... yeah i dunno what else to say04:55
amrithso, cp16net, about the datastore registration spec04:55
cp16netword04:56
amrithI wonder if sushilkm is around04:56
amrithis he up in seattle now or back home?04:56
cp16neti'm not sure04:56
cp16neti think home04:56
amrithme too04:56
cp16netcool so you can knock on his door04:57
cp16net:-P04:57
amrithlet me do that. one second, I think I have his phone number at least.04:57
cp16netlolz04:57
cp16netdoesnt seem to be online at least04:57
amrithcalling him04:59
amrithhe'll be getting online in a couple of minutes05:00
amrithjust spooked with him.05:00
cp16netok cool05:00
cp16netso the registration...05:01
amrithyes ...05:01
amriththat thing05:01
amrithok to just go through from the top?05:01
cp16netok05:01
amrithso at a high level is this intended to be a synchronous or async api?05:02
amriththe spec talks about a return code of 200 and accepted.05:02
sushilkmhello amrith cp16net05:02
amrithnot sure which he intended.05:02
cp16netsince it just updates the db i'd say sync05:03
amrithhi sushilkm ...05:03
cp16netyeah thats something i brought up as well05:03
amriththen the code must be updated.05:03
amritheither 202 accepted or 200 success05:03
cp16netyeah 200 OK05:03
* SlickNik joins the party05:03
* amrith wonders whether SlickNik brought anything nice to drink05:03
cp16net202 for async stuffs05:03
cp16netnot allowed in the party unless drinks in hand05:04
cp16net:-P05:04
SlickNik200 - success would be my call, fwiw05:04
* SlickNik returns to the kitchen to grab some beers.05:04
amrithhey! I had a shitload more comments05:04
amrithwhere did they go?05:04
* amrith needs more beer05:04
cp16netpatch before?05:04
*** esmute_ has joined #openstack-trove05:05
amrithlooking05:05
amrithdon't see them05:05
sushilkmare you saing "200 OK" is not good05:05
cp16netno05:06
cp16netwe are saying the spec says... 200 accepted05:06
cp16netwhich is contradicting05:06
amrithyou are correct05:06
cp16netshould be 200 OK or SUCCESS05:06
amrithpatch set 1805:06
amrithjust pushed them.05:06
sushilkmyeah i see that i updated the code but missed to update the message05:06
amrithas cp16net says ... 200 OK05:07
amrithnot 200 Acepted05:07
amrithaccepted05:07
amrithcomments pushed on PS 1805:07
amrithlet me walk through those quickly05:07
* cp16net feels accomplished (just solved my rubics cube again)05:08
amrithre: patch (around line 220)05:08
amrithso the patch is allowing me to update some parameters.05:08
amrithmy comment is longish so let me not retype it here; y'all can look there.05:08
* cp16net reading05:09
*** esmute_ has quit IRC05:09
* amrith wonders how long it will take SlickNik to return with beers.05:09
amrithI noticed a typo in my comment05:10
amrithsadly I can't fix it.05:10
amrith"I may be wrong here but the RESTful way to do things is to send all the data and the server ignores the things that are changed OR send only the things that are changed."05:10
amrithshould read05:10
amrithI may be wrong here but the RESTful way to do things is to send all the data and the server ignores the things that are UNchanged OR send only the things that are changed.05:10
amrithchanged word "changed" to "UNchanged" in one place.05:10
* amrith runs for power05:11
cp16netyeah that was a little off but i think i got what you mean05:11
cp16netso for a PATCH verb i like the idea of only sending what needs to change05:11
sushilkmhow i had thought this was you may send the only attribute you want to update05:11
cp16netespecially when there are 50 fields05:11
cp16netthere is no need to send them all05:11
sushilkmand the attributes i have listed in spec are those which are updateable05:11
amrithso please don't call "image": "new-image-id" ;)05:12
cp16neti think showing or not a uuid in the field is a fruitless point05:12
amrithor you give me the feeling that I can change it.05:12
sushilkmthus not allowing to update datastore_version_id, datastore_version_name and datastore to which this version is attached.05:12
cp16netyou should be able to change the id of the image that the version has05:13
amrithand please identify which fields are changeable and which are not in some way.05:13
amrithso cp16net I don't understand what "image" means. Is it a UUID05:13
sushilkmi did not get the point of "new-image-id"05:13
amrithor is it some other id.05:13
amrithsushilkm, I don't either05:13
amrithwhat is "new image id"05:13
amrithis it a glance id?05:14
amrithby some chance?05:14
cp16netimage is the glance id yeah05:14
cp16netits what we store in the db05:14
cp16netto boot the instance05:14
amrithif it is a glance id, I understand it; I'm just not thrilled trying to guess which are UUID's and which aren't but you think that's moot.05:14
cp16netthis is sort of a copy from the trove-manage cmd05:14
cp16netbut putting it in the mgmt api now05:15
amrithcp16net, that I think is nikhil's and my issue; the trove manage command is not a good thing to point to as a good "api".05:15
amrithand making an API based on that is not generating a very nice API IMHO05:15
openstackgerritSergey Vilgelm proposed openstack/trove: Switch to the oslo_log library  https://review.openstack.org/20382805:15
cp16netno i agree05:15
amrithon to line 232 then.05:15
amrithwhy send me a response?05:15
amrithI want to patch one field.05:16
amrithso if you tell me you succeeded, I know what the final thing is.05:16
amrithwhy do I need to get all this crap back.05:16
amriththe bigger issue is whether we want this to be the API or we want to make a good API and make the trove CLI use that; deprecate the trove-manage command.05:17
cp16nethmm05:17
cp16neti invisioned thats the direction this would go05:17
cp16nettheres no need to use the manage cmd after we can update this with the api05:18
cp16netand the api should be up and running any way once we get to the point of building images05:18
amrithso let's make an API that is not just an API version of the current trove-manage command. instead make an API without the shackles of how trove-manage did things and then write the command to use it.05:18
cp16netand creating datastores/versions05:18
amrithso the operations are these.05:19
amrithcreate a datastore05:19
amrithcreate a datastore version05:19
amrithset a default datastore05:19
amrithset a default datastore version05:19
amrithfor each of these05:19
amrithlist, update, delete05:19
amriththe workflow would be natural with that.05:20
cp16netwell there was a thought that why should be have operation of datastore05:20
amrithwhy is that?05:20
cp16netthat doesnt really make sense and makes the process more complicated05:20
cp16netwhen all we REALLY care about is a version05:20
amrithwon't an operator want to add datastores? without editing files that is.05:20
cp16netso this hides the idea that datastore is a separate object05:20
cp16netif the datastore doesnt exist it would create it05:21
cp16netor use it05:21
amrithso the current trove-manage workflow is ...05:22
cp16netSlickNik: mentioned this and i think it makes alot of sense when you usually want to just create a version with an image and manager and other goodies05:22
amrithfirst make a datastore with no version; you'll add that later.05:22
amriththat's step 1.05:22
amriththat's also my step 1, make a datastore.05:22
sushilkmit was SlickNik's suggestion to simplify the process rather than immitating how trove-manage does it05:22
amrithwe are talking about an API, not a command05:22
amrithyour command may be to create a datastore/version in one shot; that command may make three API calls.05:22
amrithmy point is this; command invocations do not need to have a 1:1 matching with API's.05:23
cp16netok i follow05:23
amrithyour command may be; just as it is today; trove-new-manage register-datastore-version mysql version-5.5 manager-class available-to-all this-validation-rule.json my-name min-flavor ...05:24
amriththat could translate into a half dozen API calls.05:24
amrithtrove list datastores05:24
amrithis there a mysql?05:24
amrithno?05:24
amrithtrove make-datastore mysql05:24
amrithnow make version05:24
amriththen register class05:24
amriththen set availability05:24
amrithor maybe part of prev call05:24
amriththen set validation rules etc.,05:24
amrithsorry; you said "ok i follow". should have shut up ;)05:24
cp16neti see your work flow05:25
* cp16net processing05:25
* amrith calls security for a wellbeing check on SlickNik (actually a wellbeing check on the beer)05:26
cp16neti think there is merit to having a separation05:26
cp16netbefore SlickNik mentioned to simplify the calls i was in the same thought you had amrith05:27
*** ashleighfarnham has joined #openstack-trove05:28
amrithlet's wait and see what SlickNik has to say. in general my thought re: API's is make them small atomic things and build on that.05:28
cp16netyeah i think of rest apis modeled after the data05:29
cp16netwhich was what this bp showed before05:29
cp16netif we didnt have datastores and only versions ....05:30
cp16netthen i think this would simplify things05:30
cp16netif only....05:30
amrithbut the datastore/version split does have some benefits05:32
*** ashleighfarnham has quit IRC05:32
amrithyou get to associate a bunch of attributes with the datastore05:32
sushilkmit was SlickNik's suggestion on patchset 14 "the trove-manage command provides a really poor user experience ......."05:32
amrithand it automatically gets inherited to the version.05:32
cp16netumm what attrs you talking about?05:33
cp16neta name?05:33
amrithsushilkm, I agree with that comment05:33
amrithmanager class05:33
cp16netthe datastore table has an id, name, default_version_id05:34
cp16netthat on the version05:34
cp16neti can specify what ever manager i want05:35
amrithcp16net, I'm saying the split as it is now is not much use; but a split (done slightly differently) could be very useful.05:35
amrithright now, the name merely helps to determine which section of the conf file to look in and a couple of other things.05:35
cp16netah thats possible05:35
amrithlike sushilkm's other chkin on datastore specific timeouts.05:36
amrithnow, either make that datastore version specific or more meaningfully implement the datastore/version split05:36
amrithlike for example, allow the user to provide parameters at the global level; at the datastore level or the datastore version level. use the most specific one preferentially.05:37
amriththat's how I'd like this to have been ...05:37
cp16netyeah i think the default for all leads to a bit more complication05:38
amrithso, I think SlickNik isnt around and we should wait for his input. You know what I'm talking about. How about we wait for him and then continue?05:38
cp16neti think thats fair05:38
sushilkmi think i am not able to grasp some ideas, about what is the new thing being looked into05:39
amrithsushilkm, how about we wait for SlickNik and then one of us can summarize05:40
sushilkmcool05:40
amrithi'd hate to have you spin another patch set05:40
amrithbefore there's some consensus.05:40
cp16netamrith: after this convo i'm split on the topic05:40
amrithok, let's unsplit you.05:40
*** exploreshaifali has joined #openstack-trove05:40
cp16netmaybe after some sleep i'll wake up on one side of the other of the bed05:40
amrithok, go take a nap, let's talk tomorrow05:41
cp16netyea05:41
amrithsushilkm, you in your local office or wfh?05:41
sushilkmwfh05:41
amrithk05:42
sushilkmr u in India, amrith05:42
amrithok all, time for a break.05:42
*** bhunter71 has quit IRC05:42
amrithwill talk to y'all later05:42
amrithnope05:42
amrithg'night all05:43
cp16netnite05:43
cp16netamrith: good talk tho05:43
sushilkmgd nyt05:43
amrithcp16net, i think SlickNik is sleep walking05:43
cp16netto the store05:43
cp16netor bar05:43
cp16net-P05:43
amrith;)05:44
amrithwhatever it is, no beer arrived.05:44
amrithjust saying.05:44
SlickNikback05:44
*** rjaiswal has quit IRC05:44
* amrith looks for the beer05:44
cp16netoh just in time05:44
SlickNikI have beer here05:44
* SlickNik reads scrollback05:44
amrithcp16net, should we let SlickNik read the scrollback and reconvene tomorrow after you've had a chance to sleep on it.05:44
amrithand he's had a chance to drink the beer that he isn't sharing.05:45
amrithok, it's late for me I'm calling it quits for now.05:45
cp16netso here is what i am thinking right now around this...05:50
cp16net1. the api should be modeled around the objects so that it makes sense in a restful way05:50
cp16net2. if we need a way to make things even easier like this helper that does multiple calls from a single command this might call for a new api call05:52
amrithcp16net, I'll look for this in scrollback later and maybe post you a response. we've typed a bunch so let's also give SlickNik a chance to drink his beer and process what we've been talking about.05:52
amrithbye for now.05:52
amrithwill look to read what you've written in a couple of hours. cp16net ^^ cheerios05:53
cp16net3. calling multiple api call from a single cmd gets the job done but seems wrong05:53
cp16netpeace out i'm just putting what my current thoughts are here.05:53
cp16neti'm out05:58
*** amrith is now known as _amrith_06:02
lefredcp16net: did you find the issue with mysql ?06:02
cp16netnot yet06:06
cp16neti'm trying out pxc56 now06:07
*** esmute_ has joined #openstack-trove06:07
cp16netits time for sleep i'm going to pick it back up in the morning06:09
lefredcp16net: ok but I'm 100% sure this is not related to the mysql/pxc version ;)06:09
cp16netthats  my thought as well but it shouldnt be hard to update that06:10
cp16neti tryed installing pxc55 on a vagrant box06:10
cp16netand tried to replicate whats happening and i had no luck replicating the weird issue06:11
cp16neti'll poke some more tomorrow though.06:11
*** esmute_ has quit IRC06:11
lefredno prob, have a good nigh06:11
lefredt06:11
*** exploreshaifali has quit IRC06:15
*** exploreshaifali has joined #openstack-trove06:19
*** chlong has quit IRC06:49
*** pmackinn has joined #openstack-trove06:50
*** pmackinn has quit IRC07:07
*** ashleighfarnham has joined #openstack-trove07:16
*** ashleighfarnham has quit IRC07:21
*** exploreshaifali has quit IRC07:42
*** exploreshaifali has joined #openstack-trove07:56
*** tosky has joined #openstack-trove07:58
*** mingdang1 has joined #openstack-trove08:24
*** sgotliv has joined #openstack-trove08:33
*** haomaiwang has joined #openstack-trove08:34
*** sgotliv has quit IRC08:34
*** sgotliv has joined #openstack-trove08:34
*** exploreshaifali has quit IRC08:38
*** mingdang1 has quit IRC08:52
*** ashleighfarnham has joined #openstack-trove09:05
*** ashleighfarnham has quit IRC09:10
*** saban has joined #openstack-trove09:29
sabanI have a database image09:29
sabanwhat to do to have trove-guest agent installed on it?09:29
sabando service.py file has to run on that image?09:30
*** k4n0 has joined #openstack-trove09:31
*** saban has quit IRC09:40
*** saban has joined #openstack-trove09:40
sushilkm@saban, you can simply install trove on ur image09:42
sabanthat's what i am asking09:44
sabanhow to install trove on image09:44
saban?09:44
sushilkmjust clone it and run setup.py09:45
sushilkmhow r u building ur image09:45
sabanusing DIB09:48
sushilkmok09:48
sushilkmalso you can have a look at trove-integration to find the elements09:49
*** exploreshaifali has joined #openstack-trove09:50
sushilkmalso a gud document for building images is in trove09:50
sushilkmhttps://github.com/openstack/trove/blob/master/doc/source/dev/building_guest_images.rst09:50
*** erkules has quit IRC09:53
*** erkules has joined #openstack-trove09:53
*** saban has quit IRC09:54
openstackgerritMerged openstack/trove: Switch to the oslo.context library  https://review.openstack.org/20382910:05
openstackgerritMerged openstack/trove: Switch to the oslo.serialization library  https://review.openstack.org/20382710:06
openstackgerritMerged openstack/trove: MongoDB prepare needs to wait for Mongo to start  https://review.openstack.org/20365010:06
openstackgerritMerged openstack/python-troveclient: Updated from global requirements  https://review.openstack.org/20314510:07
*** coolsvap is now known as coolsvap|away10:27
*** ashleighfarnham has joined #openstack-trove10:54
*** ashleighfarnham has quit IRC10:58
*** chlong has joined #openstack-trove11:08
*** esmute_ has joined #openstack-trove11:12
*** esmute_ has quit IRC11:16
*** mingdang1 has joined #openstack-trove11:28
*** mingdang1 has quit IRC11:28
*** mingdang1 has joined #openstack-trove11:28
*** daemontool_ has joined #openstack-trove11:36
*** daemontool_ has quit IRC11:36
*** daemontool_ has joined #openstack-trove11:37
*** exploreshaifali has quit IRC11:46
*** tomblank has joined #openstack-trove11:59
*** _amrith_ is now known as amrith12:15
*** pboros has joined #openstack-trove12:15
*** lexholden has joined #openstack-trove12:24
*** ashleighfarnham has joined #openstack-trove12:43
openstackgerritMerged openstack/trove: Configuration Groups for Redis  https://review.openstack.org/19186012:45
*** ashleighfarnham has quit IRC12:47
*** amrith is now known as _amrith_12:48
*** _crobertsrh is now known as crobertsrh12:48
openstackgerritOpenStack Proposal Bot proposed openstack/trove: Updated from global requirements  https://review.openstack.org/20315212:54
*** k4n0_ has joined #openstack-trove13:06
*** k4n0 has quit IRC13:06
*** _amrith_ is now known as amrith13:07
*** esmute_ has joined #openstack-trove13:14
*** esmute_ has quit IRC13:18
*** k4n0_ has quit IRC13:31
dbennettcp16net ping me if you need any help with PXC13:40
*** exploreshaifali has joined #openstack-trove13:48
*** mingdang1 has quit IRC14:14
*** thedodd has joined #openstack-trove14:18
*** rbrooker has joined #openstack-trove14:20
*** ashleighfarnham has joined #openstack-trove14:31
*** ashleighfarnham has quit IRC14:36
*** sabeen1 has joined #openstack-trove14:39
*** amrith is now known as _amrith_14:45
*** exploreshaifali has quit IRC14:46
*** georgelorch has quit IRC14:51
*** georgelorch has joined #openstack-trove14:59
*** sabeen3 has joined #openstack-trove15:01
*** sabeen1 has quit IRC15:02
*** rjaiswal has joined #openstack-trove15:06
*** bhunter71 has joined #openstack-trove15:07
*** sriram_tesora has joined #openstack-trove15:10
*** daemontool_ is now known as marzif_15:10
*** sgotliv has quit IRC15:10
*** david-lyle has joined #openstack-trove15:17
*** marzif_ has quit IRC15:28
*** rbrooker has quit IRC15:30
*** ashleighfarnham has joined #openstack-trove15:32
*** ashleighfarnham has quit IRC15:37
*** rbrooker has joined #openstack-trove15:38
openstackgerritMorgan Jones proposed openstack/python-troveclient: Redis Clustering Initial Implementation  https://review.openstack.org/20370115:42
*** zhiyan has quit IRC15:58
*** zhiyan has joined #openstack-trove15:58
*** exploreshaifali has joined #openstack-trove16:08
*** rbrooker has quit IRC16:12
*** esmute_ has joined #openstack-trove16:13
*** serverascode has quit IRC16:14
*** esmute_ has quit IRC16:14
*** serverascode has joined #openstack-trove16:16
*** sgotliv has joined #openstack-trove16:24
*** ashleighfarnham has joined #openstack-trove16:25
openstackgerritSergey Vilgelm proposed openstack/trove: Switch to the oslo_log library  https://review.openstack.org/20382816:32
*** lexholden has quit IRC16:34
cp16netdbennett: i tried out pxc5616:37
cp16netbut the test instance size we have of 512MB wont run pxc apparently16:38
*** georgelorch has quit IRC16:38
cp16netit keeps dieing from not enough memory16:38
cp16netlefred: if you are arround ^^16:38
lefredcp16net: dying at what point ?16:40
*** georgelorch has joined #openstack-trove16:41
cp16neton start16:42
lefredcp16net: in 5.6 (mysql) the buffer pool default is larger (128M) so you should add in your config something like innodb_buffer_pool_size = 10M16:42
lefredand check if it starts16:42
cp16netlefred: https://gist.github.com/cp16net/9dba437e7b357f62a4ba16:47
cp16neti get this sort of errors on start16:47
cp16netmysql/error.log and syslog16:48
lefredwith a buffer pool of 10M ?16:48
cp16netyeah with or without16:48
lefredwhat's the value of key_buffer_size ?16:49
lefredgcache.size = 300M;16:49
lefredyou need to change that too16:49
dbennettcp16net,  no chance of increasing VM ram?16:49
lefredwsrep_provider_options="gcache.size=16M"16:50
cp16neti could but its our default vm size for testing16:50
lefredbecause this is mmaped16:50
dbennettack16:50
cp16netkey_buffer is 16M16:51
cp16netits the default install 5616:51
cp16netso i havnt modified any configs16:51
dbennettyou might follow some of the advice here:   http://www.tocker.ca/2014/03/10/configuring-mysql-to-use-minimal-memory.html16:51
dbennettdon't set max_connections to 1 obviously16:52
dbennettactually,  before you do that...16:53
*** esmute_ has joined #openstack-trove16:54
*** thedodd has quit IRC16:54
dbennettcp16net,  can you dump your SHOW GLOBAL VARIABLES somewhere?16:55
cp16netmysql reads the last value you set for those right?16:55
cp16netso i can copy and paste that at the bottom and it should be ok as long as its in the [mysqld] section?16:56
cp16netdbennett: how do you do that when its not starting?16:56
lefredcp16net: you should have some changes somewhere, for example the gcache default size is 128M not 30017:00
dbennettcp16net,  good point,   how about /usr/sbin/mysqld --verbose --help17:03
dbennettit may take a minute with PXC but it will eventually spit out all of the settings17:03
edmondk2015-07-23 16:57:59.328 8777 DEBUG trove.common.base_wsgi [-] Empty body provided in request deserialize_body /opt/stack/venvs/trove/local/lib/python2.7/site-packages/trove/common/base_wsgi.py:66117:04
edmondk2015-07-23 16:57:59.328 8777 DEBUG trove.common.wsgi [-] Getting schema for type:index get_schema /opt/stack/venvs/trove/local/lib/python2.7/site-packages/trove/common/wsgi.py:37317:04
edmondk2015-07-23 16:57:59.329 8777 INFO eventlet.wsgi [-] 127.0.0.1 - - [23/Jul/2015 16:57:59] "GET / HTTP/1.0" 200 281 0.00162717:04
edmondk2015-07-23 16:58:00.045 8775 INFO eventlet.wsgi [-] (8775) accepted ('127.0.0.1', 57449)17:04
edmondk2015-07-23 16:58:00.048 8775 DEBUG trove.common.base_wsgi [-] Empty body provided in request deserialize_body /opt/stack/venvs/trove/local/lib/python2.7/site-packages/trove/common/base_wsgi.py:66117:04
edmondk2015-07-23 16:58:00.048 8775 DEBUG trove.common.wsgi [-] Getting schema for type:index get_schema /opt/stack/venvs/trove/local/lib/python2.7/site-packages/trove/common/wsgi.py:37317:04
edmondk2015-07-23 16:58:00.050 8775 INFO eventlet.wsgi [-] 127.0.0.1 - - [23/Jul/2015 16:58:00] "GET / HTTP/1.0" 200 281 0.00295717:04
edmondk2015-07-23 16:58:00.060 8778 INFO eventlet.wsgi [-] (8778) accepted ('127.0.0.1', 57450)17:04
edmondk2015-07-23 16:58:00.062 8778 DEBUG trove.common.base_wsgi [-] Empty body provided in request deserialize_body /opt/stack/venvs/trove/local/lib/python2.7/site-packages/trove/common/base_wsgi.py:66117:04
edmondk2015-07-23 16:58:00.063 8778 DEBUG trove.common.wsgi [-] Getting schema for type:index get_schema /opt/stack/venvs/trove/local/lib/python2.7/site-packages/trove/common/wsgi.py:37317:04
edmondk2015-07-23 16:58:00.065 8778 INFO eventlet.wsgi [-] 127.0.0.1 - - [23/Jul/2015 16:58:00] "GET / HTTP/1.0" 200 281 0.00313217:04
edmondkwhoops meant to paste that in a paste17:05
edmondkGist doesn't appear to be working17:05
cp16netlol17:05
edmondkI guess my question was has anyone ever seen this message constantly repeated in trove-api17:05
edmondktrove-api is just constantly outputting this and seems not be handling any requests17:06
openstackgerritSergey Vilgelm proposed openstack/trove: Remove openstack.common package  https://review.openstack.org/20382617:06
cp16netedmondk: looks like that might be getting the versions17:06
*** mingdang1 has joined #openstack-trove17:15
*** mingdang1 has quit IRC17:19
*** coolsvap|away is now known as coolsvap17:22
*** lexholden has joined #openstack-trove17:39
*** lexholden has quit IRC17:42
*** pmackinn has joined #openstack-trove17:43
openstackgerritPetr Malik proposed openstack/trove: Configuration Groups for MongoDB  https://review.openstack.org/19473918:21
openstackgerritPetr Malik proposed openstack/trove: Improve the guestagent configuration manager  https://review.openstack.org/19859518:27
*** exploreshaifali has quit IRC18:35
*** sriram_ has joined #openstack-trove18:53
*** pmackinn has quit IRC18:53
*** bitblt has joined #openstack-trove18:55
*** sriram_tesora has quit IRC18:55
*** bitblt has quit IRC18:58
*** annashen has joined #openstack-trove18:59
cp16netlefred: dunno if you are still around... but i lookedinto the time the mysql table was updated19:07
cp16netthe mysq/user.* files were last modified in the same minute that the grant happened19:08
cp16netbut looking at the db using root i dont see the grant there19:09
*** tomblank has quit IRC19:10
*** pboros has quit IRC19:12
*** pmackinn has joined #openstack-trove19:19
openstackgerritPetr Malik proposed openstack/trove: Add generic int-test classes  https://review.openstack.org/20327419:23
*** sriram_tesora has joined #openstack-trove19:28
*** mattgriffin has joined #openstack-trove19:28
*** sriram_ has quit IRC19:29
*** annashen has quit IRC19:31
*** annashen has joined #openstack-trove19:32
*** pmackinn has quit IRC19:34
openstackgerritMerged openstack/trove: Updated from global requirements  https://review.openstack.org/20315219:34
*** esmute_ has quit IRC19:37
*** esmute_ has joined #openstack-trove19:39
*** mattgriffin has quit IRC19:43
*** mattgriffin has joined #openstack-trove19:45
openstackgerritMorgan Jones proposed openstack/python-troveclient: Redis Clustering Initial Implementation  https://review.openstack.org/20370120:04
openstackgerritMorgan Jones proposed openstack/trove: Redis Cluster Initial Implementation  https://review.openstack.org/20370220:07
*** john_f_ has joined #openstack-trove20:11
*** bhunter71 has quit IRC20:20
*** lexholden has joined #openstack-trove20:25
*** crobertsrh is now known as _crobertsrh20:33
*** pmackinn has joined #openstack-trove20:46
*** mattgriffin has quit IRC20:53
*** mattgriffin has joined #openstack-trove20:57
*** pmackinn has quit IRC21:16
sabeen3Hi All, i'm trying to create a trove instance in devstack and i'm getting the following error - TroveError: Error creating security group for instance: b88b7037-9730-47a4-86b8-17bd2e234767. Any advice on how to fix this will be appreciated! :)21:20
*** john_f_ has quit IRC21:23
*** pmackinn has joined #openstack-trove21:26
*** bhunter71 has joined #openstack-trove21:50
*** rjaiswal has quit IRC21:54
*** thedodd has joined #openstack-trove21:55
*** mattgriffin has quit IRC21:56
*** mattgriffin has joined #openstack-trove22:03
*** mattgriffin has quit IRC22:03
sabeen3pmackinn: i'm getting an error while trying to create a trove db in devstack - TroveError: Error creating security group for instance: xxxxxxxx22:09
sabeen3i'm using heat to create the trove db.. i've added use_heat=True in /etc/trove/trove/conf22:10
sabeen3i see that it shouldn't go into the if statement if use_heat is set to true: https://github.com/openstack/trove/blob/master/trove/taskmanager/models.py#L36322:11
sabeen3do you know what could be wrong?22:11
*** pmackinn_ has joined #openstack-trove22:13
*** pmackinn has quit IRC22:13
cp16netsabeen3: sorry i've not run with heat before :-/22:14
cp16neti'd look in the trove-taskmanager logs and see if there are hints22:15
cp16netit sounds like ther permissions to create a security group might be missing for the user creating the heat stack?22:15
cp16netfrom what you shared i'm not sure if there is a issue with heat creating the security group or trove22:17
cp16neti dont recall how that works but i *think* its heat that should be creatig the security group from the heat template we have22:17
cp16netmy 2 cents hopefully that helps you debugging22:18
sabeen3cp16net: thank you!22:20
sabeen3cp16net: i'll check in the trove-taskmanager22:20
*** pmackinn_ has quit IRC22:24
*** annashen has quit IRC22:25
*** esmute_ has quit IRC22:27
*** sabeen3 has quit IRC22:32
*** annashen has joined #openstack-trove22:32
*** esmute_ has joined #openstack-trove22:33
*** tosky has quit IRC22:43
*** chlong has quit IRC22:52
*** coolsvap is now known as coolsvap|away23:00
*** david-lyle has quit IRC23:02
*** lexholden has quit IRC23:08
*** ashuk has joined #openstack-trove23:10
*** esmute_ has quit IRC23:20
*** esmute_ has joined #openstack-trove23:21
*** rjaiswal has joined #openstack-trove23:23
*** sriram_tesora has quit IRC23:28
*** annashen has quit IRC23:31
*** david-lyle has joined #openstack-trove23:36
*** mingdang1 has joined #openstack-trove23:45
*** thedodd has quit IRC23:50
*** ashleighfarnham has quit IRC23:54

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