[fuel-ci] fuel-web stable/5.0 branch doesn't pass CI

Bug #1445423 reported by Aleksandra Fedorova
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Fix Committed
High
Sebastian Kalinowski

Bug Description

Traceback (most recent call last):
  File "manage.py", line 259, in <module>
    action(params) if action else parser.print_help()
  File "manage.py", line 185, in action_dropdb
    dropdb()
  File "/home/jenkins/workspace/stackforge-verify-fuel-web/nailgun/nailgun/db/sqlalchemy/__init__.py", line 61, in dropdb
    Base.metadata.drop_all(bind=engine)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/schema.py", line 2598, in drop_all
    tables=tables)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 2302, in _run_visitor
    conn._run_visitor(visitorcallable, element, **kwargs)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1972, in _run_visitor
    **kwargs).traverse_single(element)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/sql/visitors.py", line 106, in traverse_single
    return meth(obj, **kw)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/engine/ddl.py", line 130, in visit_metadata
    self.traverse_single(table, drop_ok=True)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/sql/visitors.py", line 106, in traverse_single
    return meth(obj, **kw)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/engine/ddl.py", line 173, in visit_table
    self.connection.execute(schema.DropTable(table))
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1542, in _execute_ddl
    compiled
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/home/jenkins/workspace/stackforge-verify-fuel-web_VENV/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.InternalError: (InternalError) cannot drop table clusters because other objects depend on it
DETAIL: constraint cluster_plugins_cluster_id_fkey on table cluster_plugins depends on table clusters
constraint nodegroups_cluster_id_fkey on table nodegroups depends on table clusters
constraint vmware_attributes_cluster_id_fkey on table vmware_attributes depends on table clusters
HINT: Use DROP ... CASCADE to drop the dependent objects too.
 '\nDROP TABLE clusters' {}

https://fuel-jenkins.mirantis.com/job/stackforge-verify-fuel-web/4305/

description: updated
Changed in fuel:
status: New → Confirmed
importance: Undecided → High
Changed in fuel:
assignee: Fuel Python Team (fuel-python) → Sebastian Kalinowski (prmtl)
Changed in fuel:
status: Confirmed → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-web (stable/5.0)

Fix proposed to branch: stable/5.0
Review: https://review.openstack.org/175821

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to fuel-web (stable/5.0)

Reviewed: https://review.openstack.org/175821
Committed: https://git.openstack.org/cgit/stackforge/fuel-web/commit/?id=3b16b3a83b1bdb7ad02c1057e378ad69f969268e
Submitter: Jenkins
Branch: stable/5.0

commit 3b16b3a83b1bdb7ad02c1057e378ad69f969268e
Author: Sebastian Kalinowski <email address hidden>
Date: Tue Apr 21 13:31:28 2015 +0200

    Backport improved database cleaning

    Bakckported bunch of changes that improve removing
    data from database. Instead of removing just tables
    that was defined in models, all data will be removed.

    Change-Id: Id2bebc9009c269b464606db3938e8f45a8a1f44e
    Closes-Bug: #1445423

Changed in fuel:
status: In Progress → Fix Committed
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.