Ask Your Question
0

Getting TypeError SQLite DateTime while creating multi-region setup [closed]

asked 2013-12-26 23:35:38 -0500

sushan.pth gravatar image

updated 2013-12-27 14:40:59 -0500

smaffulli gravatar image

I am trying to implement multi-region setup with OpenStack. I have two nodes with following configuration:-

First node (node1):- 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.

Second node (node2):- 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 (nova-compute.log).


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

(more)
edit retag flag offensive reopen delete

Closed for the following reason too localized by Closed for the following reason "too localized" by dheeru
close date 2014-01-03 02:54:13.698076

2 answers

Sort by ยป oldest newest most voted
0

answered 2013-12-27 21:06:17 -0500

dheeru gravatar image

You must be using the SQLLite wrongly. Check your nova.conf on compute node. Your description says that you are using the mysql. Ensure that you have done the complete configuration for sql on compute.

edit flag offensive delete publish link more

Comments

Do you have problem ? Is this resolved ?

dheeru ( 2014-01-02 08:26:03 -0500 )edit

ok. shall I go ahead and close the issue ?

dheeru ( 2014-01-03 01:01:08 -0500 )edit
0

answered 2014-01-03 00:07:36 -0500

sushan.pth gravatar image

Hi,

Thanks for answer. I formatted and reinstalled OS and installed Fresh OpenStack and now multi-region is working fine.

edit flag offensive delete publish link more

Question Tools

Follow
1 follower

Stats

Asked: 2013-12-26 23:35:38 -0500

Seen: 84 times

Last updated: Jan 03