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

admin

ERROR: Could not access cell0.
Has the nova_api database been created?
Has the nova_cell0 database been created?
0 Q; ]1 w8 }# N" R! |( R5 ]Has "nova-manage api_db sync" been run?
1 q6 X5 j  D* J" ]/ @. f5 c& M: rHas "nova-manage cell_v2 map_cell0" been run?
Is [api_database]/connection set in nova.conf?
3 k9 T3 z$ t" l1 lIs the cell0 database connection URL correct?
: [5 f8 D: t' V, n& }* ^8 R7 BError: 317 is not 318
) d; L1 p' E6 L5 T1 V

" }9 d& e' `8 y解决办法：
在endpoint中要加上这个%\(tenant_id\)s才可以


3 v# b5 `$ E5 R' x  q
% x, t  a6 T9 _3 o6 ^! E

2 _+ h! R" A8 c处理步骤：
7 S+ o: u) G7 z- o su -s /bin/sh -c "nova-manage api_db sync" nova
su -s /bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova
231680ee-43d1-48bc-91db-139ff7ef43a2
/ _* r2 K6 g2 N4 E  u9 y7 t, Q su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
+ K% V9 Y" n& Q+ }. q' X& |% @" p su -s /bin/sh -c "nova-manage db sync" nova
: P* S6 o+ `. l- v. R# n* `0 i# s: A/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')
, Z$ n' u6 g2 E3 ], A# O  result = self._query(query)
/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')
! S$ H$ n1 i4 s' t  result = self._query(query)
: G5 I0 w& Y" F% V) Q3 U; g) g4 }ERROR: Could not access cell0.
Has the nova_api database been created?
5 C% R: [% l6 L- {Has the nova_cell0 database been created?
9 c. y. c) D6 j1 k# CHas "nova-manage api_db sync" been run?
Has "nova-manage cell_v2 map_cell0" been run?
# A4 Y1 u, r5 A) @; v  v* AIs [api_database]/connection set in nova.conf?
3 z' L0 e- c; @; s8 Q) v' bIs the cell0 database connection URL correct?
Error: 317 is not 318
An error has occurred:
7 P# o# _0 F) ^' ]& [6 P8 KTraceback (most recent call last):
* l: p) k( T0 D0 M8 `& _  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
    ret = fn(*fn_args, **fn_kwargs)
1 P+ [, ~6 e6 B) P9 T/ d  I  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
% a# [( b* L; N! d% E% x    return migration.db_sync(version)
  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)
. _( h4 f+ r4 J8 E& L7 ?7 K  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync
    repository, version)
& j9 O) L- _: s+ [; W: N9 R' _" k  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
8 p% |. v" E0 c& z8 ?6 Z6 E" T    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
  File "<string>", line 2, in _migrate
; S1 x: a3 S! Z; f% ?! K2 D9 N* u  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
' g/ Y4 c) F$ ?9 s& m" n    return f(*a, **kw)
' {( q8 r+ ?( C  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
    (self.version, startver))
  x- w0 H: a- Q! FInvalidVersionError: 317 is not 318
su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
1 L% I( y) D6 n: HCell0 is already setup
+ Y& x( J4 P3 [4 G& R: N2 L/ K# y su -s /bin/sh -c "nova-manage db sync" nova

同步数据库完成。
, F, `* D5 u0 I) C/ V& F
; V# o! n9 G. L' g, v

admin

An error has occurred:
- l+ R# Y* A; v3 VTraceback (most recent call last):
: S; x; C) y. J8 o5 e* }  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
) ^/ Q" |6 @6 i) p; o8 A* ~: v8 o4 b    ret = fn(*fn_args, **fn_kwargs)
- g7 G( c* M; s  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
    return migration.db_sync(version)
+ c9 R2 l1 c/ o* G2 L3 t  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)
0 F) C5 N/ x8 o7 ?  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync
5 s  d8 M$ e2 N0 u' \    repository, version)
" S. N8 D% @. W4 q  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
. W- B! Y' ~  J2 }. a1 h7 G1 U    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
4 m3 I; `0 z5 l  File "<string>", line 2, in _migrate
' u: [" B) J* c$ [, S2 |  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
# `0 h* `5 z& u    schema.runchange(ver, change, changeset.step)
# V- V! F# y! @/ ?" F: R+ _  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
    (self.version, startver))
InvalidVersionError: 317 is not 318

admin

ERROR: Could not access cell0.
Has the nova_api database been created?
Has the nova_cell0 database been created?
* o) a) }" P- E6 }" c+ K3 ZHas "nova-manage api_db sync" been run?
Has "nova-manage cell_v2 map_cell0" been run?
6 A5 q' S5 ^4 Z7 T; WIs [api_database]/connection set in nova.conf?
0 @, @  c' o5 a. N( s7 R: `, _Is the cell0 database connection URL correct?
Error: 317 is not 318
An error has occurred:
, c- F* |4 q, {3 [" y7 WTraceback (most recent call last):
) s* \- c- \8 n+ Q$ P  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
+ m6 \$ N; U' z  X  Q    return migration.db_sync(version)
  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)
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync
2 }6 k! h/ o, L( l( ?1 J9 y1 F    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
2 ^7 F1 r5 \& Z  w& G  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
    return f(*a, **kw)
) T7 W  m( Q: j- R# T5 ^  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
9 j5 x+ h8 k. H( D( ~# \" }. t0 x  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
    change.run(self.engine, step)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run
: ~: q, ^6 ?% g0 ?8 x" k    script_func(engine)
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py", line 1443, in upgrade
7 F4 o6 j& W  `/ D) g5 v8 w    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
    conn._run_visitor(visitorcallable, element, **kwargs)
, n+ l$ I6 I" V6 E' \  }! J- n  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
6 W1 E$ b" V3 Z) k    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
- r, P7 @; c  n) E+ L2 p  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
    return meth(obj, **kw)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 860, in visit_index
# }9 n6 O6 F; x. b/ _4 ]" \+ T& l    self.connection.execute(CreateIndex(index))
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
    return meth(self, multiparams, params)
$ ~; J; a& @) e) X8 z3 d! b9 Q1 {8 K  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
: m; T) \3 u  M: x% M$ b2 n0 q    return connection._execute_ddl(self, multiparams, params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1042, in _execute_ddl
    compiled,
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
    e, statement, parameters, cursor, context
  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)
  K. z1 R8 Y* v2 E5 ~  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
    cursor, statement, parameters, context
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
- S6 p* Y" s% ^! {3 Z; g$ p8 Y    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
1 ^# t& [# T- O3 @) m    result = self._query(query)
  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
$ B& K; c+ S/ A    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
6 R5 i. i$ ]  x0 @: l$ e2 J    result.read()
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
    first_packet = self.connection._read_packet()
* l: d$ Z3 B( ?& D* L1 E  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
: c1 s$ r  K% ?$ |$ b* ?    packet.check_error()
& B% p# Q3 g- b- Q  File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
2 ]& [( j0 A" N7 ~, c3 J7 u6 q    err.raise_mysql_exception(self._data)
  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
- n/ `( q# p7 D6 ROperationalError: (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)