Tacker db population fails due to sql foreign key constraint on MariaDB version >5.5
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
tacker |
Fix Released
|
Critical
|
Sripriya |
Bug Description
DB migration scripts needs to be modified to handle modification of foreign key columns by dropping the constraint, and then adding back the constraint once the column changes are done. This needs to be done for applicable scripts which try to change the column that is involved in a foreign key constraint.
Tacker (master) Devstack installation is failing due to db migration.
INFO [alembic.
2016-06-21 06:28:56.910 | Traceback (most recent call last):
2016-06-21 06:28:56.910 | File "/usr/bin/
2016-06-21 06:28:56.910 | sys.exit(main())
2016-06-21 06:28:56.910 | File "/opt/stack/
2016-06-21 06:28:56.910 | CONF.command.
2016-06-21 06:28:56.910 | File "/opt/stack/
2016-06-21 06:28:56.910 | do_alembic_
2016-06-21 06:28:56.910 | File "/opt/stack/
2016-06-21 06:28:56.910 | getattr(
2016-06-21 06:28:56.910 | File "/usr/lib/
2016-06-21 06:28:56.910 | script.run_env()
2016-06-21 06:28:56.910 | File "/usr/lib/
2016-06-21 06:28:56.910 | util.load_
2016-06-21 06:28:56.910 | File "/usr/lib/
2016-06-21 06:28:56.910 | module = load_module_
2016-06-21 06:28:56.910 | File "/usr/lib/
2016-06-21 06:28:56.910 | mod = imp.load_
2016-06-21 06:28:56.910 | File "/opt/stack/
2016-06-21 06:28:56.910 | run_migrations_
2016-06-21 06:28:56.910 | File "/opt/stack/
2016-06-21 06:28:56.910 | context.
2016-06-21 06:28:56.910 | File "<string>", line 8, in run_migrations
2016-06-21 06:28:56.910 | File "/usr/lib/
2016-06-21 06:28:56.911 | self.get_
2016-06-21 06:28:56.911 | File "/usr/lib/
2016-06-21 06:28:56.911 | step.migration_
2016-06-21 06:28:56.911 | File "/opt/stack/
2016-06-21 06:28:56.911 | type_=types.Uuid)
2016-06-21 06:28:56.911 | File "<string>", line 8, in alter_column
2016-06-21 06:28:56.911 | File "<string>", line 3, in alter_column
2016-06-21 06:28:56.911 | File "/usr/lib/
2016-06-21 06:28:56.911 | return operations.
2016-06-21 06:28:56.911 | File "/usr/lib/
2016-06-21 06:28:56.911 | return fn(self, operation)
2016-06-21 06:28:56.911 | File "/usr/lib/
2016-06-21 06:28:56.911 | **operation.kw
2016-06-21 06:28:56.911 | File "/usr/lib/
2016-06-21 06:28:56.911 | else existing_
2016-06-21 06:28:56.911 | File "/usr/lib/
2016-06-21 06:28:56.911 | return conn.execute(
2016-06-21 06:28:56.911 | File "/usr/lib64/
2016-06-21 06:28:56.911 | return meth(self, multiparams, params)
2016-06-21 06:28:56.911 | File "/usr/lib64/
2016-06-21 06:28:56.911 | return connection.
2016-06-21 06:28:56.911 | File "/usr/lib64/
2016-06-21 06:28:56.911 | compiled
2016-06-21 06:28:56.911 | File "/usr/lib64/
2016-06-21 06:28:56.911 | context)
2016-06-21 06:28:56.911 | File "/usr/lib64/
2016-06-21 06:28:56.912 | exc_info
2016-06-21 06:28:56.912 | File "/usr/lib64/
2016-06-21 06:28:56.912 | reraise(
2016-06-21 06:28:56.912 | File "/usr/lib64/
2016-06-21 06:28:56.912 | context)
2016-06-21 06:28:56.912 | File "/usr/lib64/
2016-06-21 06:28:56.912 | cursor.
2016-06-21 06:28:56.912 | File "/usr/lib/
2016-06-21 06:28:56.912 | result = self._query(query)
2016-06-21 06:28:56.912 | File "/usr/lib/
2016-06-21 06:28:56.912 | conn.query(q)
2016-06-21 06:28:56.912 | File "/usr/lib/
2016-06-21 06:28:56.912 | self._affected_rows = self._read_
2016-06-21 06:28:56.912 | File "/usr/lib/
2016-06-21 06:28:56.912 | result.read()
2016-06-21 06:28:56.912 | File "/usr/lib/
2016-06-21 06:28:56.912 | first_packet = self.connection
2016-06-21 06:28:56.912 | File "/usr/lib/
2016-06-21 06:28:56.912 | packet.
2016-06-21 06:28:56.912 | File "/usr/lib/
2016-06-21 06:28:56.912 | err.raise_
2016-06-21 06:28:56.912 | File "/usr/lib/
2016-06-21 06:28:56.912 | _check_
2016-06-21 06:28:56.912 | File "/usr/lib/
2016-06-21 06:28:56.912 | raise InternalError(
2016-06-21 06:28:56.913 | sqlalchemy.
2016-06-21 06:28:56.948 | Error on exit
stack.sh.
-------
2016-06-21 06:21:53.265 | stack.sh log /opt/stack/
2016-06-21 06:21:55.843 | Installing package prerequisites
2016-06-21 06:21:57.740 | tacker's plugin.sh was called...
2016-06-21 06:21:58.881 | Installing OpenStack project source
2016-06-21 06:22:09.394 | tacker's plugin.sh was called...
2016-06-21 06:22:09.420 | Installing Tacker
2016-06-21 06:22:10.014 | Starting RabbitMQ
2016-06-21 06:22:11.993 | Configuring and starting MySQL
2016-06-21 06:22:19.263 | Starting Keystone
2016-06-21 06:25:14.627 | Configuring Horizon
2016-06-21 06:25:17.501 | Configuring Glance
2016-06-21 06:25:21.938 | Configuring Neutron
2016-06-21 06:25:42.711 | Configuring Nova
2016-06-21 06:25:54.787 | tacker's plugin.sh was called...
2016-06-21 06:25:54.814 | Configuring Tacker
2016-06-21 06:26:15.560 | Starting Glance
2016-06-21 06:26:24.190 | Uploading images
2016-06-21 06:26:29.182 | Starting Nova API
2016-06-21 06:26:35.682 | Starting Neutron
2016-06-21 06:26:54.911 | Creating initial neutron network elements
2016-06-21 06:27:21.032 | Starting Nova
2016-06-21 06:27:56.307 | Configuring Heat
2016-06-21 06:27:57.332 | Starting Heat
2016-06-21 06:28:10.359 | Starting Horizon
2016-06-21 06:28:56.223 | tacker's plugin.sh was called...
2016-06-21 06:28:56.252 | Initializing Tacker
Changed in tacker: | |
assignee: | nobody → Janki Chhatbar (jankihchhatbar) |
Changed in tacker: | |
assignee: | Janki Chhatbar (jankihchhatbar) → nobody |
Changed in tacker: | |
assignee: | nobody → Sripriya (sseetha) |
Changed in tacker: | |
importance: | Medium → Critical |
Can you please share the environment details you used to reproduce this bug? are you running devstack on a RHEL system?