Description of problem: Deployment fails during neutron-db-manage step: Error: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]: Failed to call refresh: neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugin.ini upgrade heads returned 1 instead of one of [0] 10:59:43 Error: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]: neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugin.ini upgrade heads returned 1 instead of one of [0] Trying to run the command manually on the nodes I see the following error: oslo_db.exception.DBError: (pymysql.err.InternalError) (1067, u"Invalid default value for 'created_at'") [SQL: u"\nCREATE TABLE opendaylightjournal_new (\n\tseqnum BIGINT NOT NULL AUTO_INCREMENT, \n\tobject_type VARCHAR(36) NOT NULL, \n\tobject_uuid VARCHAR(36) NOT NULL, \n\toperation VARCHAR(36) NOT NULL, \n\tdata BLOB, \n\tstate ENUM('pending','processing','failed','completed') NOT NULL, \n\tretry_count INTEGER, \n\tcreated_at DATETIME DEFAULT now(), \n\tlast_retried TIMESTAMP NULL DEFAULT now(), \n\tPRIMARY KEY (seqnum)\n)ENGINE=InnoDB\n\n"] Version-Release number of selected component (if applicable): python-neutron-tests-9.0.0-1.5.el7ost.noarch openstack-neutron-openvswitch-9.0.0-1.5.el7ost.noarch openstack-neutron-metering-agent-9.0.0-1.5.el7ost.noarch openstack-neutron-bigswitch-agent-7.0.5-0.20161015221623.f83c499.el7ost.noarch openstack-neutron-ml2-9.0.0-1.5.el7ost.noarch python-neutronclient-6.0.0-1.1.el7ost.noarch python-neutron-lib-0.4.0-1.el7ost.noarch openstack-neutron-common-9.0.0-1.5.el7ost.noarch openstack-neutron-bigswitch-lldp-7.0.5-0.20161015221623.f83c499.el7ost.noarch openstack-neutron-lbaas-9.0.0-2.el7ost.noarch python-neutron-9.0.0-1.5.el7ost.noarch python-neutron-lbaas-9.0.0-2.el7ost.noarch openstack-neutron-9.0.0-1.5.el7ost.noarch openstack-neutron-sriov-nic-agent-9.0.0-1.5.el7ost.noarch puppet-neutron-9.4.0-2.el7ost.noarch How reproducible: 100% Steps to Reproduce: 1. Deploy overcloud with composable roles Actual results: Deployment fails in neutron-db-manage step Expected results: Deployment doesn't fail. Additional info: After applying this patch: https://review.openstack.org/#/c/391283/ neutron-db-manage completed successfully.
Looks like a backport request for https://review.openstack.org/#/c/391283/ essentially.
Making sure you see this Mike.
Did RHOS10 deployment of 1 controller, 2 compute, 1 CEPH no composable roles at all. | AllNodesDeploySteps | 33d59502-1654-4909-8bf2-7e4a3461c652 | OS::TripleO::PostDeploySteps | CREATE_FAILED | 2016-10-30T07:51:05Z | Attached deployment error log
Created attachment 1215700 [details] error log of deployment failure
What version of python-networking-odl is used here? How are you deploying? RHOS Director?
(In reply to Mike Kolesnik from comment #5) > What version of python-networking-odl is used here? python-networking-odl-2.0.1-1.2.f95b320git.el7ost.noarch > How are you deploying? RHOS Director? Yes, with Director.
Jon it seems a new build of the driver is needed with the aforementioned patch in it.
*** Bug 1390317 has been marked as a duplicate of this bug. ***
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHEA-2016-2948.html