| Summary: | neutron-db-manage fails with: 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) N | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat OpenStack | Reporter: | Marius Cornea <mcornea> | ||||
| Component: | python-networking-odl | Assignee: | Mike Kolesnik <mkolesni> | ||||
| Status: | CLOSED ERRATA | QA Contact: | Itzik Brown <itbrown> | ||||
| Severity: | urgent | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 10.0 (Newton) | CC: | amuller, chrisw, jschluet, mandreou, mcornea, mkolesni, nyechiel, rhos-flags, rrasouli, sclewis, srevivo | ||||
| Target Milestone: | rc | Keywords: | AutomationBlocker, Triaged | ||||
| Target Release: | 10.0 (Newton) | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | python-networking-odl-2.0.1-1.3.264292dgit.el7ost | Doc Type: | If docs needed, set a value | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: |
N/A
|
|||||
| Last Closed: | 2016-12-14 16:26:32 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Attachments: |
|
||||||
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 |
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.