Open Stack

On 02/04/2015 05:28 AM, raghavendra.lad at accenture.com wrote:
>
> 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)
>

Have you checked that the database you have configured for your API cell 
has the cells table in the nova database?

There are multiple databases with cells, one for the API cell and one 
for each child cell.  You will need to run nova-manage db sync for each 
of them so that they are all set up correctly.


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20150204/bb4e58ff/attachment.html>