Open Stack

Hi ,

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]
Sent: Wednesday, February 04, 2015 1:31 PM
To: openstack at lists.openstack.org
Cc: 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



________________________________

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/20150204/930c19cf/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ATT00001.txt
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20150204/930c19cf/attachment.txt>