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

admin

ERROR: Could not access cell0.
  o1 G9 g2 n4 Y1 SHas the nova_api database been created?
Has the nova_cell0 database been created?
Has "nova-manage api_db sync" been run?
3 E9 B3 R2 ^* g/ zHas "nova-manage cell_v2 map_cell0" been run?
0 j+ A5 A- W  T+ N- |Is [api_database]/connection set in nova.conf?
/ x1 K3 J" u& T% c" Z2 D5 dIs the cell0 database connection URL correct?
Error: 317 is not 318

+ F# Z% E2 T! ^
解决办法：
在endpoint中要加上这个%\(tenant_id\)s才可以
: X$ C7 }9 ^" I; [- c
5 T/ c2 v% P# i" G4 @

' Y8 f& }' Z' i' S, C/ [  n( O

处理步骤：
0 _% D& [3 Q  ~3 X3 J# z su -s /bin/sh -c "nova-manage api_db sync" nova
* e- L& n, U$ t4 ?su -s /bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova
% }% i' F6 N8 N0 u) k7 Z) W3 H231680ee-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
' P! D: l/ |. A% t/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')
1 i; b$ P7 K6 C7 V) Z  h- _$ B  result = self._query(query)
0 l- L0 [& I: K, O' S0 ]/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.
) w! w* C' Q' `( EHas the nova_api database been created?
" l6 t6 k4 a9 J. A8 rHas the nova_cell0 database been created?
Has "nova-manage api_db sync" been run?
Has "nova-manage cell_v2 map_cell0" been run?
Is [api_database]/connection set in nova.conf?
" m5 j/ ?3 a* T' |5 k& S3 F3 XIs the cell0 database connection URL correct?
, e. @4 ?8 ?3 t' Z! k' s6 }1 o1 h2 pError: 317 is not 318
An error has occurred:
" D9 ?3 B8 ~0 ?8 N" o- v5 ]; CTraceback (most recent call last):
0 L, n5 s7 K- P0 a2 K0 I  x2 D  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
% A# z% E1 p) H1 L, d1 M! N5 _2 W7 t    ret = fn(*fn_args, **fn_kwargs)
5 F' y" R+ h; V' {; l  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
* Q+ o) [' P0 Z. S* w6 `    return migration.db_sync(version)
3 U" F* [+ W5 E  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)
" L: X# |: [5 R# l- b& L+ g  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
    return f(*a, **kw)
/ T6 g# P6 v& w0 {' O/ p  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))
7 P9 ~$ Q; K3 @; vInvalidVersionError: 317 is not 318
su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
Cell0 is already setup
2 U+ b/ L* L3 Y" @; K2 U0 i su -s /bin/sh -c "nova-manage db sync" nova

同步数据库完成。

4 i: q& n. I0 B+ O3 e

admin

An error has occurred:
# t% O" S, l' p# E5 a" @Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
( ^8 i, d8 r6 d' p    ret = fn(*fn_args, **fn_kwargs)
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
: {9 J, G8 e% y, N4 b% r# l    return migration.db_sync(version)
* Y; n/ h; x' I5 S& [- E( L0 E! ?  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)
9 X5 O+ u: x' p+ O  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
" J5 |# n: S  K/ r; @5 \& L6 [  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
    return f(*a, **kw)
8 m5 R3 v! g0 t. r; p  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
0 o; a- d! d7 e( d    schema.runchange(ver, change, changeset.step)
1 Y/ K- Z4 X. w$ \# z0 W2 P( X# i* |  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
    (self.version, startver))
7 {3 M3 ~9 {4 x* Y  fInvalidVersionError: 317 is not 318

admin

ERROR: Could not access cell0.
0 h: q' u1 M! X# @Has the nova_api database been created?
. [# I- r5 `- |Has the nova_cell0 database been created?
, u/ K  N0 M" y$ E. U4 SHas "nova-manage api_db sync" been run?
- d( c% j4 R+ M: wHas "nova-manage cell_v2 map_cell0" been run?
, g! k5 C: B3 {9 `+ {0 N& f4 ZIs [api_database]/connection set in nova.conf?
$ K2 M3 u# u7 c! TIs the cell0 database connection URL correct?
Error: 317 is not 318
, \$ T5 L1 Q+ s5 ]/ t; ]! u- G; W, FAn error has occurred:
. L" H5 Y3 K7 m! Q* K$ PTraceback (most recent call last):
( r5 s6 d0 L- X  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
    ret = fn(*fn_args, **fn_kwargs)
/ M# f; u  K7 M1 x8 l, |  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
    return migration.db_sync(version)
* m; ^$ s/ B* }  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
1 G0 |: |2 H# z8 D    return IMPL.db_sync(version=version, database=database, context=context)
9 v: C/ Z* A, Y7 ~2 v7 ^& O7 U0 z) w  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
: K5 Q& d+ V. ~, T    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
) w, v1 m  g+ P+ H' W% l0 v  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)
0 G1 @, j3 V8 Z, x  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
$ |! e) z  `/ z    schema.runchange(ver, change, changeset.step)
  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
    script_func(engine)
; C6 c) ]1 c( k' U& l4 A  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py", line 1443, in upgrade
$ w! s- n, h8 L3 U    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)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
+ w# P  w' v* S& f9 v    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
" i2 O9 O; Z* S: s( ^) X9 b1 d  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
    return meth(obj, **kw)
; g/ Q( t5 F" T  z- O  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 860, in visit_index
) u+ |) c& Z" l' G7 @; M    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)
  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
    compiled,
0 a8 U6 U, N2 c  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
, {& t# `  ~( M6 p  j    e, statement, parameters, cursor, context
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception
9 w5 h7 ^0 H: I7 D) ]# _$ [- [    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)
$ G6 X$ v/ L, s# {" H  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
0 G$ w3 a; W1 F    cursor, statement, parameters, context
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
- H  }3 v2 {! X0 s9 N' q- b$ f+ ]    cursor.execute(statement, parameters)
  j, R1 S+ G% c# {- @! {; {  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
7 @. p" P/ A* R) R" ^    result = self._query(query)
& Y( C( w. C; M! W0 ~' [  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
; V2 e" T% e% h" e# I1 p  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
+ s3 x; S1 t& ^6 J: 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
/ [' `1 w6 l/ D4 u/ T7 ^1 U    result.read()
+ T  D% W! W& ?& i2 j4 R* R! u  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
' S1 _1 |# P# G7 l) P. v8 L* d    first_packet = self.connection._read_packet()
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
# D( n: H: u, _2 P( f    packet.check_error()
3 }; q4 V  P9 h* K& r  File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
& F% n+ p/ Q6 b    err.raise_mysql_exception(self._data)
% P* V" G9 Q  s# }  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
- L' v/ I* E; U5 b& O+ X" j    raise errorclass(errno, errval)
7 F! k, w, f0 P% \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)