I am trying to implement multi-region setup with OpenStack. I have two nodes with following configuration:-
Installed components:- MySQL, keystone, nova, glance, cinder, horizon, heat, ceilometer.
Created two endpoints for each services with regionOne as this node and regionTwo as next node.
Installed components:- MySQL, nova, glance, cinder, horizon, heat, ceilometer.
All services are using node1 as auth (keystone) server and with local database.
With above setup i can see two Regions at Horizon (Dashboard) of node1 and can create networks, routers, images at regionTwo.
But while creating Instances i get following error at both nodes.
2013-12-26 11:58:07.130 2389 INFO nova.compute.manager [-] Running instance usage audit for host "HOSTNAME" from 2013-12-26 09:00:00 to 2013-12-26 10:00:00. 4 instances.
2013-12-26 11:58:07.138 2389 ERROR nova.openstack.common.periodic_task [-] Error during ComputeManager._instance_usage_audit: Remote error: DBError SQLite DateTime type only accepts Python datetime and date objects as input. (original cause: TypeError: SQLite DateTime type only accepts Python datetime and date objects as input.) 'INSERT INTO task_log (created_at, updated_at, deleted_at, deleted, task_name, state, host, period_beginning, period_ending, message, task_items, errors) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' [{'period_ending': u'2013-12-26T10:00:00.000000', 'state': 'RUNNING', 'updated_at': None, 'host': u'"HOSTNAME"', 'task_items': 4, 'task_name': u'instance_usage_audit', 'period_beginning': u'2013-12-26T09:00:00.000000', 'message': u'Instance usage audit started...', 'deleted_at': None}]
[u'Traceback (most recent call last):\n', u' File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 461, in _process_data\n **args)\n', u' File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/dispatcher.py", line 172, in dispatch\n result = getattr(proxyobj, method)(ctxt, **kwargs)\n', u' File "/usr/lib/python2.7/dist-packages/nova/conductor/manager.py", line 471, in task_log_begin_task\n message)\n', u' File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 1891, in task_log_begin_task\n message)\n', u' File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 108, in wrapper\n return f(*args, **kwargs)\n', u' File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 5435, in task_log_begin_task\n task.save()\n', u' File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/models.py", line 53, in save\n session.flush()\n', u' File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 543, in _wrap\n raise exception.DBError(e)\n', u"DBError: SQLite DateTime type only accepts Python datetime and date objects as input. (original cause: TypeError: SQLite DateTime type only accepts Python datetime and date objects as input.) 'INSERT INTO task_log (created_at, updated_at, deleted_at, deleted, task_name, state, host, period_beginning, period_ending, message, task_items, errors) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' [{'period_ending': u'2013-12-26T10:00:00.000000', 'state': 'RUNNING', 'updated_at': None, 'host': u'"HOSTNAME"', 'task_items': 4, 'task_name': u'instance_usage_audit', 'period_beginning': u'2013-12-26T09:00:00.000000', 'message': u'Instance usage audit started...', 'deleted_at': None}]\n"].
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task Traceback (most recent call last):
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/periodic_task.py", line 180, in run_periodic_tasks
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task task(self, context)
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/compute/manager.py", line 4495, in _instance_usage_audit
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task self.host, num_instances)
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/compute/utils.py", line 372, in start_instance_usage_audit
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task "Instance usage audit started...")
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/conductor/api.py", line 279, in task_log_begin_task
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task task_items, message)
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/conductor/rpcapi.py", line 411, in task_log_begin_task
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task task_items=task_items, message=message)
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/rpcclient.py", line 85, in call
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task return self._invoke(self.proxy.call, ctxt, method, **kwargs)
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/rpcclient.py", line 63, in _invoke
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task return cast_or_call(ctxt, msg, **self.kwargs)
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/proxy.py", line 126, in call
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task result = rpc.call(context, real_topic, msg, timeout)
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/__init__.py", line 139, in call
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task return _get_impl().call(CONF, context, topic, msg, timeout)
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/impl_kombu.py", line 816, in call
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task rpc_amqp.get_connection_pool(conf, Connection))
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 574, in call
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task rv = list(rv)
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 539, in __iter__
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task raise result
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task RemoteError: Remote error: DBError SQLite DateTime type only accepts Python datetime and date objects as input. (original cause: TypeError: SQLite DateTime type only accepts Python datetime and date objects as input.) 'INSERT INTO task_log (created_at, updated_at, deleted_at, deleted, task_name, state, host, period_beginning, period_ending, message, task_items, errors) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' [{'period_ending': u'2013-12-26T10:00:00.000000', 'state': 'RUNNING', 'updated_at': None, 'host': u'"HOSTNAME"', 'task_items': 4, 'task_name': u'instance_usage_audit', 'period_beginning': u'2013-12-26T09:00:00.000000', 'message': u'Instance usage audit started...', 'deleted_at': None}]
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task [u'Traceback (most recent call last):\n', u' File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 461, in _process_data\n **args)\n', u' File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/dispatcher.py", line 172, in dispatch\n result = getattr(proxyobj, method)(ctxt, **kwargs)\n', u' File "/usr/lib/python2.7/dist-packages/nova/conductor/manager.py", line 471, in task_log_begin_task\n message)\n', u' File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 1891, in task_log_begin_task\n message)\n', u' File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 108, in wrapper\n return f(*args, **kwargs)\n', u' File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 5435, in task_log_begin_task\n task.save()\n', u' File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/models.py", line 53, in save\n session.flush()\n', u' File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 543, in _wrap\n raise exception.DBError(e)\n', u"DBError: SQLite DateTime type only accepts Python datetime and date objects as input. (original cause: TypeError: SQLite DateTime type only accepts Python datetime and date objects as input.) 'INSERT INTO task_log (created_at, updated_at, deleted_at, deleted, task_name, state, host, period_beginning, period_ending, message, task_items, errors) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' [{'period_ending': u'2013-12-26T10:00:00.000000', 'state': 'RUNNING', 'updated_at': None, 'host': u'"HOSTNAME"', 'task_items': 4, 'task_name': u'instance_usage_audit', 'period_beginning': u'2013-12-26T09:00:00.000000', 'message': u'Instance usage audit started...', 'deleted_at': None}]\n"].
2013-12-26 11:58:07.138 2389 TRACE nova.openstack.common.periodic_task
2013-12-26 11:58:07.141 2389 AUDIT nova.compute.resource_tracker [-] Auditing locally available compute resources
2013-12-26 11:58:07.490 2389 AUDIT nova.compute.resource_tracker [-] Free ram (MB): 35496
2013-12-26 11:58:07.490 2389 AUDIT nova.compute.resource_tracker [-] Free disk (GB): 1689
2013-12-26 11:58:07.490 2389 AUDIT nova.compute.resource_tracker [-] Free VCPUS: 2
2013-12-26 11:58:07.670 2389 INFO nova.compute.resource_tracker [-] Compute_service record updated for "HOSTNAME":"HOSTNAME"