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

admin

ERROR: Could not access cell0.
; |0 G( q1 ]$ a7 E9 vHas the nova_api database been created?
5 }+ P6 f" P  s" W( OHas 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?
9 _2 I3 e& K6 Z4 f8 V  E8 \+ iIs the cell0 database connection URL correct?
; k1 w# z+ P3 f6 m/ AError: 317 is not 318


解决办法：
在endpoint中要加上这个%\(tenant_id\)s才可以

; C3 g3 V! u1 J8 t# g2 P7 @: R
% v( s% `  h: M8 ~2 S" D# @
  P; @9 `% ]* s1 {6 E
; h6 J6 E+ |  j1 Q
处理步骤：
su -s /bin/sh -c "nova-manage api_db sync" nova
* p5 k$ F- s4 P8 K9 Msu -s /bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova
8 B% p: c3 H7 B" W% R231680ee-43d1-48bc-91db-139ff7ef43a2
2 S$ Y: o+ {2 Y. X( I5 X su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
su -s /bin/sh -c "nova-manage db sync" nova
) V* _" G1 O. x- {/ L/ @6 e4 Z- F, a1 X4 j  q/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')
0 @* a5 ~3 P8 z0 {8 v  result = self._query(query)
0 S$ p5 ~5 s) h' p6 f; s6 I1 v/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?
/ L8 ]- F4 m  e5 g' O  gHas the nova_cell0 database been created?
/ V' V- v5 a& K4 c! g0 kHas "nova-manage api_db sync" been run?
4 h/ ^; f4 l1 g. P3 j) m7 @4 s5 O3 yHas "nova-manage cell_v2 map_cell0" been run?
Is [api_database]/connection set in nova.conf?
Is the cell0 database connection URL correct?
Error: 317 is not 318
2 K+ ~: {8 P3 Z0 `) R. k( E0 qAn error has occurred:
Traceback (most recent call last):
. ]( D4 ~  r& F, S' C  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
. e% }; l9 E9 p$ M+ Z: h1 A0 N; [    return migration.db_sync(version)
- D/ O. y8 K+ d; J$ N  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)
; }7 u5 S+ z* ?+ ^3 ^6 ^9 c7 I  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync
+ `7 M1 V% X4 w$ a2 |    repository, version)
. ^( Q! C! @3 [( P  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
0 g) ^! f8 \) N    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
- a1 w. u% d7 n( Q  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)
  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
7 A, u. G  n$ w, E$ D    (self.version, startver))
( g4 ?4 k  V  z2 s- QInvalidVersionError: 317 is not 318
) ~* d$ j9 V/ Z9 p* K su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
1 {3 w1 C& V; z2 y# y8 UCell0 is already setup
( k9 a& c+ r( d( ~. `# ]% ?- M su -s /bin/sh -c "nova-manage db sync" nova

/ O" X( k6 T( w; k3 @3 e4 P同步数据库完成。

admin

An error has occurred:
) ]# Y7 [; }# N. H& w2 ATraceback (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)
* S) ~) r# K- ]" ^: u  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
    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)
  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)
; Q, _, \( A# S1 y% d- X: P  File "<string>", line 2, in _migrate
  Q; y( I; r1 @/ u7 ~+ q: v4 E  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
/ P( e8 ~$ V! @. K8 L    return f(*a, **kw)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
$ j: I+ [, o; l- R) a1 g    schema.runchange(ver, change, changeset.step)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
+ }% x6 ^% B1 H    (self.version, startver))
InvalidVersionError: 317 is not 318

admin

ERROR: Could not access cell0.
Has the nova_api database been created?
; a: o0 ^9 m7 \Has the nova_cell0 database been created?
# ?7 ]% _) a8 Q0 M' t; G6 cHas "nova-manage api_db sync" been run?
Has "nova-manage cell_v2 map_cell0" been run?
# F$ G1 O6 a; I# _  V% X, d0 YIs [api_database]/connection set in nova.conf?
& d9 u- E# a1 T+ v8 oIs the cell0 database connection URL correct?
% T; P; C6 l7 sError: 317 is not 318
  C, @: y/ ]2 ^: t# B0 }An error has occurred:
5 R9 e# [" p7 e& M5 b# F4 U9 ]' }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)
  x! ?+ J# X1 \4 Q8 c$ Z. O/ o  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
    return migration.db_sync(version)
$ W+ V, K2 T' c; e: t  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
: V3 m( d( u6 h3 `: F    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)
; [1 G1 b) X/ T' O9 C/ A+ b  File "<string>", line 2, in _migrate
8 m# z) x) ]' {  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
) n8 q. G# t' x9 r8 h. f/ D! i' u    return f(*a, **kw)
& \* h' ?8 V; g: P  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
$ Q# z, P; W1 C& t0 C7 v) q- X, K    schema.runchange(ver, change, changeset.step)
3 E9 x9 `# f3 I- p# }. q5 |2 u1 p  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
% J4 n- M0 o) @+ L' M- Z    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
2 r* `  O9 {9 z) c$ D1 p    index.create(migrate_engine)
1 K5 Y/ o; ]; H2 s2 r- o  ]  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3656, in create
0 R6 ^: W3 G( H* `0 I, g    bind._run_visitor(ddl.SchemaGenerator, self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
" h+ j% c' \5 ?/ v' c1 m    conn._run_visitor(visitorcallable, element, **kwargs)
& g: W. M) ^: y* l  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
- |5 O* b% h  w( }  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
    return meth(obj, **kw)
# V+ A; ?0 \* o9 F) j+ @  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 860, in visit_index
) e' D) o- e/ M0 d* M9 c    self.connection.execute(CreateIndex(index))
4 @7 L$ e5 c* m# k  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
7 @; C6 f& N, m/ B+ J0 x% q3 K7 g    return meth(self, multiparams, params)
: u$ L* C4 @! C5 Y  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% A$ M% Y' d! Y5 M1 E    compiled,
5 H7 c- _; q+ l  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
  i( r/ w, w" d7 a4 V: B. ~  A    e, statement, parameters, cursor, context
' F9 b( b0 d% v; j  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)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
# Z  z8 l- K9 U3 y# n  f, d2 Q5 w    cursor, statement, parameters, context
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
* B/ l, z' N$ ^1 G    cursor.execute(statement, parameters)
) Q: S( T& M% B( t' ~$ a4 ~& f  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
    result = self._query(query)
  s' J, J1 z" E# J3 w' X4 }  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
& [1 _# f0 y+ |    conn.query(q)
, _: Z, i8 }' {4 a, }% F& I  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
0 P* U  v: Z% Q: j3 d& |0 I' E    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
" {# N- o+ g# @$ u9 y9 E; l  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result
1 x+ m# a' w# W3 ?) H6 q3 _6 Y$ h    result.read()
6 \, ?) v( Y2 M8 g  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
    packet.check_error()
  File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
. [5 g* {% y$ E3 A! |1 V; `. Q& w$ c    err.raise_mysql_exception(self._data)
; Q$ d0 V8 }) [8 a* {  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    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)