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

易陆发现互联网技术论坛

 找回密码
 开始注册
易陆发现互联网技术论坛»首页 › 云计算开源区 › OpenStack问题汇总 › 同步keystone数据库的时候，出现的error
查看: 5701|回复: 2
收起左侧

同步keystone数据库的时候，出现的error

[复制链接]
admin
发表于 2018-8-10 20:12:08 | 显示全部楼层 |阅读模式

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

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

x
2018-08-10 20:11:08.007 22951 WARNING py.warnings [-] /usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py:74: SAWarning: An exception has occurred during handling of a previous exception.  The previous exception is:
  j. T  S7 x0 r <class 'oslo_db.exception.DBDeadlock'> (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u"\nCREATE TABLE service (\n\tid VARCHAR(64) NOT NULL, \n\ttype VARCHAR(255), \n\tenabled BOOL NOT NULL DEFAULT '1', \n\textra TEXT, \n\tPRIMARY KEY (id), \n\tCHECK (enabled IN (0, 1))\n)ENGINE=InnoDB CHARSET=utf8\n\n"]0 \' E. q- c9 X8 W0 `! L% d
  "is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))) ]6 o4 i$ J% {' E1 B
: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')1 J/ K: S$ v1 @! ]4 f
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool [-] Exception during reset or similar: InternalError: (1047, u'WSREP has not yet prepared node for application use')+ r# z. B; ~0 V" X% r
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):
& P# Y. r2 s* S$ C0 Z" q2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 687, in _finalize_fairy
8 c( \8 S' b# F; N2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     fairy._reset(pool)  N" G2 u" [& i* e- i8 v3 ^1 S* U
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 829, in _reset. G+ H; J7 j) |
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pool._dialect.do_rollback(self)
3 D3 X$ l# N! N' o2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 1598, in do_rollback# I, e! v3 x0 x. a: W# _
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     dbapi_connection.rollback(): C* F% K4 ~% b
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback
' }; M" ~# x1 W9 e5 z2 M$ X2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     self._read_ok_packet()0 g: b) P* S9 ]
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 767, in _read_ok_packet
/ u7 N; h/ K7 P- N, K" T) I; `2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pkt = self._read_packet()' ~* i! U" ~1 E
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet7 w! t% Z& k, Y3 ^) V1 V8 J
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     packet.check_error()* _+ z4 B4 X# e9 d) E
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
% O& N- B5 m0 {) J0 l3 [. ^2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     err.raise_mysql_exception(self._data)
! l  [# J0 a( u! j2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
$ l1 v8 V  E# K" z) E+ I2 i& ?2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     raise errorclass(errno, errval): @; q: }% s4 d
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool InternalError: (1047, u'WSREP has not yet prepared node for application use')
9 i" V! x/ _4 _1 F8 Z5 b2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool
) A$ u0 L# m+ {+ d2018-08-10 20:11:08.011 22951 ERROR 067_kilo [-] Exception while creating table: Table('service', MetaData(bind=Engine(mysql+pymysql://keystone:***@controller/keystone)), Column('id', String(length=64), table=<service>, primary_key=True, nullable=False), Column('type', String(length=255), table=<service>), Column('enabled', Boolean(), table=<service>, nullable=False, default=ColumnDefault(True), server_default=DefaultClause('1', for_update=False)), Column('extra', Text(), table=<service>), schema=None): InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use'). n* r% B; }) z& G2 H: y
2018-08-10 20:11:08.011 22951 ERROR 067_kilo Traceback (most recent call last):6 J2 K4 J" N  D0 n
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/keystone/common/sql/migrate_repo/versions/067_kilo.py", line 245, in upgrade3 L3 v- M' q9 t# q; a. O/ s
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     table.create()9 A" w! o0 c; i( T5 t/ i
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 756, in create
) u) V: Z* m! D% w( J6 f2018-08-10 20:11:08.011 22951 ERROR 067_kilo     checkfirst=checkfirst)& T4 \, E2 o6 }/ v
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1929, in _run_visitor
2 k- e' Q' J; R2018-08-10 20:11:08.011 22951 ERROR 067_kilo     conn._run_visitor(visitorcallable, element, **kwargs)
# v! U0 D% q3 ]; x- e" g2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1538, in _run_visitor
: Q4 x( \6 z( @, r, I$ J2018-08-10 20:11:08.011 22951 ERROR 067_kilo     **kwargs).traverse_single(element)
. {! z  }0 m0 a2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single: e1 B5 z! E! ?, L. H. ^! G% L
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(obj, **kw)
$ K8 r7 y8 Z2 P. S: F9 ?+ `2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 767, in visit_table
8 v0 m. s" k1 E; Y+ b2018-08-10 20:11:08.011 22951 ERROR 067_kilo     include_foreign_key_constraints=include_foreign_key_constraints
6 ]3 z4 \; {3 A3 E; j' s2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
, I% j0 y( u5 J7 E3 \: j2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(self, multiparams, params)
! n! b8 e, Y4 C* u/ W2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
) ~8 ?( Y7 |8 L6 g! j2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return connection._execute_ddl(self, multiparams, params)+ Y8 ?$ m1 u& B- }
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1002, in _execute_ddl4 \# h: P6 _9 Z% A5 K+ j/ r
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compiled. v# G9 k, \* o
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
7 G' `8 U& p/ s; J, r1 {7 x2018-08-10 20:11:08.011 22951 ERROR 067_kilo     context)/ A; y9 f) A3 w1 b1 L
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1395, in _handle_dbapi_exception
* }" r4 Z' W5 A) u6 q0 n: F2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback()
" J/ d, g9 ]. }1 v& s; r0 Y2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 76, in __exit__% q2 V. f& i% v4 K; K) B: r
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compat.reraise(type_, value, traceback)% H% A1 ]" ]5 \  E+ R
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1395, in _handle_dbapi_exception# B7 ~! n* c9 v5 U3 l# p) \5 D
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback()3 H; L) K% i6 w1 ?& m5 o! W7 j
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 824, in _autorollback
: V1 w% X+ e8 Y. ]& ?" J; \+ j2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._root._rollback_impl()
; D- K: t, O5 ?+ `9 ~% {2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 703, in _rollback_impl
6 O- S0 B9 O, c$ v; M2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._handle_dbapi_exception(e, None, None, None, None). D8 e! {* U6 l* ?
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1323, in _handle_dbapi_exception
% S' R. R6 C8 s# P2018-08-10 20:11:08.011 22951 ERROR 067_kilo     exc_info' I: V, p; @+ B: R, C  Z7 |
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause5 W0 a- Z( s' [( c2 f  |
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     reraise(type(exception), exception, tb=exc_tb, cause=cause)& K1 k5 G! u& `' d% @6 f
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 701, in _rollback_impl" |  W. p$ k, I( r
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self.engine.dialect.do_rollback(self.connection)9 r: e8 z4 o  D+ j0 v  e, @
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 1598, in do_rollback
2 m1 O/ c. q* X4 p. \* }9 y8 b' e/ _2018-08-10 20:11:08.011 22951 ERROR 067_kilo     dbapi_connection.rollback()
$ {! U! q8 [: [3 z: p2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback( n% I- V9 r, {' U$ Z
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._read_ok_packet()% `7 y6 F7 L6 Q1 v
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 767, in _read_ok_packet. ~: V. ?4 Q- t& V: {% R. \) o
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     pkt = self._read_packet()  b6 [% \! U& ?/ G/ x1 ]
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet
% K' |: h# q/ T2018-08-10 20:11:08.011 22951 ERROR 067_kilo     packet.check_error()4 `: C0 d4 A+ C8 v5 P
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
5 x: W. Z- z8 K0 V  q/ J$ d2018-08-10 20:11:08.011 22951 ERROR 067_kilo     err.raise_mysql_exception(self._data)
) k4 {; o! s$ W% Q2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
5 p3 C2 I3 ~/ g( T! G) B% f2018-08-10 20:11:08.011 22951 ERROR 067_kilo     raise errorclass(errno, errval)$ ?8 v- G' ~6 t. S2 B
2018-08-10 20:11:08.011 22951 ERROR 067_kilo InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')* F! u% p) k6 E) G0 u" P# \
2018-08-10 20:11:08.011 22951 ERROR 067_kilo
5 w/ `) c9 R6 ~, I9 d2018-08-10 20:11:08.016 22951 CRITICAL keystone [-] Unhandled error: DbMigrationError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
7 z9 U# a6 P" v6 p2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):: G/ w! U! `4 g- U2 L
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>
% ?1 {$ Y7 E5 J+ o$ S8 B2018-08-10 20:11:08.016 22951 ERROR keystone     sys.exit(main())
! F9 [; p7 Y1 a' `4 N/ y. W+ Q2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/manage.py", line 44, in main! p& ]$ z+ `/ P6 \
2018-08-10 20:11:08.016 22951 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)3 }# Q6 S; a4 Y6 T6 M  ^
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 1331, in main
/ Y' ?1 x0 k/ g" J, l7 k2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.cmd_class.main()& p' m+ O9 @( Q# T+ W
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 530, in main. c* f! w* B, r3 Q* ]
2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.version)' a# v7 U" r; c" K
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/sql/upgrades.py", line 250, in offline_sync_database_to_version' b5 |" s+ p  k/ n( J
2018-08-10 20:11:08.016 22951 ERROR keystone     expand_schema()
1 d4 Q: d/ ], B9 y5 p. ?2 `, k2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/sql/upgrades.py", line 321, in expand_schema
# w* \2 A6 i# Y0 k) {2018-08-10 20:11:08.016 22951 ERROR keystone     _sync_common_repo(version=None)" n% ?6 C) d- u" n" T& N6 Q1 v
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/sql/upgrades.py", line 170, in _sync_common_repo
3 ]: ~! X* H3 P" X2018-08-10 20:11:08.016 22951 ERROR keystone     init_version=init_version, sanity_check=False)
) n0 J* H7 c7 I. A  R# o% X2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py", line 81, in db_sync
' h, c( W8 G% f1 f4 {! W0 K, N2018-08-10 20:11:08.016 22951 ERROR keystone     raise exception.DbMigrationError(ex)
! Y, f8 g2 e+ l; v2018-08-10 20:11:08.016 22951 ERROR keystone DbMigrationError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
; D: Z% u9 N% D7 M2018-08-10 20:11:08.016 22951 ERROR keystone ( }% f- P8 e0 O! W$ V0 q& x
回复

使用道具 举报

admin
 楼主| 发表于 2018-8-10 20:36:33 | 显示全部楼层
数据库出现脑裂导致的问题，需要好好看看什么原因
回复 支持 反对

使用道具 举报

admin
 楼主| 发表于 2018-8-10 21:28:15 | 显示全部楼层
莫名其妙的出现数据库脑裂，好奇怪哦，需要好好看看配置文件了，有地方配置有问题。
回复 支持 反对

使用道具 举报

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

本版积分规则

关闭

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

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

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

GMT+8, 2026-4-8 17:04 , Processed in 0.055244 second(s), 32 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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