devstack

Ceilometer fails to sync db

Bug #1298415 reported by Dimitri Mazmanov on 2014-03-27

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	devstack	Invalid	Undecided	Unassigned

Bug Description

This problem occurs when I try to install ceilometer 2014.1.b3 branch

2014-03-27 14:10:50.668 | 2014-03-27 14:10:49.621 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.671 | 2014-03-27 14:10:49.622 8471 INFO migrate.versioning.api [-] 17 -> 18...
2014-03-27 14:10:50.673 | 2014-03-27 14:10:49.695 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.675 | 2014-03-27 14:10:49.695 8471 INFO migrate.versioning.api [-] 18 -> 19...
2014-03-27 14:10:50.678 | 2014-03-27 14:10:49.758 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.680 | 2014-03-27 14:10:49.758 8471 INFO migrate.versioning.api [-] 19 -> 20...
2014-03-27 14:10:50.682 | 2014-03-27 14:10:49.892 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.685 | 2014-03-27 14:10:49.892 8471 INFO migrate.versioning.api [-] 20 -> 21...
2014-03-27 14:10:50.687 | 2014-03-27 14:10:49.971 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.690 | 2014-03-27 14:10:49.971 8471 INFO migrate.versioning.api [-] 21 -> 22...
2014-03-27 14:10:50.692 | 2014-03-27 14:10:50.027 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.694 | 2014-03-27 14:10:50.027 8471 INFO migrate.versioning.api [-] 22 -> 23...
2014-03-27 14:10:50.697 | 2014-03-27 14:10:50.119 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.699 | 2014-03-27 14:10:50.119 8471 INFO migrate.versioning.api [-] 23 -> 24...
2014-03-27 14:10:50.703 | 2014-03-27 14:10:50.248 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.705 | 2014-03-27 14:10:50.248 8471 INFO migrate.versioning.api [-] 24 -> 25...
2014-03-27 14:10:50.708 | 2014-03-27 14:10:50.373 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.710 | 2014-03-27 14:10:50.373 8471 INFO migrate.versioning.api [-] 25 -> 26...
2014-03-27 14:10:50.713 | 2014-03-27 14:10:50.451 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.715 | 2014-03-27 14:10:50.451 8471 INFO migrate.versioning.api [-] 26 -> 27...
2014-03-27 14:10:50.718 | 2014-03-27 14:10:50.510 8471 INFO migrate.versioning.api [-] done
2014-03-27 14:10:50.721 | 2014-03-27 14:10:50.511 8471 INFO migrate.versioning.api [-] 27 -> 28...
2014-03-27 14:10:50.724 | 2014-03-27 14:10:50.619 8471 CRITICAL ceilometer [-] OperationalError: (OperationalError) (1051, "Unknown table 'alembic_version'") '\nDROP TABLE alembic_version' ()
2014-03-27 14:10:50.726 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer Traceback (most recent call last):
2014-03-27 14:10:50.729 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/bin/ceilometer-dbsync", line 10, in <module>
2014-03-27 14:10:50.731 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer sys.exit(dbsync())
2014-03-27 14:10:50.734 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/opt/stack/ceilometer/ceilometer/storage/__init__.py", line 164, in dbsync
2014-03-27 14:10:50.738 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer get_connection(cfg.CONF).upgrade()
2014-03-27 14:10:50.740 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/opt/stack/ceilometer/ceilometer/storage/impl_sqlalchemy.py", line 231, in upgrade
2014-03-27 14:10:50.743 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer migration.db_sync(self._engine)
2014-03-27 14:10:50.745 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/opt/stack/ceilometer/ceilometer/storage/sqlalchemy/migration.py", line 32, in db_sync
2014-03-27 14:10:50.748 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer versioning_api.upgrade(engine, repository)
2014-03-27 14:10:50.750 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
2014-03-27 14:10:50.752 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2014-03-27 14:10:50.755 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "<string>", line 2, in _migrate
2014-03-27 14:10:50.757 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 159, in with_engine
2014-03-27 14:10:50.760 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer return f(*a, **kw)
2014-03-27 14:10:50.763 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
2014-03-27 14:10:50.765 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer schema.runchange(ver, change, changeset.step)
2014-03-27 14:10:50.768 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in runchange
2014-03-27 14:10:50.770 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer change.run(self.engine, step)
2014-03-27 14:10:50.773 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145, in run
2014-03-27 14:10:50.775 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer script_func(engine)
2014-03-27 14:10:50.778 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/opt/stack/ceilometer/ceilometer/storage/sqlalchemy/migrate_repo/versions/028_alembic_migrations.py", line 135, in upgrade
2014-03-27 14:10:50.781 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer delete_alembic(meta)
2014-03-27 14:10:50.783 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/opt/stack/ceilometer/ceilometer/storage/sqlalchemy/migrate_repo/versions/028_alembic_migrations.py", line 32, in delete_alembic
2014-03-27 14:10:50.786 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer sa.Table('alembic_version', meta, autoload=True).drop()
2014-03-27 14:10:50.788 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 662, in drop
2014-03-27 14:10:50.790 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer checkfirst=checkfirst)
2014-03-27 14:10:50.793 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1516, in _run_visitor
2014-03-27 14:10:50.796 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer conn._run_visitor(visitorcallable, element, **kwargs)
2014-03-27 14:10:50.799 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1164, in _run_visitor
2014-03-27 14:10:50.801 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer **kwargs).traverse_single(element)
2014-03-27 14:10:50.804 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 119, in traverse_single
2014-03-27 14:10:50.806 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer return meth(obj, **kw)
2014-03-27 14:10:50.809 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 823, in visit_table
2014-03-27 14:10:50.812 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer self.connection.execute(DropTable(table))
2014-03-27 14:10:50.815 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 717, in execute
2014-03-27 14:10:50.818 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer return meth(self, multiparams, params)
2014-03-27 14:10:50.821 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 67, in _execute_on_connection
2014-03-27 14:10:50.823 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer return connection._execute_ddl(self, multiparams, params)
2014-03-27 14:10:50.826 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 771, in _execute_ddl
2014-03-27 14:10:50.829 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer compiled
2014-03-27 14:10:50.833 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 927, in _execute_context
2014-03-27 14:10:50.836 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer context)
2014-03-27 14:10:50.839 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1076, in _handle_dbapi_exception
2014-03-27 14:10:50.841 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer exc_info
2014-03-27 14:10:50.844 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
2014-03-27 14:10:50.846 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer reraise(type(exception), exception, tb=exc_tb)
2014-03-27 14:10:50.849 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 920, in _execute_context
2014-03-27 14:10:50.851 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer context)
2014-03-27 14:10:50.853 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 425, in do_execute
2014-03-27 14:10:50.855 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer cursor.execute(statement, parameters)
2014-03-27 14:10:50.858 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2014-03-27 14:10:50.860 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer self.errorhandler(self, exc, value)
2014-03-27 14:10:50.864 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2014-03-27 14:10:50.867 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer raise errorclass, errorvalue
2014-03-27 14:10:50.869 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer OperationalError: (OperationalError) (1051, "Unknown table 'alembic_version'") '\nDROP TABLE alembic_version' ()
2014-03-27 14:10:50.871 | 2014-03-27 14:10:50.619 8471 TRACE ceilometer
2014-03-27 14:10:50.874 | + exit_trap
2014-03-27 14:10:50.877 | + local r=1
2014-03-27 14:10:50.880 | ++ jobs -p
2014-03-27 14:10:50.883 | + jobs=
2014-03-27 14:10:50.885 | + [[ -n '' ]]
2014-03-27 14:10:50.888 | + exit 1

Here's my local.conf

#Credentials
ADMIN_PASSWORD=devstack
MYSQL_PASSWORD=devstack
RABBIT_PASSWORD=devstack
SERVICE_PASSWORD=devstack
SERVICE_TOKEN=devstack

# Network configuration
HOST_IP=192.168.55.10
HOST_IP_IFACE=eth1
FLAT_INTERFACE=br100
PUBLIC_INTERFACE=eth1
FLOATING_RANGE=192.168.55.224/27

# Keep data directory separate from /opt/stack due to sharing
DATA_DIR=/opt/data

#Log Output
LOGFILE=stack.sh.log
VERBOSE=True
LOG_COLOR=True

#Stable Branches
NOVA_BRANCH=2014.1.b3
CINDER_BRANCH=2014.1.b3
GLANCE_BRANCH=2014.1.b3
KEYSTONE_BRANCH=2014.1.b3
NEUTRON_BRANCH=2014.1.b3
SWIFT_BRANCH=2014.1.b3
HEAT_BRANCH=2014.1.b3
CEILOMETER_BRANCH=2014.1.b3

# Horizon (master branch)
ENABLED_SERVICES+=,horizon
HORIZON_REPO=https://github.com/openstack/horizon
HORIZON_BRANCH=master

# Heat (master branch)
HEAT_REPO=https://github.com/openstack/heat.git
HEAT_BRANCH=master

#Enabled services
enable_service rabbit
enable_service mysql
enable_service key

##Neutron
disable_service n-net
enable_service q-svc
enable_service q-agt
enable_service q-dhcp
enable_service q-l3
enable_service q-meta
enable_service neutron

# Disable Cinder as it not needed
disable_service cinder
disable_service c-api
disable_service c-sch
disable_service c-vol

##Swift
#enable_service s-proxy s-object s-container s-account

##Heat
ENABLED_SERVICES+=,heat,h-api,h-api-cfn,h-api-cw,h-eng
#IMAGE_URLS+=",http://fedorapeople.org/groups/heat/prebuilt-jeos-images/F17-x86_64-cfntools.qcow2"
#IMAGE_URLS+=",https://launchpad.net/cirros/trunk/0.3.0/+download/cirros-0.3.0-x86_64-disk.img"

##Ceilometer
CEILOMETER_BACKEND=mysql
enable_service ceilometer-acompute ceilometer-acentral ceilometer-anotification ceilometer-collector
enable_service ceilometer-alarm-evaluator,ceilometer-alarm-notifier
enable_service ceilometer-api

Revision history for this message

Sean Dague (sdague) wrote on 2017-06-14:

This devstack bug was last updated over 180 days ago, as devstack
is a fast moving project and we'd like to get the tracker down to
currently actionable bugs, this is getting marked as Invalid. If the
issue still exists, please feel free to reopen it.

Changed in devstack:
status:	New → Invalid

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.