同步nova数据库 su -s /bin/sh -c "nova-manage db sync" nova ERROR: Could no

admin

ERROR: Could not access cell0.
7 A# v# X1 R7 K. N$ g9 E: Q: p. ?5 gHas the nova_api database been created?
8 g: h" R7 K. k8 }Has the nova_cell0 database been created?
Has "nova-manage api_db sync" been run?
7 o- ~2 T. ~9 g) J, |Has "nova-manage cell_v2 map_cell0" been run?
; l0 B4 G; s( g$ c  j3 yIs [api_database]/connection set in nova.conf?
5 \( _2 \2 V  }/ x6 wIs the cell0 database connection URL correct?
, N2 c9 Y9 _2 D* H) r6 XError: 317 is not 318
$ c. `: X! V* a1 w3 k8 I
( k" L6 w* s+ P$ I3 d/ w
解决办法：
/ s+ r+ I+ ?5 v. n% n. h在endpoint中要加上这个%\(tenant_id\)s才可以





处理步骤：
% _/ ^; }+ e( W2 E  L/ o1 Q( p: ~ su -s /bin/sh -c "nova-manage api_db sync" nova
2 S$ z3 @7 F- o0 A, c# {" ?8 zsu -s /bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova
231680ee-43d1-48bc-91db-139ff7ef43a2
su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
" K2 e) Q0 U8 g  C! p6 Z# d su -s /bin/sh -c "nova-manage db sync" nova
/usr/lib/python2.7/site-packages/pymysql/cursors.py:170: Warning: (1831, u'Duplicate index `block_device_mapping_instance_uuid_virtual_name_device_name_idx`. This is deprecated and will be disallowed in a future release')
+ N" k/ s; Y% ~! _$ B  result = self._query(query)
1 t$ [; y1 \+ Z1 {  x1 s2 W3 \/usr/lib/python2.7/site-packages/pymysql/cursors.py:170: Warning: (1831, u'Duplicate index `uniq_instances0uuid`. This is deprecated and will be disallowed in a future release')
  result = self._query(query)
ERROR: Could not access cell0.
Has the nova_api database been created?
Has the nova_cell0 database been created?
Has "nova-manage api_db sync" been run?
' f% h, d6 M' a8 K( B) E8 Q: LHas "nova-manage cell_v2 map_cell0" been run?
/ @: ]3 C1 M3 |! S2 E3 K1 L6 [Is [api_database]/connection set in nova.conf?
% y; E2 a6 A' f( _2 r8 k) M  xIs the cell0 database connection URL correct?
$ U% G% Q) C- F7 m' o/ I, D; u; lError: 317 is not 318
An error has occurred:
; ]: `& v1 N2 a+ e: [8 UTraceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
7 i9 H; f9 W6 V5 l8 g    ret = fn(*fn_args, **fn_kwargs)
3 O3 Y2 m5 F- ?; L4 f# a  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
    return migration.db_sync(version)
* h4 Y! N7 ^0 c  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
7 W; P" c1 v1 u4 w9 G" n, J) Z- v    return IMPL.db_sync(version=version, database=database, context=context)
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync
    repository, version)
  File "/usr/lib/python2.7/site-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/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
- v1 n6 u3 A9 b7 X( |2 |; ^    return f(*a, **kw)
( ~; r5 p" W3 i$ f- N4 z; y% ^  L  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
1 G* R3 a+ q$ ~/ ~7 c! \) t- q    (self.version, startver))
. l  W7 A9 S. nInvalidVersionError: 317 is not 318
* A) ^! T0 o: M1 w9 _' U" {: ` su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
Cell0 is already setup
9 u8 d9 P0 k( o  ~ su -s /bin/sh -c "nova-manage db sync" nova
) m# D* p. Y8 X; J% m
同步数据库完成。
$ k: j! d) w1 m4 W; u* z. s) s1 k
0 c- n6 Q& d% ~4 t

admin

An error has occurred:
Traceback (most recent call last):
  {$ q' {0 G6 q  t  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
    ret = fn(*fn_args, **fn_kwargs)
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
    return migration.db_sync(version)
$ u) g( q0 g# G6 `$ {" Q3 t2 l  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
0 V( A, o' X+ _& x    return IMPL.db_sync(version=version, database=database, context=context)
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync
1 H$ T5 x8 y* D7 ?) B    repository, version)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
' {# t; `  n1 h1 Z3 w/ e/ e    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
; [. j3 e# m  W% J* g: f3 H* D  File "<string>", line 2, in _migrate
" ^" _1 \1 h9 Q) B+ B/ U  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
    return f(*a, **kw)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
# _* L! V+ W! Y! T% l) _  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
' i6 j1 j2 a2 ]% _) ]1 V& E8 [/ M    (self.version, startver))
InvalidVersionError: 317 is not 318
3 n. \% o% o9 |* ]9 R

admin

ERROR: Could not access cell0.
$ F# e2 Z5 Q( a& S( EHas the nova_api database been created?
Has the nova_cell0 database been created?
$ K/ e0 S$ o) T+ r- D. ~3 UHas "nova-manage api_db sync" been run?
2 q( M3 a: t+ C4 {Has "nova-manage cell_v2 map_cell0" been run?
* \. @  c/ e( F! q! u( xIs [api_database]/connection set in nova.conf?
, D0 y) \4 J, ^* A: E6 ^Is the cell0 database connection URL correct?
Error: 317 is not 318
6 ^& B% X! D! O9 r6 y. U7 H: Q+ i7 @An error has occurred:
Traceback (most recent call last):
$ L5 w  G3 V/ H! _1 n  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
6 y. B. c: p; b2 f0 U$ X    ret = fn(*fn_args, **fn_kwargs)
4 ~- {8 a# u( I) O0 V0 ]  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
    return migration.db_sync(version)
3 f6 b  H$ v+ H/ ]( f  G  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
    return IMPL.db_sync(version=version, database=database, context=context)
& P$ V/ [7 x. r& L  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync
* k6 m4 N) ?+ u% i8 _! F    repository, version)
9 z1 B, J7 p/ a* \1 S! N3 t  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
3 o% h/ B! a9 `1 }5 R  \    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
3 {1 l4 D( K1 i$ j  File "<string>", line 2, in _migrate
  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
    return f(*a, **kw)
3 t' l6 h3 o' {4 D( a  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
2 k7 ]8 d# ^) @- w: Q' S5 q# K" h% m    schema.runchange(ver, change, changeset.step)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
  C" L% ^) g3 x1 d: {9 [    change.run(self.engine, step)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run
    script_func(engine)
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py", line 1443, in upgrade
- Y; |1 \8 ^' Z5 w# n. c1 |    index.create(migrate_engine)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3656, in create
    bind._run_visitor(ddl.SchemaGenerator, self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
5 ~8 `3 @$ P) t4 }; ~3 |0 c    conn._run_visitor(visitorcallable, element, **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
5 u) ^4 V5 g9 v' m    return meth(obj, **kw)
+ M8 c( y5 B- Z; b/ x  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 860, in visit_index
    self.connection.execute(CreateIndex(index))
/ t3 `+ m6 X8 p, n  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
    return meth(self, multiparams, params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1042, in _execute_ddl
' `" n- {/ A5 b8 A  M+ O    compiled,
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
( d$ s" C. _$ U0 y    e, statement, parameters, cursor, context
7 w+ M5 s: n+ v6 x5 E1 z  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception
    util.raise_from_cause(newraise, exc_info)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  H  r* O& j0 C4 t4 r) U% V0 o  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
$ [1 G" g, M( u8 [9 _3 {    cursor, statement, parameters, context
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
( N3 \  K. K& X  R0 q    result = self._query(query)
% z7 J, U4 r+ v2 n) d- c0 u  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
9 K; p% S/ |0 E" g2 h    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result
    result.read()
. x! I( H/ |( X* C* r6 D  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
' G6 u4 |2 O/ b* y* Z8 g$ `    first_packet = self.connection._read_packet()
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
  F6 N5 C3 F6 Q) C% m7 I    packet.check_error()
3 r4 {, g) Y; J& A  File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
9 E) r) T, g+ V$ y% W" T  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
( B9 E7 A% J! _" y3 V    raise errorclass(errno, errval)
4 H+ B8 j! n8 ]% ]OperationalError: (pymysql.err.OperationalError) (1213, u'WSREP replication failed. Check your wsrep connection state and retry the query.') [SQL: u'CREATE INDEX certificates_project_id_deleted_idx ON certificates (project_id, deleted)'] (Background on this error at: http://sqlalche.me/e/e3q8)