Open Stack

Hi Glynn,
Thanks for helping. I also started to exclude ceilometer as a culprit when
I commented out the monitoring settings on the compute host and still got
the error.
My nova-conductor init.d file suggest that nova-conductor use nova.conf as
a configuration file.
I double checked the nova.conf files across both controller and compute and
there is no difference between them except the parameter "my_ip".
I might be missing a nova.conf parameter...

​Cheers​,

*BUSSY Jean-Daniel*


On Wed, Nov 20, 2013 at 6:34 PM, Eoghan Glynn <eglynn at redhat.com> wrote:

>
> Hi Jean-Daniel,
>
> That doesn't look like a ceilometer issue.
>
> Rather, IIUC it's a case of the nova-compute agent reporting an issue
> from the nova-conductor service when it calls out to the conductor over
> RPC to record the beginning of a task in the task log.
>
> Interestingly, the error message seems to suggest that the nova-conductor
> is using sqlite:
>
>   DBError SQLite DateTime type only accepts Python datetime and date
> objects as input.
>
> whereas the nova.conf you quote suggests that mysql is in use:
>
>   connection = mysql://nova:password@infra-eval-03/nova
>
> Please check the config used by your nova-conductor service, as the
> same DB should be configured for the nova services across the board.
>
> Cheers,
> Eoghan
>
> ----- Original Message -----
> > ​​ Hi stackers!
> >
> > When integrating ceilometer I experience periodic task errors on a
> compute
> > node.
> > I paste below my configurations, if anyone has experienced this or a
> clue of
> > what could be the cause info would be very helpful.
> >
> > The error output is:
> > nova-compute.log======================================
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > Traceback (most recent call last):
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > task(self, context)
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > self.host, num_instances)
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > "Instance usage audit started...")
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > task_items, message)
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > task_items=task_items, message=message)
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > return self._invoke(self.proxy.call, ctxt, method, **kwargs)
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > return cast_or_call(ctxt, msg, **self.kwargs)
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > result = rpc.call(context, real_topic, msg, timeout)
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > return _get_impl().call(CONF, context, topic, msg, timeout)
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> > rpc_amqp.get_connection_pool(conf, Connection))
> > 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
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> rv =
> > list(rv)
> > 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__
> > 2013-11-20 15:01:46.068 22480 TRACE nova.openstack.common.periodic_task
> raise
> > result
> > 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}]
> > 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"].
> > ​===========================================​
> >
> > My nova.conf is:
> > nova.conf​===========================================​
> > [DEFAULT]
> > dhcpbridge_flagfile=/etc/nova/nova.conf
> > dhcpbridge=/usr/bin/nova-dhcpbridge
> > logdir=/var/log/nova
> > state_path=/var/lib/nova
> > lock_path=/var/lock/nova
> > force_dhcp_release=True
> > iscsi_helper=tgtadm
> > libvirt_use_virtio_for_bridges=True
> > connection_type=libvirt
> > root_helper=sudo nova-rootwrap /etc/nova/rootwrap.conf
> > verbose=False
> > debug=False
> > ec2_private_dns_show_ip=True
> > api_paste_config=/etc/nova/api-paste.ini
> > volumes_path=/var/lib/nova/volumes
> > enabled_apis=ec2,osapi_compute,metadata
> > connection = mysql://nova:password@infra-eval-03/nova
> > my_ip=192.168.1.26
> > vncserver_listen=0.0.0.0
> > vncserver_proxyclient_address=172.16.1.16
> > rpc_backend = nova.rpc.impl_kombu
> > rabbit_host = infra-eval-03
> > glance_host = infra-eval-03
> > network_api_class=nova.network.neutronv2.api.API
> > neutron_url= http://infra-eval-03:9696
> > neutron_auth_strategy=keystone
> > neutron_admin_tenant_name=service
> > neutron_admin_username=neutron
> > neutron_admin_password=password
> > neutron_admin_auth_url= http://infra-eval-03:35357/v2.0
> > firewall_driver=nova.virt.firewall.NoopFirewallDriver
> > ​​===========================================​
> >
> > My ceilometer conf file is:
> > ceilometer.conf​===========================================​
> > [DEFAULT]
> > sqlite_db=ceilometer.sqlite
> > log_dir=/var/log/ceilometer
> > rabbit_host=infra-eval-03
> > [publisher_rpc]
> > metering_secret=password
> > [ssl]
> > [database]
> > connection = mongodb://ceilometer:password@infra-eval-03
> :27017/ceilometer
> > [alarm]
> > [rpc_notifier2]
> > [api]
> > [service_credentials]
> > [dispatcher_file]
> > [keystone_authtoken]
> > auth_host = infra-eval-03
> > auth_port = 35357
> > auth_protocol = http
> > admin_tenant_name = service
> > admin_user = ceilometer
> > admin_password = password
> > auth_uri = http://192.168.1.23:5000
> > [collector]
> > [matchmaker_ring]
> > [matchmaker_redis]
> > ​===========================================​​
> >
> > regards
> >
> >
> > BUSSY Jean-Daniel
> >
> >
> > _______________________________________________
> > Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> > Post to     : openstack at lists.openstack.org
> > Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20131120/56d9324e/attachment.html>