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

admin

ERROR: Could not access cell0.
2 c9 G+ [8 G2 lHas the nova_api database been created?
Has the nova_cell0 database been created?
Has "nova-manage api_db sync" been run?
  k/ E2 R: y) M( {: S- C% E1 vHas "nova-manage cell_v2 map_cell0" been run?
4 V2 I/ N4 O5 X* p/ t, xIs [api_database]/connection set in nova.conf?
0 W2 U% d9 W) c8 L0 LIs the cell0 database connection URL correct?
5 |( H2 E* k  v: n5 x/ kError: 317 is not 318


) x* L1 Y; J0 y3 Y" }8 _% H解决办法：
6 b3 Q2 y2 n0 Q9 }* t6 N在endpoint中要加上这个%\(tenant_id\)s才可以
. }- U/ \0 `. t8 E7 {& A# R  m8 s' r

2 |  I4 j) Q# F& f' u
- Q' Y& P: L" r% a+ t

处理步骤：
# n! t5 c$ }6 L8 M: T- D su -s /bin/sh -c "nova-manage api_db sync" nova
' f5 N: K$ a+ d; s0 G8 psu -s /bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova
2 Q! G4 l) y/ h6 [231680ee-43d1-48bc-91db-139ff7ef43a2
su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
su -s /bin/sh -c "nova-manage db sync" nova
9 F4 U/ g, {( K$ Y" U* n6 p/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')
  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')
$ j+ c- O) O) G7 w' z) @  result = self._query(query)
& F! N6 W  t/ Z( T! {ERROR: Could not access cell0.
Has the nova_api database been created?
Has the nova_cell0 database been created?
! H- m# J, n- I* J5 [/ ~1 jHas "nova-manage api_db sync" been run?
Has "nova-manage cell_v2 map_cell0" been run?
  J: z) m' H3 K$ J; qIs [api_database]/connection set in nova.conf?
Is the cell0 database connection URL correct?
$ ^3 ]; ?5 g+ `9 ^5 c: X- b5 CError: 317 is not 318
4 ?) `( @( m/ uAn error has occurred:
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
    ret = fn(*fn_args, **fn_kwargs)
6 H$ I! A/ Y& R) q  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
- [* r/ A  ?9 ^) R    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
    repository, version)
+ l2 A% |7 g: n7 T$ D0 f  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
- N4 R9 z$ ^+ ]" E    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
- A+ [- v- Z5 A* \2 t& q  File "<string>", line 2, in _migrate
  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
3 h9 ?0 ~/ m9 M+ H& B& ~8 S    return f(*a, **kw)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
, v: q. o8 r3 d( {' B: n    schema.runchange(ver, change, changeset.step)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
# W, X7 b) d5 ~9 p/ l5 w# r- P    (self.version, startver))
InvalidVersionError: 317 is not 318
su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
Cell0 is already setup
su -s /bin/sh -c "nova-manage db sync" nova
9 |" `* H& Y9 E' M3 J$ m4 k* m4 a
同步数据库完成。
* [: ~. Z8 D+ t! T& v7 l

admin

An error has occurred:
Traceback (most recent call last):
  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
/ G% B; g/ _+ W+ ?3 X, L5 g    return migration.db_sync(version)
  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
% V% J2 `6 |- @; U) y7 u* J6 M  o; T" q    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
3 _) [, M! r- e3 T( H( |1 @$ @    repository, version)
9 d2 b* Y& t( o4 J7 x$ K  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)
% B$ L& M: ~* D% i: x% r- A8 W  File "<string>", line 2, in _migrate
7 Z! b' q4 s& V4 {" G# R  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
5 L+ c( ?4 @! w( r    schema.runchange(ver, change, changeset.step)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
    (self.version, startver))
4 a" s3 K) @" F; `  @2 HInvalidVersionError: 317 is not 318
) ]; N5 b; o" g

admin

ERROR: Could not access cell0.
2 L- U  l  {- L! ~9 GHas the nova_api database been created?
Has the nova_cell0 database been created?
Has "nova-manage api_db sync" been run?
5 Z# R  e) }! C3 f6 {Has "nova-manage cell_v2 map_cell0" been run?
Is [api_database]/connection set in nova.conf?
9 Q9 g7 `5 l' _9 \( K5 H) h6 L' zIs the cell0 database connection URL correct?
Error: 317 is not 318
An error has occurred:
9 G. E- _: @* a8 ^3 n: q# [Traceback (most recent call last):
4 e, D4 M9 w8 Q! i; q/ ~& A0 P  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
: ?0 c3 J2 S5 d    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)
3 g3 I( D0 V8 R* f& g; x% ]8 T  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
, {, N) Z9 W) y0 v  e& X$ T    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
) N1 I9 v: P6 i; R/ S0 i  Y, C- r    repository, version)
9 ?& g. Z; V* j. [, n* b3 I( Y" r4 U  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
2 K$ I; t& d' X( r    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
  File "<string>", line 2, in _migrate
. v4 x7 U8 A/ B2 r: u4 g8 [4 x0 O  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
; K* T5 J/ h- s9 P# V& V    return f(*a, **kw)
" `' ^4 W3 T' Z& E, B8 O  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 93, in runchange
' v. Y: r  W' i7 b& J    change.run(self.engine, step)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run
$ E4 n! @3 V$ o9 B- Y    script_func(engine)
, a' v2 s0 W& d# m  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py", line 1443, in upgrade
    index.create(migrate_engine)
3 N& m, a: p( I- I; Q8 C. h( x  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3656, in create
# B& I& z1 `! ^* C. y( g" j* X& E    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)
: j" Y& M0 V5 m, r  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
    return meth(obj, **kw)
4 Q( @1 v. D( f* A+ b  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 860, in visit_index
    self.connection.execute(CreateIndex(index))
7 R* n  F% x: T5 a  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
    return meth(self, multiparams, params)
7 X! |+ a/ G, A; P  u" ^0 Y  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
4 L, d! ?+ m( u+ P    return connection._execute_ddl(self, multiparams, params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1042, in _execute_ddl
( P3 P/ e0 h, S    compiled,
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
    e, statement, parameters, cursor, context
. t7 ^& J" r6 r$ L! @' X$ c  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception
; G! x3 X! f- W1 |    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)
" P! X: o4 b% y  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
* _# h( q; j/ z) g5 B4 U    cursor, statement, parameters, context
* s; V5 l/ B5 F7 Q8 b3 f  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
) f3 l- o; B4 M$ r    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
  g, H2 ]/ d  s    result = self._query(query)
  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
6 h+ W8 x2 J# j8 c, E- S' t    conn.query(q)
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
2 E1 k3 y( R4 g, Z% ^  T    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
2 Y; T& S5 l9 z" A% ~8 v3 [$ a    result.read()
- }3 W& C+ x; q( e, R, t( N  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
    first_packet = self.connection._read_packet()
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
. {% |! S9 T7 B( Q+ j1 a    packet.check_error()
  File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
+ r* d5 D" s. I3 o# X    err.raise_mysql_exception(self._data)
  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
6 W. M: {/ [% f% E, T    raise errorclass(errno, errval)
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)