Guest User

Untitled

a guest
Mar 22nd, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.55 KB | None | 0 0
  1. sqlalchemy.exc.InternalError: (psycopg2.InternalError) cannot drop table parameter_subtype because other objects depend on it
  2.  
  3. INFO [alembic.autogenerate.compare] Detected removed foreign key (event_id) (id) on table stage_has_event
  4. INFO [alembic.autogenerate.compare] Detected removed column 'stage_has_event.event_id'
  5. Generating /app/migrations/versions/e224df1a4818_.py ... done
  6. (venv) $ ./manage db upgrade
  7. INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
  8. INFO [alembic.runtime.migration] Will assume transactional DDL.
  9. INFO [alembic.runtime.migration] Running upgrade cadf22871ae0 -> e224df1a4818, empty message
  10. Traceback (most recent call last):
  11. File "/app/venv/bin/flask", line 11, in <module>
  12. sys.exit(main())
  13. File "/app/venv/lib/python2.7/site-packages/flask_cli/cli.py", line 502, in main
  14. cli.main(args=args, prog_name=name)
  15. File "/app/venv/lib/python2.7/site-packages/flask_cli/cli.py", line 369, in main
  16. return AppGroup.main(self, *args, **kwargs)
  17. File "/app/venv/lib/python2.7/site-packages/click/core.py", line 697, in main
  18. rv = self.invoke(ctx)
  19. File "/app/venv/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
  20. return _process_result(sub_ctx.command.invoke(sub_ctx))
  21. File "/app/venv/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
  22. return _process_result(sub_ctx.command.invoke(sub_ctx))
  23. File "/app/venv/lib/python2.7/site-packages/click/core.py", line 895, in invoke
  24. return ctx.invoke(self.callback, **ctx.params)
  25. File "/app/venv/lib/python2.7/site-packages/click/core.py", line 535, in invoke
  26. return callback(*args, **kwargs)
  27. File "/app/venv/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
  28. return f(get_current_context(), *args, **kwargs)
  29. File "/app/venv/lib/python2.7/site-packages/flask/cli.py", line 257, in decorator
  30. return __ctx.invoke(f, *args, **kwargs)
  31. File "/app/venv/lib/python2.7/site-packages/click/core.py", line 535, in invoke
  32. return callback(*args, **kwargs)
  33. File "/app/venv/lib/python2.7/site-packages/flask_migrate/cli.py", line 134, in upgrade
  34. _upgrade(directory, revision, sql, tag, x_arg)
  35. File "/app/venv/lib/python2.7/site-packages/flask_migrate/__init__.py", line 259, in upgrade
  36. command.upgrade(config, revision, sql=sql, tag=tag)
  37. File "/app/venv/lib/python2.7/site-packages/alembic/command.py", line 254, in upgrade
  38. script.run_env()
  39. File "/app/venv/lib/python2.7/site-packages/alembic/script/base.py", line 427, in run_env
  40. util.load_python_file(self.dir, 'env.py')
  41. File "/app/venv/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file
  42. module = load_module_py(module_id, path)
  43. File "/app/venv/lib/python2.7/site-packages/alembic/util/compat.py", line 141, in load_module_py
  44. mod = imp.load_source(module_id, path, fp)
  45. File "migrations/env.py", line 87, in <module>
  46. run_migrations_online()
  47. File "migrations/env.py", line 80, in run_migrations_online
  48. context.run_migrations()
  49. File "<string>", line 8, in run_migrations
  50. File "/app/venv/lib/python2.7/site-packages/alembic/runtime/environment.py", line 836, in run_migrations
  51. self.get_context().run_migrations(**kw)
  52. File "/app/venv/lib/python2.7/site-packages/alembic/runtime/migration.py", line 330, in run_migrations
  53. step.migration_fn(**kw)
  54. File "/app/migrations/versions/e224df1a4818_.py", line 21, in upgrade
  55. op.drop_table('parameter_subtype')
  56. File "<string>", line 8, in drop_table
  57. File "<string>", line 3, in drop_table
  58. File "/app/venv/lib/python2.7/site-packages/alembic/operations/ops.py", line 1187, in drop_table
  59. operations.invoke(op)
  60. File "/app/venv/lib/python2.7/site-packages/alembic/operations/base.py", line 319, in invoke
  61. return fn(self, operation)
  62. File "/app/venv/lib/python2.7/site-packages/alembic/operations/toimpl.py", line 70, in drop_table
  63. operation.to_table(operations.migration_context)
  64. File "/app/venv/lib/python2.7/site-packages/alembic/ddl/impl.py", line 203, in drop_table
  65. self._exec(schema.DropTable(table))
  66. File "/app/venv/lib/python2.7/site-packages/alembic/ddl/impl.py", line 118, in _exec
  67. return conn.execute(construct, *multiparams, **params)
  68. File "/app/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
  69. return meth(self, multiparams, params)
  70. File "/app/venv/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
  71. return connection._execute_ddl(self, multiparams, params)
  72. File "/app/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
  73. compiled
  74. File "/app/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
  75. context)
  76. File "/app/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
  77. exc_info
  78. File "/app/venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
  79. reraise(type(exception), exception, tb=exc_tb, cause=cause)
  80. File "/app/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
  81. context)
  82. File "/app`enter code here`/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
  83. cursor.execute(statement, parameters)
  84. sqlalchemy.exc.InternalError: (psycopg2.InternalError) cannot drop table parameter_subtype because other objects depend on it
  85. DETAIL: constraint parameter_parameter_subtype_id_fkey on table parameter depends on table parameter_subtype
  86. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  87. [SQL: 'nDROP TABLE parameter_subtype']
Add Comment
Please, Sign In to add comment