API tools faq
paste
Guest User

Untitled

a guest
Feb 11th, 2016
211
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.20 KB | None | 0 0
raw download clone embed print report
  1. root@controller1:/var/log/trove# su -s /bin/sh -c "trove-manage db_sync" trove
  2. No handlers could be found for logger "oslo_config.cfg"
  3. 2016-02-11 16:26:56.586 782 INFO trove.db.sqlalchemy.migration [-] Upgrading mysql://trove:[email protected]
  4. .0.150/trove to version latest
  5. 2016-02-11 16:26:56.601 782 INFO migrate.versioning.api [-] 18 -> 19...
  6. /usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py:3872: SAWarning: Textual column expression 'id' should be e
  7. xplicitly declared with text('id'), or use column('id') for more specificity (this warning may be suppressed after 10 o
  8. ccurrences)
  9. if guess_is_literal else "column"
  10. Command failed, please check log for more info.
  11. 2016-02-11 16:26:56.630 782 CRITICAL root [-] InternalError: (pymysql.err.InternalError) (1832, u"Cannot change column
  12. 'datastore_version_id': used in a foreign key constraint 'instances_ibfk_1'") [SQL: u'\nALTER TABLE instances CHANGE CO
  13. LUMN datastore_version_id datastore_version_id VARCHAR(36) NOT NULL']
  14. 2016-02-11 16:26:56.630 782 ERROR root Traceback (most recent call last):
  15. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/bin/trove-manage", line 10, in <module>
  16. 2016-02-11 16:26:56.630 782 ERROR root sys.exit(main())
  17. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/trove/cmd/manage.py", line 220, in main
  18. 2016-02-11 16:26:56.630 782 ERROR root Commands().execute()
  19. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/trove/cmd/manage.py", line 59, in execu
  20. te
  21. 2016-02-11 16:26:56.630 782 ERROR root exec_method(**kwargs)
  22. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/trove/cmd/manage.py", line 44, in db_sy
  23. nc
  24. 2016-02-11 16:26:56.630 782 ERROR root self.db_api.db_sync(CONF, repo_path=repo_path)
  25. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/trove/db/sqlalchemy/api.py", line 103,
  26. in db_sync
  27. 2016-02-11 16:26:56.630 782 ERROR root migration.db_sync(options, version, repo_path)
  28. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/trove/db/sqlalchemy/migration.py", line
  29. 122, in db_sync
  30. 2016-02-11 16:26:56.630 782 ERROR root upgrade(options, version=version, repo_path=repo_path)
  31. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/trove/db/sqlalchemy/migration.py", line
  32. 64, in upgrade
  33. 2016-02-11 16:26:56.630 782 ERROR root return versioning_api.upgrade(sql_connection, repo_path, version)
  34. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, i
  35. n upgrade
  36. 2016-02-11 16:26:56.630 782 ERROR root return _migrate(url, repository, version, upgrade=True, err=err, **opts)
  37. 2016-02-11 16:26:56.630 782 ERROR root File "<string>", line 2, in _migrate
  38. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", l
  39. ine 160, in with_engine
  40. 2016-02-11 16:26:56.630 782 ERROR root return f(*a, **kw)
  41. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, i
  42. n _migrate
  43. 2016-02-11 16:26:56.630 782 ERROR root schema.runchange(ver, change, changeset.step)
  44. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93,
  45. in runchange
  46. 2016-02-11 16:26:56.630 782 ERROR root change.run(self.engine, step)
  47. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line
  48. 148, in run
  49. 2016-02-11 16:26:56.630 782 ERROR root script_func(engine)
  50. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/trove/db/sqlalchemy/migrate_repo/versions/019_datastore_fix.py", line 114, in upgrade
  51. 2016-02-11 16:26:56.630 782 ERROR root instance_table.c.datastore_version_id.alter(nullable=False)
  52. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/schema.py", line 534, in alter
  53. 2016-02-11 16:26:56.630 782 ERROR root return alter_column(self, *p, **k)
  54. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/schema.py", line 141, in alter_column
  55. 2016-02-11 16:26:56.630 782 ERROR root engine._run_visitor(visitorcallable, delta)
  56. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
  57. 2016-02-11 16:26:56.630 782 ERROR root conn._run_visitor(visitorcallable, element, **kwargs)
  58. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
  59. 2016-02-11 16:26:56.630 782 ERROR root **kwargs).traverse_single(element)
  60. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 56, in traverse_single
  61. 2016-02-11 16:26:56.630 782 ERROR root ret = super(AlterTableVisitor, self).traverse_single(elem)
  62. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
  63. 2016-02-11 16:26:56.630 782 ERROR root return meth(obj, **kw)
  64. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/databases/mysql.py", line 47, in visit_column
  65. 2016-02-11 16:26:56.630 782 ERROR root self.execute()
  66. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 44, in execute
  67. 2016-02-11 16:26:56.630 782 ERROR root return self.connection.execute(self.buffer.getvalue())
  68. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 906, in execute
  69. 2016-02-11 16:26:56.630 782 ERROR root return self._execute_text(object, multiparams, params)
  70. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1054, in _execute_text
  71. 2016-02-11 16:26:56.630 782 ERROR root statement, parameters
  72. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  73. 2016-02-11 16:26:56.630 782 ERROR root context)
  74. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
  75. 2016-02-11 16:26:56.630 782 ERROR root exc_info
  76. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
  77. 2016-02-11 16:26:56.630 782 ERROR root reraise(type(exception), exception, tb=exc_tb)
  78. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  79. 2016-02-11 16:26:56.630 782 ERROR root context)
  80. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  81. 2016-02-11 16:26:56.630 782 ERROR root cursor.execute(statement, parameters)
  82. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 132, in execute
  83. 2016-02-11 16:26:56.630 782 ERROR root result = self._query(query)
  84. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 271, in _query
  85. 2016-02-11 16:26:56.630 782 ERROR root conn.query(q)
  86. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 726, in query
  87. 2016-02-11 16:26:56.630 782 ERROR root self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  88. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 861, in _read_query_result
  89. 2016-02-11 16:26:56.630 782 ERROR root result.read()
  90. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1064, in read
  91. 2016-02-11 16:26:56.630 782 ERROR root first_packet = self.connection._read_packet()
  92. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 826, in _read_packet
  93. 2016-02-11 16:26:56.630 782 ERROR root packet.check_error()
  94. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 370, in check_error
  95. 2016-02-11 16:26:56.630 782 ERROR root raise_mysql_exception(self._data)
  96. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 116, in raise_mysql_exception
  97. 2016-02-11 16:26:56.630 782 ERROR root _check_mysql_exception(errinfo)
  98. 2016-02-11 16:26:56.630 782 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
  99. 2016-02-11 16:26:56.630 782 ERROR root raise InternalError(errno, errorvalue)
  100. 2016-02-11 16:26:56.630 782 ERROR root InternalError: (pymysql.err.InternalError) (1832, u"Cannot change column 'datastore_version_id': used in a foreign key constraint 'instances_ibfk_1'") [SQL: u'\nALTER TABLE instances CHANGE COLUMN datastore_version_id datastore_version_id VARCHAR(36) NOT NULL']
  101. 2016-02-11 16:26:56.630 782 ERROR root
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!