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

易陆发现互联网技术论坛

 找回密码
 开始注册
易陆发现互联网技术论坛»首页 › 云计算开源区 › OpenStack问题汇总 › 同步nova数据库 su -s /bin/sh -c "nova-manage db sync ...
查看: 6190|回复: 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; X* S# V0 F! xHas the nova_api database been created?( O- Q& L# H1 t5 @4 w& F0 Y, G
Has the nova_cell0 database been created?3 V4 C  h5 o) j& P+ V- P& G3 B
Has "nova-manage api_db sync" been run?; C! M4 v5 U2 X" ]7 y& T7 U
Has "nova-manage cell_v2 map_cell0" been run?
" u$ c; q# p  F' v: ]/ KIs [api_database]/connection set in nova.conf?7 m% N  ]: {2 A; O/ w- G
Is the cell0 database connection URL correct?
9 f" p; w5 w* w- ^0 z0 MError: 317 is not 318( |' S! n4 D+ z

: z0 N' t# F5 Q  v8 U4 X7 {
" t+ l+ W/ i( F; ~4 B0 n解决办法：
2 v7 X7 H2 G* S8 G" F$ q在endpoint中要加上这个%\(tenant_id\)s才可以. t% u) G# ?+ a0 ]  i

, o' D; n8 ~7 a9 Q' D$ B6 _8 f8 `5 l! Y- o" X: F* T* ?6 K# g

$ L& J, ?. H( C3 X" e
3 R# o' ]/ n- C5 V: C
. ~+ U9 d& \+ z处理步骤：
4 L5 {+ q5 d  ` su -s /bin/sh -c "nova-manage api_db sync" nova% p, D- e+ }8 x! _0 ^
su -s /bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova
. t0 C9 u3 ]- Q* ?5 h9 P) P231680ee-43d1-48bc-91db-139ff7ef43a2
: J, T2 r: i! s" A0 m+ j- n, b' \ su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
8 f( Y1 I1 I9 L su -s /bin/sh -c "nova-manage db sync" nova( Z# O- S" c4 D( i/ q+ v
/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 F) c$ D2 i; i  result = self._query(query)6 K" F% }6 Y! |$ S1 ^1 n3 P
/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')* ~+ w% L% m. E) ]* R8 A$ e2 C
  result = self._query(query)1 w' {+ J$ C; y" i! G+ n8 d; H$ R
ERROR: Could not access cell0./ H+ O, c0 s" O: G1 B( S: I9 F+ c
Has the nova_api database been created?5 S! @6 V- B7 h' R, j
Has the nova_cell0 database been created?/ D: I" X. [, p* P( Z# X
Has "nova-manage api_db sync" been run?. d) ^( M+ z9 F
Has "nova-manage cell_v2 map_cell0" been run?
) `, Q5 H) _/ t% W2 b1 o" g0 HIs [api_database]/connection set in nova.conf?3 G" Y6 x) k$ ?+ R0 _1 t4 U* S
Is the cell0 database connection URL correct?
0 _2 V8 N: y& C+ Q& _  Y. uError: 317 is not 318
- h2 H* W, Z* C# A9 g( tAn error has occurred:3 U, t  e6 W1 [
Traceback (most recent call last):  h8 m: W- M1 O' b
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main" |! k, L9 f: X6 ^
    ret = fn(*fn_args, **fn_kwargs)
9 A2 {2 X9 g) i2 c9 V# N- L  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
. s- \& u" C' ^0 S: X- L5 L% D' @    return migration.db_sync(version)6 u& M* L9 [0 c' E5 E% O
  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
8 L% n; q7 ]2 ?' S% c8 z+ x    return IMPL.db_sync(version=version, database=database, context=context)
( I  X- W: E) Z3 |4 d  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync
$ C' p6 t) T) H$ j; r# o    repository, version)) q8 U  C( R. b0 H
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade* C3 Z2 `0 L4 ~/ I% U
    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
: b- |4 i* `9 ~2 ~) z  File "<string>", line 2, in _migrate0 A; m2 a! N+ d- ]1 W
  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
$ ~, l1 _/ j" J! d  {6 t    return f(*a, **kw)- M$ M8 h0 I6 g5 M0 K$ d$ b
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate6 S' j2 q: m2 o5 t! @/ c) z
    schema.runchange(ver, change, changeset.step)- N8 `& v% Q1 n9 N$ }5 x
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange9 K! _0 v+ [- m* |7 B3 z7 e
    (self.version, startver))
/ }6 t7 Q' Y+ V" B6 F7 L: A  q7 VInvalidVersionError: 317 is not 3183 Z9 n5 ?& E( h3 P1 b
su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova
: M  y' C: y3 dCell0 is already setup
' d, p: L( g( w, z; { su -s /bin/sh -c "nova-manage db sync" nova
. l  {$ p: H; Y' M" m
9 R5 P3 z% `" S同步数据库完成。& m. H+ U, m. ]: `' E
. M9 }6 R1 i* C" V+ Z5 |0 [
回复

使用道具 举报

admin
 楼主| 发表于 2020-1-5 11:53:24 | 显示全部楼层
An error has occurred:
# J! L$ E9 B' H; FTraceback (most recent call last):$ s4 T( z8 @4 {
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main- C* I$ v; n% Z! v. Q& ?( ^
    ret = fn(*fn_args, **fn_kwargs)
) ]+ |2 w! g8 h  k  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
. L/ _: Q; w5 L/ M    return migration.db_sync(version)
9 {; `# ^- d8 {) R0 Q- ?  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync7 N( ^: x( k, _
    return IMPL.db_sync(version=version, database=database, context=context)- P5 v" k4 [5 y8 @' A! o& o
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync5 C/ b* }4 \+ d$ C' n' L0 ~& K
    repository, version), b' ]6 a5 {; T+ `  a- W: D; m
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
8 ^* i" W1 A* N- `    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
. Y" w2 e7 q! k  File "<string>", line 2, in _migrate
& _0 b) e) i# o* F  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine. E2 A0 j3 B7 H
    return f(*a, **kw)1 o% O  P. t- f9 o
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
0 P5 Y9 d5 {8 k, H. M9 Q    schema.runchange(ver, change, changeset.step)
( O: |2 X& R0 V6 b  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange" N9 \; V" `$ g5 v8 M
    (self.version, startver))
- ~, }1 a0 g6 f/ UInvalidVersionError: 317 is not 318
8 [5 b" H! N4 E6 Y" S3 }: f+ |
回复 支持 反对

使用道具 举报

admin
 楼主| 发表于 2020-1-5 14:12:09 | 显示全部楼层
ERROR: Could not access cell0.
" B6 E; B& M8 {/ l# l2 zHas the nova_api database been created?- b3 |1 e+ G% w6 r& R2 w# A, @" N
Has the nova_cell0 database been created?% q1 m7 d. Y* r6 [
Has "nova-manage api_db sync" been run?
5 [* L& o( k" e% W% oHas "nova-manage cell_v2 map_cell0" been run?6 e" J$ L" ]& I8 T; h0 l
Is [api_database]/connection set in nova.conf?
" H# h4 ~2 L1 N0 q7 L' v8 z0 x" uIs the cell0 database connection URL correct?: c9 Q: N) o+ f- `0 a
Error: 317 is not 318) f" P" y) A# c7 z; x% q
An error has occurred:. }8 E) C  m2 O( T8 w7 C( K
Traceback (most recent call last):
9 ]! s% y, F: R% Z7 V5 R4 {  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
/ d$ h! ?/ b0 e4 S6 `/ V. d0 t3 p1 h! Y    ret = fn(*fn_args, **fn_kwargs)1 E( b" S: A% S0 U: t3 B
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
" F7 }1 J) z" ?; O: ~3 Z    return migration.db_sync(version)
/ J% K  n7 |( [! p  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync/ F- d/ Q& P3 s" {
    return IMPL.db_sync(version=version, database=database, context=context)
9 m3 t0 |, K1 S6 q  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync3 _1 r. |; l3 f( @( h% r8 Q
    repository, version)
* I9 ]. j) J3 |4 o. s1 n( H$ `  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade9 A& m+ C4 G4 I& J9 S
    return _migrate(url, repository, version, upgrade=True, err=err, **opts)3 l) x) Q6 f% l1 {
  File "<string>", line 2, in _migrate5 V. Q" r5 P9 e( L# w
  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
& x* |6 D4 M( Q( C, S    return f(*a, **kw)% _3 D. y; W$ p( ]* W
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate9 U  H5 E- M6 Y
    schema.runchange(ver, change, changeset.step)
! g9 P9 r* S- a: C$ T" N4 H  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange* P, e/ a2 S9 N9 u/ q( t( a
    change.run(self.engine, step)1 s& [% {+ t  r$ x
  File "/usr/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run
5 E3 q# G6 x7 t& V5 b    script_func(engine)' j& @  g6 W, Q+ T
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py", line 1443, in upgrade
+ z& h: P, v. r    index.create(migrate_engine)0 L3 d7 v- L/ F! \' y( H) ^4 A
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3656, in create) d$ x5 t) @& i
    bind._run_visitor(ddl.SchemaGenerator, self)
6 m+ K' R+ }2 D  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
1 \, @9 C3 t' t' X# P( }( x    conn._run_visitor(visitorcallable, element, **kwargs)
1 T2 l' @9 u9 U3 a3 a3 c  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
' j. f: n! R  T. Q' d    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)! z" h6 Q5 H4 I4 G
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
: T' g5 H/ H) T9 b% K' l    return meth(obj, **kw); v& c/ E2 Q2 \: ?4 L# i( P! S
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 860, in visit_index; z% D1 e; u3 T
    self.connection.execute(CreateIndex(index))
2 [$ a+ \$ {5 Y3 b2 o  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
! W. I/ ^2 x0 o, J3 R( L    return meth(self, multiparams, params)
( ]  K# S* A1 g& W: a" T  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection1 s; W+ e1 f; M, V- g: e" o
    return connection._execute_ddl(self, multiparams, params)6 M) U: h1 y& ]$ R
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1042, in _execute_ddl
) J' |2 T2 z0 C& z! S    compiled,
% \3 H- z# s; }' b  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
; d6 e. g* s  ?) j    e, statement, parameters, cursor, context
6 v6 `. ?9 G: [& [6 v* j2 I  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception7 N6 a, ]+ h0 [. }2 I: h# i
    util.raise_from_cause(newraise, exc_info)
6 M' P9 \* ^1 e7 E  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
! V4 F. @* ^! v5 J' o' _/ p    reraise(type(exception), exception, tb=exc_tb, cause=cause)
4 h. u( i4 y  `; Y! k  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
, {  k( z* _& h: Z# {    cursor, statement, parameters, context. ^/ I  r/ C8 J' S0 ^: X) f" ~
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute# F& E3 x/ F( V4 z6 p4 F3 G' j; h
    cursor.execute(statement, parameters)
6 ^- B; \1 q3 c/ b0 o3 g! K  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
  r9 m$ y: O9 n9 w+ q+ y, F    result = self._query(query)& D' ^/ s2 q" h- `1 L
  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
4 c% A( d% i1 `! Y1 X8 u% @    conn.query(q)
4 ]7 L/ @- G: ?: G3 J" q3 A  Y. K  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query; r" O, d1 r! o5 [  r+ ]
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)$ h7 S# q8 g* m5 T' }
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result7 ?; n! n- O% c: F, X- H
    result.read()
% G2 p4 _) ^" N% |0 a  H2 }4 `! C  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
9 S/ Z1 S# j8 D/ c8 G- _/ m- k    first_packet = self.connection._read_packet()
$ C6 \% G! F* r# z4 b  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
; U9 M4 x0 F) G8 [6 d    packet.check_error()+ ]! _2 j2 {  ^
  File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error, F8 Y4 N0 D: ^, Q
    err.raise_mysql_exception(self._data)# `% ~* d" F6 v! v, V2 L
  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
) {' l$ c" |2 \, C! _7 |    raise errorclass(errno, errval)
* F) a7 T/ l3 ?  l" \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.043251 second(s), 22 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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