openstack team mailing list archive

[Trinath Somanchi <trinath.somanchi@xxxxxxxxx>]

Hi-

I have installed Openstack Folsom-3 Glance for my testing and found this
error while db sync.

/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py:8:
UserWarning: Module glance was already imported from
/opt/stack/glance/glance/__init__.pyc, but
/usr/local/lib/python2.7/dist-packages/glance-2012.2-py2.7.egg is being
added to sys.path
  import pkg_resources
Traceback (most recent call last):
  File "./bin/glance-manage", line 131, in <module>
    main()
  File "./bin/glance-manage", line 127, in main
    dispatch_cmd(args)
  File "./bin/glance-manage", line 103, in dispatch_cmd
    cmd_func(args)
  File "./bin/glance-manage", line 91, in do_db_sync
    glance.db.sqlalchemy.migration.db_sync(version, current_version)
  File "/opt/stack/glance/glance/db/sqlalchemy/migration.py", line 124, in
db_sync
    upgrade(version=version)
  File "/opt/stack/glance/glance/db/sqlalchemy/migration.py", line 67, in
upgrade
    return versioning_api.upgrade(sql_connection, repo_path, version)
  File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py",
line 186, in upgrade
    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
  File "<string>", line 2, in _migrate
  File
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py",
line 159, in with_engine
    return f(*a, **kw)
  File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py",
line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
  File
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line
91, in runchange
    change.run(self.engine, step)
  File
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py",
line 145, in run
    script_func(engine)
  File
"/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/versions/001_add_images_table.py",
line 49, in upgrade
    create_tables(tables)
  File "/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/schema.py",
line 96, in create_tables
    table.create()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/schema.py", line
594, in create
    checkfirst=checkfirst)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 2303, in _run_visitor
    conn._run_visitor(visitorcallable, element, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1973, in _run_visitor
    **kwargs).traverse_single(element)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py",
line 106, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/ddl.py",
line 86, in visit_table
    self.connection.execute(schema.CreateTable(table))
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1449, in execute
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1542, in _execute_ddl
    compiled
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1691, in _execute_context
    context)
  File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
331, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (OperationalError) table images already
exists u'\nCREATE TABLE images (\n\tid INTEGER NOT NULL, \n\tname
VARCHAR(255), \n\ttype VARCHAR(30), \n\tsize INTEGER, \n\tstatus
VARCHAR(30) NOT NULL, \n\tis_public BOOLEAN NOT NULL, \n\tlocation TEXT,
\n\tcreated_at DATETIME NOT NULL, \n\tupdated_at DATETIME, \n\tdeleted_at
DATETIME, \n\tdeleted BOOLEAN NOT NULL, \n\tPRIMARY KEY (id), \n\tCHECK
(is_public IN (0, 1)), \n\tCHECK (deleted IN (0, 1))\n)\n\n' ()

Can any one help me on troubleshooting the same.




-- 
Regards,
----------------------------------------------
Trinath Somanchi,
+91 9866 235 130