sql migration error in 020_add_metadata_tables

[gordon chung]

2013-12-04 10:06:54.715 16748 CRITICAL ceilometer [-] Boolean value of this clause is not defined
2013-12-04 10:06:54.715 16748 TRACE ceilometer Traceback (most recent call last):
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/usr/local/bin/ceilometer-dbsync", line 10, in <module>
2013-12-04 10:06:54.715 16748 TRACE ceilometer sys.exit(dbsync())
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/opt/stack/ceilometer/ceilometer/storage/__init__.py", line 140, in dbsync
2013-12-04 10:06:54.715 16748 TRACE ceilometer get_connection(cfg.CONF).upgrade()
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/opt/stack/ceilometer/ceilometer/storage/impl_sqlalchemy.py", line 179, in upgrade
2013-12-04 10:06:54.715 16748 TRACE ceilometer migration.db_sync(session.get_bind())
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/opt/stack/ceilometer/ceilometer/storage/sqlalchemy/migration.py", line 36, in db_sync
2013-12-04 10:06:54.715 16748 TRACE ceilometer versioning_api.upgrade(engine, repository)
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
2013-12-04 10:06:54.715 16748 TRACE ceilometer return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "<string>", line 2, in _migrate
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 159, in with_engine
2013-12-04 10:06:54.715 16748 TRACE ceilometer return f(*a, **kw)
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
2013-12-04 10:06:54.715 16748 TRACE ceilometer schema.runchange(ver, change, changeset.step)
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in runchange
2013-12-04 10:06:54.715 16748 TRACE ceilometer change.run(self.engine, step)
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145, in run
2013-12-04 10:06:54.715 16748 TRACE ceilometer script_func(engine)
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/opt/stack/ceilometer/ceilometer/storage/sqlalchemy/migrate_repo/versions/020_add_metadata_tables.py", line 66, in upgrade
2013-12-04 10:06:54.715 16748 TRACE ceilometer if ins:
2013-12-04 10:06:54.715 16748 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/expression.py", line 1803, in __nonzero__
2013-12-04 10:06:54.715 16748 TRACE ceilometer raise TypeError("Boolean value of this clause is not defined")
2013-12-04 10:06:54.715 16748 TRACE ceilometer TypeError: Boolean value of this clause is not defined

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/59999

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/59999
Committed: http://github.com/openstack/ceilometer/commit/765370b89fd8a65dbfa8e50e86c2aa17b53b8ad6
Submitter: Jenkins
Branch: master

commit 765370b89fd8a65dbfa8e50e86c2aa17b53b8ad6
Author: Gordon Chung <email address hidden>
Date: Wed Dec 4 10:16:22 2013 -0500

    sql migration error in 020_add_metadata_tables

    - add check to verify resource_metadata is not empty
    - fix check to verify insert statement is set

    Change-Id: I6b7c1d4a8ebf35af2547d97baa39831597012468
    Closes-Bug: #1257779