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:[email protected]] 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, <[email protected]<mailto:[email protected]>> <[email protected]<mailto:[email protected]>> 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: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Wednesday, February 04, 2015 1:31 PM To: [email protected]<mailto:[email protected]> Cc: [email protected]<mailto:[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 From: Openstack [mailto:openstack-bounces+raghavendra.lad=accenture....@lists.launchpad.net] On Behalf Of Sam Morrison Sent: Monday, July 15, 2013 12:22 PM To: [email protected]<mailto:[email protected]> 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>
_______________________________________________ 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
