neutron-db-manage failed with SQL error: Table 'agents' already exists

Bug #1636611 reported by Maksym Strukov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Invalid
High
Fuel Sustaining
Nominated for Ocata by Oleksiy Molchanov
Mitaka
Invalid
High
Fuel Sustaining
Newton
Invalid
High
Fuel Sustaining

Bug Description

Scenario:
1. Revert snapshot with ready master node
2. Copy and install external-lb and detach-haproxy plugins
3. Bootstrap 3 slaves from default nodegroup
4. Create cluster with Neutron VXLAN and custom nodegroups
5. Run 'fuel-mirror' to replace cluster repositories with local mirrors
6. Bootstrap 2 slaves nodes from second nodegroup and one node from third node group
7. Enable plugins for cluster
8. Add 2 controllers from default nodegroup and 1 controller from second node group
9. Add 1 compute+cinder from default node group and 1 compute+cinder from second node group
10. Add haproxy node from third node group
11. Verify networks
12. Deploy cluster

Actual result:

Deployment has failed. All nodes are finished. Failed tasks: Task[primary-openstack-network-plugins-l2/1] Stopping the deployment process!

Astute log:
2016-10-25 04:09:48 INFO [27880] Cluster[]: All nodes are finished. Failed tasks: Task[primary-openstack-network-plugins-l2/1] Stopping the deployment process!

Puppet log on node-1:
2016-10-25T03:59:24.031269+00:00 notice: (/Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns) Running upgrade for neutron
...
2016-10-25T03:59:24.077411+00:00 notice: (/Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns) sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'agents' already exists") [SQL: u"\nCREATE TABLE agents (\n\tid VARCHAR(36) NOT NULL, \n\tagent_type VARCHAR(255) NOT NULL, \n\t`binary` VARCHAR(255) NOT NULL, \n\ttopic VARCHAR(255) NOT NULL, \n\thost VARCHAR(255) NOT NULL, \n\tadmin_state_up BOOL NOT NULL DEFAULT true, \n\tcreated_at DATETIME NOT NULL, \n\tstarted_at DATETIME NOT NULL, \n\theartbeat_timestamp DATETIME NOT NULL, \n\tdescription VARCHAR(255), \n\tconfigurations VARCHAR(4095) NOT NULL, \n\t`load` INTEGER NOT NULL DEFAULT '0', \n\tPRIMARY KEY (id), \n\tCONSTRAINT uniq_agents0agent_type0host UNIQUE (agent_type, host), \n\tCHECK (admin_state_up IN (0, 1))\n)ENGINE=InnoDB\n\n"]
2016-10-25T03:59:24.078628+00:00 err: (/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 head returned 1 instead of one of [0]

Env: 9.2-#430
https://product-ci.infra.mirantis.net/job/9.x.system_test.ubuntu.plugins.thread_separate_haproxy/104/testReport/(root)/separate_haproxy/separate_haproxy/

Tags: area-library
Revision history for this message
Maksym Strukov (unbelll) wrote :
no longer affects: fuel/future
Changed in fuel:
milestone: none → 11.0
assignee: nobody → Fuel Sustaining (fuel-sustaining-team)
status: New → Confirmed
tags: added: area-library
Revision history for this message
Vladimir Kuklin (vkuklin) wrote :

I could suppose that the only root cause for this issue would be split-brain of MySQL

Revision history for this message
Oleksiy Molchanov (omolchanov) wrote :

@Vova, you are right. Closing as Invalid.

Changed in fuel:
status: Confirmed → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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