将设为首页浏览此站
收藏本站联系我们相册切换到窄版

易陆发现互联网技术论坛

 找回密码
 开始注册
易陆发现互联网技术论坛»首页 › 云计算开源区 › OpenStack问题汇总 › 同步nova数据库 su -s /bin/sh -c "nova-manage db sync ...
查看: 6191|回复: 2
收起左侧

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

[复制链接]
admin
发表于 2020-1-5 11:50:57 | 显示全部楼层 |阅读模式

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

您需要 登录 才可以下载或查看，没有账号？开始注册

x
ERROR: Could not access cell0.
+ c* ~8 K4 w  M2 x1 u- Q- U% \Has the nova_api database been created?, I# i4 j8 C0 H* M: O
Has the nova_cell0 database been created?
+ B. X/ i$ W6 h1 PHas "nova-manage api_db sync" been run?
) T/ m, ^, Y- s7 jHas "nova-manage cell_v2 map_cell0" been run?0 @! I+ e' U% @
Is [api_database]/connection set in nova.conf?4 @3 W; _0 P! c" M: B& P. H
Is the cell0 database connection URL correct?
& ~  ]7 ^/ a2 t9 _: ~: j) GError: 317 is not 318
( f% J0 w' V. l* V
% t6 W* w" w" n1 o) r/ ?9 i; ?( a' r9 {! R( a7 I! o
解决办法：7 {3 i3 S- y* x7 |) ]- P8 b4 q
在endpoint中要加上这个%\(tenant_id\)s才可以
" D% j) x. {7 t, P' {
3 v! P$ V) c9 l5 c& P5 M, ^
. {! A; Q+ [- f3 m& ~; ~' u  M: p/ V
+ e: h) H0 w  ]3 ~1 u7 v+ B- g
7 g: i6 g3 b3 K) F6 l* A9 y* G$ T! e
处理步骤：# e! z5 m6 x# S+ \$ T
su -s /bin/sh -c "nova-manage api_db sync" nova7 P" w4 }$ k1 s. N# c9 f
su -s /bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova6 |  M6 J' r% a- X+ t" ^
231680ee-43d1-48bc-91db-139ff7ef43a2
- t5 a! R, f& u6 G  ` su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
0 Q9 l) J/ c/ a su -s /bin/sh -c "nova-manage db sync" nova
% `9 ^- C: P& x. g/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')7 K* S# M/ ?5 m* q
  result = self._query(query)
2 v0 v* |4 M8 ^9 F3 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')0 t( l9 C& ?( b5 V& b
  result = self._query(query)
# m! z/ N* K( x9 f8 h' M. e  wERROR: Could not access cell0.) |& U1 W1 f0 P) R
Has the nova_api database been created?3 ~5 b2 o9 T' P1 A
Has the nova_cell0 database been created?, L8 J( N8 o8 }; B  u
Has "nova-manage api_db sync" been run?
; _, U9 `. p. y; O% W" s8 wHas "nova-manage cell_v2 map_cell0" been run?% g3 y3 p! j* @; p& L
Is [api_database]/connection set in nova.conf?6 u/ B5 D0 h3 _. U9 d# z. o1 K% T
Is the cell0 database connection URL correct?
- N1 `% S$ s" x$ K' O) `! MError: 317 is not 318* N  l; W2 N# H/ r3 u
An error has occurred:- H* I3 z: Z. Q0 N$ r3 }6 e
Traceback (most recent call last):$ U$ V, f4 g0 j& Z: T& e) M; L$ W5 }
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
( S& g% l, _, C  X) _0 V    ret = fn(*fn_args, **fn_kwargs)
5 i3 L! i: ^: T1 d8 ?3 x  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync6 c2 \" C9 k  v1 \
    return migration.db_sync(version)3 j& w9 y0 l+ }6 ]
  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
( K; Z* @6 S3 i    return IMPL.db_sync(version=version, database=database, context=context)
& M6 ~9 I- u1 w  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync2 \/ j% S/ v2 n! Q, ~
    repository, version)5 R& ~5 |& c: E8 N$ t
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
# r. S7 b  F* m  N! f    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
+ e2 g# F6 R% J% t  File "<string>", line 2, in _migrate( ], D) {9 ~5 L' s+ {+ U3 }
  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine2 s* {2 \: f$ U7 v! n  h6 t
    return f(*a, **kw)
! R/ y2 m! _2 v3 M7 w  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
0 U3 t: n0 `# q0 `1 f( [3 d: v    schema.runchange(ver, change, changeset.step)
' S, a  A& m3 @  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange4 f1 ?* u& @  H2 e2 z) ]" p
    (self.version, startver))& K, N  S* H8 Z
InvalidVersionError: 317 is not 318
* i4 K0 h5 l) D# n- @ su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
2 E1 ?' v* y% d- v& Z% QCell0 is already setup: O* A% [( x( I- `$ R9 W
su -s /bin/sh -c "nova-manage db sync" nova& L; F" h5 S' ^% \, z6 n
5 D0 ~8 V3 e! _! ~# T0 \
同步数据库完成。
0 u$ g, F# T- E0 E6 ?! P9 D1 n8 o2 K# _+ c$ L" Q, f, f  J& t- o2 y. I
回复

使用道具 举报

admin
 楼主| 发表于 2020-1-5 11:53:24 | 显示全部楼层
An error has occurred:
' O6 v/ j1 a7 B' V' a, `Traceback (most recent call last):
* a7 }+ [. W" F0 d3 l8 L8 d  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
; _9 h4 {9 Y, ]5 @- ?    ret = fn(*fn_args, **fn_kwargs)$ I0 I0 ]/ {* h& Y9 ]$ A
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync. g+ @: A& p2 |2 {, r& t4 X3 h
    return migration.db_sync(version)
8 t9 C% _( m; U9 `  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync# z6 k0 _& o" f5 b/ A: c$ n8 n
    return IMPL.db_sync(version=version, database=database, context=context)0 O# z' T. S/ x( `! z8 |
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync1 h) m$ `0 n3 J- a3 D- W
    repository, version)7 H; q4 ~. O7 i* f; o5 M, p0 E
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
; O1 l; ]" `+ K* e) E: \    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
9 c) y9 F- d+ z  File "<string>", line 2, in _migrate3 B* n" q! z+ B1 ^) ^' \5 I
  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine' g& |3 f& g, M2 X+ p- W, h. \
    return f(*a, **kw)
1 c! A5 E+ H) ~% b# h4 I( m  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
: L, X' f3 U, ]$ ^3 r% Q5 K    schema.runchange(ver, change, changeset.step)- S  p6 Y7 I6 c3 l, F( m0 ?( {
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
4 _- n9 z8 E6 k' N    (self.version, startver))
6 i2 \* h0 `  h! d' xInvalidVersionError: 317 is not 318
" H! o* I0 U5 M! E! X
回复 支持 反对

使用道具 举报

admin
 楼主| 发表于 2020-1-5 14:12:09 | 显示全部楼层
ERROR: Could not access cell0.9 l0 W4 z, b1 n/ `& C
Has the nova_api database been created?  x4 e+ L. L) D7 V' u
Has the nova_cell0 database been created?1 _* X: O) M5 W
Has "nova-manage api_db sync" been run?
5 f! N8 I- N2 l9 yHas "nova-manage cell_v2 map_cell0" been run?
7 s6 C$ k& l( OIs [api_database]/connection set in nova.conf?! A3 S- G. A% n* `6 a5 R
Is the cell0 database connection URL correct?6 D3 b4 N( D6 n! s  I$ K( n$ D
Error: 317 is not 318
' E5 q9 H2 n# F, Y5 _" ]8 [An error has occurred:% W# M7 h1 j5 H
Traceback (most recent call last):
, Y- T0 A) C9 g- y+ b8 n+ Y! m  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main/ D) k+ V5 X) w1 _
    ret = fn(*fn_args, **fn_kwargs)
) @* C" A' T9 t  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync* I1 }; G' @( D2 L
    return migration.db_sync(version)' q/ \5 n' R& N+ K' D
  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync" v6 _8 y5 d! n: }4 Y( H
    return IMPL.db_sync(version=version, database=database, context=context)8 W  Y( u9 ~% e! r
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync& ]8 s) Z8 H( U3 o
    repository, version), n, J3 l& ?) O- f3 X1 x- T
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
& q$ I" x8 @* ]8 d% }7 ^4 F- a    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
" g7 i9 [+ c) I; z& K8 D, A* d3 r  File "<string>", line 2, in _migrate: y/ S; b: e  Z  X  R- H
  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine+ x- X; g5 t, `) p7 |" H- n3 h
    return f(*a, **kw)
' w9 k  E' D2 z) [: H! G9 m0 I9 u  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate' T3 b+ P4 |5 H4 N8 U
    schema.runchange(ver, change, changeset.step)' I) m& T  ~, s# f4 o' X" J
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange( w6 c0 o) o2 c6 y* ]# p
    change.run(self.engine, step)! i* a7 V9 L! U5 [! `
  File "/usr/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run
+ `# s* V9 ?9 P( \* R! ?% t$ T    script_func(engine)
) n) Q: C6 l2 b6 p: G; C& [0 o) ~) E  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py", line 1443, in upgrade
7 ^. G4 ~, Z0 c" b0 U9 F    index.create(migrate_engine)
9 ]/ j; @9 @! p8 [  n% [  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3656, in create
6 l* h8 Q& X. C+ s    bind._run_visitor(ddl.SchemaGenerator, self)& T6 u8 l3 P% W7 R5 {. c
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor2 k$ e- ]: g- O# k  b
    conn._run_visitor(visitorcallable, element, **kwargs)) v1 x. G7 x5 {9 c
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor  M# q4 Z- \+ ^
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)$ i3 _+ C0 I$ E. j. ]
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
3 J* @, V( f6 Y% j- `# w& r9 w    return meth(obj, **kw): n' l% s% m) I$ w6 ^' l
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 860, in visit_index
. D  g4 f& X7 |( u    self.connection.execute(CreateIndex(index))
1 j9 x2 f; ^4 ]0 h$ v0 y  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute# N) X+ W! `+ V; N9 g
    return meth(self, multiparams, params)8 l2 Z& g* M( x0 V- c, T
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
* u/ B! }# D# d0 o5 G2 ^    return connection._execute_ddl(self, multiparams, params)  M2 \# e3 b; ]( \; i* L
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1042, in _execute_ddl3 E) i$ L& ]6 H, }9 G
    compiled,
) P5 L) I# O3 U) [* z  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
: U4 o- h# x$ q    e, statement, parameters, cursor, context* W) \1 c0 y, C( M0 S8 ]
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception# R7 J# n0 p+ r3 ~" t: N
    util.raise_from_cause(newraise, exc_info)
: G! K( O8 K& C) l% i. q  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause8 d& I, Y! P! n3 D# G
    reraise(type(exception), exception, tb=exc_tb, cause=cause)$ C0 o2 Q4 |) q; `2 S6 N
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
1 V3 o: b, g; h  \( }, J1 t    cursor, statement, parameters, context& k/ a% t3 m2 w1 _5 D* o
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute& I: `3 u: j: V4 k: D& {& s) s
    cursor.execute(statement, parameters)
% }2 _/ |! U# z: y  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute0 m+ d; q: `3 n" |" c
    result = self._query(query)
, q( R% E* |; }& ?) R6 V6 Q  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
7 {3 i* w: i# A; y: A1 F0 h    conn.query(q)4 b( V  S# o3 d9 p3 R7 c! b! V
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
& }' g5 e2 _) {! j7 Q' [    self._affected_rows = self._read_query_result(unbuffered=unbuffered)$ a- m6 o  J7 V( Q: A
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result; f8 F2 X0 v7 K
    result.read()
) q, S6 x2 Q- Q* A$ q) g  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read& t! |2 j7 K* z% a+ {" i. v& E
    first_packet = self.connection._read_packet()
* X; L5 M& ^) ]  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet* v; `1 c: e# ~; w3 A; M. }
    packet.check_error(); h# d: h  x/ n5 }( J
  File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
6 A+ ^& o1 m1 O    err.raise_mysql_exception(self._data)
1 k6 ^1 x: [: R) n; |6 }  k4 A  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
- @9 F2 [" h& q; B    raise errorclass(errno, errval)
# L  R. z+ O: v( ]  [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)
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 开始注册

本版积分规则

关闭

站长推荐上一条 /4 下一条

北京云银创陇科技有限公司以云计算运维，代码开发

QQ|返回首页|Archiver|小黑屋|易陆发现技术论坛 点击这里给我发消息

GMT+8, 2026-4-8 15:28 , Processed in 0.041726 second(s), 22 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

快速回复 返回顶部 返回列表