when use db2 as the database, ceilometer-dbsync can not work with sqlalchemy
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ceilometer |
Won't Fix
|
Low
|
Unassigned |
Bug Description
After creating a db2 database
then config ceilometer.conf
sql_connection = ibm_db_
ceilometer-dbsync
2013-09-06 01:35:26.157 27539 CRITICAL ceilometer [-] No 'ceilometer.
2013-09-06 01:35:26.157 27539 TRACE ceilometer Traceback (most recent call last):
2013-09-06 01:35:26.157 27539 TRACE ceilometer File "/usr/bin/
2013-09-06 01:35:26.157 27539 TRACE ceilometer sys.exit(dbsync())
2013-09-06 01:35:26.157 27539 TRACE ceilometer File "/usr/lib/
2013-09-06 01:35:26.157 27539 TRACE ceilometer get_connection(
2013-09-06 01:35:26.157 27539 TRACE ceilometer File "/usr/lib/
2013-09-06 01:35:26.157 27539 TRACE ceilometer return get_engine(
2013-09-06 01:35:26.157 27539 TRACE ceilometer File "/usr/lib/
2013-09-06 01:35:26.157 27539 TRACE ceilometer invoke_
2013-09-06 01:35:26.157 27539 TRACE ceilometer File "/usr/lib/
2013-09-06 01:35:26.157 27539 TRACE ceilometer (namespace, name))
2013-09-06 01:35:26.157 27539 TRACE ceilometer RuntimeError: No 'ceilometer.
2013-09-06 01:35:26.157 27539 TRACE ceilometer
For get the engine_name, I comment 'engine_name = urlparse.
Then modify entry_points.txt
Add ibm_db_sa = ceilometer.
then execute ceilometer-dbsync
2013-09-09 04:50:03.517 21830 INFO migrate.
2013-09-09 04:50:03.962 21830 CRITICAL ceilometer [-] ibm_db_
2013-09-09 04:50:03.962 21830 TRACE ceilometer Traceback (most recent call last):
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/bin/
2013-09-09 04:50:03.962 21830 TRACE ceilometer sys.exit(dbsync())
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer get_connection(
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer migration.
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer versioning_
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "<string>", line 2, in _migrate
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer return f(*a, **kw)
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer schema.
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer change.
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer script_func(engine)
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer i.create()
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer checkfirst=
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer conn._run_
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer **kwargs)
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer return meth(obj, **kw)
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer self.traverse_
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer return meth(obj, **kw)
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer self.connection
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer params)
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer compiled
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer context)
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib/
2013-09-09 04:50:03.962 21830 TRACE ceilometer cursor.
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer self._execute_
2013-09-09 04:50:03.962 21830 TRACE ceilometer File "/usr/lib64/
2013-09-09 04:50:03.962 21830 TRACE ceilometer raise self.messages[
2013-09-09 04:50:03.962 21830 TRACE ceilometer Warning: ibm_db_
2013-09-09 04:50:03.962 21830 TRACE ceilometer
and I can see another problem like the error when change the type of some column.
Changed in ceilometer: | |
assignee: | nobody → Chen Xiao (chenxiao) |
status: | New → In Progress |
Changed in ceilometer: | |
milestone: | none → havana-rc1 |
importance: | Undecided → Medium |
milestone: | havana-rc1 → none |
Fix proposed to branch: master /review. openstack. org/46974
Review: https:/