Open Stack

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

> 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.

> 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