Open Stack

Hi Sam,

I am able to run the nova DB sync  however it gives error and is not able to sync with (nova) 8774.
Let me know if we have to create nova cells or user in Mysql database or how rabbit user id for child
Or api user works.


Regards,
Raghavendra Lad

From: Sam Morrison [mailto:sorrison at gmail.com]
Sent: Thursday, February 05, 2015 1:48 AM
To: Lad, Raghavendra
Subject: Re: [Openstack] Running multiple nova-cells

You need to run a DB sync to initialize your DB.

Sam


On 5 Feb 2015, at 1:21 am, <raghavendra.lad at accenture.com<mailto:raghavendra.lad at accenture.com>> <raghavendra.lad at accenture.com<mailto:raghavendra.lad at accenture.com>> wrote:
Hi Sam,

I am able to perform the configuration on API cell as root for child cells.

I need help with the Parent.

I am getting the error

Command failed, please check log for more info
2015-02-04 12:25:26.625 8239 CRITICAL nova [req-de64d699-abba-4cfb-abf7-3e24a9b7c770 None] OperationalError: (OperationalError) no such table: cells u'INSERT INTO cells (deleted_at, deleted, created_at, updated_at, name, api_url, transport_url, weight_offset, weight_scale, is_parent) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (None, 0, '2015-02-04 06:55:26.623676', None, u'api', None, 'rabbit://api_user:api_passwd@hostnameip:5672/api_vhost', 1.0, 1.0, 1)


Regards,
Raghavendra Lad

From: raghavendra.lad at accenture.com<mailto:raghavendra.lad at accenture.com> [mailto:raghavendra.lad at accenture.com]
Sent: Wednesday, February 04, 2015 1:31 PM
To: openstack at lists.openstack.org<mailto:openstack at lists.openstack.org>
Cc: raghavendra_lad at rediffmail.com<mailto:raghavendra_lad at rediffmail.com>
Subject: [Openstack] FW: cells

HI Stackers,

I am trying to implement the cells in Openstack. However I get the below error when I follow the Openstack document.
The controller node has nova-api and all nova services. The compute node has the child configuration. Any thoughts or ideas
Would be appreciated.

Reference
http://docs.openstack.org/juno/config-reference/content/section_compute-cells.html

# nova-manage cell create --name api --cell_type parent \
> --username api_user --password api_passwd --hostname ip\
> --port 5672 --virtual_host api_vhost --woffset 1.0 --wscale 1.0
Command failed, please check log for more info
2015-02-04 12:25:26.625 8239 CRITICAL nova [req-de64d699-abba-4cfb-abf7-3e24a9b7c770 None] OperationalError: (OperationalError) no such table: cells u'INSERT INTO cells (deleted_at, deleted, created_at, updated_at, name, api_url, transport_url, weight_offset, weight_scale, is_parent) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (None, 0, '2015-02-04 06:55:26.623676', None, u'api', None, 'rabbit://api_user:api_passwd@hostnameip:5672/api_vhost', 1.0, 1.0, 1)
2015-02-04 12:25:26.625 8239 TRACE nova Traceback (most recent call last):
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/bin/nova-manage", line 10, in <module>
2015-02-04 12:25:26.625 8239 TRACE nova     sys.exit(main())
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1401, in main
2015-02-04 12:25:26.625 8239 TRACE nova     ret = fn(*fn_args, **fn_kwargs)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1239, in create
2015-02-04 12:25:26.625 8239 TRACE nova     db.cell_create(ctxt, values)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 1558, in cell_create
2015-02-04 12:25:26.625 8239 TRACE nova     return IMPL.cell_create(context, values)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 125, in wrapper
2015-02-04 12:25:26.625 8239 TRACE nova     return f(*args, **kwargs)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 4663, in cell_create
2015-02-04 12:25:26.625 8239 TRACE nova     cell.save()
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/models.py", line 62, in save
2015-02-04 12:25:26.625 8239 TRACE nova     super(NovaBase, self).save(session=session)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/models.py", line 48, in save
2015-02-04 12:25:26.625 8239 TRACE nova     session.flush()
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1919, in flush
2015-02-04 12:25:26.625 8239 TRACE nova     self._flush(objects)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2037, in _flush
2015-02-04 12:25:26.625 8239 TRACE nova     transaction.rollback(_capture_exception=True)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2015-02-04 12:25:26.625 8239 TRACE nova     compat.reraise(exc_type, exc_value, exc_tb)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2001, in _flush
2015-02-04 12:25:26.625 8239 TRACE nova     flush_context.execute()
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute
2015-02-04 12:25:26.625 8239 TRACE nova     rec.execute(self)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute
2015-02-04 12:25:26.625 8239 TRACE nova     uow
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 65, in save_obj
2015-02-04 12:25:26.625 8239 TRACE nova     mapper, table, insert)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 602, in _emit_insert_statements
2015-02-04 12:25:26.625 8239 TRACE nova     execute(statement, params)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
2015-02-04 12:25:26.625 8239 TRACE nova     return meth(self, multiparams, params)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 321, in _execute_on_connection
2015-02-04 12:25:26.625 8239 TRACE nova     return connection._execute_clauseelement(self, multiparams, params)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
2015-02-04 12:25:26.625 8239 TRACE nova     compiled_sql, distilled_params
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
2015-02-04 12:25:26.625 8239 TRACE nova     context)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1156, in _handle_dbapi_exception
2015-02-04 12:25:26.625 8239 TRACE nova     util.raise_from_cause(newraise, exc_info)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2015-02-04 12:25:26.625 8239 TRACE nova     reraise(type(exception), exception, tb=exc_tb)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2015-02-04 12:25:26.625 8239 TRACE nova     context)
2015-02-04 12:25:26.625 8239 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
2015-02-04 12:25:26.625 8239 TRACE nova     cursor.execute(statement, parameters)
2015-02-04 12:25:26.625 8239 TRACE nova OperationalError: (OperationalError) no such table: cells u'INSERT INTO cells (deleted_at, deleted, created_at, updated_at, name, api_url, transport_url, weight_offset, weight_scale, is_parent) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (None, 0, '2015-02-04 06:55:26.623676', None, u'api', None, 'rabbit://api_user:api_passwd@hotsnameip:5672/api_vhost', 1.0, 1.0, 1)
2015-02-04 12:25:26.625 8239 TRACE nova

Regards,
Raghavendra Lad





From: Openstack [mailto:openstack-bounces+raghavendra.lad=accenture.com at lists.launchpad.net] On Behalf Of Sam Morrison
Sent: Monday, July 15, 2013 12:22 PM
To: openstack at lists.launchpad.net<mailto:openstack at lists.launchpad.net> list
Subject: [Openstack] Running multiple nova-cells

Hi,

We have a reasonably large deployment with nova cells and we are having issues consuming messages fast enough at the top level due to all the instance updates etc.

We've done some tuning to some of the periodic tasks but users can trigger hundreds of messages to be sent upwards.
It looks like a bug where 1 message to be sent upwards somehow turns into about 50. We're debugging this at the moment.

Bu what I'm also wondering is if it's possible to run multiple nova-cell processes within a cell?
I see there is a blueprint [1]  which makes me think it's not possible yet?

We get spikes of 100/200 messages a second for a couple minutes and it takes a while for our nova-cell service to consume all of these.

Cheers,
Sam


[1] https://blueprints.launchpad.net/nova/+spec/multiple-nova-cell


________________________________

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
______________________________________________________________________________________

www.accenture.com<http://www.accenture.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20150205/5cfa2aef/attachment.html>