On 02/04/2015 05:28 AM, [email protected] 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:*[email protected]
[mailto:[email protected]]
*Sent:* Wednesday, February 04, 2015 1:31 PM
*To:* [email protected]
*Cc:* [email protected]
*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 : [email protected]
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
_______________________________________________
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : [email protected]
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
