浏览此站
联系我们相册切换到窄版 Language

 找回密码
 注册
易陆发现论坛»论坛 › 云计算开源区 › OpenStack问题汇总 › 同步nova数据库 su -s /bin/sh -c "nova-manage db sync ...
返回列表 发新帖
查看: 6188|回复: 2

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

[复制链接]
admin

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2020-1-5 11:50:57 | 显示全部楼层 |阅读模式
ERROR: Could not access cell0.
. I! H) B# v0 q9 s' M$ J3 gHas the nova_api database been created?1 ~) i$ V% @+ s6 {
Has the nova_cell0 database been created?
4 ~. X8 t0 ~4 N5 AHas "nova-manage api_db sync" been run?# K* u( @# n% x: T+ D6 `0 I. s
Has "nova-manage cell_v2 map_cell0" been run?
% {: [$ P  P/ w1 `% u( B* _. dIs [api_database]/connection set in nova.conf?+ i: v/ }$ u6 G0 o$ X6 @
Is the cell0 database connection URL correct?" U. P/ N5 M" Z2 _
Error: 317 is not 318
( m; G; C6 m1 p8 @$ h, v3 g3 c8 l2 e0 E& _+ {* v8 v

* u9 i8 T5 N! }1 o) r+ z解决办法：& B7 p  D. x; i- @5 d+ p- z
在endpoint中要加上这个%\(tenant_id\)s才可以& P" t8 |9 [: d% E5 Z/ c. R7 U

& U; Q' Q' b( n( ^7 F  p
2 \( S, Y4 L: f4 L& R/ V8 }. @8 ~# {
, I: _5 C& B2 ?3 l" {7 u6 |/ T) B8 m% A5 s5 l" L& k

% U- l2 }1 T" w& V, M, x- O处理步骤：8 ^( b" A* z/ I) _& P) B
su -s /bin/sh -c "nova-manage api_db sync" nova2 Y. u  G# O3 J* {, B& n/ }7 j. C
su -s /bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova
( U  q4 Y3 g. o% O) T231680ee-43d1-48bc-91db-139ff7ef43a2
/ w, }+ r" ^) m: ^% h; h su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova8 u- p; G4 J* E$ B4 k& Z- X& }, n
su -s /bin/sh -c "nova-manage db sync" nova& {, q6 k! v2 i! ^  g5 m8 o
/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')  a  b) b9 C% Z! v! z. G9 F- i; W; O
  result = self._query(query)
  Q( _; u, g3 L4 g- w! t/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')
' B( A+ A6 J5 J9 k  H9 p) M  result = self._query(query)9 S4 A1 w6 [6 U& d
ERROR: Could not access cell0.* \) j4 _: x: j# V+ ~
Has the nova_api database been created?
8 j2 ~/ c" Y; A4 YHas the nova_cell0 database been created?9 S$ Y  w  B1 i  l. w
Has "nova-manage api_db sync" been run?( w7 m/ i7 F8 A6 i+ }. }
Has "nova-manage cell_v2 map_cell0" been run?0 v" U% e2 s, X  i
Is [api_database]/connection set in nova.conf?
: D- @% Q. j( }5 M+ aIs the cell0 database connection URL correct?
# a. O; Q7 q% ^* x$ GError: 317 is not 3180 M* f! M- r* s
An error has occurred:
$ ^# G2 k$ _7 {Traceback (most recent call last):/ I' g* x6 V# ~; b
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
1 e6 P7 B/ G  n5 g    ret = fn(*fn_args, **fn_kwargs)
! K* ^6 {: f( |  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync* y6 g4 a- `' o4 Q
    return migration.db_sync(version)3 _8 e& |5 B( {- M
  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
1 A& p% Y3 a$ y    return IMPL.db_sync(version=version, database=database, context=context)
% m1 x2 G8 Y% l  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync: c) w6 U+ v( k( i
    repository, version)+ ?# J1 O" j! U0 z4 x4 f; R
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
: P. m& m) B5 w* ~; B" U    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
5 f# I0 c( A% `' ~& T" Y  File "<string>", line 2, in _migrate
6 ^7 M1 x1 j$ _( P" {  S1 x) ?$ \  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
2 U( i* h% A+ A: Z    return f(*a, **kw)1 ~: _  j; ?8 K& t8 e) D
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
  b' j. I2 f& e8 d1 W3 U; |" |    schema.runchange(ver, change, changeset.step)8 V' D) |+ e; [: B
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange% Z# U- i5 W. M" C" _( f
    (self.version, startver))
6 k8 j0 F! s. J* P) vInvalidVersionError: 317 is not 318
# C; m" K( L( L9 x* P8 _* K su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova# c0 d9 ~% O/ i% w
Cell0 is already setup, c3 E1 B% g0 i  e9 G6 E
su -s /bin/sh -c "nova-manage db sync" nova
+ ~7 ]6 |: p& a* d& v! h8 t- a: C6 k
同步数据库完成。
' C( V5 H3 }' X, i; a3 O4 ?/ y$ L% V: G$ [
回复

举报

admin

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2020-1-5 11:53:24 | 显示全部楼层
An error has occurred:
  o% b6 t1 L; rTraceback (most recent call last):
; @$ d+ P* a2 G, u  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main; y6 ]+ n5 @& r6 b. v
    ret = fn(*fn_args, **fn_kwargs)* A; b' S% q6 P  l2 c
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
! t: E1 |7 K' Y0 h' K& }    return migration.db_sync(version)
0 {& |' |/ @6 t, k8 H8 d  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
  R3 p" N" R6 c1 |5 U% i    return IMPL.db_sync(version=version, database=database, context=context)
* F% \; L/ e& V2 k1 w  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync- c# J% D3 |' z' r$ K8 ]
    repository, version)
: K! O1 Z/ I0 u2 s" D' j  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
+ k% Y% i$ K; q* V; M& _    return _migrate(url, repository, version, upgrade=True, err=err, **opts)# }) |9 d6 ?/ c+ X
  File "<string>", line 2, in _migrate
8 D# }' e' {0 X- G' l  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine( |3 \8 I  O+ r6 @" P3 z
    return f(*a, **kw)/ L; E8 e2 w' H7 J5 N/ p
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate. b! R$ O+ n0 o
    schema.runchange(ver, change, changeset.step)% N2 A" ^9 p4 i; s6 w1 b
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
- z: T0 z3 j" Y( R  E. h    (self.version, startver))7 ]! n0 W; Y& a5 F) t) Q) M
InvalidVersionError: 317 is not 318$ d$ J( z' i0 h, ?
回复

举报

admin

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2020-1-5 14:12:09 | 显示全部楼层
ERROR: Could not access cell0.
4 N, G5 w) G  Z6 h9 [Has the nova_api database been created?6 _. C' Z, X; ]. A
Has the nova_cell0 database been created?
1 w. @$ A7 L% R% P. a. NHas "nova-manage api_db sync" been run?) s6 N1 T) Z. s  v: j$ Q
Has "nova-manage cell_v2 map_cell0" been run?& \( ]+ [7 ], D5 z
Is [api_database]/connection set in nova.conf?  u7 Q8 r: N' a$ T( b" x2 ?
Is the cell0 database connection URL correct?
( z; Z( q% i6 E! ]Error: 317 is not 318: h' N: K- F3 {. m- i) B
An error has occurred:3 ~) H5 ?3 F- o/ X
Traceback (most recent call last):3 n4 y( d+ Y9 k1 K' G9 f6 E
  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2375, in main
3 ^7 c$ P, }) g% o    ret = fn(*fn_args, **fn_kwargs)
' l0 R  Q6 I# v  File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 495, in sync
( m* @) F3 m3 v3 ]2 f4 R    return migration.db_sync(version)8 |7 F3 S+ n% x; ~/ r, \+ g9 C$ X+ y
  File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync9 D; y) h9 C" j2 z5 T4 }% z9 m
    return IMPL.db_sync(version=version, database=database, context=context). [" i% u0 H0 L* }1 L1 u; U. C
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 61, in db_sync
1 A2 t3 u  i" N7 Z+ d    repository, version)7 Q: e1 R: F2 @4 O) x
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
/ g" q1 b) j7 a* X5 ]/ f    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
; `% m1 a: D3 I% n* w  File "<string>", line 2, in _migrate4 z; K! Q! q% T9 ~  k2 W
  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine' [1 A& G3 v8 @. t
    return f(*a, **kw)% U' B5 H' b; o/ [  [6 `
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate. y! k5 P; J4 c$ e
    schema.runchange(ver, change, changeset.step)
& W4 ^+ V6 L$ U  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange& Y* ?  X8 n" ^
    change.run(self.engine, step)1 G; }' n; h: W7 d( @9 q
  File "/usr/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run
7 x" O' Z7 _; e" m+ l0 u7 R    script_func(engine)! P& _1 S9 E) \( s$ k" s: J
  File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py", line 1443, in upgrade
  x7 P7 Z% B1 C; E, k/ `# @2 v0 J    index.create(migrate_engine)
0 H2 I! n  f# a2 _/ p$ w  `  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3656, in create
9 r% t. d. M, r' N5 R: Y) i8 s    bind._run_visitor(ddl.SchemaGenerator, self)8 l) h9 p, |' T) h$ l
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
% L* s+ Q: i) f# f$ T" W    conn._run_visitor(visitorcallable, element, **kwargs)1 H: R- ]* H3 e* E
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor  H0 ~2 d8 O8 o  K: Q
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)- Q  @  U7 G' F% D& [
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single6 l: ^/ n1 }( _& v2 j1 d- e
    return meth(obj, **kw)3 ~; r6 I" t. _* {
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 860, in visit_index: t; _3 ^# E$ k2 R1 J. N0 b
    self.connection.execute(CreateIndex(index))
0 t" U# O" z2 u' W8 j) b( S  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute: K( {6 Z# {9 Y. P: s
    return meth(self, multiparams, params)
$ z2 E6 \8 C4 E  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
; y) g: T9 t+ B    return connection._execute_ddl(self, multiparams, params)0 e8 _: ~. T$ A) V4 y
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1042, in _execute_ddl# h' F' X+ Z% S) o2 p% G- f, s/ I+ x
    compiled,
# {' Z1 e- ?# ]3 q( t) C  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context1 ^2 }8 \: L. D7 f
    e, statement, parameters, cursor, context0 ~. x8 X% v" N8 q: H
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception8 h/ I/ b+ |' q$ t( X
    util.raise_from_cause(newraise, exc_info)
  R. V+ r* x" L  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
. T2 O. I5 |9 |7 T5 K    reraise(type(exception), exception, tb=exc_tb, cause=cause)1 W3 v% {& u3 H- r( H7 T7 ]& f
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context/ l, |( w/ Q+ |$ z% ~
    cursor, statement, parameters, context
3 R% ]1 ~; h! s4 f% ~7 V  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute8 |; [0 X3 N7 m7 }7 ?5 E
    cursor.execute(statement, parameters)
; z* l5 H. }: c! e- |* V  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
7 i2 p  a# b# ?9 n3 i! f: X    result = self._query(query)
4 p# b7 e5 j2 N  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
4 ~5 j1 b  I$ |( P) f, C    conn.query(q)8 J. y) S) B5 f. c
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
+ F6 e( c$ _1 J- U: `. I* Q' Z0 m    self._affected_rows = self._read_query_result(unbuffered=unbuffered)* e0 C$ B8 i# d% C) [, I
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result
& P! m0 T( S- U" ^% c* I: V    result.read()$ ~. Z* O. S- {+ W" _& b
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
; S; S/ S3 y9 T# Z    first_packet = self.connection._read_packet()
- {% [  c) f& Q# N: h  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet' b; V1 G" {8 _3 W: i/ b
    packet.check_error()
% m: g( _2 T0 r0 p$ Q* ]+ d% s  File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
  Y! L) P" O* ]7 _$ X! @    err.raise_mysql_exception(self._data)" p! B8 W. h& o3 q9 Z
  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception. \% [8 s; I; J. q1 a5 s! K
    raise errorclass(errno, errval)* I# O& f! g# h% r: r" R4 k! m. I- U
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
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 01:29 , Processed in 0.025525 second(s), 23 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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