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

易陆发现互联网技术论坛

 找回密码
 开始注册
易陆发现互联网技术论坛»首页 › 云计算开源区 › OpenStack问题汇总 › 同步keystone数据库的时候，出现的error
查看: 5707|回复: 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:9 T7 f) t& x. l' q+ \) _
<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 ^* d: f5 R$ z, w" {  "is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))
& V7 G/ I4 w: @- o: P: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
+ G7 X+ R# ?2 J7 D+ S4 b6 W2018-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')
4 w; k2 |8 v2 @' W: J% i2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):: H$ s& Z; D7 Z; `
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
% S+ C9 X1 A  T+ R4 u: k" E2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     fairy._reset(pool)! m; ^. K, J" I; O! X
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
+ p- `$ i! f1 c! Q; R2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pool._dialect.do_rollback(self)5 y0 Q8 {9 M6 |0 S- ]) v
2018-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
3 w! ?0 O  t; g4 f8 y; B' b2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     dbapi_connection.rollback()4 N& Y/ U  h6 c3 z! g
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/ b* V+ v; N  p' p: O
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     self._read_ok_packet()! N! B( X1 ~: M7 g( |
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' L- v" _0 H. s# x7 V/ H. @1 P5 D
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pkt = self._read_packet()
7 P8 T# N( q! A- f; R7 f8 t2018-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_packet# G0 Q5 t! Q6 M
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     packet.check_error()
) ~4 d4 Z/ q7 z8 N; j+ d2018-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_error1 `5 ?' Q1 w2 W9 ^" V1 V% @2 C' k
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     err.raise_mysql_exception(self._data)
- b" ], W# ^8 y% w' 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
$ q& m% l% B. Q+ T" t- }2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     raise errorclass(errno, errval)
( P! }  w+ {5 V! ]/ R9 q2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool InternalError: (1047, u'WSREP has not yet prepared node for application use')& P  @$ i" p2 g: o9 ?
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool
* b4 v: w/ L" b  ^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+ S$ ?! n/ ^6 j2018-08-10 20:11:08.011 22951 ERROR 067_kilo Traceback (most recent call last):
$ J5 o' E1 o; j$ q; m2 z2018-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( i9 F  @: Q. ^. B& P
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     table.create()
2 m0 D9 A, |$ h5 \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# W) W, l' l& I! J( q3 w, K
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     checkfirst=checkfirst)% G  f9 Q' x3 @* ]8 C; t
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
. z. E/ p% U; e* K/ T1 A2018-08-10 20:11:08.011 22951 ERROR 067_kilo     conn._run_visitor(visitorcallable, element, **kwargs)
# l6 e% B9 n/ _2 N7 K2018-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
' l6 P& V0 Y: M8 l# V2018-08-10 20:11:08.011 22951 ERROR 067_kilo     **kwargs).traverse_single(element)2 d0 s! x; c1 b6 K& H
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_single3 }  I) k9 i! y, O1 d
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(obj, **kw)
' E$ k8 y- b( [, F5 j! u% U& }: T2018-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
) N2 N% z! a8 R& K2018-08-10 20:11:08.011 22951 ERROR 067_kilo     include_foreign_key_constraints=include_foreign_key_constraints( l9 b& Y. [4 D4 @
2018-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$ e7 h$ k2 i8 C! z, b, B
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(self, multiparams, params)0 @- v- S6 x+ w  O( V( M5 ~
2018-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_connection2 n5 W8 e* t, N* r+ p0 p9 G+ H- m
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return connection._execute_ddl(self, multiparams, params)
& y$ Y  L( K4 K9 j% N, ^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
- c8 o# v) H+ n6 K3 ?2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compiled
2 T* u$ [" K. z2 \1 B5 y2018-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
8 Y7 N' }0 T" R/ E$ R8 F2018-08-10 20:11:08.011 22951 ERROR 067_kilo     context)
* _( r+ W3 J" v3 F* R8 [1 m2018-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
# R! {" v$ t# U2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback(), I  p5 {2 {# h- O$ I" r' `
2018-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__
" t/ ^+ R' X# {2 a# z4 |2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compat.reraise(type_, value, traceback)
2 N6 p/ L8 V9 {- {. `! l2018-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_exception9 W1 u6 u  C8 o# S. Z( u
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback()* L; h5 f2 X$ K# _$ x
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. S, H- R$ v6 K9 t
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._root._rollback_impl()3 G5 x" Y% N1 [: m+ s( @) t; @7 }
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
+ \- U; V% e; m8 T8 v2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._handle_dbapi_exception(e, None, None, None, None)
1 Y  Y9 u' _" |7 o& t8 m5 c2018-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& W/ E) a# W+ L/ q# _
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     exc_info! R; _0 M; S0 T2 q  ?% w1 `
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_cause2 y8 y3 a& Y; F! S* x1 u" U
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     reraise(type(exception), exception, tb=exc_tb, cause=cause)7 z1 c: F- X4 H& W4 ~. t# Y
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! @& }9 z: q2 l1 D2 G
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self.engine.dialect.do_rollback(self.connection)# t* v/ t. R  A! R
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_rollback7 l1 q, j! `% e* N3 }+ e
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     dbapi_connection.rollback()
% O. W4 B6 q5 O& ?, 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
5 Z" v* K5 |1 t% r& Q2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._read_ok_packet()6 w: d8 ~0 r. z6 J3 E5 z9 l* G
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
- ^  u& ?6 s' I; I6 |4 M: g2018-08-10 20:11:08.011 22951 ERROR 067_kilo     pkt = self._read_packet()2 w) G& D) V" h7 L! b/ D6 \$ e
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_packet5 ?+ z+ b( k8 R+ {* B4 B8 ]
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     packet.check_error()
$ Q/ G4 A2 D- `3 d. }: Z2018-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
: m' J# z* _# k9 A2018-08-10 20:11:08.011 22951 ERROR 067_kilo     err.raise_mysql_exception(self._data)
0 N. L$ p+ }' u; j& y6 U) 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
; l* P+ B- J" M  Y. c2018-08-10 20:11:08.011 22951 ERROR 067_kilo     raise errorclass(errno, errval)# e. e* H0 b& l+ q1 w. ~9 u
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')
% H% Z! Z& ?0 w" ?, [8 d, y8 |9 }2018-08-10 20:11:08.011 22951 ERROR 067_kilo
, I( m+ k* g2 Z% A1 x  ^$ U* R2018-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')" h# q* I3 T' T0 }
2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):) D6 T% e! A: }: A: F& j
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>: E% E- n( N- j% Q5 a/ v
2018-08-10 20:11:08.016 22951 ERROR keystone     sys.exit(main())4 f) `: z7 o! d: D1 H6 V0 {
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 j! l7 W& f" S, D+ r2 j7 ]+ j2018-08-10 20:11:08.016 22951 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)8 i+ h  \6 r) P' O- D4 Q
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" C( d, k( \3 N  ]1 S' Q. D& K
2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.cmd_class.main()" S+ t7 a) Z3 q0 u) {- u' a0 D' E
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 530, in main5 U' Y4 K/ a1 ~0 k% l1 m
2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.version)
$ f$ |! h% u5 z# a2018-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
8 Y4 K: @: n/ z+ b- A$ ^2018-08-10 20:11:08.016 22951 ERROR keystone     expand_schema()$ ?0 S2 N& a- q# 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
+ u! `. y: b% g' T+ C& f7 y+ j2018-08-10 20:11:08.016 22951 ERROR keystone     _sync_common_repo(version=None)$ v2 B( @; `1 O
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_repo1 f+ ]2 r( z6 g) G2 B' X0 x( i8 o
2018-08-10 20:11:08.016 22951 ERROR keystone     init_version=init_version, sanity_check=False)$ o/ |3 D( n: U. Q9 d
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% }( \2 J2 i: l) t/ i9 y" c
2018-08-10 20:11:08.016 22951 ERROR keystone     raise exception.DbMigrationError(ex)
2 h  e; }8 X: J$ C# y! h2018-08-10 20:11:08.016 22951 ERROR keystone DbMigrationError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
1 x! V1 Q% p& Q$ S1 z" ]2018-08-10 20:11:08.016 22951 ERROR keystone * j! k! u9 e- Y: a1 s8 B
回复

使用道具 举报

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 15:22 , Processed in 0.043457 second(s), 23 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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