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

易陆发现互联网技术论坛

 找回密码
 开始注册
易陆发现互联网技术论坛»首页 › 云计算开源区 › 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:
2 |* Q  S4 Q& F, X/ _ <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"]
7 m; I: b; l/ o* u5 O3 P  "is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1])); g" k, h- ~- Q5 }
: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
9 C: x/ q4 s/ t2018-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; v" ~" D- k, A. S2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):1 m; m% b  {6 a& Q
2018-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: \& ?$ Z* z; z# I
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     fairy._reset(pool)
( ]( E0 ^$ t  J* P5 j! Y( g2018-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& v# U% x. k5 h; F# Q; Q' L
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pool._dialect.do_rollback(self)
( p# a; O0 c2 E0 W2018-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
* w8 a7 ]' B& n4 u$ h2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     dbapi_connection.rollback()! Y" J% H, x7 E( A* P7 N
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
/ S1 d& n& |8 Q- [8 z4 y2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     self._read_ok_packet()
( K# N7 U1 j* L2018-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! n. S; N! b  T. R
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pkt = self._read_packet()
# e5 u$ S' b. i& j  W1 \* q2018-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_packet3 P2 D# l+ x+ r
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     packet.check_error()$ K& d) _0 ?5 a" e) Z9 g7 W- Q
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
5 A, o4 R# s' v2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     err.raise_mysql_exception(self._data)
4 z- o2 g6 R; ?* S' X2018-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
, l' V# F' j9 J2 A. R% S% B2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     raise errorclass(errno, errval)  M# N0 ]1 \4 j, g5 H
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool InternalError: (1047, u'WSREP has not yet prepared node for application use')
. ?( o; V+ P9 h1 T5 a  d3 W: ?+ T2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool $ i4 c2 L( u- W* {: t8 ]
2018-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')1 M) _9 W1 r9 d# T$ E3 q
2018-08-10 20:11:08.011 22951 ERROR 067_kilo Traceback (most recent call last):
4 G: e6 m, E; k& M# ?+ @. S- O7 Z) X2018-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 upgrade* E+ q( @0 s! ~/ M  j" i$ ?
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     table.create()
' j& D3 c4 k3 `6 X2018-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
  Z3 u# G, ?7 U' P* f2018-08-10 20:11:08.011 22951 ERROR 067_kilo     checkfirst=checkfirst)
- y1 X+ x/ z: E% [8 V, o2018-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
' E- ~0 g' U0 r2018-08-10 20:11:08.011 22951 ERROR 067_kilo     conn._run_visitor(visitorcallable, element, **kwargs)
( X" K1 K& X" q2018-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_visitor3 Q5 ?! r+ S" k+ ^
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     **kwargs).traverse_single(element)8 _/ n1 G$ j1 e1 K/ [
2018-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) @; i$ j* ?% ~; E  M' J
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(obj, **kw)$ t& i& g8 U4 f
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/ ~) X# W% Y0 w) N! E
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     include_foreign_key_constraints=include_foreign_key_constraints
; @0 q0 E6 p# U/ i2018-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# o& f0 f6 x8 W: v; ?; s
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(self, multiparams, params)
& ]% J7 o# b- }5 t. h% F' 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
) Y  P' k6 D# {2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return connection._execute_ddl(self, multiparams, params)8 H8 m; x) R, _
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_ddl
8 _8 G3 l) h- p, o' e2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compiled+ p9 a, n/ S  e7 \2 C* U
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
" T0 M: P4 N$ @6 ]8 q: d2018-08-10 20:11:08.011 22951 ERROR 067_kilo     context)
$ {% @& |4 K8 V9 ~' T% {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" Z# L" V5 Q& h4 R& W0 i, B
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback()
0 r' U0 q$ u! h9 ?5 S2018-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__
  E5 T! D. D% \2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compat.reraise(type_, value, traceback)' j# x" W( c8 b3 Z; V" X/ ]
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
8 p! L  {  ?& q' p2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback()  x' ]  S8 f/ `
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
) J! ~7 q' \+ R( Q6 A( h' R" i2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._root._rollback_impl()
& G6 d9 u8 E, U( Z4 J2018-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
8 {6 q5 o, K* h2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._handle_dbapi_exception(e, None, None, None, None)/ E0 R* [3 a: c8 k/ {
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# h# F4 n1 P5 j6 W7 \& j& E1 E
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     exc_info# T1 H8 s3 {  O- d6 t. i7 ]4 N
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_cause' `* D/ x* W. z/ M& P
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     reraise(type(exception), exception, tb=exc_tb, cause=cause)
( ?- }9 \, n. n/ a* L) X7 J2018-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
8 K- E2 v1 p$ o. [2 A2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self.engine.dialect.do_rollback(self.connection)* g- }' C: v$ f( C/ \7 k9 L# Z
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% K1 E# l2 W- u0 A& F! {/ {+ M1 s
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     dbapi_connection.rollback()
8 e  N- F) T3 R( v6 s  i& t2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback
. z' |# ~" }& g; D% y: O  W2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._read_ok_packet()9 E) k3 M9 D9 m' t- o
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
( n1 ?4 X9 P( D6 }* v2 ?! B2018-08-10 20:11:08.011 22951 ERROR 067_kilo     pkt = self._read_packet()2 }/ K. [1 @. j
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+ I% p. e- {) S0 c; N$ f
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     packet.check_error()
1 Y% J; G2 X& C& S) d+ y3 l2018-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. H/ C1 H* B7 U
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     err.raise_mysql_exception(self._data)
- u" i9 w$ z, B$ i$ Y7 F/ s2018-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- h- r- l* D& K9 c9 ~( o8 G# z( h
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     raise errorclass(errno, errval): A) R% Y; u5 ?
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')
4 f* l/ W& n, g6 j' c1 `2018-08-10 20:11:08.011 22951 ERROR 067_kilo : D7 T! h+ w" b. s! i
2018-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')
; d0 F2 R( L2 ?- l4 O$ x2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):5 H6 i6 ]4 ^" ^8 l. K' w
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>) `( }- l3 p' U5 m- d# X
2018-08-10 20:11:08.016 22951 ERROR keystone     sys.exit(main())5 z0 d% F1 r2 F! L6 W. f
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/manage.py", line 44, in main
0 H8 V3 f; C, E; t0 z# q2018-08-10 20:11:08.016 22951 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)
/ M. s+ }) E7 k2 f& x& N2 d  c2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 1331, in main1 r$ N7 B) |4 H6 b
2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.cmd_class.main(). c/ j) y4 ^2 A7 X
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! W% O7 [. z# o- T3 k
2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.version)1 g7 i* w  ?! C7 s- ?. n
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' t2 q, d% `, r0 A, F% u
2018-08-10 20:11:08.016 22951 ERROR keystone     expand_schema()# C, E, J( R* h
2018-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
" w0 H4 s% ~2 M# i, V2018-08-10 20:11:08.016 22951 ERROR keystone     _sync_common_repo(version=None)
2 _6 Y: v; B9 {) n# y& q2018-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 w0 y4 z, |9 Q# N, r2018-08-10 20:11:08.016 22951 ERROR keystone     init_version=init_version, sanity_check=False)  H: c$ j$ t# [+ w
2018-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, Z" N  Y; d2 j' S
2018-08-10 20:11:08.016 22951 ERROR keystone     raise exception.DbMigrationError(ex)
. h4 e& V- m1 U  q) O2 W2018-08-10 20:11:08.016 22951 ERROR keystone DbMigrationError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use'); \+ |& c9 Z( g
2018-08-10 20:11:08.016 22951 ERROR keystone ! v# ]4 w* E2 V- g3 a
回复

使用道具 举报

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

使用道具 举报

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

使用道具 举报

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

本版积分规则

关闭

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

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

QQ|返回首页|Archiver|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )点击这里给我发消息

GMT+8, 2026-4-8 21:22 , Processed in 0.053847 second(s), 23 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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