Advertisement
Guest User

mistral-populate-db-error

a guest
Jun 19th, 2016
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 4.94 KB | None | 0 0
  1. root@controller:/home/saphi# mistral-db-manage --config-file /etc/mistral/mistral.conf populate
  2. /usr/lib/python2.7/dist-packages/sqlalchemy/sql/default_comparator.py:153: SAWarning: The IN-predicate on "action_definitions_v2.id" was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate.  Consider alternative strategies for improved performance.
  3.   'strategies for improved performance.' % expr)
  4. Traceback (most recent call last):
  5.   File "/usr/bin/mistral-db-manage", line 10, in <module>
  6.     sys.exit(main())
  7.   File "/usr/lib/python2.7/dist-packages/mistral/db/sqlalchemy/migration/cli.py", line 129, in main
  8.     CONF.command.func(config, CONF.command.name)
  9.   File "/usr/lib/python2.7/dist-packages/mistral/db/sqlalchemy/migration/cli.py", line 70, in do_populate
  10.     action_manager.sync_db()
  11.   File "/usr/lib/python2.7/dist-packages/mistral/services/action_manager.py", line 82, in sync_db
  12.     _clear_system_action_db()
  13.   File "/usr/lib/python2.7/dist-packages/mistral/services/action_manager.py", line 77, in _clear_system_action_db
  14.     db_api.delete_action_definitions(is_system=True)
  15.   File "/usr/lib/python2.7/dist-packages/mistral/db/v2/api.py", line 193, in delete_action_definitions
  16.     return IMPL.delete_action_definitions(**kwargs)
  17.   File "/usr/lib/python2.7/dist-packages/mistral/db/sqlalchemy/base.py", line 110, in _within_session
  18.     result = func(*args, **kw)
  19.   File "/usr/lib/python2.7/dist-packages/mistral/db/v2/sqlalchemy/api.py", line 542, in delete_action_definitions
  20.     return _delete_all(models.ActionDefinition, **kwargs)
  21.   File "/usr/lib/python2.7/dist-packages/mistral/db/v2/sqlalchemy/api.py", line 153, in _delete_all
  22.     _secure_query(model).filter_by(**kwargs).delete(synchronize_session=False)
  23.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3048, in delete
  24.     delete_op.exec_()
  25.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 1127, in exec_
  26.     self._do_exec()
  27.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 1311, in _do_exec
  28.     mapper=self.mapper)
  29.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1046, in execute
  30.     bind, close_with_result=True).execute(clause, params or {})
  31.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
  32.     return meth(self, multiparams, params)
  33.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  34.     return connection._execute_clauseelement(self, multiparams, params)
  35.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  36.     compiled_sql, distilled_params
  37.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  38.     context)
  39.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  40.     util.raise_from_cause(newraise, exc_info)
  41.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
  42.     reraise(type(exception), exception, tb=exc_tb)
  43.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  44.     context)
  45.   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  46.     cursor.execute(statement, parameters)
  47.   File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 158, in execute
  48.     result = self._query(query)
  49.   File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 308, in _query
  50.     conn.query(q)
  51.   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 820, in query
  52.     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  53.   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1002, in _read_query_result
  54.     result.read()
  55.   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1285, in read
  56.     first_packet = self.connection._read_packet()
  57.   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
  58.     packet.check_error()
  59.   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
  60.     err.raise_mysql_exception(self._data)
  61.   File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
  62.     _check_mysql_exception(errinfo)
  63.   File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
  64.     raise errorclass(errno, errorvalue)
  65. sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'mistral.action_definitions_v2' doesn't exist") [SQL: u'DELETE FROM action_definitions_v2 WHERE (action_definitions_v2.project_id = %(project_id_1)s OR action_definitions_v2.scope = %(scope_1)s OR action_definitions_v2.id != action_definitions_v2.id) AND action_definitions_v2.is_system = true'] [parameters: {u'project_id_1': '<default-project>', u'scope_1': 'public'}]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement