<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style>
<!--
@font-face
        {font-family:Helvetica}
@font-face
        {font-family:"MS Gothic"}
@font-face
        {font-family:"MS Gothic"}
@font-face
        {font-family:Calibri}
@font-face
        {font-family:Tahoma}
@font-face
        {font-family:"Comic Sans MS"}
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif"}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif"}
span.EmailStyle17
        {font-family:"Calibri","sans-serif";
        color:#1F497D}
span.BalloonTextChar
        {font-family:"Tahoma","sans-serif"}
.MsoChpDefault
        {font-family:"Calibri","sans-serif"}
@page WordSection1
        {margin:72.0pt 72.0pt 72.0pt 72.0pt}
-->
</style><style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1" lang="EN-CA" link="blue" vlink="purple">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">To me, one of the benefits of cinder is the ability to have the volume outlast the vm. So, for example, if you knew a yum upgrade went bad on the vm, but the db data is safe, it
 would be nice to be able to just delete the vm and have trove relaunch using the existing volume, not having to import all the data again. Or the host it was running on died but the volume is ok. It would be very nice if Trove supported this use case.<br>
<br>
Thanks,<br>
Kevin<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF928422"><font face="Tahoma" color="#000000" size="2"><b>From:</b> Peter Stachowski [peter@tesora.com]<br>
<b>Sent:</b> Tuesday, June 28, 2016 3:39 PM<br>
<b>To:</b> OpenStack Development Mailing List (not for usage questions); Ali Adil<br>
<b>Subject:</b> Re: [openstack-dev] Change in openstack/trove[master]: Ophaned Volume Not Removed on Instance Delete<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Hi Will,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Trove is a managed database service.  Once you delete the database, all associated volumes with it are also deleted, as is the Nova instance.  One of the
 key benefits of using Trove is that you don’t have to manage servers/volumes/security_groups etc.  Also, depending on the provider’s implementation, the volume may not be visible to the end user and thus would just be left lying around using up resources if
 it isn’t deleted by Trove (while potentially having the use charged back to the end user).  This is the case that is being addressed – having a volume left undeleted even if the Nova instance is gone (or in this case didn’t start successfully).</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Thanks,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Peter</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"" lang="EN-US">From:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"" lang="EN-US"> Will Zhou [mailto:zzxwill@gmail.com]
<br>
<b>Sent:</b> June-28-16 10:55 AM<br>
<b>To:</b> OpenStack Development Mailing List (not for usage questions); Ali Adil<br>
<b>Subject:</b> Re: [openstack-dev] Change in openstack/trove[master]: Ophaned Volume Not Removed on Instance Delete</span></p>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Hi Scott, many thanks for your figuration.  Thanks and +1 for your nomination to nova core:)</p>
<div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Hi aadil, we should <span style="font-family:"Helvetica","sans-serif"; color:#212121">DETACH the volume, instead of DELETE. Please help enhance your code which is really a helpful fix to the bug. Thanks.</span></p>
</div>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<div>
<p class="MsoNormal">On Tue, Jun 28, 2016 at 10:51 PM D'Angelo, Scott <<a href="mailto:scott.dangelo@hpe.com" target="_blank">scott.dangelo@hpe.com</a>> wrote:</p>
</div>
<blockquote style="border:none; border-left:solid #CCCCCC 1.0pt; padding:0cm 0cm 0cm 6.0pt; margin-left:4.8pt; margin-right:0cm">
<p class="MsoNormal">If a volume is attached to an instance, and the instance is deleted, the volume will be DETACHED, but the volume will still exist, it will NOT be DELETED.<br>
<br>
It is up to the volume owner to delete the volume if they wish.<br>
<br>
________________________________<br>
From: Will Zhou <<a href="mailto:zzxwill@gmail.com" target="_blank">zzxwill@gmail.com</a>><br>
Sent: Tuesday, June 28, 2016 8:43:51 AM<br>
To: <a href="mailto:aadil@tesora.com" target="_blank">aadil@tesora.com</a>; OpenStack Development Mailing List (not for usage questions)<br>
Subject: Re: [openstack-dev] Change in openstack/trove[master]: Ophaned Volume Not Removed on Instance Delete<br>
<br>
Hi all,<br>
<br>
I'd like to make sure should the volume, which is attached to an instance, be detached or be deleted after the instance is deleted? Thanks.<br>
<br>
<br>
On Tue, Jun 28, 2016 at 10:16 PM Ali Asgar Adil (Code Review) <<a href="mailto:review@openstack.org" target="_blank">review@openstack.org</a><mailto:<a href="mailto:review@openstack.org" target="_blank">review@openstack.org</a>>> wrote:<br>
Ali Asgar Adil has posted comments on this change.<br>
<br>
Change subject: Ophaned Volume Not Removed on Instance Delete<br>
......................................................................<br>
<br>
<br>
Patch Set 1:<br>
<br>
In what situation would a nova instance be in "available" state. Also, we are are deleting the instance so we would want the volume to be deleted as well not detached.<br>
<br>
--<br>
To view, visit <a href="https://review.openstack.org/334722" target="_blank">https://review.openstack.org/334722</a><br>
To unsubscribe, visit <a href="https://review.openstack.org/settings" target="_blank">
https://review.openstack.org/settings</a><br>
<br>
Gerrit-MessageType: comment<br>
Gerrit-Change-Id: Ie921a8ff2851e2d9d76a3c3836945c750f090c4e<br>
Gerrit-PatchSet: 1<br>
Gerrit-Project: openstack/trove<br>
Gerrit-Branch: master<br>
Gerrit-Owner: Ali Asgar Adil <<a href="mailto:aadil@tesora.com" target="_blank">aadil@tesora.com</a><mailto:<a href="mailto:aadil@tesora.com" target="_blank">aadil@tesora.com</a>>><br>
Gerrit-Reviewer: Ali Asgar Adil <<a href="mailto:aadil@tesora.com" target="_blank">aadil@tesora.com</a><mailto:<a href="mailto:aadil@tesora.com" target="_blank">aadil@tesora.com</a>>><br>
Gerrit-Reviewer: Jenkins<br>
Gerrit-Reviewer: zzxwill <<a href="mailto:zzxwill@gmail.com" target="_blank">zzxwill@gmail.com</a><mailto:<a href="mailto:zzxwill@gmail.com" target="_blank">zzxwill@gmail.com</a>>><br>
Gerrit-HasComments: No<br>
--<br>
<br>
---------------------------------------------<br>
?<br>
???<br>
Mobile: 13701280947<<a href="tel:13701280947" target="_blank">tel:13701280947</a>><br>
?WeChat: 472174291<br>
<br>
__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" target="_blank">
OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a></p>
</blockquote>
</div>
<div>
<p class="MsoNormal">-- </p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"> </p>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt; font-family:"Arial","sans-serif"; color:#222222">---------------------------------------------</span></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#222222">​</span><span style="font-family:"Comic Sans MS"; color:#222222"></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"MS Gothic"; color:#222222">周正喜</span><span style="font-family:"Arial","sans-serif"; color:#222222"></span></p>
</div>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Comic Sans MS"; color:#222222">Mobile: <a href="tel:13701280947" target="_blank"><span style="color:#1155CC">13701280947</span></a></span><span style="font-family:"Arial","sans-serif"; color:#222222"></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><span style="color:#222222">​</span><span style="font-family:"Comic Sans MS"; color:#222222">WeChat: 472174291</span><span style="font-family:"Arial","sans-serif"; color:#222222"></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>