<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif"><span style="font-size:13px">Hi stackers!</span></div><div class="gmail_default" style="font-size:13px;font-family:tahoma,sans-serif"><br>When integrating ceilometer I experience periodic task errors on a compute node.</div>
<div class="gmail_default" style="font-size:13px;font-family:tahoma,sans-serif">I paste below my configurations, if anyone has experienced this or a clue of what could be the cause info would be very helpful.<br><br></div>
<div class="gmail_default" style="font-size:13px;font-family:tahoma,sans-serif">The error output is:</div><div class="gmail_default" style="font-size:13px;font-family:tahoma,sans-serif">nova-compute.log======================================</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:13px"><div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task Traceback (most recent call last):</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 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</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task task(self, context)</font></div><div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/compute/manager.py", line 4495, in _instance_usage_audit</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task self.host, num_instances)</font></div><div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/compute/utils.py", line 372, in start_instance_usage_audit</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task "Instance usage audit started...")</font></div><div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/conductor/api.py", line 279, in task_log_begin_task</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task task_items, message)</font></div><div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/conductor/rpcapi.py", line 411, in task_log_begin_task</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task task_items=task_items, message=message)</font></div><div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/rpcclient.py", line 85, in call</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task return self._invoke(self.proxy.call, ctxt, method, **kwargs)</font></div><div class="gmail_default">
<font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/rpcclient.py", line 63, in _invoke</font></div><div class="gmail_default">
<font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task return cast_or_call(ctxt, msg, **self.kwargs)</font></div><div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/proxy.py", line 126, in call</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task result = rpc.call(context, real_topic, msg, timeout)</font></div><div class="gmail_default">
<font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/__init__.py", line 139, in call</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task return _get_impl().call(CONF, context, topic, msg, timeout)</font></div><div class="gmail_default">
<font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/impl_kombu.py", line 816, in call</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task rpc_amqp.get_connection_pool(conf, Connection))</font></div><div class="gmail_default">
<font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 574, in call</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task rv = list(rv)</font></div><div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 539, in __iter__</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task raise result</font></div><div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 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-11-20T06:00:00.000000', 'state': 'RUNNING', 'updated_at': None, 'host': u'infra-eval-06', 'task_items': 2, 'task_name': u'instance_usage_audit', 'period_beginning': u'2013-11-20T05:00:00.000000', 'message': u'Instance usage audit started...', 'deleted_at': None}]</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">2013-11-20 15:01:46.068 22480 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-11-20T06:00:00.000000', 'state': 'RUNNING', 'updated_at': None, 'host': u'infra-eval-06', 'task_items': 2, 'task_name': u'instance_usage_audit', 'period_beginning': u'2013-11-20T05:00:00.000000', 'message': u'Instance usage audit started...', 'deleted_at': None}]\n"].</font></div>
</div><div style="font-family:arial,sans-serif;font-size:13px"><div dir="ltr"><div><div class="gmail_default" style="font-family:tahoma,sans-serif">===========================================</div><div class="gmail_default" style="font-family:tahoma,sans-serif">
<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif">My nova.conf is:</div><div class="gmail_default" style="font-family:tahoma,sans-serif">nova.conf===========================================<br>
</div>
<div>[DEFAULT]</div><div>dhcpbridge_flagfile=/etc/nova/nova.conf</div><div>dhcpbridge=/usr/bin/nova-dhcpbridge</div><div>logdir=/var/log/nova</div><div>state_path=/var/lib/nova</div><div>lock_path=/var/lock/nova</div><div>
force_dhcp_release=True</div><div>iscsi_helper=tgtadm</div><div>libvirt_use_virtio_for_bridges=True</div><div>connection_type=libvirt</div><div>root_helper=sudo nova-rootwrap /etc/nova/rootwrap.conf</div><div>verbose=False</div>
<div>debug=False</div><div>ec2_private_dns_show_ip=True</div><div>api_paste_config=/etc/nova/api-paste.ini</div><div>volumes_path=/var/lib/nova/volumes</div><div>enabled_apis=ec2,osapi_compute,metadata</div><div>connection = mysql://nova:password@infra-eval-03/nova</div>
<div>my_ip=192.168.1.26</div><div>vncserver_listen=0.0.0.0</div><div>vncserver_proxyclient_address=172.16.1.16</div><div>rpc_backend = nova.rpc.impl_kombu</div><div>rabbit_host = infra-eval-03</div><div>glance_host = infra-eval-03</div>
<div>network_api_class=nova.network.neutronv2.api.API</div><div>neutron_url=<a href="http://infra-eval-03:9696/" target="_blank">http://infra-eval-03:9696</a></div><div>neutron_auth_strategy=keystone</div><div>neutron_admin_tenant_name=service</div>
<div>neutron_admin_username=neutron</div><div>neutron_admin_password=password</div><div>neutron_admin_auth_url=<a href="http://infra-eval-03:35357/v2.0" target="_blank">http://infra-eval-03:35357/v2.0</a></div><div>firewall_driver=nova.virt.firewall.NoopFirewallDriver</div>
</div><div><div class="gmail_default" style="font-family:tahoma,sans-serif">===========================================</div><div class="gmail_default" style="font-family:tahoma,sans-serif"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif">
My ceilometer conf file is:</div><div class="gmail_default" style="font-family:tahoma,sans-serif">ceilometer.conf===========================================</div><div class="gmail_default"><div class="gmail_default"><font face="tahoma, sans-serif">[DEFAULT]</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">sqlite_db=ceilometer.sqlite</font></div><div class="gmail_default"><font face="tahoma, sans-serif">log_dir=/var/log/ceilometer</font></div><div class="gmail_default">
<font face="tahoma, sans-serif">rabbit_host=infra-eval-03</font></div><div class="gmail_default"><font face="tahoma, sans-serif">[publisher_rpc]</font></div><div class="gmail_default"><font face="tahoma, sans-serif">metering_secret=password</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">[ssl]</font></div><div class="gmail_default"><font face="tahoma, sans-serif">[database]</font></div><div class="gmail_default"><font face="tahoma, sans-serif">connection = mongodb://ceilometer:password@infra-eval-03:27017/ceilometer</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">[alarm]</font></div><div class="gmail_default"><font face="tahoma, sans-serif">[rpc_notifier2]</font></div><div class="gmail_default"><font face="tahoma, sans-serif">[api]</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">[service_credentials]</font></div><div class="gmail_default"><font face="tahoma, sans-serif">[dispatcher_file]</font></div><div class="gmail_default"><font face="tahoma, sans-serif">[keystone_authtoken]</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">auth_host = infra-eval-03</font></div><div class="gmail_default"><font face="tahoma, sans-serif">auth_port = 35357</font></div><div class="gmail_default"><font face="tahoma, sans-serif">auth_protocol = http</font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">admin_tenant_name = service</font></div><div class="gmail_default"><font face="tahoma, sans-serif">admin_user = ceilometer</font></div><div class="gmail_default">
<font face="tahoma, sans-serif">admin_password = password</font></div><div class="gmail_default"><font face="tahoma, sans-serif">auth_uri = <a href="http://192.168.1.23:5000/" target="_blank">http://192.168.1.23:5000</a></font></div>
<div class="gmail_default"><font face="tahoma, sans-serif">[collector]</font></div><div class="gmail_default"><font face="tahoma, sans-serif">[matchmaker_ring]</font></div><div class="gmail_default"><font face="tahoma, sans-serif">[matchmaker_redis]</font></div>
</div><div class="gmail_default" style="font-family:tahoma,sans-serif">===========================================</div><div class="gmail_default" style="font-family:tahoma,sans-serif"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif">
regards</div></div></div></div><div class="gmail_default" style="font-family:tahoma,sans-serif"><br clear="all"></div><div><div dir="ltr"><div><br></div><font face="tahoma, sans-serif"><b style="color:rgb(51,51,51)">BUSSY Jean-Daniel</b><br>
<br></font></div></div>
</div>