Skip to content

Instantly share code, notes, and snippets.

@ahsan518
Created September 7, 2016 18:26
Show Gist options
  • Save ahsan518/e4dbbbd39ea10c0e69e9d283ba3e126c to your computer and use it in GitHub Desktop.
Save ahsan518/e4dbbbd39ea10c0e69e9d283ba3e126c to your computer and use it in GitHub Desktop.
INFO [alembic.runtime.migration] Running upgrade -> ffdc1a500db1, craton_inventory_init
Traceback (most recent call last):
File "/usr/local/bin/craton-inventory-dbsync", line 10, in <module>
sys.exit(main())
File "/usr/local/lib/python2.7/dist-packages/craton/cmd/dbsync.py", line 69, in main
CONF.command.func()
File "/usr/local/lib/python2.7/dist-packages/craton/cmd/dbsync.py", line 12, in upgrade
migration.upgrade(CONF.command.revision)
File "/usr/local/lib/python2.7/dist-packages/craton/db/sqlalchemy/migration.py", line 31, in upgrade
alembic.command.upgrade(config, revision or 'head')
File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade
script.run_env()
File "/usr/local/lib/python2.7/dist-packages/alembic/script/base.py", line 407, in run_env
util.load_python_file(self.dir, 'env.py')
File "/usr/local/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "/usr/local/lib/python2.7/dist-packages/craton/db/sqlalchemy/alembic/env.py", line 66, in <module>
run_migrations_online()
File "/usr/local/lib/python2.7/dist-packages/craton/db/sqlalchemy/alembic/env.py", line 63, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/usr/local/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/local/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations
step.migration_fn(**kw)
File "/usr/local/lib/python2.7/dist-packages/craton/db/sqlalchemy/alembic/versions/ffdc1a500db1_craton_inventory_init.py", line 84, in upgrade
unique=False)
File "<string>", line 8, in create_index
File "<string>", line 3, in create_index
File "/usr/local/lib/python2.7/dist-packages/alembic/operations/ops.py", line 849, in create_index
return operations.invoke(op)
File "/usr/local/lib/python2.7/dist-packages/alembic/operations/base.py", line 318, in invoke
return fn(self, operation)
File "/usr/local/lib/python2.7/dist-packages/alembic/operations/toimpl.py", line 88, in create_index
operations.impl.create_index(idx)
File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 206, in create_index
self._exec(schema.CreateIndex(index))
File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 118, in _exec
return conn.execute(construct, *multiparams, **params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
util.raise_from_cause(newraise, exc_info)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1072, "Key column 'project_id' doesn't exist in table") [SQL: u'CREATE INDEX ix_users_project_id ON users (project_id)']
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment