Open Stack

I can do some consulting if you want :p
Which mail are you referring to?
and what do you mean by “crazy”? Performance-wise or did you have some bugs due to your inconsistent database?

-- 
Razique

On 6 Nov 2013 at 06:06:47, Antonio Messina (antonio.s.messina at gmail.com) wrote:

On Wed, Nov 6, 2013 at 12:46 PM, Razique Mahroua  
<razique.mahroua at gmail.com> wrote:  
> I’d say it’s risky since it’s possible that you end up with inconsistent  
> states, especially with the security_groups and keypairs tables.  
>  
> You should probably dump the whole database and restore it if needed  

I cannot.  
The reason why I need to do it is because the current database is  
already in a state which is driving nova-network crazy.  

I have sent an email a few days ago about the problem we are having  
with our installation. After some more checking, it seems that the
problem is caused by the *data* currently stored in the database; we  
tried with an empty one and everything was working smoothly: instances  
are started within one minute and deleted as needed, while going back  
to the original database brings back the issue.  

So, we guess it's something on the database, but we don't have either  
the time nor the competence nor the need to further debug the issue,  
since we are planning to move Havana soon and we have to keep the  
cloud up&running ASAP.  

Therefore we decided to clean up the database and remove more or less  
everything, but as I said, we would like to keep the information  
mentioned before.  

.a.  

>  
>  
> Razique  
>  
> --  
> Razique  
>  
> On 6 Nov 2013 at 03:46:02, Antonio Messina (antonio.s.messina at gmail.com)
> wrote:  
>  
> Hi all,  
>  
> We need to backup and then recover some information from the nova  
> database, specifically:  
>  
> * flavors  
> * quotas  
> * keypairs  
> * security groups  
>  
> I would like to know which tables I am supposed to back up and  
> recover, I guess the following:  
>  
> * quotas  
> * security_groups
> * security_group_rules
> * instance_types  
>  
> are enough? Can I just dump them with mysqldump and recover them with  
> mysql < backupfile?  
>  
> .a.  
>  
> -- br/>antonio.s.messina@@gmail.com
> antonio.messina at uzh.ch +41 (0)44 635 42 22  
> GC3: Grid Computing Competence Center http://www.gc3.uzh.ch/
> University of Zurich  
> Winterthurerstrasse 190  
> CH-8057 Zurich Switzerland  
>  
> _______________________________________________
> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to : openstack at lists.openstack.org
> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack



--  
antonio.s.messina at gmail.com
antonio.messina at uzh.ch +41 (0)44 635 42 22  
GC3: Grid Computing Competence Center http://www.gc3.uzh.ch/
University of Zurich  
Winterthurerstrasse 190  
CH-8057 Zurich Switzerland  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20131106/743e9d96/attachment.html>