Open Stack

On 6 Nov 2013 at 10:48:30, Antonio Messina (antonio.s.messina at gmail.com) wrote:
On Wed, Nov 6, 2013 at 7:27 PM, Razique Mahroua 
<razique.mahroua at gmail.com> wrote: 
> Thank you for your feedback 
> How many fields does the “fixed_ips” contain? 

256 
Ok it’s not much


> what’s the size of the database? 

what do you mean? Which table? Or the size of the file? The 
`instances` table has 38k rows, the /var/lib/mysql has only 5.1GB but 
it also contains an old backup. 

> You can check rabbitmq log to see if there’s anything suspicious 

Rabbitmq seems fine. I don't see any queued message on any queue. 

.a. 
Are others CLI operations fine? such as keystone user-list, nova reboot etc…?





> On 6 Nov 2013 at 06:28:16, Antonio Messina (antonio.s.messina at gmail.com) 
> wrote: 
> 
> On Wed, Nov 6, 2013 at 3:06 PM, Razique Mahroua 
> <razique.mahroua at gmail.com> wrote: 
>> I can do some consulting if you want :p 
> 
> This may be interesting, but totally off topic :) 
> 
>> Which mail are you referring to? 
> 
> This one: 
> http://lists.openstack.org/pipermail/openstack/2013-November/002623.html 
> subject: "Instances fail during/after networking" 
> 
>> and what do you mean by “crazy”? Performance-wise or did you have some 
>> bugs 
>> due to your inconsistent database? 
> 
> nova-network is spinning at 80-90% of cpu for minutes, giving IP 
> addresses only after a few *minutes*, so that the creation of the VM 
> goes in timeout and thus is failing. 
> Similarly when deleting a VM, it takes ages and sometimes I have to 
> terminate them twice in order to have them killed. 
> 
> .a. 
> 
> 
>> 
>> -- 
>> 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 
>> 
>> 
>> 
>> -- 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 
> 
> 
> 
> -- 
> 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 



-- 
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/da742b5e/attachment.html>