Tuesday, 2015-06-02

openstackgerritPetr Malik proposed openstack/trove: Fix leaked mocks in the 'LimitsControllerTest'  https://review.openstack.org/18610800:16
*** flwang1 has quit IRC00:37
*** flwang has joined #openstack-trove00:51
*** radez is now known as radez_g0n301:33
*** serverascode has quit IRC01:36
*** erkules_ has joined #openstack-trove01:40
*** mattgriffin has joined #openstack-trove01:42
*** erkules has quit IRC01:43
*** _amrith_ is now known as amrith01:43
*** pmackinn_ has quit IRC01:43
*** serverascode has joined #openstack-trove01:44
*** shakamunyi_ has joined #openstack-trove01:46
*** shakamunyi_ has quit IRC01:46
*** erkules_ has quit IRC01:50
*** erkules_ has joined #openstack-trove01:51
*** johnma has quit IRC01:57
*** tobe has joined #openstack-trove02:03
*** shakamunyi has joined #openstack-trove02:26
*** shakamunyi has quit IRC02:33
*** chlong has quit IRC02:39
*** mattgriffin has quit IRC02:40
*** danritchie has quit IRC02:45
*** mattgriffin has joined #openstack-trove02:55
*** mattgriffin has quit IRC03:00
*** mattgriffin has joined #openstack-trove03:07
*** mattgriffin has quit IRC03:13
*** chlong has joined #openstack-trove03:22
*** bhunter71 has quit IRC03:42
*** david-lyle has quit IRC04:24
*** david-lyle has joined #openstack-trove04:25
*** exploreshaifali has joined #openstack-trove04:26
*** danritchie has joined #openstack-trove04:34
*** danritchie has quit IRC04:38
*** exploreshaifali has quit IRC04:51
*** Longgeek has joined #openstack-trove05:07
*** tobe has quit IRC05:08
*** johnma has joined #openstack-trove05:11
*** nosnos has joined #openstack-trove05:12
*** Longgeek has quit IRC05:13
*** nosnos has quit IRC05:37
*** tobe has joined #openstack-trove05:37
*** Longgeek has joined #openstack-trove05:52
*** tobe has quit IRC06:13
*** tobe has joined #openstack-trove06:38
*** sgotliv has joined #openstack-trove07:50
*** chlong has quit IRC07:56
*** erkules_ is now known as erkules08:29
*** erkules has quit IRC08:29
*** erkules has joined #openstack-trove08:29
*** vkmc has quit IRC08:45
*** vkmc has joined #openstack-trove08:45
*** kbyrne has joined #openstack-trove08:53
*** blinky_ghost has joined #openstack-trove09:35
tobeWhen is the meeting of trove? I would like to join all all of you :)09:43
blinky_ghostvkmc: good morning :) can you test your script? :)09:55
blinky_ghostI*09:55
*** danritchie has joined #openstack-trove10:00
*** danritchie has quit IRC10:05
vkmctobe, its tomorrow at 18UTC in #openstack-meeting-alt10:12
vkmctobe, looking forward to see you there!10:12
vkmcblinky_ghost, sure, there is another branch in the git repo that add the fixes for centos10:12
blinky_ghostvkmc: thanks, what's the branch name?10:13
vkmcblinky_ghost, copr-kilo10:14
tobeGreat! Thanks @vkmc10:14
vkmcblinky_ghost, I'm still testing it though, I'm going to merge the changes to the master branch once I make sure it is working as expected10:15
blinky_ghostvkmc: Ok thanks10:16
blinky_ghostvkmc: I'm doing some tests here with a cloud-init based vm, I see that the guest starts the command /usr/bin/python2 /usr/bin/trove-guestagent --config-file /usr/share/trove/trove-dist.conf --config-file /etc/trove/trove-guestagent.conf --config-file /etc/trove/guest_info. But the file that is being generated on the guest is: /etc/trove/conf.d/guest_info.conf, so I guess is that why I see  TRACE oslo_messaging.rpc.dispatcher ModelNotFoundErr10:57
blinky_ghostor: InstanceServiceStatus Not Found error and it fails. Am I thinking right? :)10:57
vkmcblinky_ghost, how did you load the image?10:57
blinky_ghostvkmc: I loaded an centos7 qcow2 image using glance, then I run cloud init to install trove10:59
vkmcblinky_ghost, you need to update the trove datastore with the image you loaded to glance10:59
vkmcblinky_ghost, if you are using my script, that should be done as load_trove_image -s mysql -v centos5.5 -p mariadb-galera-server -i <glance-id>11:00
vkmcyou don't need cloudinit if you are using a prebaked imag11:00
vkmce11:00
*** Longgeek_ has joined #openstack-trove11:01
blinky_ghostvkmc: done that also, everything runs ok, the vm is spwaned the service starts, I can reach the controller, however I see that error, because I think the guest_info location is wrong11:01
*** Longgeek has quit IRC11:01
blinky_ghostvkmc: yes I know, I was just doing some tests before I have your image to test11:01
vkmcif you created the image using copr-kilo, you should specify in trove-taskmanager.conf injected_config_location "/etc/trove/conf.d"11:02
blinky_ghostvkmc: ok, so in the guest it will start like this: /usr/bin/python2 /usr/bin/trove-guestagent --config-file /usr/share/trove/trove-dist.conf --config-file /etc/trove/trove-guestagent.conf --config-file /etc/trove/conf.d/guest_info.conf. Correct?11:04
vkmc--config-file /etc/trove/conf.d/trove-guestagent.conf11:04
vkmcyeah, that is how the .service file looks like11:04
blinky_ghostok11:06
blinky_ghostvkmc: guess not if I change the location guestagent doesn't start11:32
vkmcblinky_ghost, what are you getting in the taskmanager?11:35
blinky_ghostvkmc: you mean in the logs?11:36
vkmcblinky_ghost, yes11:37
blinky_ghostvkmc: on taskmanager: 2015-06-02 11:40:29.009 3430 TRACE trove.openstack.common.periodic_task BadRequest: Malformed request URL: URL's project_id 'services' doesn't match Context's project_id '8d55aabb875c44459540668f5b95bc98' (HTTP 400) (Request-ID: req-ebcc3e91-7d18-4e1e-ad57-9276e4f67284)11:42
blinky_ghostvkmc: on conductor: 2015-06-02 11:42:11.783 3719 TRACE oslo_messaging.rpc.dispatcher ModelNotFoundError: InstanceServiceStatus Not Found11:43
blinky_ghostvkmc: I don't understand why doesn't use /etc/trove/guest_info instead of /etc/trove/conf.d/guest_info.conf although I force it taskmanager :/11:45
vkmcit should be the other way round11:49
vkmcyou should put /etc/trove/conf.d/guest_info.conf in the taskmanager.conf11:50
*** tomblank has joined #openstack-trove11:51
blinky_ghostvkmc: done that, the problem is that guest uses /etc/trove/guest_info however If I force in systemd on the guest to /etc/trove/conf.d/guest_info.conf it doesn't start.11:52
vkmcblinky_ghost, check conf.d permissions11:52
vkmcblinky_ghost, trove user should be able to read from there11:53
blinky_ghostvkmc: Ok I'll test thank you for your patience :)11:53
vkmcblinky_ghost, no, its ok, I'm sorry you are finding some blockers with this... its frustrating11:55
vkmcs/some/so many11:55
*** tomblank has quit IRC11:56
blinky_ghostvkmc: Ok so in taskmanager I should have:11:57
blinky_ghostguest_config = /etc/trove/conf.d/trove-guestagent.conf11:57
blinky_ghostguest_info = /etc/trove/conf.d/guest_info11:57
blinky_ghostinjected_config_location = /etc/trove11:57
blinky_ghostcloudinit_location = /etc/trove/cloudinit11:57
blinky_ghost?11:57
vkmcblinky_ghost, http://paste.openstack.org/show/256085/ this is on a working environment12:05
vkmcusing the copr-kilo repo image12:06
*** tobe has quit IRC12:07
*** pmackinn_ has joined #openstack-trove12:16
vkmchey guys, do we support another backup mechanism for mysql other than percona xtrabackup?12:37
dougshelley66vkmc, there is a mysql dump based strategy12:38
dougshelley66guestagent.strategies.backup.mysql_impl.MySQLDump12:40
vkmcdougshelley66, thanks :)12:40
amrithvkmc, the guest specifies config path as a directory, not a file12:49
amrithit loads multiple files from there12:49
amrithunlike the controller services which each take a file.12:49
amrithblinky_ghost ^^12:49
vkmcamrith, which configuration parameter are you referring to?12:50
*** _crobertsrh is now known as crobertsrh12:51
*** johnma has quit IRC13:17
openstackgerritMatthew Van Dijk proposed openstack/trove-specs: MongoDB user management commands  https://review.openstack.org/18482613:17
*** amrith is now known as _amrith_13:23
*** radez_g0n3 is now known as radez13:28
*** mattgriffin has joined #openstack-trove13:31
*** ErickHeinrich has joined #openstack-trove13:41
*** ErickHeinrich has quit IRC13:41
*** bhunter71 has joined #openstack-trove13:46
*** k4n0 has quit IRC13:59
*** csoukup has joined #openstack-trove14:00
*** tomblank has joined #openstack-trove14:07
blinky_ghostvkmc: so I changed the guestagent location no I'm having this error on the guest: "exception during message handling: could not find pkg mysql55"14:15
*** radez is now known as radez_g0n314:23
*** radez_g0n3 is now known as radez14:26
*** _amrith_ is now known as amrith14:33
*** sriram_tesora has joined #openstack-trove14:36
amrithvkmc, the default is to launch the guest agent with the --config-dir option14:39
*** sriram_tesora has quit IRC14:41
blinky_ghostamrith: any explanation for my error? on the guest?14:42
*** johnma has joined #openstack-trove14:42
*** coolsvap|afk has quit IRC14:45
amrithblinky_ghost, to be perfectly honest I have not been following it closely because I have been concerned about the end point you would arrive at. Making a trove guest image is not straightforward and debugging a failed one is not trivial. Given that, I haven't been following along. Sorry14:45
*** coolsvap|afk has joined #openstack-trove14:48
pmackinn_blinky_ghost, which distro is the guestagent?14:50
blinky_ghostpmackinn_: centos 714:50
*** sriram_tesora has joined #openstack-trove14:51
*** exploreshaifali has joined #openstack-trove14:51
*** sgotliv_ has joined #openstack-trove14:51
*** sgotliv has quit IRC14:52
*** exploreshaifali has quit IRC14:52
pmackinn_blinky_ghost, and what repos have you enabled in your guestagent? anything beyond base and/or epel?14:53
*** ashleighfarnham has joined #openstack-trove14:53
blinky_ghostpmackinn_: I've enabled rdo repos14:53
*** radez is now known as radez_g0n314:54
pmackinn_blinky_ghost, try registering the package in the datastore as "mariadb-galera-server"14:56
blinky_ghostpmackinn_ ok, thanks I'll test14:57
vkmcpmackinn_, blinky_ghost is deploying Trove with Packstack14:59
vkmcpmackinn_, using the kilo-copr repo right now14:59
blinky_ghosttrove-manage --config-file /etc/trove/trove.conf datastore_version_update  mariadb-galera-server mysql-5.5 mariadb-galera-server glance_image_ID mysql-server-5.5 1?14:59
openstackgerritMatthew Van Dijk proposed openstack/trove-specs: MongoDB database management commands  https://review.openstack.org/18316614:59
pmackinn_vkmc, mine?15:00
vkmcblinky_ghost, use the load_trove_image script, its easier for you15:00
vkmcpmackinn_, yes15:00
pmackinn_sudo ./load_trove_image.sh -s mysql -v 5.5 -p mariadb-galera-server -i XXXXXXXXXXXXX15:02
*** john_f_ has quit IRC15:17
blinky_ghostpmackinn_: it seems to be working now :) thanks15:18
blinky_ghostpmackinn_: although I see some errors in the guestagent logs15:18
pmackinn_blinky_ghost, :-)15:19
blinky_ghostpmackinn_: 4 days with this thank god :P15:19
vkmcblinky_ghost, that's great news15:19
blinky_ghostvkmc: sure thank you for your help, so I was using the wrong datastore, the guest_info location  was wrong, also the 401 errors I changed from admin user to trove user with admin role15:21
vkmcblinky_ghost, good to know... I'm working on writing some sort of blog post to make things easier for people using Packstack to deploy Trove15:23
vkmcI'll add your comments15:23
vkmcalso... take in mind that the instance you have now working might not be sane enough... keep us posted so we can add the required fixes15:24
blinky_ghost1518 TRACE trove.guestagent.datastore.mysql.service Stderr: u"\x07/usr/bin/mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'\nCheck that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!\n"15:24
blinky_ghostvkmc:the db is up but i see some errors15:25
vkmcblinky_ghost, check 'sudo systemctl -l status mariadb'15:26
blinky_ghost Active: active (running) since Tue 2015-06-02 15:17:20 UTC; 9min ago15:26
blinky_ghostvkmc: I'll paste the logs a sec15:27
blinky_ghostvkmc: can you take a look please? http://paste.openstack.org/show/256611/15:29
blinky_ghostvkmc, pmackinn_, although those errors I can log on successfully from my pc to db15:33
*** danritchie has joined #openstack-trove15:34
*** barra204 has joined #openstack-trove15:35
*** jaredrohe has joined #openstack-trove15:35
*** shakamunyi has joined #openstack-trove15:35
*** danritchie has quit IRC15:39
*** jaredrohe has quit IRC15:40
*** jaredrohe has joined #openstack-trove15:40
pmackinn_blinky_ghost, yeah a perms issue we're investigating15:42
*** openstackgerrit has quit IRC15:42
*** openstackgerrit has joined #openstack-trove15:43
blinky_ghostpmackinnn, vkmc,  anyway I've used centos qcow2 image with this cloudinit if it helps: http://paste.openstack.org/show/256654/15:46
vkmcblinky_ghost, you shouldn't use cloudinit if you are using a prebaked image15:48
blinky_ghostvkmc: I wasn't using a prebaked image, I was waiting for you to finish your script, so I just downloaded an "official" centos7 qcow2 http://cloud.centos.org/centos/7/images/CentOS-7-x86_64-GenericCloud.qcow2 and applied cloudinit.15:50
vkmcblinky_ghost, oooooh now I understand you, I though you were using kilo-copr version of the image builder15:53
blinky_ghostvkmc: I've also tried to create an image using your script but I couldn't logon to the VM to see what was happening so I tested it that way and it seems to work15:54
vkmcblinky_ghost, if you are using Horizon, you can get a VNC console from the instances panel and access to it using trove user15:54
blinky_ghostvkmc: no, I was waiting for you to merge it to master :)15:54
vkmcblinky_ghost, we are going to remove that in the future for security reasons, but now its good enough for debugging15:55
vkmcblinky_ghost, k k, sorry about that :)15:55
blinky_ghostvkmc: cool I didn't know that15:55
blinky_ghostvkmc: anyway the instructions on https://www.rdoproject.org/forum/discussion/1010/creation-of-trove-compatible-images-for-rdo need to be corrected because you need to use another datastore "mariadb-galera-server", not "mysql"15:57
blinky_ghostvkmc: at least for centos 7 of course :)15:58
vkmcblinky_ghost, sure thing15:58
blinky_ghostvkmc: can I ask another thing if you don't mind? :) Is it possible to create mariadb galera clusters using trove? like creating 3 mariadb instances that sync each other?16:01
dougshelley66blinky_ghost, Provisioning Mysql/Maria/Percona clusters hasn't been implemented in Trove yet16:02
blinky_ghostdougshelley66, ok what cluster options do I have? Mysql master-slave?16:03
dougshelley66blinky_ghost, yes master-slave replication is supported for mysql & percona16:04
dougshelley66using mysql asynch replication16:04
blinky_ghostdougshelley66: with trove cluster-create?16:05
dougshelley66there is a blueprint that is underway for mysql clustering - https://blueprints.launchpad.net/trove/+spec/support-pxc-5.5-and-5.616:05
dougshelley66blinky_ghost, no - replication is enabled using trove create ... --replica_of16:05
*** tomblank has quit IRC16:06
blinky_ghostdougshelley66: ok, so what does trove cluster-create do? what kind of cluster?16:06
dougshelley66blinky_ghost, as of today clustering is implemented for MongoDB16:08
blinky_ghostdougshelley66: ok thanks :)16:08
*** tomblank has joined #openstack-trove16:10
*** bhunter71 has quit IRC16:31
*** bhunter71 has joined #openstack-trove16:33
sushilkmhey all reviewers16:34
sushilkmneeded ur help for https://review.openstack.org/#/c/167733/16:34
*** jaredrohe has quit IRC16:34
sushilkmthe vertica int tests patchset16:34
sushilkmit has been waiting for long16:34
*** jaredrohe has joined #openstack-trove16:38
*** tomblank has quit IRC16:43
ashleighfarnhamvgnbkr can you look at sushilkm's review? Looks like he responded to your comments.16:45
*** IanGovett has joined #openstack-trove16:54
*** IanGovett1 has joined #openstack-trove16:59
*** IanGovett has quit IRC17:01
*** johnma has quit IRC17:03
*** johnma has joined #openstack-trove17:03
*** sgotliv_ has quit IRC17:04
amrithvkmc, yt?17:07
amrithvkmc, please take a look at https://review.openstack.org/#/c/182910/1. I'd like to WF+1 this17:08
*** IanGovett has joined #openstack-trove17:09
*** IanGovett has quit IRC17:09
*** IanGovett1 has quit IRC17:11
*** jaredrohe has quit IRC17:16
*** jaredrohe has joined #openstack-trove17:17
*** mattgriffin has quit IRC17:20
vkmcamrith, sure thing17:27
openstackgerritamrith proposed openstack/trove-specs: Allow users to specify backup encryption key  https://review.openstack.org/18595017:35
openstackgerritMerged openstack/trove-specs: Add backup and restore to the Redis datastore  https://review.openstack.org/18291017:48
openstackgerritMerged openstack/trove-specs: Configuration Groups for Cassandra  https://review.openstack.org/18075017:50
*** pmackinn_ is now known as _pmackinn17:50
*** jaredrohe has quit IRC17:58
*** jaredrohe has joined #openstack-trove17:59
*** radez_g0n3 is now known as radez18:02
*** jaredrohe has quit IRC18:02
*** jaredrohe has joined #openstack-trove18:02
*** openstackgerrit has quit IRC18:09
*** openstackgerrit has joined #openstack-trove18:10
openstackgerritMatthew Van Dijk proposed openstack/trove-specs: MongoDB user management commands  https://review.openstack.org/18482618:19
openstackgerritamrith proposed openstack/trove: correct api schema for instance patch  https://review.openstack.org/18699218:25
*** blinky_ghost has quit IRC18:26
openstackgerritMatthew Van Dijk proposed openstack/trove-integration: Use mongodb 3 instead of 2.4  https://review.openstack.org/18690418:28
*** mattgriffin has joined #openstack-trove18:38
*** PeterSchwaller has joined #openstack-trove18:46
*** openstackgerrit has quit IRC18:56
*** openstackgerrit has joined #openstack-trove18:56
*** sgotliv has joined #openstack-trove19:06
openstackgerritMerged openstack/trove-specs: MongoDB database management commands  https://review.openstack.org/18316619:10
openstackgerritMatthew Van Dijk proposed openstack/trove: Enable authentication in the MongoDB guest agent  https://review.openstack.org/18773419:22
*** crobertsrh is now known as _crobertsrh19:22
openstackgerritMatthew Van Dijk proposed openstack/trove: Enable authentication in the MongoDB guest agent  https://review.openstack.org/18773419:28
*** sgotliv has quit IRC19:48
openstackgerritPeter Stachowski proposed openstack/trove-integration: Allow specifying devstack branch in redstack  https://review.openstack.org/17826419:49
*** openstackgerrit has quit IRC20:10
*** openstackgerrit has joined #openstack-trove20:10
*** amrith is now known as _amrith_20:22
vkmchey folks, how can I debug replication?20:46
vkmcI'm getting TroveError: An error occurred while deleting a bad replication snapshot from instance in the taskmanager.log20:47
vkmcand there are no more information than that20:47
*** _pmackinn has quit IRC20:52
dougshelley66vkmc, it looks like the master snapshot failed20:53
dougshelley66you may want to look in the master guestagent log and see why the backup failed20:53
vkmcdougshelley66, oh, the tail wasn't enough20:57
vkmcthanks :D20:57
*** shakamunyi_ has joined #openstack-trove21:03
*** shakamunyi__ has joined #openstack-trove21:04
*** shakamunyi__ is now known as tylerdurden21:05
*** tylerdurden has quit IRC21:08
*** shakamunyi_ has quit IRC21:08
*** radez is now known as radez_g0n321:11
*** radez_g0n3 is now known as radez21:14
*** johnma_ has joined #openstack-trove21:17
*** johnma has quit IRC21:17
*** johnma_ is now known as johnma21:17
*** jaredrohe has quit IRC21:31
*** mattgriffin has quit IRC21:37
*** mattgriffin has joined #openstack-trove21:40
*** radez is now known as radez_g0n321:59
*** johnma has quit IRC22:05
*** tylerhannan has quit IRC22:06
*** jaredrohe has joined #openstack-trove22:22
*** ashleighfarnham has quit IRC22:26
*** sriram_tesora has quit IRC22:37
*** tylerhannan has joined #openstack-trove22:39
*** tosky_ has joined #openstack-trove22:46
*** bhunter71 has quit IRC22:57
*** tosky_ has quit IRC22:57
*** jeraldv has joined #openstack-trove23:16
*** csoukup has quit IRC23:18
*** chlong has joined #openstack-trove23:22
*** mattgriffin has quit IRC23:25
*** jeraldv has quit IRC23:39
*** barra204 has quit IRC23:57
*** shakamunyi has quit IRC23:57
openstackgerritSharika Pongubala proposed openstack/trove-specs: Adding licensing support for clusters and instances  https://review.openstack.org/18781723:59

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